<%@ page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" errorPage="..\errorPage.htm" %>
<%@ page import = "petrel.*,com.ceic.ResultSets.*"%><%
System.out.println("1--------------------------------");
    //get contact page info
   String givenName        = request.getParameter("givenName");
   String lastName         = request.getParameter("lastName");
   String chineseName      = "null";
   String companyName      = request.getParameter("companyName");
   String title            = request.getParameter("title");
   String role             = request.getParameter("role");
   String TelNo            = request.getParameter("Main_countryCode")+"-"+request.getParameter("Main_areaCode")+"-"+request.getParameter("Main_telNo");
   String ExtNo            = request.getParameter("ExtNo");
   String MobNo            = request.getParameter("Mob_countryCode")+"-"+request.getParameter("Mob_areaCode")+"-"+request.getParameter("Mob_telNo");
   String FaxNo            = request.getParameter("Fax_countryCode")+"-"+request.getParameter("Fax_areaCode")+"-"+request.getParameter("Fax_telNo");
   String email            = request.getParameter("email");
   String country          = request.getParameter("Country");
   String stateOrProvince  = request.getParameter("stateOrProvince");
   String city             = request.getParameter("city");
   String address          = request.getParameter("address");
   String zipCode          = request.getParameter("zipCode");   
   
   String recordNo         = request.getParameter("RecordNo");
   session.setAttribute("recordNo",recordNo);
   
    //judge if the name is null
    String errormsg="";
   if((givenName==null)||(givenName.trim().length()==0)||(companyName==null)||(companyName.trim().length()==0))
   {
   errormsg = "Given Name Or Company Name can not be null!";
    ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
   }else{
   
   //connect to database,judge if the customer exists
   
   Result rs = ResultFactory.getResult("Vector");
   rs.setConnType("jdbc");
   
   String checkSql = "select * from Contact where GivenName='"+givenName+"' and CompanyName='"+companyName+"'";
   rs.setSql(checkSql);
   System.out.println("1a");
   rs.Create();
   System.out.println("a2");
   boolean find = false;
   if (rs.next())
   {
   find = true;
   System.out.println("3a");
   errormsg = "This person has already existed, please use another name";
  ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
   }
   rs.close();
   
   System.out.println("4a");
   if(!find)
    {
    Result insertRs = ResultFactory.getResult("Vector");
    insertRs.setConnType("Vector");
    String sql = "insert into Contact values('"+givenName+"','"+companyName+"','"+recordNo+"','"+lastName+"','"+chineseName+"','"+title
                    +"','"+role+"','"+TelNo+"','"+ExtNo+"','"+MobNo+"','"+FaxNo+"','"+email+"','"+country+"','"+stateOrProvince
                    +"','"+city+"','"+address+"','"+zipCode+"')";
   insertRs.setConnType("jdbc");
   insertRs.setSql(sql,ResultInfo.INSERT);
   insertRs.Update();
   System.out.println("a5");
//  boolean ok=insertRs.Update();
    insertRs.close();
   insertRs = null;
 //  if(ok)
 //  {
//     errormsg = "Insert a person successfully!";
//     System.out.println("6a");
     
     %>
     <jsp:forward page="ContactNew.jsp">
       <jsp:param name = "RecordNo" value="<%= recordNo%>" />
 </jsp:forward>     <%
 // }else
 //  {
 //  System.out.println("7a");
 //   errormsg= "Insert a person failed!some illegal character existed or databased duplicated.";
 //    ErrorMsg.CreateMsg(request,response,errormsg,"ContactNew.jsp");
 //  }
   System.out.println("8a");   }
  
   }%>