public List <Empmast> GetEmployeesData() { var db = new ULTRAEntities(); var list2 = db.Empmasts.Where(s => 1 == 1); List <Empmast> list = new List <Empmast>(); foreach (var item in list2.ToList()) { Empmast employeeObj = new Empmast(); employeeObj.Emcempid = item.Emcempid; employeeObj.Emcfname = item.Emcfname; employeeObj.Emclname = item.Emclname; employeeObj.Emcmname = item.Emcmname; //employeeObj.Created_at = DateTime.Now; employeeObj.Emcaddr1 = item.Emcaddr1; employeeObj.Emcaddr2 = item.Emcaddr2; employeeObj.Emccity = item.Emccity; employeeObj.Emcstate = item.Emcstate; employeeObj.Emczipcode = item.Emczipcode; employeeObj.Emccountry = item.Emccountry; employeeObj.Emcmarital = item.Emcmarital; employeeObj.Emcsex = item.Emcsex; employeeObj.Emtbirth = item.Emtbirth; employeeObj.Emthire = item.Emthire; employeeObj.Emtrehire = item.Emtrehire; employeeObj.Emcemptype = item.Emcemptype; //employeeObj.Updated_at = DateTime.Now; list.Add(employeeObj); } return(list); }
public List <Empmast> UpdateUsersData() { DataTable dt = new DataTable(); List <Empmast> list = new List <Empmast>(); 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 Empmast", conn); DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { Empmast employeeObj = new Empmast(); employeeObj.Emcempid = dr["Emcempid"].ToString(); employeeObj.Emcfname = dr["Emcfname"].ToString(); employeeObj.Emclname = dr["Emclname"].ToString(); employeeObj.Emcmname = dr["Emcmname"].ToString(); //employeeObj.Created_at = DateTime.Now"].ToString(); employeeObj.Emcaddr1 = dr["Emcaddr1"].ToString(); employeeObj.Emcaddr2 = dr["Emcaddr2"].ToString(); employeeObj.Emccity = dr["Emccity"].ToString(); employeeObj.Emcstate = dr["Emcstate"].ToString(); employeeObj.Emczipcode = dr["Emczipcode"].ToString(); employeeObj.Emccountry = dr["Emccountry"].ToString(); employeeObj.Emcmarital = dr["Emcmarital"].ToString(); employeeObj.Emcsex = dr["Emcsex"].ToString(); employeeObj.Emtbirth = Convert.ToDateTime(dr["Emtbirth"]); employeeObj.Emthire = Convert.ToDateTime(dr["Emthire"]); employeeObj.Emtrehire = Convert.ToDateTime(dr["Emtrehire"]); employeeObj.Emcemptype = Convert.ToString(dr["Emcemptype"]); //employeeObj.Updated_at = DateTime.Now; list.Add(employeeObj); } } } catch (Exception ex) { ExceptionHandlerController.infoMessage(ex.Message); ExceptionHandlerController.writeErrorLog(ex); } return(list); }