public MyDBModels.GasList getDataById(int id)
{
var db = new MyDBModels.DB();
MyDBModels.GasList gasModel = db.gasList.Where(b => b.GasListId == id).FirstOrDefault();
return(gasModel);
}
// DELETE api/values/
public void Delete(int id)
{
var db = new MyDBModels.DB();
MyDBModels.GasList gasList = db.gasList.Where(gl => gl.GasListId == id).FirstOrDefault();
if (gasList != null)
{
db.gasList.Remove(gasList);
db.SaveChanges();
}
}
// POST api/values
public void Post(Models.GasListModel value)
{
var db = new MyDBModels.DB();
MyDBModels.GasList gasList = new MyDBModels.GasList();
gasList.BusId = value.BusId;
gasList.CostGas = value.CostGas;
gasList.CountLitre = value.CountLitre;
gasList.TimeGet = value.TimeGet;
db.gasList.Add(gasList);
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.GasList logicMethodForGetData(int id)
{
MyDBModels.GasList data = dataAccess.getDataById(id);
return(data);
}
