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