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