//linq query used to update employee details of (ImSS_Master_Emp_List)
public List <ImSS_Master_Emp_List> UpdateEmployee(ImSS_Master_Emp_List empl)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.ID == empl.ID select c).FirstOrDefault();
UpdateEmployee.Emp_Number = empl.Emp_Number;
UpdateEmployee.Emp_Name = empl.Emp_Name;
UpdateEmployee.DOJ = empl.DOJ;
UpdateEmployee.Previous_Exp = empl.Previous_Exp;
UpdateEmployee.ImSS_Exp = empl.ImSS_Exp;
UpdateEmployee.Total_Exp = empl.Total_Exp;
UpdateEmployee.Domain = empl.Domain;
UpdateEmployee.Business_Unit = empl.Business_Unit;
UpdateEmployee.Reporting = empl.Reporting;
UpdateEmployee.Primary_Skills = empl.Primary_Skills;
UpdateEmployee.Secondary_Skills = empl.Secondary_Skills;
UpdateEmployee.Category = empl.Category;
UpdateEmployee.Status = empl.Status;
UpdateEmployee.Mobile_Number = empl.Mobile_Number;
UpdateEmployee.Replaced_by = empl.Replaced_by;
UpdateEmployee.Relived_Date = empl.Relived_Date;
context.SaveChanges();
var val = (from e in context.ImSS_Emp_Details
where e.Employee_ID == empl.Emp_Number && e.Manager_ID == empl.Reporting &&
e.End_Date == null
select e).Count();
if (val == 0)
{
ImSS_Emp_Details Empdet = (from c in context.ImSS_Emp_Details where c.Employee_ID == empl.Emp_Number && c.End_Date == null select c).FirstOrDefault();
Empdet.End_Date = DateTime.Now;
ImSS_Emp_Details lst = new ImSS_Emp_Details();
lst.Start_Date = DateTime.Now;
lst.Employee_ID = empl.Emp_Number;
lst.Manager_ID = empl.Reporting;
context.ImSS_Emp_Details.Add(lst);
context.SaveChanges();
}
return((from a in context.ImSS_Master_Emp_List select a).ToList());
}
}
catch (Exception e)
{
throw e;
}
}
//linq query used to insert employee details into (ImSS_Master_Emp_List)
//public ImSS_Master_Emp_List AddEmployee(ImSS_Master_Emp_List Addemp)
//{
// try
// {
// using (var context = new Billing_StagingEntities1())
// {
// ImSS_Emp_Details lst=new ImSS_Emp_Details();
// lst.Start_Date = DateTime.Now;
// lst.Employee_ID = Addemp.Emp_Number;
// lst.Manager_ID = Addemp.Reporting;
// context.ImSS_Master_Emp_List.Add(Addemp);
// context.ImSS_Emp_Details.Add(lst);
// context.SaveChanges();
// return Addemp;
// }
// }
// catch (Exception e)
// {
// throw e;
// }
//}
public ImSS_Master_Emp_List AddEmployee(ImSS_Master_Emp_List Addemp)
{
try
{
using (var context = new Billing_StagingEntities1())
{
ImSS_Emp_Details lst = new ImSS_Emp_Details();
lst.Start_Date = DateTime.Now;
lst.Employee_ID = Addemp.Emp_Number;
lst.Manager_ID = Addemp.Reporting;
context.ImSS_Master_Emp_List.Add(Addemp);
context.ImSS_Emp_Details.Add(lst);
context.SaveChanges();
return(Addemp);
}
}
catch (Exception e)
{
throw e;
}
}
