public void postWork(Models.WorkListModel value) { var db = new MyDBModels.DB(); MyDBModels.WorkList workList = new MyDBModels.WorkList(); workList.DriverId = value.DriverId; workList.BusId = value.BusId; workList.SecondNameDispatcher = value.SecondNameDispatcher; workList.DateAction = value.DateAction; db.workList.Add(workList); MyDBModels.Bus busModel = db.bus.Where(b => b.BusId == value.BusId).FirstOrDefault(); string title = "Bus: " + busModel.BusNumber.ToString() + "/" + busModel.Model; string info = "Date: " + value.DateAction + "\nDispatcher: " + value.SecondNameDispatcher; string number = EncryptClass.DESEncrypt(db.driver.Where(b => b.DriverId == value.DriverId).FirstOrDefault().DriverNumber.ToString()); MyDBModels.Account accountModel = db.account.Where(b => b.NumberWorker == number).FirstOrDefault(); string token = accountModel.Token; sendRequestToFirebase("\"" + title + "\"", "\"" + info + "\"", "\"" + token + "\""); db.SaveChanges(); }
public MyDBModels.Bus getDataById(int id) { var db = new MyDBModels.DB(); MyDBModels.Bus busModel = db.bus.Where(b => b.BusId == id).FirstOrDefault(); return(busModel); }
// DELETE api/values/ public void Delete(int id) { var db = new MyDBModels.DB(); MyDBModels.Bus bus = db.bus.Where(b => b.BusId == id).FirstOrDefault(); if (bus != null) { db.bus.Remove(bus); db.SaveChanges(); } }
// POST api/values public void Post(Models.BusModel newbus) { var db = new MyDBModels.DB(); MyDBModels.Bus bus = new MyDBModels.Bus(); bus.BusCondition = newbus.Condition; bus.BusNumber = newbus.BusNomber; bus.Model = newbus.Model; db.bus.Add(bus); db.SaveChanges(); }
public MyDBModels.Bus logicMethodForGetData(int id) { MyDBModels.Bus data = dataAccess.getDataById(id); return(data); }