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