public string EditVehicle(VehicleModel vehicle)
{
using (var db = new FleetManagementDb())
{
db.spEditVehicle(vehicle.Id, vehicle.Plate, vehicle.Make, vehicle.Mode, vehicle.Year = DateTime.Now, vehicle.DriverName);
return("success");
}
}
public string DeleteVehicle(int id)
{
using (var db = new FleetManagementDb())
{
db.spDeleteVehicle(id);
return("success");
}
}
public VehicleModel GetCurrentVehicle(int id)
{
using (var db = new FleetManagementDb())
{
var result = db.spGetCurrentVehicle(id).Select(a => new VehicleModel
{
Id = a.Id,
DriverName = a.Driver,
Make = a.Make,
Mode = a.Mode,
Plate = a.Rego,
Year = (DateTime)a.CreateDate
}).FirstOrDefault();
return(result);
}
}
public List <VehicleModel> GetAllVehicles()
{
using (var db = new FleetManagementDb())
{
var result = db.spGetAllVehicles()
.Select(a => new VehicleModel
{
Id = a.Id,
DriverName = a.Driver,
Make = a.Make,
Mode = a.Mode,
Plate = a.Rego,
Year = (DateTime)a.CreateDate
}).OrderByDescending(a => a.Year).ToList();
return(result);
}
}
