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