public void ADOCanSearchInventoryNoParams() { var repo = new InventoryRepositoryADO(); var found = repo.SearchInventory(new VehicleSearchParameters { }); Assert.AreEqual(20, found.Count()); }
public void ADOCanSearchInventoryAllParams() { var repo = new InventoryRepositoryADO(); var found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MakeModelYear = "T", MinPrice = 20000, MaxPrice = 80000, MinYear = 2010, MaxYear = 2016 }); Assert.AreEqual(2, found.Count()); }
public void CanGetListOfPurchaseTypes() { var repo = new InventoryRepositoryADO(); var types = repo.GetPurchaseTypes(); Assert.AreEqual(3, types.Count); Assert.AreEqual("Bank Finance", types[0].PurchaseTypeName); }
public void CanSearchSalesInvoiceBySalesPerson() { var repo = new InventoryRepositoryADO(); var found = repo.SearchSalesInvoices(new SalesReportSearchParameters { SalesPerson = "Eric Ward" }); Assert.AreEqual(1, found.Count()); }
public void ADOCanCheckIsSold() { var repo = new InventoryRepositoryADO(); var sold = repo.IsSold(100000); Assert.IsTrue(sold); sold = repo.IsSold(14); Assert.IsFalse(sold); }
public void ADOCanSearchInventoryFourParams() { var repo = new InventoryRepositoryADO(); var found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MakeModelYear = "C", MinPrice = 20000, MaxPrice = 50000 }); Assert.AreEqual(5, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MinPrice = 10000, MaxPrice = 30000, MinYear = 2012 }); Assert.AreEqual(6, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MaxPrice = 30000, MinYear = 2012, MaxYear = 2018 }); Assert.AreEqual(6, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MakeModelYear = "C", MaxPrice = 20000, MinYear = 2016 }); Assert.AreEqual(1, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MakeModelYear = "C", MinYear = 2011, MaxYear = 2015 }); Assert.AreEqual(4, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MinPrice = 20000, MinYear = 2011, MaxYear = 2013 }); Assert.AreEqual(2, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "Navigator", MinPrice = 20000, MaxPrice = 40000, MinYear = 2018 }); Assert.AreEqual(2, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "Navigator", MinPrice = 20000, MinYear = 2018, MaxYear = 2018 }); Assert.AreEqual(2, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "Navigator", MinPrice = 10000, MinYear = 2017, MaxYear = 2018 }); Assert.AreEqual(2, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinPrice = 30000, MaxPrice = 40000, MinYear = 2010, MaxYear = 2018 }); Assert.AreEqual(4, found.Count()); }
public void CanGetListOfStates() { var repo = new InventoryRepositoryADO(); var states = repo.GetStates(); Assert.AreEqual(28, states.Count); Assert.AreEqual("AK", states[0].State); Assert.AreEqual(5, states[0].StateId); }
public ActionResult Inventory() { var model = new InventoryReportViewModel(); var repo = new InventoryRepositoryADO(); var newRepo = repo.GetNewInventory().ToList(); var usedRepo = repo.GetUsedInventory().ToList(); model.NewInventory = newRepo; model.UsedInventory = newRepo; return(View(model)); }
public void CanLoadNewIventory() { var repo = new InventoryRepositoryADO(); List <InventoryReportItem> cars = repo.GetNewVehicles().ToList(); Assert.AreEqual(6, cars.Count()); Assert.AreEqual("Chevrolet", cars[0].CarMakeName); Assert.AreEqual("Silverado", cars[0].CarModelName); Assert.AreEqual(2018, cars[0].CarYear); Assert.AreEqual(1, cars[0].Count); Assert.AreEqual(23590M, cars[0].StockValue); }
public void CanLoadUsedIventory() { var repo = new InventoryRepositoryADO(); List <InventoryReportItem> cars = repo.GetUsedVehicles().ToList(); Assert.AreEqual(5, cars.Count()); Assert.AreEqual("Dodge", cars[0].CarMakeName); Assert.AreEqual("Ram", cars[0].CarModelName); Assert.AreEqual(2006, cars[0].CarYear); Assert.AreEqual(1, cars[0].Count); Assert.AreEqual(9500M, cars[0].StockValue); }
public void ADOGetFeaturedVehicles() { var repo = new InventoryRepositoryADO(); var vehicles = repo.GetFeaturedVehicles().ToList(); Assert.AreEqual(6, vehicles.Count()); Assert.AreEqual(6, vehicles[3].VehicleId); Assert.AreEqual(2016, vehicles[3].VehicleYear); Assert.AreEqual("Chevrolet", vehicles[3].MakeDescription); Assert.AreEqual("Express", vehicles[3].ModelDescription); Assert.AreEqual(15000M, vehicles[3].VehicleSalesPrice); Assert.AreEqual("inventory-6.PNG", vehicles[3].VehiclePicture); }
public void CanGetUsedInventory() { var repo = new InventoryRepositoryADO(); var usedList = repo.GetUsedInventory().ToList(); Assert.AreEqual(5, usedList.Count()); Assert.AreEqual(2, usedList[0].MakeID); Assert.AreEqual(5, usedList[2].ModelID); Assert.AreEqual("Chevy", usedList[1].MakeName); Assert.AreEqual("Aura", usedList[2].ModelName); Assert.AreEqual(1, usedList[0].Count); Assert.AreEqual(2007, usedList[2].Year); Assert.AreEqual(8564, usedList[1].StockValue); }
public void CanGetNewInventory() { var repo = new InventoryRepositoryADO(); var newList = repo.GetNewInventory().ToList(); Assert.AreEqual(3, newList.Count()); Assert.AreEqual(1, newList[0].MakeID); Assert.AreEqual(3, newList[2].ModelID); Assert.AreEqual("Chevy", newList[1].MakeName); Assert.AreEqual("F150", newList[2].ModelName); Assert.AreEqual(1, newList[0].Count); Assert.AreEqual(2017, newList[2].Year); Assert.AreEqual(11975, newList[1].StockValue); }
public void ADOCanGetVehicleDetails() { var repo = new InventoryRepositoryADO(); var vehicle = repo.GetVehicleDetails(12); Assert.IsNotNull(vehicle); Assert.AreEqual(2016, vehicle.VehicleYear); Assert.AreEqual("Ford", vehicle.MakeDescription); Assert.AreEqual("Transit Connect", vehicle.ModelDescription); Assert.AreEqual("Van", vehicle.BodyStyleDescription); Assert.AreEqual("Light Gray", vehicle.InteriorColorDescription); Assert.AreEqual("Manual", vehicle.TransmissionDescription); Assert.AreEqual(50000, vehicle.VehicleMileage); Assert.AreEqual("Silver", vehicle.BodyColorDescription); Assert.AreEqual("12111111111111111", vehicle.VehicleVIN); Assert.AreEqual(14500M, vehicle.VehicleSalesPrice); Assert.AreEqual(15000M, vehicle.VehicleMSRP); Assert.AreEqual("inventory-12.PNG", vehicle.VehiclePicture); Assert.AreEqual("Test12 Lorem ipsum dolor sit amet, consectetur adipiscing elit.", vehicle.VehicleDescription); }
public void ADOCanSearchInventoryOneParam() { var repo = new InventoryRepositoryADO(); var found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "New" }); Assert.AreEqual(6, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "2017" }); Assert.AreEqual(2, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "C" }); Assert.AreEqual(15, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinPrice = 30000 }); Assert.AreEqual(18, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MaxPrice = 35000 }); Assert.AreEqual(16, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinYear = 2017 }); Assert.AreEqual(7, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MaxYear = 2009 }); Assert.AreEqual(11, found.Count()); }
public void CanInsertSalesInvoice() { SalesInvoice newInvoice = new SalesInvoice(); var repo = new InventoryRepositoryADO(); newInvoice.CarId = 23; newInvoice.StateId = 1; newInvoice.ZipCode = "44857"; newInvoice.PurchaseTypeId = 1; newInvoice.UserEmail = "*****@*****.**"; newInvoice.ContactName = "Amy Samsonite"; newInvoice.SalesPerson = "Austyn Hill"; newInvoice.TelephoneNumber = "356-555-4321"; newInvoice.StreetAddress1 = "123 Somewhere Street"; newInvoice.StreetAddress2 = "Apt 2"; newInvoice.City = "Norwalk"; newInvoice.PurchaseTypeId = 1; newInvoice.Total = 15050M; repo.Insert(newInvoice); Assert.AreEqual(27, newInvoice.InvoiceId); }
public void ADOCanSearchInventoryFiveParams() { var repo = new InventoryRepositoryADO(); var found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MakeModelYear = "E", MinPrice = 30000, MaxPrice = 80000, MinYear = 2010 }); Assert.AreEqual(1, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MinPrice = 30000, MaxPrice = 80000, MinYear = 2010, MaxYear = 2015 }); Assert.AreEqual(3, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MakeModelYear = "E", MaxPrice = 60000, MinYear = 2010, MaxYear = 2016 }); Assert.AreEqual(1, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "Navigator", MinPrice = 30000, MaxPrice = 40000, MinYear = 2018, MaxYear = 2018 }); Assert.AreEqual(2, found.Count()); }
public void ADOCanSearchInventoryTwoParams() { var repo = new InventoryRepositoryADO(); var found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "New", MakeModelYear = "2017" }); Assert.AreEqual(1, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "New", MinPrice = 20000 }); Assert.AreEqual(5, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MaxPrice = 34000 }); Assert.AreEqual(12, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MinYear = 2005 }); Assert.AreEqual(20, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { NewUsed = "Used", MaxYear = 2005 }); Assert.AreEqual(6, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "C", MinPrice = 30000 }); Assert.AreEqual(7, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "C", MaxPrice = 30000 }); Assert.AreEqual(8, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "C", MinYear = 2010 }); Assert.AreEqual(9, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MakeModelYear = "C", MaxYear = 2010 }); Assert.AreEqual(6, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinYear = 2005, MaxYear = 2016 }); Assert.AreEqual(19, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinPrice = 30000, MaxPrice = 50000 }); Assert.AreEqual(9, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinPrice = 30000, MinYear = 2010 }); Assert.AreEqual(11, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MinPrice = 30000, MaxYear = 2010 }); Assert.AreEqual(7, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MaxPrice = 30000, MinYear = 2010 }); Assert.AreEqual(9, found.Count()); found = repo.SearchInventory(new VehicleSearchParameters { MaxPrice = 30000, MaxYear = 2010 }); Assert.AreEqual(5, found.Count()); }