public List <Customer_contact> GetCustomerContacts() { var db = new ULTRAEntities(); var CusContList = db.Cusconts.ToList(); List <Customer_contact> customersContactsList = new List <Customer_contact>(); foreach (var item in CusContList) { Customer_contact customerContactObj = new Customer_contact(); customerContactObj.Ccccontact = item.Ccccontact; customerContactObj.Ccccontcde = item.Ccccontcde; customerContactObj.Ccccontmsc = item.Ccccontmsc; customerContactObj.Ccccuscont = item.Ccccuscont; customerContactObj.Ccccusmast = item.Ccccusmast; customerContactObj.Cccemail = item.Cccemail; customerContactObj.Cccemlbody = item.Cccemlbody; customerContactObj.Cccfname = item.Cccfname; customerContactObj.Ccclname = item.Ccclname; customerContactObj.Cccmname = item.Cccmname; customerContactObj.Cccphone1 = item.Cccphone1; customerContactObj.Cccphone2 = item.Cccphone2; customerContactObj.Cccphone3 = item.Cccphone3; customerContactObj.Cccsalcde = item.Cccsalcde; customerContactObj.Ccmnotes = item.Ccmnotes; customerContactObj.Customer_id = item.Cusmast.Cuccustid; customersContactsList.Add(customerContactObj); } return(customersContactsList); }
public List <Customer_contact> UpdateCustomerContacts() { List <Customer_contact> customersContactsList = new List <Customer_contact>(); DataTable dt = new DataTable(); try { using (OdbcConnection conn = new OdbcConnection("Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=C:\\Users\\sazhar\\Desktop\\WindowsService1\\Employees_and_Customers tables\\QFS\\ULTRA.DBC;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;")) { conn.Open(); OdbcDataAdapter da = new OdbcDataAdapter("SELECT * from Cuscont", conn); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { Customer_contact customerContactObj = new Customer_contact(); customerContactObj.Ccccontact = dr["Ccccontact"].ToString(); customerContactObj.Ccccontcde = dr["Ccccontcde"].ToString(); customerContactObj.Ccccontmsc = dr["Ccccontmsc"].ToString(); customerContactObj.Ccccuscont = dr["Ccccuscont"].ToString(); customerContactObj.Ccccusmast = dr["Ccccusmast"].ToString(); customerContactObj.Cccemail = dr["Cccemail"].ToString(); customerContactObj.Cccemlbody = dr["Cccemlbody"].ToString(); customerContactObj.Cccfname = dr["Cccfname"].ToString(); customerContactObj.Ccclname = dr["Ccclname"].ToString(); customerContactObj.Cccmname = dr["Cccmname"].ToString(); customerContactObj.Cccphone1 = dr["Cccphone1"].ToString(); customerContactObj.Cccphone2 = dr["Cccphone2"].ToString(); customerContactObj.Cccphone3 = dr["Cccphone3"].ToString(); customerContactObj.Cccsalcde = dr["Cccsalcde"].ToString(); customerContactObj.Ccmnotes = dr["Ccmnotes"].ToString(); customerContactObj.Customer_id = dr["CusmastCuccustid"].ToString(); customersContactsList.Add(customerContactObj); } } } catch (Exception ex) { ExceptionHandlerController.infoMessage(ex.Message); ExceptionHandlerController.writeErrorLog(ex); } return(customersContactsList); }