public void EditVehicle(Vehicle car) { using (var ctx = new CarDealarshipEntities()) { var original = ctx.Vehicle.FirstOrDefault(m => m.VehicleId == car.VehicleId); original.ModelId = ctx.Models.FirstOrDefault(m => m.ModelId == car.ModelId.ModelId); original.MakeId = ctx.Make.FirstOrDefault(m => m.MakeId == car.MakeId.MakeId); original.Color = car.Color; original.Description = car.Description; original.Color = car.Color; original.Interior = car.Interior; original.IsNew = car.IsNew; original.Mileage = car.Mileage; original.MSRP = car.MSRP; original.Transmission = car.Transmission; original.Year = car.Year; original.VinNumber = car.VinNumber; original.SalesPrice = car.SalesPrice; original.Description = car.Description; original.VehicleType = car.VehicleType; original.VehicleId = car.VehicleId; original.ImageFileName = "Images/" + car.ImageFileName; ctx.SaveChanges(); } }
public void DeleteSpecial(int specialId) { Specials sp = context.Specials.Find(specialId); context.Specials.Remove(sp); context.SaveChanges(); }
public void AddContactUs(ContactUs contact) { using (var ctx = new CarDealarshipEntities()) { if (ctx.ContactUs.Count() == 0) { contact.ContactUsId = 1; } else { contact.ContactUsId = ctx.ContactUs.Max(c => c.ContactUsId) + 1; } ctx.ContactUs.Add(contact); ctx.SaveChanges(); } }
public void AddModel(Models newModel) { using (var ctx = new CarDealarshipEntities()) { if (ctx.Models.Count() == 0) { newModel.ModelId = 1; } else { newModel.ModelId = ctx.Models.Max(m => m.ModelId) + 1; } ctx.Models.Add(newModel); ctx.SaveChanges(); } }
public void AddSpecial(Specials special) { using (var ctx = new CarDealarshipEntities()) { if (ctx.Specials.Count() == 0) { special.SpecialId = 1; } else { special.SpecialId = ctx.Specials.Max(m => m.SpecialId) + 1; } ctx.Specials.Add(special); ctx.SaveChanges(); } }
public void PurchaseVehicle(Sales sale) { using (var ctx = new CarDealarshipEntities()) { if (ctx.Sales.Count() == 0) { sale.SaleId = 1; } else { sale.SaleId = ctx.Sales.Max(s => s.SaleId) + 1; } ctx.Sales.Add(sale); ctx.SaveChanges(); } }
public void AddMake(Make newMake) { using (var ctx = new CarDealarshipEntities()) { if (ctx.Make.Count() == 0) { newMake.MakeId = 1; } else { newMake.MakeId = ctx.Make.Max(m => m.MakeId) + 1; } ctx.Make.Add(newMake); ctx.SaveChanges(); } }
public void AddVehicle(Vehicle car) { using (var ctx = new CarDealarshipEntities()) { if (ctx.Vehicle.Count() == 0) { car.VehicleId = 1; } else { car.VehicleId = ctx.Vehicle.Include("MakeId").Include("ModelId").Max(v => v.VehicleId) + 1; } ctx.Vehicle.Add(car); ctx.SaveChanges(); } }