public ActionResult Search() { CarViewModel carViewModel = new CarViewModel(); var carRepo = GuildRepositoryFactory.GetRepository(); var carList = carRepo.GetAllCars(); List <CarViewModel> carVMList = carList.Select(x => new CarViewModel { CarID = x.CarID, Year = x.Year, MakeName = x.Make.MakeName, ModelName = x.Model.ModelName, BodyStyleName = x.BodyStyle.BodyStyleName, TransmissionType = x.Transmission.TransmissionType, ExteriorColorName = x.ExteriorColor.Color, InteriorColorName = x.InteriorColor.Color, Mileage = x.Mileage, VIN = x.VIN, SalePrice = x.SalePrice, MSRP = x.MSRP, ImageFileName = x.Photo }).ToList(); return(View(carVMList)); }
public ActionResult Add() { var model = new CarAddViewModel(); var carRepo = GuildRepositoryFactory.GetRepository(); var makesRepo = MakeFactory.GetRepository(); var modelRepo = ModelFactory.GetRepository(); var typesRepo = ConditionFactory.GetRepository(); var bodyStylesRepo = BodyStyleFactory.GetRepository(); var transmissionsRepo = TransmissionFactory.GetRepository(); var extColorsRepo = ExteriorColorFactory.GetRepository(); var intColorsRepo = InteriorColorFactory.GetRepository(); CarAddViewModel viewModel = new CarAddViewModel { Makes = makesRepo.GetMakes(), Models = modelRepo.GetModels(), Types = typesRepo.GetConditions(), BodyStyles = bodyStylesRepo.GetBodyStyles(), Transmissions = transmissionsRepo.GetTransmissions(), ExteriorColors = extColorsRepo.GetExteriorColors(), InteriorColors = intColorsRepo.GetInteriorColors() }; return(View(viewModel)); }
public ActionResult Index() { CarViewModel model = new CarViewModel(); var carRepo = GuildRepositoryFactory.GetRepository(); var makesRepo = MakeFactory.GetRepository(); var modelRepo = ModelFactory.GetRepository(); var typesRepo = ConditionFactory.GetRepository(); var bodyStylesRepo = BodyStyleFactory.GetRepository(); var transmissionsRepo = TransmissionFactory.GetRepository(); var extColorsRepo = ExteriorColorFactory.GetRepository(); var intColorsRepo = InteriorColorFactory.GetRepository(); List <Car> carList = carRepo.GetAllCars(); List <CarViewModel> carVMList = carList.Select(x => new CarViewModel { CarID = x.CarID, MakeID = x.MakeID, MakeName = makesRepo.GetMakeById(x.MakeID).MakeName, ModelID = x.ModelID, ModelName = modelRepo.GetModelById(x.ModelID).ModelName, Year = x.Year, MSRP = x.MSRP, SalePrice = x.SalePrice, ImageFileName = x.Photo }).ToList(); /*foreach (var car in carList) * { * }*/ return(View(carVMList)); }
public ActionResult Index() { CarViewModel carViewModel = new CarViewModel(); var carRepo = GuildRepositoryFactory.GetRepository(); return(View()); }
public ActionResult Details(int id) { CarViewModel carViewModel = new CarViewModel(); var carRepo = GuildRepositoryFactory.GetRepository(); var makesRepo = MakeFactory.GetRepository(); var modelRepo = ModelFactory.GetRepository(); var typesRepo = ConditionFactory.GetRepository(); var bodyStylesRepo = BodyStyleFactory.GetRepository(); var transmissionsRepo = TransmissionFactory.GetRepository(); var extColorsRepo = ExteriorColorFactory.GetRepository(); var intColorsRepo = InteriorColorFactory.GetRepository(); var transactionRepo = TransactionFactory.GetRepository(); var carsInStock = carRepo.GetAllCars(); var isInStock = carsInStock.Where(x => x.CarID == id).Select(x => x.IsInStock).FirstOrDefault(); if (isInStock) { carViewModel.IsBought = true; } var carvm = carRepo.GetCarById(id); carViewModel.CarID = carvm.CarID; carViewModel.Year = carvm.Year; carViewModel.Make = new Make(); carViewModel.Make.MakeID = carvm.MakeID; carViewModel.MakeName = makesRepo.GetMakeById(carvm.MakeID).MakeName; carViewModel.Model = new Model(); carViewModel.Model.ModelID = carvm.ModelID; carViewModel.ModelName = modelRepo.GetModelById(carvm.ModelID).ModelName; carViewModel.BodyStyle = new BodyStyle(); carViewModel.BodyStyleID = carvm.BodyStyleID; carViewModel.BodyStyleName = bodyStylesRepo.GetBodyStyleById(carvm.BodyStyleID).BodyStyleName; carViewModel.Transmission = new Transmission(); carViewModel.TransmissionID = carvm.TransmissionID; carViewModel.TransmissionType = transmissionsRepo.GetTransmissionById(carvm.TransmissionID).TransmissionType; carViewModel.ExteriorColor = new ExteriorColor(); carViewModel.ExteriorColorID = carvm.ExteriorColorID; carViewModel.ExteriorColorName = extColorsRepo.GetExteriorColorById(carvm.ExteriorColorID).Color; carViewModel.InteriorColor = new InteriorColor(); carViewModel.InteriorColorID = carvm.InteriorColorID; carViewModel.InteriorColorName = intColorsRepo.GetInteriorColorById(carvm.InteriorColorID).Color; carViewModel.Mileage = carvm.Mileage; carViewModel.VIN = carvm.VIN; carViewModel.SalePrice = carvm.SalePrice; carViewModel.MSRP = carvm.MSRP; carViewModel.ImageFileName = carvm.Photo; carViewModel.Description = carvm.Description; return(View(carViewModel)); }
public IHttpActionResult Search([FromUri] ListingSearchParameters parameters) { var repo = GuildRepositoryFactory.GetRepository(); try { var result = repo.Search(parameters); return(Ok(result)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult Edit(CarEditViewModel model) { if (ModelState.IsValid) { var carRepo = GuildRepositoryFactory.GetRepository(); carRepo.UpdateCar(model.Car); return(RedirectToAction("Vehicles")); } else { return(View(model.Car)); } }
public ActionResult Edit(int id) { var carViewModel = new CarEditViewModel(); var carRepo = GuildRepositoryFactory.GetRepository(); var makesRepo = MakeFactory.GetRepository(); var modelRepo = ModelFactory.GetRepository(); var typesRepo = ConditionFactory.GetRepository(); var bodyStylesRepo = BodyStyleFactory.GetRepository(); var transmissionsRepo = TransmissionFactory.GetRepository(); var extColorsRepo = ExteriorColorFactory.GetRepository(); var intColorsRepo = InteriorColorFactory.GetRepository(); var carvm = carRepo.GetCarById(id); carViewModel.CarID = carvm.CarID; carViewModel.Year = carvm.Year; carViewModel.Make = new Make(); carViewModel.Makes = makesRepo.GetMakes(); carViewModel.MakesID = carvm.MakeID; carViewModel.Model = new Model(); carViewModel.Models = modelRepo.GetModels(); carViewModel.ModelsID = carvm.ModelID; carViewModel.Condition = new Condition(); carViewModel.ConditionTypes = typesRepo.GetConditions(); carViewModel.ConditionTypesID = carvm.ConditionID; carViewModel.BodyStyle = new BodyStyle(); carViewModel.BodyStyles = bodyStylesRepo.GetBodyStyles(); carViewModel.BodyStylesID = carvm.BodyStyleID; carViewModel.Transmission = new Transmission(); carViewModel.Transmissions = transmissionsRepo.GetTransmissions(); carViewModel.TransmissionsID = carvm.TransmissionID; carViewModel.ExteriorColor = new ExteriorColor(); carViewModel.ExteriorColors = extColorsRepo.GetExteriorColors(); carViewModel.ExteriorColorsID = carvm.ExteriorColorID; carViewModel.InteriorColor = new InteriorColor(); carViewModel.InteriorColors = intColorsRepo.GetInteriorColors(); carViewModel.InteriorColorsID = carvm.InteriorColorID; carViewModel.Mileage = carvm.Mileage; carViewModel.VIN = carvm.VIN; carViewModel.SalePrice = carvm.SalePrice; carViewModel.MSRP = carvm.MSRP; carViewModel.ImageFileName = carvm.Photo; carViewModel.Description = carvm.Description; return(View(carViewModel)); }
public ActionResult Inventory() { if (ModelState.IsValid) { InventoryViewModel inventoryViewModel = new InventoryViewModel(); var inventoryRepo = GuildRepositoryFactory.GetRepository(); var makesRepo = MakeFactory.GetRepository(); var modelRepo = ModelFactory.GetRepository(); List <Car> carList = inventoryRepo.GetAllCars(); List <Car> newCarList = carList.Where(x => x.Mileage == "New").ToList(); List <InventoryViewModel> newGroupCars = newCarList.GroupBy(x => (x.Year, makesRepo.GetMakeById(x.MakeID).MakeName, modelRepo.GetModelById(x.ModelID).ModelName)) .Select(b => new InventoryViewModel { Year = b.Key.Year.ToString(), Make = b.Key.MakeName, Model = b.Key.ModelName, Count = b.Count(), StockValue = b.Sum(bn => bn.SalePrice).ToString() }).ToList(); var usedCarList = carList.Where(x => x.Mileage != "New").ToList(); List <InventoryViewModel> usedGroupCars = usedCarList.GroupBy(x => (x.Year, makesRepo.GetMakeById(x.MakeID).MakeName, modelRepo.GetModelById(x.ModelID).ModelName)) .Select(b => new InventoryViewModel { Year = b.Key.Year.ToString(), Make = b.Key.MakeName, Model = b.Key.ModelName, Count = b.Count(), StockValue = b.Sum(bn => bn.SalePrice).ToString() }).ToList(); var model = new GroupedInventoryViewModel { NewVehicles = newGroupCars, UsedVehicles = usedGroupCars }; return(View(model)); } return(View()); }
protected override void Seed(GuildCars.UI.Models.ApplicationDbContext context) { //AspNetRoles table if (!context.Roles.Any(r => r.Name == "Administrator")) { var store = new RoleStore <IdentityRole>(context); var manager = new RoleManager <IdentityRole>(store); var role = new IdentityRole { Name = "Administrator" }; manager.Create(role); } //AspNetUsers table if (!context.Users.Any(u => u.UserName == "*****@*****.**")) { var passwordHasher = new PasswordHasher(); var store = new UserStore <ApplicationUser>(context); var manager = new UserManager <ApplicationUser>(store); var user = new ApplicationUser { FirstName = "Bob", LastName = "Guild", UserName = "******", Email = "*****@*****.**", PasswordHash = passwordHasher.HashPassword("Pa$$w0rd1"), RoleID = 2 // User = 1, Admin = 2 }; manager.Create(user); manager.AddToRole(user.Id, "Administrator"); } if (context.States.Count() == 0) { var statesRepo = StateFactory.GetRepository(); IList <State> statesToAdd = new List <State>(); foreach (var state in statesRepo.GetStates()) { statesToAdd.Add(state); } context.States.AddRange(statesToAdd); base.Seed(context); } if (context.Makes.Count() == 0) { var makesRepo = MakeFactory.GetRepository(); IList <Make> makesToAdd = new List <Make>(); foreach (var make in makesRepo.GetMakes()) { makesToAdd.Add(make); } context.Makes.AddRange(makesToAdd); base.Seed(context); } if (context.Models.Count() == 0) { var modelsRepo = ModelFactory.GetRepository(); IList <Model> modelsToAdd = new List <Model>(); foreach (var model in modelsRepo.GetModels()) { modelsToAdd.Add(model); } context.Models.AddRange(modelsToAdd); base.Seed(context); } if (context.BodyStyles.Count() == 0) { var bodyStylesRepo = BodyStyleFactory.GetRepository(); IList <BodyStyle> bodyStylesToAdd = new List <BodyStyle>(); foreach (var bodyStyle in bodyStylesRepo.GetBodyStyles()) { bodyStylesToAdd.Add(bodyStyle); } context.BodyStyles.AddRange(bodyStylesToAdd); base.Seed(context); } if (context.Conditions.Count() == 0) { var conditionsRepo = ConditionFactory.GetRepository(); IList <Condition> conditionsToAdd = new List <Condition>(); foreach (var condition in conditionsRepo.GetConditions()) { conditionsToAdd.Add(condition); } context.Conditions.AddRange(conditionsToAdd); base.Seed(context); } if (context.ExteriorColors.Count() == 0) { var extColorsRepo = ExteriorColorFactory.GetRepository(); IList <ExteriorColor> extColorsToAdd = new List <ExteriorColor>(); foreach (var extColor in extColorsRepo.GetExteriorColors()) { extColorsToAdd.Add(extColor); } context.ExteriorColors.AddRange(extColorsToAdd); base.Seed(context); } if (context.ExteriorColors.Count() == 0) { var extColorsRepo = ExteriorColorFactory.GetRepository(); IList <ExteriorColor> extColorsToAdd = new List <ExteriorColor>(); foreach (var extColor in extColorsRepo.GetExteriorColors()) { extColorsToAdd.Add(extColor); } context.ExteriorColors.AddRange(extColorsToAdd); base.Seed(context); } if (context.InteriorColors.Count() == 0) { var intColorsRepo = InteriorColorFactory.GetRepository(); IList <InteriorColor> intColorsToAdd = new List <InteriorColor>(); foreach (var intColor in intColorsRepo.GetInteriorColors()) { intColorsToAdd.Add(intColor); } context.InteriorColors.AddRange(intColorsToAdd); base.Seed(context); } if (context.PurchaseTypes.Count() == 0) { var purchaseTypesRepo = PurchaseTypeFactory.GetRepository(); IList <PurchaseType> purchaseTypesToAdd = new List <PurchaseType>(); foreach (var purchaseType in purchaseTypesRepo.GetPurchaseTypes()) { purchaseTypesToAdd.Add(purchaseType); } context.PurchaseTypes.AddRange(purchaseTypesToAdd); base.Seed(context); } if (context.Specials.Count() == 0) { var specialsRepo = SpecialsFactory.GetRepository(); IList <Specials> specialsToAdd = new List <Specials>(); foreach (var special in specialsRepo.GetSpecials()) { specialsToAdd.Add(special); } context.Specials.AddRange(specialsToAdd); base.Seed(context); } if (context.Transmissions.Count() == 0) { var transmissionsRepo = TransmissionFactory.GetRepository(); IList <Transmission> transmissionsToAdd = new List <Transmission>(); foreach (var special in transmissionsRepo.GetTransmissions()) { transmissionsToAdd.Add(special); } context.Transmissions.AddRange(transmissionsToAdd); base.Seed(context); } if (context.Cars.Count() == 0) { var carsRepo = GuildRepositoryFactory.GetRepository(); IList <Car> carsToAdd = new List <Car>(); foreach (var car in carsRepo.GetAllCars()) { carsToAdd.Add(car); } context.Cars.AddRange(carsToAdd); base.Seed(context); } if (context.GuildRoles.Count() == 0) { var rolesRepo = RoleFactory.GetRepository(); IList <GuildRole> rolesToAdd = new List <GuildRole>(); foreach (var role in rolesRepo.GetRoles()) { rolesToAdd.Add(role); } context.GuildRoles.AddRange(rolesToAdd); base.Seed(context); } }
public ActionResult Add(CarAddViewModel model) { if (ModelState.IsValid) { var carRepo = GuildRepositoryFactory.GetRepository(); var makesRepo = MakeFactory.GetRepository(); var modelRepo = ModelFactory.GetRepository(); var typesRepo = ConditionFactory.GetRepository(); var bodyStylesRepo = BodyStyleFactory.GetRepository(); var transmissionsRepo = TransmissionFactory.GetRepository(); var extColorsRepo = ExteriorColorFactory.GetRepository(); var intColorsRepo = InteriorColorFactory.GetRepository(); try { model.Car.UserID = AuthorizeUtilities.GetUserId(this); model.Car.BodyStyle = new BodyStyle(); model.Car.BodyStyle.BodyStyleID = model.Car.BodyStyleID; model.Car.BodyStyle.BodyStyleName = bodyStylesRepo.GetBodyStyleById(model.Car.BodyStyleID).BodyStyleName; model.Car.Condition = new Condition(); model.Car.Condition.ConditionID = model.Car.ConditionID; model.Car.Condition.ConditionType = typesRepo.GetConditionById(model.Car.ConditionID).ConditionType; model.Car.ExteriorColor = new ExteriorColor(); model.Car.ExteriorColor.ExteriorColorID = model.Car.ExteriorColorID; model.Car.ExteriorColor.Color = extColorsRepo.GetExteriorColorById(model.Car.ExteriorColorID).Color; model.Car.InteriorColor = new InteriorColor(); model.Car.InteriorColor.InteriorColorID = model.Car.InteriorColorID; model.Car.InteriorColor.Color = intColorsRepo.GetInteriorColorById(model.Car.InteriorColorID).Color; model.Car.Make = new Make(); model.Car.Make.MakeID = model.Car.MakeID; model.Car.Make.MakeName = makesRepo.GetMakeById(model.Car.MakeID).MakeName; model.Car.Make.DateAdded = DateTime.Now.ToString("MM/dd/yyyy"); model.Car.Make.UserID = model.Car.UserID; model.Car.Model = new Model(); model.Car.Model.ModelID = model.Car.ModelID; model.Car.Model.MakeID = model.Car.MakeID; model.Car.Model.ModelName = modelRepo.GetModelById(model.Car.ModelID).ModelName; model.Car.Model.DateAdded = DateTime.Now.ToString("MM/dd/yyyy"); model.Car.Model.UserID = model.Car.UserID; model.Car.DateAdded = DateTime.Now.ToString("MM/dd/yyyy"); model.Car.Transmission = new Transmission(); model.Car.Transmission.TransmissionID = model.Car.TransmissionID; model.Car.Transmission.TransmissionType = transmissionsRepo.GetTransmissionById(model.Car.TransmissionID).TransmissionType; if (model.ImageUpload != null && model.ImageUpload.ContentLength > 0) { var savepath = Server.MapPath("~/Images"); string fileName = Path.GetFileNameWithoutExtension(model.ImageUpload.FileName); string extension = Path.GetExtension(model.ImageUpload.FileName); var filePath = Path.Combine(savepath, fileName + extension); /*int counter = 1; * while (System.IO.File.Exists(filePath)) * { * filePath = Path.Combine(savepath, fileName + counter.ToString() + extension); * counter++; * }*/ model.ImageUpload.SaveAs(filePath); model.Car.Photo = Path.GetFileName(filePath); } carRepo.InsertCar(model.Car); bodyStylesRepo.InsertBodyStyle(model.Car.BodyStyle); typesRepo.InsertCondition(model.Car.Condition); extColorsRepo.InsertExteriorColor(model.Car.ExteriorColor); intColorsRepo.InsertInteriorColor(model.Car.InteriorColor); makesRepo.InsertMake(model.Car.Make); modelRepo.InsertModel(model.Car.Model); transmissionsRepo.InsertTransmission(model.Car.Transmission); /*if (Settings.GetRepositoryType() == "EF") * { * _context.Cars.Add(model.Car); * * if (model.Car == null) * model.Car = new Car(); * * _context.SaveChanges(); * } * else * { * carRepo.InsertCar(model.Car); * bodyStylesRepo.InsertBodyStyle(model.Car.BodyStyle); * typesRepo.InsertCondition(model.Car.Condition); * extColorsRepo.InsertExteriorColor(model.Car.ExteriorColor); * intColorsRepo.InsertInteriorColor(model.Car.InteriorColor); * makesRepo.InsertMake(model.Car.Make); * modelRepo.InsertModel(model.Car.Model); * transmissionsRepo.InsertTransmission(model.Car.Transmission); * }*/ return(RedirectToAction("Vehicles")); } catch (Exception ex) { throw ex; } } else { return(View(model)); } }