public List <Vehicle> GetFeaturedVehicles()
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Vehicle.Include("MakeId").Include("ModelId").Where(f => f.IsFeatured == true && !ctx.Sales.Any(s => s.VehicleId == f.VehicleId)).ToList());
}
}
public List <Vehicle> GetAll()
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Vehicle.ToList());
}
}
public List <Vehicle> GetByPrice(decimal price)
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Vehicle.Where(v => v.SalesPrice == price).ToList());
}
}
public Vehicle GetVehicleById(int id)
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Vehicle.Include("MakeId").Include("ModelId").Where(v => v.VehicleId == id).FirstOrDefault());
}
}
public List <Users> GetAllUsers()
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Users.Include("Roles").ToList());
}
}
public List <Vehicle> GetByModel(string model)
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Vehicle.Where(v => v.ModelId.ModelName == model).ToList());
}
}
public Users GetUserById(string role)
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Users.FirstOrDefault(m => m.Id == role));
}
}
public Models GetModelById(int id)
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Models.Where(m => m.ModelId == id).FirstOrDefault());
}
}
public Make GetMakeById(int id)
{
using (var ctx = new CarDealarshipEntities())
{
return(ctx.Make.Where(m => m.MakeId == id).FirstOrDefault());
}
}
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 List <Make> GetAllMakes()
{
using (var ctx = new CarDealarshipEntities())
{
var ur = ctx.Users.ToList();
var result = ctx.Make.ToList();
foreach (var r in result)
{
r.user = ctx.Users.First(u => u.Id == r.UserId);
}
//result.First().user.c
return(result.ToList());
}
}
public List <Models> GetAllModel()
{
using (var ctx = new CarDealarshipEntities())
{
var ur = ctx.Users.ToList();
var result = ctx.Models.Include("Make").ToList();
foreach (var r in result)
{
r.user = ctx.Users.First(u => u.Id == r.UserId);
}
return(ctx.Models.ToList());
}
}
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 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 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();
}
}