public MyDBModels.WorkList getDataById(int id)
{
var db = new MyDBModels.DB();
MyDBModels.WorkList workModel = db.workList.Where(b => b.WorkListId == id).FirstOrDefault();
return(workModel);
}
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 void deleteWork(int id)
{
var db = new MyDBModels.DB();
MyDBModels.WorkList workList = db.workList.Where(wl => wl.WorkListId == id).FirstOrDefault();
if (workList != null)
{
db.workList.Remove(workList);
db.SaveChanges();
}
}
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);
db.SaveChanges();
}
public void postRepair(Models.RepairListModel value, int number)
{
var db = new MyDBModels.DB();
int idDriver = db.driver.Where(d => d.DriverNumber == number).FirstOrDefault().DriverId;
MyDBModels.WorkList work = db.workList.Where(d => d.DriverId == idDriver && d.DateAction == value.TimeGet).FirstOrDefault();
MyDBModels.RepairList repairList = new MyDBModels.RepairList();
repairList.BusId = work.BusId;
repairList.BusCondition = value.BusCondition;
repairList.TimeGet = value.TimeGet;
db.repairList.Add(repairList);
db.SaveChanges();
}
public void postGas(Models.GasListModel value, int number)
{
var db = new MyDBModels.DB();
int idDriver = db.driver.Where(d => d.DriverNumber == number).FirstOrDefault().DriverId;
MyDBModels.WorkList work = db.workList.Where(d => d.DriverId == idDriver && d.DateAction == value.TimeGet).FirstOrDefault();
MyDBModels.GasList gasList = new MyDBModels.GasList();
gasList.BusId = work.BusId;
gasList.CostGas = value.CostGas;
gasList.CountLitre = value.CountLitre;
gasList.TimeGet = value.TimeGet;
gasList.TypeGas = value.TypeGas;
db.gasList.Add(gasList);
db.SaveChanges();
}
public MyDBModels.WorkList logicMethodForGetData(int id)
{
MyDBModels.WorkList data = dataAccess.getDataById(id);
return(data);
}
public MyDBModels.WorkList logicMethodForGetWorkListByDate(DateTime dateAction)
{
MyDBModels.WorkList data = dataAccess.getWorkListByDate(dateAction);
return(data);
}
