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