public void ADOCanGetNextVehicleId() { var repo = new VehiclesRepositoryADO(); var nextId = repo.GetNextVehicleId(); Assert.AreEqual(100009, nextId); }
public static void ADOCanDeleteVehicle() { Vehicles vehicleToAdd = new Vehicles(); var repo = new VehiclesRepositoryADO(); vehicleToAdd.ModelId = 9; vehicleToAdd.VehicleTypeId = 1; vehicleToAdd.BodyStyleId = 1; vehicleToAdd.BodyColorId = 1; vehicleToAdd.InteriorColorId = 5; vehicleToAdd.TransmissionId = 1; vehicleToAdd.VehicleYear = 2018; vehicleToAdd.VehicleMileage = 4; vehicleToAdd.VehicleVIN = "22222222222222222"; vehicleToAdd.VehicleMSRP = 46000M; vehicleToAdd.VehicleSalesPrice = 44000M; vehicleToAdd.VehicleDescription = "Test2 Lorem ipsum dolor sit amet, consectetur adipiscing elit."; vehicleToAdd.VehiclePicture = "placeholder.PNG"; vehicleToAdd.VehicleIsFeatured = true; repo.AddVehicle(vehicleToAdd); var vehicle = repo.SelectVehicle(100009); Assert.IsNotNull(vehicle); repo.DeleteVehicle(100009); vehicle = repo.SelectVehicle(100009); Assert.IsNull(vehicle); }
public static void ADOCanEditVehicle() { Vehicles vehicleToAdd = new Vehicles(); var repo = new VehiclesRepositoryADO(); vehicleToAdd.ModelId = 9; vehicleToAdd.VehicleTypeId = 1; vehicleToAdd.BodyStyleId = 1; vehicleToAdd.BodyColorId = 1; vehicleToAdd.InteriorColorId = 5; vehicleToAdd.TransmissionId = 1; vehicleToAdd.VehicleYear = 2018; vehicleToAdd.VehicleMileage = 4; vehicleToAdd.VehicleVIN = "22222222222222222"; vehicleToAdd.VehicleMSRP = 46000M; vehicleToAdd.VehicleSalesPrice = 44000M; vehicleToAdd.VehicleDescription = "Test2 Lorem ipsum dolor sit amet, consectetur adipiscing elit."; vehicleToAdd.VehiclePicture = "placeholder.PNG"; vehicleToAdd.VehicleIsFeatured = true; repo.AddVehicle(vehicleToAdd); vehicleToAdd.ModelId = 8; vehicleToAdd.VehicleTypeId = 2; vehicleToAdd.BodyStyleId = 4; vehicleToAdd.BodyColorId = 2; vehicleToAdd.InteriorColorId = 2; vehicleToAdd.TransmissionId = 2; vehicleToAdd.VehicleYear = 2017; vehicleToAdd.VehicleMileage = 8000; vehicleToAdd.VehicleVIN = "33333333333333333"; vehicleToAdd.VehicleMSRP = 23000M; vehicleToAdd.VehicleSalesPrice = 21000M; vehicleToAdd.VehicleDescription = "Test3 Lorem ipsum dolor sit amet, consectetur adipiscing elit."; vehicleToAdd.VehiclePicture = "placeholder3.PNG"; vehicleToAdd.VehicleIsFeatured = false; repo.UpdateVehicle(vehicleToAdd); var vehicle = repo.SelectVehicle(100009); Assert.IsNotNull(vehicle); Assert.AreEqual(100009, vehicle.VehicleId); Assert.AreEqual(8, vehicle.ModelId); Assert.AreEqual(2, vehicle.VehicleTypeId); Assert.AreEqual(4, vehicle.BodyStyleId); Assert.AreEqual(2, vehicle.BodyColorId); Assert.AreEqual(2, vehicle.InteriorColorId); Assert.AreEqual(2, vehicle.TransmissionId); Assert.AreEqual(2017, vehicle.VehicleYear); Assert.AreEqual(8000, vehicle.VehicleMileage); Assert.AreEqual("33333333333333333", vehicle.VehicleVIN); Assert.AreEqual(23000M, vehicle.VehicleMSRP); Assert.AreEqual(21000M, vehicle.VehicleSalesPrice); Assert.AreEqual("Test3 Lorem ipsum dolor sit amet, consectetur adipiscing elit.", vehicle.VehicleDescription); Assert.AreEqual("placeholder3.PNG", vehicle.VehiclePicture); Assert.AreEqual(false, vehicle.VehicleIsFeatured); }
public void CanLoadNewVehicles() { var repo = new VehiclesRepositoryADO(); var vehicles = repo.GetAllNewVehicles(); Assert.AreEqual(6, vehicles.Count); }
public void ADONotFoundVehicleReturnsNull() { var repo = new VehiclesRepositoryADO(); var vehicle = repo.SelectVehicle(100009); Assert.IsNull(vehicle); }
public void CanGetVehicle() { var repo = new VehiclesRepositoryADO(); var car = repo.GetVehicle(3); Vehicle v = new Vehicle(); v.VehicleId = 3; Assert.AreEqual(car.VehicleId, v.VehicleId); }
public void GetModels() { var repo = new VehiclesRepositoryADO(); int id = 3; var models = repo.GetMakeModel(id); models.Count(); Assert.AreEqual(models.Count(), 3); }
public void CanSearchNewVehicles() { var repo = new VehiclesRepositoryADO(); var par = new InventorySearchParamaters(); par.Input = "Tahoe"; par.PricerangeMin = 20000; par.PricerangeMax = 23000; par.YearMin = 2016; par.YearMax = 2017; var vehicles = repo.SearchNewVehicles(par); Assert.AreEqual(vehicles.Where(m => m.VehicleId == 4).Count(), 1); }
public void ADOCanLoadVehicle() { var repo = new VehiclesRepositoryADO(); var vehicle = repo.SelectVehicle(2); Assert.IsNotNull(vehicle); Assert.AreEqual(2, vehicle.VehicleId); Assert.AreEqual(6, vehicle.ModelId); Assert.AreEqual(2, vehicle.VehicleTypeId); Assert.AreEqual(3, vehicle.BodyStyleId); Assert.AreEqual(2, vehicle.BodyColorId); Assert.AreEqual(4, vehicle.InteriorColorId); Assert.AreEqual(2, vehicle.TransmissionId); Assert.AreEqual(2016, vehicle.VehicleYear); Assert.AreEqual(50000, vehicle.VehicleMileage); Assert.AreEqual("2222222222222222", vehicle.VehicleVIN); Assert.AreEqual(14000M, vehicle.VehicleMSRP); Assert.AreEqual(13500M, vehicle.VehicleSalesPrice); Assert.AreEqual("Test2 Lorem ipsum dolor sit amet, consectetur adipiscing elit.", vehicle.VehicleDescription); Assert.AreEqual("inventory-2.PNG", vehicle.VehiclePicture); Assert.AreEqual(false, vehicle.VehicleIsFeatured); }