public void Delete(int id)
{
using (var db = new SmartAutosContext())
{
Database.Vehicle vehicle = db.Vehicle.FirstOrDefault(vehicle => vehicle.Id == id);
if (vehicle != null)
{
db.Vehicle.Remove(vehicle);
db.SaveChanges();
}
}
}
public void Add(VehicleViewModel vehicleData)
{
using (var db = new SmartAutosContext())
{
Database.Vehicle vehicle = new Database.Vehicle();
vehicle.Registration = vehicleData.Registration;
vehicle.Mileage = vehicleData.Milage;
vehicle.EngineSize = vehicleData.EngineSize;
vehicle.Colour = vehicleData.ColourId;
vehicle.Model = vehicleData.ModelId;
db.Vehicle.Add(vehicle);
db.SaveChanges();
}
}
public void Update(VehicleViewModel vehicleData)
{
using (var db = new SmartAutosContext())
{
Database.Vehicle vehicle = db.Vehicle.FirstOrDefault(vehicle => vehicle.Id == vehicleData.Id);
if (vehicle != null)
{
vehicle.Registration = vehicleData.Registration;
vehicle.Mileage = vehicleData.Milage;
vehicle.EngineSize = vehicleData.EngineSize;
vehicle.Colour = vehicleData.ColourId;
vehicle.Model = vehicleData.ModelId;
db.SaveChanges();
}
else
{
throw new Exception("Vehicle not found");
}
}
}
