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