public ActionResult EditVehicle(int id) { var model = new EditVehicleViewModel(); var makeRepo = new MakeRepositoryADO(); var modelRepo = new ModelRepositoryADO(); var typeRepo = new TypeRepositoryADO(); var bodystyleRepo = new BodyStyleRepositoryADO(); var transmissionRepo = new TransmissionRepositoryADO(); var colorRepo = new ColorRepositoryADO(); var interiorRepo = new InteriorRepositoryADO(); var vehicleRepo = new VehicleRepositoryADO(); model.Makes = new SelectList(makeRepo.GetAll(), "MakeID", "MakeName"); model.Models = new SelectList(modelRepo.GetAll(), "ModelID", "ModelName"); model.Types = new SelectList(modelRepo.GetAll(), "TypeID", "TypeName"); model.BodyStyles = new SelectList(modelRepo.GetAll(), "BodyID", "BodyStyleName"); model.Transmissions = new SelectList(modelRepo.GetAll(), "TransmissionID", "TransmissionType"); model.Colors = new SelectList(modelRepo.GetAll(), "ColorID", "ColorName"); model.Interiors = new SelectList(modelRepo.GetAll(), "InteriorID", "InteriorColor"); model.Vehicle = vehicleRepo.GetByID(id); return(View(model)); }
public void ADOCanDeleteVehicle() { var repo = new VehicleRepositoryADO(); var vehicle = new Vehicle(); vehicle.ModelId = 9; vehicle.BodyStyleId = 4; vehicle.InteriorColorId = 2; vehicle.ExteriorColorId = 5; vehicle.SaleId = null; vehicle.IsUsed = true; vehicle.IsAutomatic = false; vehicle.IsFeatured = false; vehicle.UserId = "00000000-0000-0000-0000-000000000000"; vehicle.VIN = "9012345678ABCDEFG"; vehicle.Description = "Added vehicle"; vehicle.Image = "added.jpg"; vehicle.SalePrice = 15000m; vehicle.MSRP = 16000m; vehicle.Mileage = 90000m; repo.Insert(vehicle); var loaded = repo.GetById(3); Assert.IsNotNull(loaded); repo.Delete(3); loaded = repo.GetById(3); Assert.IsNull(loaded); }
public static void CanCreateAndDeleteVehicle() { VehicleRepositoryADO repo = new VehicleRepositoryADO(); Vehicle vehicle = new Vehicle() { Vin = "0000000000", Color = "Blue", Description = "Notes and stuff", Interior = "Black", Style = "Car", MakeId = 1, ModelId = 1, Mileage = 500, MSRP = 15000M, SalePrice = 12000M, Sold = false, Transmission = "Auto", Type = "New", Year = 2015 }; var createdvehicle = repo.Create(vehicle); Assert.AreNotEqual(null, createdvehicle); var resultId = createdvehicle.VehicleId; repo.Delete(resultId); var deletedVehicle = repo.GetById(resultId); Assert.AreEqual(null, deletedVehicle.Vin); }
public void CanAddVehicle() { Vehicle vehicleToAdd = new Vehicle(); var repo = new VehicleRepositoryADO(); vehicleToAdd.VehicleYear = 2016; vehicleToAdd.MakeID = 3; vehicleToAdd.ModelID = 1; vehicleToAdd.Price = 24000; vehicleToAdd.Mileage = 1000; vehicleToAdd.Vin = "1GNDU23W27D181467"; vehicleToAdd.MSRP = 26000; vehicleToAdd.VehicleDescription = "Beauty"; vehicleToAdd.VehicleType = "New"; vehicleToAdd.ImageFileName = "placeholder.png"; vehicleToAdd.BodyStyleID = 1; vehicleToAdd.TransmissionID = 2; vehicleToAdd.BodyColorID = 3; vehicleToAdd.InteriorColorID = 2; vehicleToAdd.SaleStatus = true; vehicleToAdd.IsFeatured = true; repo.Insert(vehicleToAdd); Assert.AreEqual(9, vehicleToAdd.VehicleID); }
public static void zCanGetFeatures() { VehicleRepositoryADO repo = new VehicleRepositoryADO(); var result = repo.GetAllFeatures(); Assert.GreaterOrEqual(1, result.features.Count); }
public void NotFoundVehicleReturnsNull() { var repo = new VehicleRepositoryADO(); var vehicle = repo.GetbyId(1000000); Assert.IsNull(vehicle); }
public ActionResult Purchase(SalesIndexPuchaseCM form) { if (ModelState.IsValid) { Purchases purchase = new Purchases(); var repo = new PurchaseRepositoryADO(); var vRepo = new VehicleRepositoryADO(); purchase.VehicleId = form.VehicleId; purchase.Phone = form.Phone; purchase.Email = form.Email; purchase.StreetOne = form.StreetOne; purchase.StreetTwo = form.StreetTwo; purchase.City = form.City; purchase.ZipCode = form.Zipcode; purchase.State = form.State; purchase.PurchasePrice = form.PurchasePrice; purchase.PurchaseType = form.PurchaseType; purchase.EmployeeId = form.EmployeeId; repo.CreatePurchase(purchase); return(RedirectToAction("Index")); } else { SalesIndexPuchaseVM VM = new SalesIndexPuchaseVM(); var vehicle = new VehicleRepositoryADO(); VM.Vehicles = vehicle.ReadAllVehicle(); VM.Form = form; return(View(VM)); } }
public ActionResult Purchase(int id) { SalesIndexPuchaseVM VM = new SalesIndexPuchaseVM(); var vehicle = new VehicleRepositoryADO(); var vehicles = vehicle.ReadByVehicleId(id); VM.Make = vehicles.MakeId.ToString(); VM.Make = vehicles.Make; VM.Model = vehicles.ModelId.ToString(); VM.Model = vehicles.Model; VM.Type = vehicles.Type; VM.BodyStyle = vehicles.BodyStyle; VM.Year = vehicles.Year; VM.Transmission = vehicles.Transmission; VM.Color = vehicles.Color; VM.Interior = vehicles.Interior; VM.Mileage = vehicles.Mileage; VM.Vin = vehicles.Vin; VM.Msrp = vehicles.Msrp; VM.SalePrice = vehicles.SalePrice; VM.Description = vehicles.Description; VM.States(); VM.PurchaseTypes(); return(View(VM)); }
public static void CanFailCreateVehicle12() { VehicleRepositoryADO repo = new VehicleRepositoryADO(); Vehicle vehicle = new Vehicle() { Vin = "0000000000", Color = "Blue", Description = "Notes and stuff", Style = "Car", Interior = "Black", MakeId = 1, ModelId = 1, Mileage = 500, MSRP = 15000M, SalePrice = 12000M, Sold = false, Transmission = "Auto", Type = "New", Year = 2050 }; var createdvehicle = repo.Create(vehicle); Assert.AreEqual(null, createdvehicle); }
public void CanAddVehicle() { var vehicle = new Vehicle(); vehicle.MakeID = 1; vehicle.ModelID = 1; vehicle.TypeID = 1; vehicle.Year = 2020; vehicle.TransmissionID = 1; vehicle.ColorID = 1; vehicle.InteriorID = 1; vehicle.BodyStyleID = 1; vehicle.Mileage = 50; vehicle.VIN = "A12B"; vehicle.MSRP = 20000; vehicle.SalePrice = 18000; vehicle.Description = "This real-deal is a complete steal!"; vehicle.ImageFileName = "placeholder.png"; // vehicle.Featured = false; var repo = new VehicleRepositoryADO(); repo.Add(vehicle); Assert.AreEqual(8, vehicle.ID); }
public void CanDeleteVehicle() { Vehicle vehicleToAdd = new Vehicle(); var repo = new VehicleRepositoryADO(); vehicleToAdd.VIN = "9870987fhej320nf"; vehicleToAdd.ModelID = 1; vehicleToAdd.ConditionID = 1; vehicleToAdd.VehicleTypeID = 1; vehicleToAdd.Year = "2018"; vehicleToAdd.TransmissionTypeID = 1; vehicleToAdd.CarColor = 1; vehicleToAdd.Interior = 1; vehicleToAdd.Mileage = "567"; vehicleToAdd.MSRP = 28000M; vehicleToAdd.SalesPrice = 26500M; vehicleToAdd.Description = "Its a green car!"; vehicleToAdd.Picture = "placeholder.png"; vehicleToAdd.Featured = true; repo.Insert(vehicleToAdd); var loaded = repo.GetById(9); Assert.IsNotNull(loaded); repo.Delete(9); loaded = repo.GetById(9); Assert.IsNull(loaded); }
public void CanGetVehicleDetails() { var repo = new VehicleRepositoryADO(); var vehicle = repo.GetDetails(1); //(VehicleID, Year, Mileage, MSRP, UserID, SalesPrice, [Description], Picture, Featured, VIN, ModelID, ColorID, TypeID, TransmissionID, InteriorID) //(1, 2017, 0, 55450, '00000000-1111-1111-0000-000000000000', 52980, 'Great car, makes you feel alive!', null, 1, 'WBAVL1C50EVR93551', 1, 3, 1, 1, 2), --corvette Assert.AreEqual(1, vehicle.VehicleID); Assert.AreEqual(2017, vehicle.Year); Assert.AreEqual(0, vehicle.Mileage); Assert.AreEqual(55450, vehicle.MSRP); Assert.AreEqual(52980, vehicle.SalesPrice); Assert.AreEqual("Great car, makes you feel alive!", vehicle.Description); Assert.AreEqual("placeholder.png", vehicle.Picture); Assert.AreEqual("WBAVL1C50EVR93551", vehicle.VIN); Assert.AreEqual(1, vehicle.ModelID); Assert.AreEqual(3, vehicle.ColorID); Assert.AreEqual(1, vehicle.TransmissionID); Assert.AreEqual(2, vehicle.InteriorID); //break Assert.AreEqual(1, vehicle.MakeID); Assert.AreEqual(3, vehicle.BodyID); Assert.AreEqual("Chevy", vehicle.MakeName); Assert.AreEqual("Corvette", vehicle.ModelName); Assert.AreEqual(2, vehicle.InteriorID); Assert.AreEqual("Coupe", vehicle.BodyStyleName); Assert.AreEqual("Grey", vehicle.InteriorColor); Assert.AreEqual("Automatic", vehicle.TransmissionType); Assert.AreEqual("Green", vehicle.ColorName); }
public ActionResult Used(VehicleSearchCM form) { if (ModelState.IsValid) { InventoryUsedVM VM = new InventoryUsedVM(); var repo = new VehicleRepositoryADO(); VM.Vehicles = repo.Search(form, false); VM.SetYear(); VM.SetPrice(); VM.Form = form; return(View(VM)); } else { InventoryUsedVM VM = new InventoryUsedVM(); var repo = new VehicleRepositoryADO(); VM.Vehicles = repo.Search(form, false); VM.SetYear(); VM.SetPrice(); VM.Form = form; return(View(VM)); } }
public void CanDeleteVehicle() { Vehicle vehicleToAdd = new Vehicle(); var repo = new VehicleRepositoryADO(); vehicleToAdd.Year = 2018; vehicleToAdd.Mileage = 0; vehicleToAdd.MSRP = 50011; vehicleToAdd.SalesPrice = 49875; vehicleToAdd.Description = "The meanest on the streets!"; vehicleToAdd.Picture = "placeholder.png"; vehicleToAdd.Featured = true; vehicleToAdd.VIN = "KMHHT6KD1CU079023"; //vehicleToAdd.MakeID = 2; vehicleToAdd.BodyID = 5; vehicleToAdd.ModelID = 3; vehicleToAdd.ColorID = 2; vehicleToAdd.TypeID = 1; vehicleToAdd.TransmissionID = 1; vehicleToAdd.InteriorID = 3; vehicleToAdd.UserID = "00000000-1111-1111-0000-000000000000"; repo.Insert(vehicleToAdd); var loaded = repo.GetByID(9); Assert.IsNotNull(loaded); repo.Delete(9); loaded = repo.GetByID(9); Assert.IsNull(loaded); }
public void CanAddPurchase() { var purchase = new PurchaseDetails(); purchase.Name = "Andrew Galvin"; purchase.Email = "*****@*****.**"; purchase.Street1 = "20 Stable Court"; purchase.City = "Wilmington"; purchase.State = "DE"; purchase.ZipCode = "19803"; purchase.PurchasePrice = 17995; purchase.PurchaseType = "Cash"; purchase.UserID = "00000000-0000-0000-0000-000000000000"; var repo = new VehicleRepositoryADO(); int id = 3; repo.Purchase(purchase, id); Assert.AreEqual(2, purchase.PurchaseID); var vehicle = repo.GetDetails(id); Assert.AreEqual(2, vehicle.PurchaseID); }
public ActionResult Vehicle(VehicleSearchCM form) { if (ModelState.IsValid) { AdminVehiclesVM VM = new AdminVehiclesVM(); var repo = new VehicleRepositoryADO(); VM.Vehicles = repo.Search(form, null); VM.SetYear(); VM.SetPrice(); VM.Form = form; return(View(VM)); } else { AdminVehiclesVM VM = new AdminVehiclesVM(); var repo = new VehicleRepositoryADO(); VM.Vehicles = repo.Search(form, null); VM.SetYear(); VM.SetPrice(); VM.Form = form; return(View(VM)); } }
public ActionResult EditVehicle(int id) { AdminEditVehicleVM VM = new AdminEditVehicleVM(); var repo = new VehicleRepositoryADO(); var modelRepo = new VehicleModelRepositoryADO(); var makeRepo = new MakeRepositoryADO(); var vehicles = repo.ReadByVehicleId(id); VM.Form.VehicleId = vehicles.VehicleId; VM.Form.Make = vehicles.Make; VM.Form.Model = vehicles.Model; VM.Form.Type = vehicles.Type; VM.Form.BodyStyle = vehicles.BodyStyle; VM.Form.Year = vehicles.Year; VM.Form.Transmission = vehicles.Transmission; VM.Form.Color = vehicles.Color; VM.Form.Interior = vehicles.Interior; VM.Form.Mileage = vehicles.Mileage; VM.Form.Vin = vehicles.Vin; VM.Form.Msrp = vehicles.Msrp; VM.Form.SalePrice = vehicles.SalePrice; VM.Form.Description = vehicles.Description; VM.SetAvailableMakes(makeRepo.ReadAllMakes()); VM.SetAvailableModels(modelRepo.ReadAllModel()); VM.BodyStyles(); VM.Colors(); VM.Interiors(); VM.Types(); return(View(VM)); }
public IHttpActionResult Search(decimal?minPrice, decimal?maxPrice, decimal?minYear, decimal?maxYear, string makeName = null, string modelName = null, string year = null) { var repo = new VehicleRepositoryADO(); try { var parameters = new VehicleSearchParams() { MinPrice = minPrice, MaxPrice = maxPrice, MakeName = makeName, ModelName = modelName, Year = year, MinYear = minYear, MaxYear = maxYear }; var result = repo.Search(parameters); return(Ok(result)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void NoVehicleReturnsNull() { var repo = new VehicleRepositoryADO(); var vehicle = repo.GetByID(1000000000); Assert.IsNull(vehicle); }
public void CanGetVehicleById() { var repo = new VehicleRepositoryADO(); Vehicle vehicle = repo.GetById(1); Assert.AreEqual(1, vehicle.VehicleID); }
public void CanLoadSpecials() { var repo = new VehicleRepositoryADO(); var specials = repo.GetSpecials().ToList(); Assert.AreEqual(3, specials.Count); Assert.AreEqual("GuildCars Huge Sale!!!", specials[0].SpecialTitle); }
public void CanAddVehicle() { Vehicle vehicleToAdd = new Vehicle(); var repo = new VehicleRepositoryADO(); vehicleToAdd.Type = "USED"; vehicleToAdd.BodyStyle = "SUV"; }
public void CanLoadFeatured() { var repo = new VehicleRepositoryADO(); var featured = repo.GetFeatured().ToList(); Assert.AreEqual(5, featured.Count); Assert.AreEqual("Audi", featured[0].Make); Assert.AreEqual("F150", featured[1].Model); }
public void CanLoadVehicle() { var repo = new VehicleRepositoryADO(); var vehicle = repo.GetById(1); Assert.IsNotNull(vehicle); Assert.AreEqual(1, vehicle.VehicleId); Assert.AreEqual("Leather", vehicle.Interior); }
public void CanLoadVehicles() { var repo = new VehicleRepositoryADO(); var vehicles = repo.GetVehicles(); Assert.AreEqual(6, vehicles.Count()); Assert.AreEqual("1HGCM82613A006357", vehicles[0].VinNumber); Assert.AreEqual(false, vehicles[4].IsFeatured); }
public ActionResult Inventory() { ReportsInventoryVM VM = new ReportsInventoryVM(); var vehicle = new VehicleRepositoryADO(); VM.NewVehicles = vehicle.ReadAllVehicle().Where(m => m.Type == true).ToList(); VM.UsedVehicles = vehicle.ReadAllVehicle().Where(m => m.Type == false).ToList(); return(View(VM)); }
public void CanSearchOnYear() { var repo = new VehicleRepositoryADO(); var found = repo.Search(new VehicleSearchParams { Year = "2018" }); Assert.AreEqual(5, found.Count()); }
public void CanSearchOnMake() { var repo = new VehicleRepositoryADO(); var found = repo.Search(new VehicleSearchParams { MakeName = "Subaru" }); Assert.AreEqual(8, found.Count()); }
public void CanSearchOnModel() { var repo = new VehicleRepositoryADO(); var found = repo.Search(new VehicleSearchParams { ModelName = "Outb" }); Assert.AreEqual(4, found.Count()); }
public void CanSearchOnMaxYeare() { var repo = new VehicleRepositoryADO(); var found = repo.Search(new VehicleSearchParams { MaxYear = 2018 }); Assert.AreEqual(8, found.Count()); }