/[H9]/trunk/tntnet/dynamic/adm_customer_edit.ecpp
ViewVC logotype

Diff of /trunk/tntnet/dynamic/adm_customer_edit.ecpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 92 by torben, Thu Nov 29 05:21:04 2007 UTC revision 126 by torben, Sun Dec 2 20:26:43 2007 UTC
# Line 15  dburl; Line 15  dburl;
15    
16  <%session scope="global">  <%session scope="global">
17  std::string userName;  std::string userName;
 bool isAdmin;  
18  </%session>  </%session>
19    
20  <%args>  <%args>
21  int id;  int id;
22  </%args>  </%args>
23    
24    <{
25    if (userName.size() == 0)
26    {
27            reply.setHeader("Location", "index");
28            return HTTP_MOVED_TEMPORARILY;
29    }
30    }>
31    
32    
33  <&header title="Customer Administration">  <&header title="Customer Administration">
34  </&header>  </&header>
35    
36    
   
37  <{  <{
38    
 if (userName.size() == 0)  
 {  
     reply.setHeader("Refresh", "0; url=login");  
         return HTTP_OK;  
 }  
   
39  if (id == -1)  if (id == -1)
40          reply.out() << "<h2>New Customer</h2>\n";          reply.out() << "<h2>New Customer</h2>\n";
41  else  else
# Line 50  tntdb::Connection conn = tntdb::connect( Line 51  tntdb::Connection conn = tntdb::connect(
51  std::string submit = qparam.param("submit");  std::string submit = qparam.param("submit");
52  if (submit == "1")  if (submit == "1")
53  {  {
54          std::string form_name = qparam.param("name");          std::string form_name = trim(qparam.param("name"));
55          std::string form_address = qparam.param("address");          std::string form_address = trim(qparam.param("address"));
56          std::string form_phone = qparam.param("phone");          std::string form_phone = trim(qparam.param("phone"));
57          std::string form_contact = qparam.param("contact");          std::string form_contact = trim(qparam.param("contact"));
58    
59    
60          if (id == -1)          if (id == -1)
# Line 64  if (submit == "1") Line 65  if (submit == "1")
65    
66                  //tntdb::Value v = conn.selectValue("SELECT lastval()"); //get the auto-generated id                  //tntdb::Value v = conn.selectValue("SELECT lastval()"); //get the auto-generated id
67                  //id = v.getInt();                  //id = v.getInt();
68                  reply.setHeader("Refresh", "0; url=adm_customer_list");  
69                  return HTTP_OK;                  reply.setHeader("Location", "adm_customer_list");
70                    return HTTP_MOVED_TEMPORARILY;
71          }          }
72          else          else
73          {          {
74                  tntdb::Statement st = conn.prepare("UPDATE customer SET name=:v1, address=:v2, phonenr=:v3, contactperson=:v4 WHERE id=:v5");                  tntdb::Statement st = conn.prepare("UPDATE customer SET name=:v1, address=:v2, phonenr=:v3, contactperson=:v4 WHERE id=:v5");
75                  st.setString("v1", form_name).setString("v2", form_address).setString("v3", form_phone).setString("v4", form_contact).setInt("v5", id);                  st.setString("v1", form_name).setString("v2", form_address).setString("v3", form_phone).setString("v4", form_contact).setInt("v5", id);
76                  st.execute();                  st.execute();
77    
78                    reply.out() << "<i>Customer updated</i><br>\n";
79          }          }
80    
81  }  }
Legend:
Removed from v.92  
changed lines
  Added in v.126
  ViewVC Help
Powered by ViewVC 1.1.20