public List <Cusmast> GetCustomersData()
{
var db = new ULTRAEntities();
var custList = db.Cusmasts.ToList();
List <Cusmast> customerList = new List <Cusmast>();
foreach (var item in custList)
{
var userobj = new Cusmast();
userobj.Cucname = item.Cucname;
userobj.Cuccustid = item.Cuccustid;
userobj.Cucaddr1 = item.Cucaddr1;
userobj.Cucaddr2 = item.Cucaddr2;
userobj.Cuccity = item.Cuccity;
userobj.Cucstate = item.Cucstate;
//userobj.CustomerAdded = DateTime.Now;
userobj.Cuczipcode = item.Cuczipcode;
userobj.Cuccountry = item.Cuccountry;
//userobj.Created_at = DateTime.Now;
userobj.Cucpono = item.Cucpono;
userobj.Cucstatus = item.Cucstatus;
customerList.Add(userobj);
}
return(customerList);
}
public List <Cusmast> UpdateCustomersData()
{
List <Cusmast> customerList = new List <Cusmast>();
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 Cusmast", conn);
DataSet ds = new DataSet();
da.Fill(ds);
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
var userobj = new Cusmast();
userobj.Cucname = dr["Cucname"].ToString();
userobj.Cuccustid = dr["Cuccustid"].ToString();
userobj.Cucaddr1 = dr["Cucaddr1"].ToString();
userobj.Cucaddr2 = dr["Cucaddr2"].ToString();
userobj.Cuccity = dr["Cuccity"].ToString();
userobj.Cucstate = dr["Cucstate"].ToString();
//userobj.CustomerAdded = DateTime.Now;
userobj.Cuczipcode = dr["Cuczipcode"].ToString();
userobj.Cuccountry = dr["Cuccountry"].ToString();
//userobj.Created_at = DateTime.Now;
userobj.Cucpono = dr["Cucpono"].ToString();
userobj.Cucstatus = dr["Cucstatus"].ToString();
customerList.Add(userobj);
}
}
}
catch (Exception ex)
{
ExceptionHandlerController.infoMessage(ex.Message);
ExceptionHandlerController.writeErrorLog(ex);
}
return(customerList);
}
