--- trunk/tntnet/dynamic/adm_customer_edit.ecpp	2007/11/28 22:27:17	89
+++ trunk/tntnet/dynamic/adm_customer_edit.ecpp	2007/11/28 23:19:28	90
@@ -3,6 +3,10 @@
 #include <tntdb/connection.h>
 #include <tntdb/result.h>
 #include <tntdb/row.h>
+
+#include <sstream>
+
+#include "common.h"
 </%pre>
 
 <%config>
@@ -20,13 +24,125 @@
 
 <&header title="Customer Administration">
 </&header>
+
+
+
 <{
 
 if (userName.size() == 0)
     reply.setHeader("Refresh", "0; url=login");
 
+if (id == -1)
+	reply.out() << "<h2>New Customer</h2>\n";
+else
+	reply.out() << "<h2>Modify customer</h2>\n";
+
+reply.out() << "<a href='adm_customer_list'>";
+reply.sout() << "<< back to customer list";
+reply.out() << "</a><br>";
+
 tntdb::Connection conn = tntdb::connect(dburl); 
 
+
+std::string submit = qparam.param("submit");
+if (submit == "1")
+{
+	std::string form_name = qparam.param("name");
+	std::string form_address = qparam.param("address");
+	std::string form_phone = qparam.param("phone");
+	std::string form_contact = qparam.param("contact");
+
+
+	if (id == -1)
+	{
+		tntdb::Statement st = conn.prepare("INSERT INTO customer (name,address,phonenr,contactperson) values (:v1, :v2, :v3, :v4)");
+		st.setString("v1", form_name).setString("v2", form_address).setString("v3", form_phone).setString("v4", form_contact);
+		st.execute();
+
+		//tntdb::Value v = conn.selectValue("SELECT lastval()"); //get the auto-generated id
+		//id = v.getInt();
+		reply.setHeader("Refresh", "0; url=adm_customer_list");
+		return HTTP_OK;
+	}
+	else
+	{
+		tntdb::Statement st = conn.prepare("UPDATE customer SET name=:v1, address=:v2, phonenr=:v3, contactperson=:v4 WHERE id=:v5");
+		st.setString("v1", form_name).setString("v2", form_address).setString("v3", form_phone).setString("v4", form_contact).setInt("v5", id);
+		st.execute();
+	}
+
+}
+
+
+std::string name;
+std::string address;
+std::string phone;
+std::string contact;
+
+bool showForm = true;
+
+if (id != -1)
+{
+	std::stringstream query;
+	query << "SELECT name,address, phonenr,contactperson FROM customer WHERE id = " << id;
+	tntdb::Result res = conn.select(query.str());
+
+	if (res.size() > 0)
+	{
+		name = res[0].getString(0);
+		address = res[0].getString(1);
+		phone = res[0].getString(2);
+		contact = res[0].getString(3);
+	}
+
+	else
+	{
+		reply.out() << "<p><i>Invalid customer ID !</i></p>\n";
+		showForm = false;
+	}
+}
+
+if (showForm)
+{
+}>
+
+<form method="post" action="adm_customer_edit">
+<table border="0">
+<tr>
+  <td>Name: </td>
+  <td><input type="text" name="name" size="40" value="<$ name $>"></td>
+</tr>
+<tr>
+  <td valign="top">Address: </td>
+  <td><textarea name="address" cols=30 rows=4><$ address $></textarea></td>
+</tr>
+<tr>
+  <td>Phone:</td>
+  <td><input type="text" name="phone" value="<$ phone $>"></td>
+</tr>
+<tr>
+  <td>Contact:</td>  
+  <td><input type="text" name="contact" value="<$ contact $>"></td>
+</tr>
+<tr>
+  <td>&nbsp;</td>
+  <td><input type="submit"><input type="reset"></td>
+</tr>
+</table>
+<input type="hidden" name="id" value="<$ id $>">
+<input type="hidden" name="submit" value="1">
+</form>
+
+<br>
+<form method="post" action="adm_customer_delete">
+<input type="hidden" name="id" value="<$ id $>">
+<input type="submit" value="Delete">
+</form>
+
+<{
+}
+
+
 }>
 
 <&footer>