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);
}
