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