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