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"); } } }