public void CanDeleteVehicle()
{
VehicleInventory vehicleToAdd = new VehicleInventory();
var repo = new VehicleInventoryRepositoryDapper();
vehicleToAdd.ModelID = 1;
vehicleToAdd.MakeID = 1;
vehicleToAdd.SalesTypeID = 1;
vehicleToAdd.BodyTypeID = 3;
vehicleToAdd.YearBuilt = 2020;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.ExtColorID = 1;
vehicleToAdd.IntColorID = 3;
vehicleToAdd.Mileage = 233;
vehicleToAdd.VINNumber = "3A4FY48B87T593601";
vehicleToAdd.MSRP = 24900;
vehicleToAdd.SalesPrice = 23000;
vehicleToAdd.VehicleDescription = "Brand New!";
vehicleToAdd.IsFeaturedVehicle = true;
vehicleToAdd.ImageFileName = "placeholder.png";
repo.AddVehicle(vehicleToAdd);
var loaded = repo.GetByID(5);
Assert.IsNotNull(loaded);
repo.DeleteVehicle(5);
loaded = repo.GetByID(5);
Assert.IsNull(loaded);
}
public void CanUpdateListing()
{
VehicleInventory vehicleToAdd = new VehicleInventory();
var repo = new VehicleInventoryRepositoryDapper();
vehicleToAdd.ModelID = 1;
vehicleToAdd.MakeID = 1;
vehicleToAdd.SalesTypeID = 1;
vehicleToAdd.BodyTypeID = 3;
vehicleToAdd.YearBuilt = 2020;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.ExtColorID = 1;
vehicleToAdd.IntColorID = 3;
vehicleToAdd.Mileage = 233;
vehicleToAdd.VINNumber = "3A4FY48B87T593601";
vehicleToAdd.MSRP = 24900;
vehicleToAdd.SalesPrice = 23000;
vehicleToAdd.VehicleDescription = "Brand New!";
vehicleToAdd.IsFeaturedVehicle = true;
vehicleToAdd.ImageFileName = "placeholder.png";
repo.AddVehicle(vehicleToAdd);
vehicleToAdd.ModelID = 2;
vehicleToAdd.MakeID = 2;
vehicleToAdd.SalesTypeID = 2;
vehicleToAdd.BodyTypeID = 3;
vehicleToAdd.YearBuilt = 2017;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.ExtColorID = 2;
vehicleToAdd.IntColorID = 1;
vehicleToAdd.Mileage = 2300;
vehicleToAdd.VINNumber = "3A4FY48Z87T593601";
vehicleToAdd.MSRP = 22900;
vehicleToAdd.SalesPrice = 22000;
vehicleToAdd.VehicleDescription = "Slightly New!";
vehicleToAdd.IsFeaturedVehicle = true;
vehicleToAdd.ImageFileName = "updated.png";
repo.UpdateVehicle(vehicleToAdd);
var updatedVehicle = repo.GetByID(5);
Assert.AreEqual(2, updatedVehicle.ModelID);
Assert.AreEqual(2, updatedVehicle.MakeID);
Assert.AreEqual(2, updatedVehicle.SalesTypeID);
Assert.AreEqual(3, updatedVehicle.BodyTypeID);
Assert.AreEqual(2017, updatedVehicle.YearBuilt);
Assert.AreEqual(1, updatedVehicle.TransmissionID);
Assert.AreEqual(2, updatedVehicle.ExtColorID);
Assert.AreEqual(1, updatedVehicle.IntColorID);
Assert.AreEqual(2300, updatedVehicle.Mileage);
Assert.AreEqual("3A4FY48Z87T593601", updatedVehicle.VINNumber);
Assert.AreEqual(22900, updatedVehicle.MSRP);
Assert.AreEqual(22000, updatedVehicle.SalesPrice);
Assert.AreEqual("Slightly New!", updatedVehicle.VehicleDescription);
Assert.AreEqual(true, updatedVehicle.IsFeaturedVehicle);
Assert.AreEqual("updated.png", updatedVehicle.ImageFileName);
}
public void CanLoadVehicle()
{
var repo = new VehicleInventoryRepositoryDapper();
var vehicle = repo.GetByID(1);
Assert.IsNotNull(vehicle);
Assert.AreEqual(1, vehicle.VehicleID);
Assert.AreEqual(1, vehicle.ModelID);
Assert.AreEqual(1, vehicle.MakeID);
Assert.AreEqual(1, vehicle.SalesTypeID);
Assert.AreEqual(2, vehicle.BodyTypeID);
Assert.AreEqual(2020, vehicle.YearBuilt);
Assert.AreEqual(1, vehicle.TransmissionID);
Assert.AreEqual(1, vehicle.ExtColorID);
Assert.AreEqual(3, vehicle.IntColorID);
Assert.AreEqual(46882, vehicle.Mileage);
Assert.AreEqual("5J8TB4H3XHL018174", vehicle.VINNumber);
Assert.AreEqual(25620, vehicle.MSRP);
Assert.AreEqual(22350, vehicle.SalesPrice);
Assert.AreEqual("Nice and Clean Acura MDX", vehicle.VehicleDescription);
Assert.AreEqual(false, vehicle.IsFeaturedVehicle);
Assert.AreEqual("placeholder.png", vehicle.ImageFileName);
}
public void CanLoadNewVehicles()
{
var repo = new VehicleInventoryRepositoryDapper();
var newVehicles = repo.GetNewInventory();
Assert.IsNotNull(newVehicles);
}
public void NotFoundVehicleReturnsNull()
{
var repo = new VehicleInventoryRepositoryDapper();
var vehicle = repo.GetByID(100000);
Assert.IsNull(vehicle);
}
public void CanLoadFeaturedVehicles()
{
var repo = new VehicleInventoryRepositoryDapper();
List <FeaturedVehicles> featured = repo.GetFeatured().ToList();
Assert.AreEqual(3, featured.Count());
Assert.AreEqual(4, featured[0].VehicleID);
Assert.AreEqual("Audi", featured[0].MakeName);
Assert.AreEqual("A3", featured[0].ModelName);
Assert.AreEqual(20000, featured[0].SalesPrice);
Assert.AreEqual("placeholder.png", featured[0].ImageFileName);
}
public void CanLoadVehicleDetails()
{
var repo = new VehicleInventoryRepositoryDapper();
var vehicle = repo.GetVehicleDetails(1);
Assert.IsNotNull(vehicle);
Assert.AreEqual(1, vehicle.VehicleID);
Assert.AreEqual(2020, vehicle.YearBuilt);
Assert.AreEqual("Acura", vehicle.MakeName);
Assert.AreEqual("MDX", vehicle.ModelName);
Assert.AreEqual(46882, vehicle.Mileage);
Assert.AreEqual("5J8TB4H3XHL018174", vehicle.VINNumber);
Assert.AreEqual(25620, vehicle.MSRP);
Assert.AreEqual(22350, vehicle.SalesPrice);
Assert.AreEqual("Nice and Clean Acura MDX", vehicle.VehicleDescription);
Assert.AreEqual("placeholder.png", vehicle.ImageFileName);
}
public void CanViewDetailsForSearchResults()
{
var repo = new VehicleInventoryRepositoryDapper();
List <VehicleItem> vehicleItems = repo.GetVehicleItems().ToList();
Assert.AreEqual(2, vehicleItems.Count);
Assert.AreEqual(1, vehicleItems[0].VehicleID);
Assert.AreEqual(2020, vehicleItems[0].YearBuilt);
Assert.AreEqual("Acura", vehicleItems[0].MakeName);
Assert.AreEqual("MDX", vehicleItems[0].ModelName);
Assert.AreEqual("placeholder.png", vehicleItems[0].ImageFileName);
Assert.AreEqual("SUV", vehicleItems[0].BodyTypeName);
Assert.AreEqual("White", vehicleItems[0].ExtColorName);
Assert.AreEqual("Gray", vehicleItems[0].IntColorName);
Assert.AreEqual(46882, vehicleItems[0].Mileage);
Assert.AreEqual("5J8TB4H3XHL018174", vehicleItems[0].VINNumber);
Assert.AreEqual(22350, vehicleItems[0].SalesPrice);
Assert.AreEqual(25620, vehicleItems[0].MSRP);
}
