//Add To CompanyInfo Table
 public bool AddCompanyInfo(companyInfo ci)
 {
     try
     {
         db.companyInfos.InsertOnSubmit(ci);
         db.SubmitChanges();
         return true;
     }
     catch (Exception error)
     {
         return false;
     }
 }
 //Edit CompanyInfo Table
 public int EditCompanyInfo(companyInfo ci)
 {
     try
     {
         var v = from i in db.companyInfos
                 where i.companyCode == ci.companyCode
                 select i;
         companyInfo newcompany = v.FirstOrDefault();
         if(newcompany != null)
         {
             newcompany = ci;
             db.SubmitChanges();
             return 1;
         }
         return 0;//not found
     }
     catch (Exception error)
     {
         return -1;
     }
 }
 partial void UpdatecompanyInfo(companyInfo instance);
 partial void DeletecompanyInfo(companyInfo instance);
 partial void InsertcompanyInfo(companyInfo instance);