public bool PostNewMonitor(ChatbotDataModelLib.Models.CustomerData data) { PhilipsDBEntities record = new PhilipsDBEntities(); record.CustomerDatas.Add(data); record.SaveChanges(); executiveName = CheckSales(data); PatientSale patientSale = CreatePatientRecord(data); record.PatientSales.Add(patientSale); record.SaveChanges(); return(true); }
[HttpPost]//Adding public bool AddNewEmployee(Employee emp) { var context = new PhilipsDBEntities(); var empTable = emp.Convert(); context.EmpTables.Add(empTable); context.SaveChanges();//Commit the transaction and save to the DB... return(true); }
public bool PostNewSalesRep(ChatbotDataModelLib.Models.SalesRep data) { PhilipsDBEntities record = new PhilipsDBEntities(); var selected = record.SalesReps.FirstOrDefault((e) => e.City.Equals(data.City)); if (selected == null) { record.SalesReps.Add(data); record.SaveChanges(); return(true); } return(false); }
bool IChatbot.DeleteMonitor(string mod) { PhilipsDBEntities record = new PhilipsDBEntities(); var selected = record.PatientMonitors.FirstOrDefault((e) => e.Model.Equals(mod)); if (selected == null) { return(false); } record.PatientMonitors.Remove(record.PatientMonitors.FirstOrDefault(e => e.Model == mod)); record.SaveChanges(); return(true); }
bool IChatbot.PostNewMonitors(PatientMonitor newmod) { PhilipsDBEntities record = new PhilipsDBEntities(); var selected = record.PatientMonitors.FirstOrDefault((e) => e.Model.Equals(newmod.Model)); if (selected == null) { record.PatientMonitors.Add(newmod); record.SaveChanges(); return(true); } return(false); }
public bool UpdateEmployee(Employee emp) { if (emp == null) { throw new Exception("Emp Details are not set"); } var context = new PhilipsDBEntities(); var selected = context.EmpTables.FirstOrDefault(e => e.EmpID == emp.ID); if (selected == null) { throw new Exception("Not found to update"); } selected.EmpName = emp.Name; selected.EmpAddress = emp.Address; selected.EmpSalary = emp.Salary; context.SaveChanges(); return(true); }