Exemplo n.º 1
0
 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();
         }
     }
 }
Exemplo n.º 2
0
        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();
            }
        }
Exemplo n.º 3
0
 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");
         }
     }
 }