public void CanSearchOnNoFilters()
{
var repo = new VehicleListingRepository();
var found = repo.GetSearchResults(new ListingSearchParameters());
Assert.AreEqual(6, found.Count());
}
public void CanSearchOnAllFilters()
{
var repo = new VehicleListingRepository();
var found = repo.GetSearchResults(new ListingSearchParameters {
SearchTerm = "Fo", MinMSRP = 30000M, MaxMSRP = 40000M, MinYear = 2013, MaxYear = 2017
});
Assert.AreEqual(1, found.Count());
}
public void CanSearchOnPartialMakeTerm()
{
var repo = new VehicleListingRepository();
var found = repo.GetSearchResults(new ListingSearchParameters {
SearchTerm = "Fo"
});
Assert.AreEqual(2, found.Count());
}
public void CanSearchOnMSRPRange()
{
var repo = new VehicleListingRepository();
var found = repo.GetSearchResults(new ListingSearchParameters {
MinMSRP = 20000M, MaxMSRP = 30000M
});
Assert.AreEqual(2, found.Count());
}
public void CanSearchOnVehicleType()
{
var repo = new VehicleListingRepository();
var found = repo.GetSearchResults(new ListingSearchParameters {
VehicleTypeId = 2
});
Assert.AreEqual(2, found.Count());
}
public void CanLoadFeaturedVehicles()
{
var repo = new VehicleListingRepository();
var vehicles = repo.GetFeatured().ToList();
Assert.AreEqual(8, vehicles.Count());
Assert.AreEqual(1, vehicles[0].VehicleListingId);
Assert.AreEqual("Ford", vehicles[0].VehicleMakeName);
Assert.AreEqual("Explorer", vehicles[0].VehicleModelName);
}
public void CanLoadListingById()
{
var repo = new VehicleListingRepository();
var vehicle = repo.GetById(2);
Assert.AreEqual(2, vehicle.VehicleMakeId);
Assert.AreEqual(2, vehicle.VehicleModelId);
Assert.AreEqual(1, vehicle.VehicleTypeId);
Assert.AreEqual(19000M, vehicle.MSRP);
Assert.AreEqual(16500M, vehicle.SalePrice);
Assert.AreEqual("test car 2", vehicle.Description);
}
public void CanLoadVehicleDetails()
{
var repo = new VehicleListingRepository();
var vehicle = repo.GetDetails(2);
Assert.AreEqual("Kia", vehicle.VehicleMakeName);
Assert.AreEqual("Soul", vehicle.VehicleModelName);
Assert.AreEqual("SUV", vehicle.BodyStyleName);
Assert.AreEqual("Automatic", vehicle.TransmissionTypeName);
Assert.AreEqual("Blue", vehicle.ColorName);
Assert.AreEqual("Beige", vehicle.InteriorColor);
Assert.AreEqual(1000, vehicle.Mileage);
}
public void CanInsertVehicleListing()
{
var repo = new VehicleListingRepository();
VehicleListing test = new VehicleListing()
{
VehicleMakeId = 1,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 2,
Year = 2020,
ColorId = 3,
InteriorColorId = 1,
Mileage = 0,
VIN = "test",
MSRP = 99000M,
SalePrice = 92000M,
Description = "New Car",
FeaturedVehicle = true,
ImageFileName = "test.png",
Sold = false
};
repo.Insert(test);
var vehicle = repo.GetById(9);
Assert.AreEqual(1, vehicle.VehicleMakeId);
Assert.AreEqual(1, vehicle.VehicleModelId);
Assert.AreEqual(2, vehicle.VehicleTypeId);
Assert.AreEqual(3, vehicle.BodyStyleId);
Assert.AreEqual(2, vehicle.TransmissionTypeId);
Assert.AreEqual(2020, vehicle.Year);
Assert.AreEqual(3, vehicle.ColorId);
Assert.AreEqual(1, vehicle.InteriorColorId);
Assert.AreEqual(0, vehicle.Mileage);
Assert.AreEqual("test", vehicle.VIN);
Assert.AreEqual(99000M, vehicle.MSRP);
Assert.AreEqual(92000M, vehicle.SalePrice);
Assert.AreEqual("New Car", vehicle.Description);
Assert.AreEqual(true, vehicle.FeaturedVehicle);
Assert.AreEqual("test.png", vehicle.ImageFileName);
Assert.AreEqual(false, vehicle.Sold);
}
public void CanDeleteVehicleListing()
{
var repo = new VehicleListingRepository();
VehicleListing test = new VehicleListing()
{
VehicleMakeId = 1,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 2,
Year = 2020,
ColorId = 3,
InteriorColorId = 1,
Mileage = 0,
VIN = "test",
MSRP = 99000M,
SalePrice = 92000M,
Description = "New Car",
FeaturedVehicle = true,
ImageFileName = "test.png",
Sold = false
};
repo.Insert(test);
var vehicle = repo.GetById(9);
Assert.IsNotNull(vehicle);
repo.Delete(9);
vehicle = repo.GetById(9);
Assert.IsNull(vehicle);
}
