public void CanLoadVehicleDetails()
{
var repo = new VehicleListingRepoQA();
var listing = repo.GetDetails(1);
Assert.AreEqual(2, listing.VehicleMakeId);
Assert.AreEqual("Kia", listing.VehicleMakeName);
Assert.AreEqual(2, listing.VehicleModelId);
Assert.AreEqual("Soul", listing.VehicleModelName);
Assert.AreEqual(2, listing.BodyStyleId);
Assert.AreEqual("Hatchback", listing.BodyStyleName);
Assert.AreEqual(1, listing.TransmissionTypeId);
Assert.AreEqual("Automatic", listing.TransmissionTypeName);
Assert.AreEqual(2011, listing.Year);
Assert.AreEqual(3, listing.ColorId);
Assert.AreEqual("Blue", listing.ColorName);
Assert.AreEqual(1, listing.InteriorColorId);
Assert.AreEqual("Black", listing.InteriorColor);
Assert.AreEqual(80000, listing.Mileage);
Assert.AreEqual("1HGBH41JXMN109186", listing.VIN);
Assert.AreEqual(17800.00M, listing.SalePrice);
Assert.AreEqual(18000M, listing.MSRP);
Assert.AreEqual("Fun and stylish Soul! Hamsters!", listing.Description);
Assert.AreEqual("Placeholder.png", listing.ImageFileName);
}
public void Init()
{
var repo = new VehicleListingRepoQA();
if (repo.GetById(2) != null)
{
repo.Delete(2);
}
}
public void CanGetSearchResults()
{
var listingRepo = new VehicleListingRepoQA();
var parameters = new ListingSearchParameters()
{
VehicleTypeId = 1
};
var searchResults = listingRepo.GetSearchResults(parameters);
Assert.AreEqual(1, searchResults.Count());
}
public void NotFoundListingReturnsNull()
{
var repo = new VehicleListingRepoQA();
var listing = repo.GetById(1000);
Assert.IsNull(listing);
var listingDetails = repo.GetDetails(1000);
Assert.IsNull(listingDetails);
}
public void CanUpdateListing()
{
var repo = new VehicleListingRepoQA();
VehicleListing car = new VehicleListing()
{
VehicleMakeId = 2,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 1,
Year = 1997,
ColorId = 2,
InteriorColorId = 4,
Mileage = 20000,
VIN = "11111111111111111",
MSRP = 40000.00M,
SalePrice = 36000.00M,
Description = "Ultimate",
FeaturedVehicle = true,
Sold = false,
ImageFileName = "placeholder.png"
};
repo.Insert(car);
var listingToUpdate = repo.GetById(5);
listingToUpdate.TransmissionTypeId = 2;
listingToUpdate.ColorId = 3;
listingToUpdate.InteriorColorId = 1;
listingToUpdate.Mileage = 1000;
listingToUpdate.MSRP = 60000.00M;
listingToUpdate.SalePrice = 48000.00M;
listingToUpdate.Description = "Updated sport utility vehicle";
repo.Update(listingToUpdate);
var updatedListing = repo.GetById(5);
Assert.AreEqual(2, updatedListing.TransmissionTypeId);
Assert.AreEqual(3, updatedListing.ColorId);
Assert.AreEqual(1, updatedListing.InteriorColorId);
Assert.AreEqual(1000, updatedListing.Mileage);
Assert.AreEqual(48000.00M, updatedListing.SalePrice);
Assert.AreEqual(60000.00M, updatedListing.MSRP);
Assert.AreEqual("Updated sport utility vehicle", updatedListing.Description);
Assert.AreEqual(true, updatedListing.FeaturedVehicle);
Assert.AreEqual("11111111111111111", updatedListing.VIN);
}
public void CanInsertListing()
{
var repo = new VehicleListingRepoQA();
VehicleListing car = new VehicleListing()
{
VehicleMakeId = 1,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 5,
TransmissionTypeId = 1,
Year = 1997,
ColorId = 2,
InteriorColorId = 4,
Mileage = 20000,
VIN = "11111111111111111",
MSRP = 40000.00M,
SalePrice = 36000.00M,
Description = "Ultimate sport utility vehicle",
FeaturedVehicle = true,
Sold = false,
ImageFileName = "placeholder.png"
};
repo.Insert(car);
var addedListing = repo.GetById(5);
Assert.AreEqual(5, addedListing.VehicleListingId);
Assert.AreEqual(1, addedListing.VehicleMakeId);
var featuredListings = repo.GetFeatured().ToList();
Assert.AreEqual(3, featuredListings.Count());
Assert.AreEqual(5, featuredListings[2].VehicleListingId);
Assert.AreEqual(1997, featuredListings[2].Year);
Assert.AreEqual("Ford", featuredListings[2].VehicleMakeName);
Assert.AreEqual("Explorer", featuredListings[2].VehicleModelName);
}
public void CanLoadVehicleListing()
{
var repo = new VehicleListingRepoQA();
var listing = repo.GetById(1);
Assert.AreEqual(2, listing.VehicleMakeId);
Assert.AreEqual(2, listing.VehicleModelId);
Assert.AreEqual(2, listing.VehicleTypeId);
Assert.AreEqual(2, listing.BodyStyleId);
Assert.AreEqual(1, listing.TransmissionTypeId);
Assert.AreEqual(2011, listing.Year);
Assert.AreEqual(3, listing.ColorId);
Assert.AreEqual(1, listing.InteriorColorId);
Assert.AreEqual(80000, listing.Mileage);
Assert.AreEqual("1HGBH41JXMN109186", listing.VIN);
Assert.AreEqual(17800.00M, listing.SalePrice);
Assert.AreEqual(18000M, listing.MSRP);
Assert.AreEqual("Fun and stylish Soul! Hamsters!", listing.Description);
Assert.AreEqual(false, listing.FeaturedVehicle);
Assert.AreEqual(false, listing.Sold);
Assert.AreEqual("Placeholder.png", listing.ImageFileName);
}
public void CanDeleteListing()
{
var repo = new VehicleListingRepoQA();
VehicleListing car = new VehicleListing()
{
VehicleMakeId = 2,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 1,
Year = 1997,
ColorId = 2,
InteriorColorId = 4,
Mileage = 20000,
VIN = "11111111111111111",
MSRP = 40000.00M,
SalePrice = 36000.00M,
Description = "Ultimate",
FeaturedVehicle = true,
Sold = false,
ImageFileName = "placeholder.png"
};
repo.Insert(car);
var listing = repo.GetById(5);
Assert.IsNotNull(listing);
repo.Delete(5);
listing = repo.GetById(5);
Assert.IsNull(listing);
}
