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 ADONotFoundVehicleReturnsNull() { var repo = new VehiclesRepositoryADO(); var vehicle = repo.SelectVehicle(100009); Assert.IsNull(vehicle); }
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); }