//linq query used to insert employee details into (ImSS_Master_Emp_List) public ImSS_Master_Client AddCustomer(ImSS_Master_Client Addcust) { try { using (var context = new Billing_StagingEntities1()) { ImSS_Cust_Emp_Details lst = new ImSS_Cust_Emp_Details(); lst.Cilent_Start_Date = DateTime.Now; lst.Emp_Number = Addcust.Emp_Name; lst.Cilent_ID = Addcust.Client_Name; if (Addcust.Status == "Active") { ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.Emp_Name == Addcust.Emp_Name select c).FirstOrDefault(); UpdateEmployee.Status = "Assigned"; } context.ImSS_Master_Client.Add(Addcust); context.ImSS_Cust_Emp_Details.Add(lst); context.SaveChanges(); return(Addcust); } } catch (Exception e) { throw e; } }
//linq query used to insert employee details into (ImSS_Master_Emp_List) public ImSS_Master_Client AddCustomer(ImSS_Master_Client Addcust) { try { using (var context = new Billing_StagingEntities1()) { ImSS_Cust_Emp_Details lst = new ImSS_Cust_Emp_Details(); lst.Cilent_Start_Date = DateTime.Now; lst.Emp_Number = Addcust.Emp_Name; lst.Cilent_ID = Addcust.Client_Name; context.ImSS_Master_Client.Add(Addcust); context.ImSS_Cust_Emp_Details.Add(lst); context.SaveChanges(); return(Addcust); } } catch (Exception e) { throw e; } }
//linq query used to update employee details of (ImSS_Master_Emp_List) public List <ImSS_Master_Client> UpdateCilent(ImSS_Master_Client cust) { try { using (var context = new Billing_StagingEntities1()) { ImSS_Master_Client UpdateCustomer = (from c in context.ImSS_Master_Client where c.ID == cust.ID select c).FirstOrDefault(); UpdateCustomer.Emp_Name = cust.Emp_Name; UpdateCustomer.Client_Name = cust.Client_Name; UpdateCustomer.Email = cust.Email; UpdateCustomer.Reporting_Manager_at_client_place = cust.Reporting_Manager_at_client_place; UpdateCustomer.Shadow = cust.Shadow; UpdateCustomer.Location = cust.Location; UpdateCustomer.Status = cust.Status; if (UpdateCustomer.Status == "Active") { ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.Emp_Name == cust.Emp_Name select c).FirstOrDefault(); UpdateEmployee.Status = "Assigned"; } else { ImSS_Master_Emp_List UpdateEmployee = (from c in context.ImSS_Master_Emp_List where c.Emp_Name == cust.Emp_Name select c).FirstOrDefault(); UpdateEmployee.Status = "Avalible"; ImSS_Cust_Emp_Details Update = (from c in context.ImSS_Cust_Emp_Details where c.Emp_Number == cust.Emp_Name select c).FirstOrDefault(); Update.Cilent_End_Date = DateTime.Now; } context.SaveChanges(); return((from a in context.ImSS_Master_Client select a).ToList()); } } catch (Exception e) { throw e; } }