public void ADOCanDeleteVehicle()
{
var repo = new VehicleRepositoryADO();
var vehicle = new Vehicle();
vehicle.ModelId = 9;
vehicle.BodyStyleId = 4;
vehicle.InteriorColorId = 2;
vehicle.ExteriorColorId = 5;
vehicle.SaleId = null;
vehicle.IsUsed = true;
vehicle.IsAutomatic = false;
vehicle.IsFeatured = false;
vehicle.UserId = "00000000-0000-0000-0000-000000000000";
vehicle.VIN = "9012345678ABCDEFG";
vehicle.Description = "Added vehicle";
vehicle.Image = "added.jpg";
vehicle.SalePrice = 15000m;
vehicle.MSRP = 16000m;
vehicle.Mileage = 90000m;
repo.Insert(vehicle);
var loaded = repo.GetById(3);
Assert.IsNotNull(loaded);
repo.Delete(3);
loaded = repo.GetById(3);
Assert.IsNull(loaded);
}
public void CanDeleteVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.VIN = "9870987fhej320nf";
vehicleToAdd.ModelID = 1;
vehicleToAdd.ConditionID = 1;
vehicleToAdd.VehicleTypeID = 1;
vehicleToAdd.Year = "2018";
vehicleToAdd.TransmissionTypeID = 1;
vehicleToAdd.CarColor = 1;
vehicleToAdd.Interior = 1;
vehicleToAdd.Mileage = "567";
vehicleToAdd.MSRP = 28000M;
vehicleToAdd.SalesPrice = 26500M;
vehicleToAdd.Description = "Its a green car!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
repo.Insert(vehicleToAdd);
var loaded = repo.GetById(9);
Assert.IsNotNull(loaded);
repo.Delete(9);
loaded = repo.GetById(9);
Assert.IsNull(loaded);
}
public static void CanCreateAndDeleteVehicle()
{
VehicleRepositoryADO repo = new VehicleRepositoryADO();
Vehicle vehicle = new Vehicle()
{
Vin = "0000000000",
Color = "Blue",
Description = "Notes and stuff",
Interior = "Black",
Style = "Car",
MakeId = 1,
ModelId = 1,
Mileage = 500,
MSRP = 15000M,
SalePrice = 12000M,
Sold = false,
Transmission = "Auto",
Type = "New",
Year = 2015
};
var createdvehicle = repo.Create(vehicle);
Assert.AreNotEqual(null, createdvehicle);
var resultId = createdvehicle.VehicleId;
repo.Delete(resultId);
var deletedVehicle = repo.GetById(resultId);
Assert.AreEqual(null, deletedVehicle.Vin);
}
public void ADONotFoundVehicleReturnsNull()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetById(100000);
Assert.IsNull(vehicle);
}
public void CanGetVehicleById()
{
var repo = new VehicleRepositoryADO();
Vehicle vehicle = repo.GetById(1);
Assert.AreEqual(1, vehicle.VehicleID);
}
public void CanLoadVehicle()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetById(1);
Assert.IsNotNull(vehicle);
Assert.AreEqual(1, vehicle.VehicleId);
Assert.AreEqual("Leather", vehicle.Interior);
}
public void CanLoadVehicle()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetById(1);
Assert.IsNotNull(vehicle);
Assert.AreEqual(1, vehicle.VehicleID);
Assert.AreEqual("1234567890ASDFGQ", vehicle.VIN);
}
public static void CanGetVehicleById()
{
VehicleRepositoryADO repo = new VehicleRepositoryADO();
var vehicle = repo.GetById(3);
Assert.AreEqual(3, vehicle.VehicleId);
Assert.AreEqual(2019, vehicle.Year);
Assert.AreEqual("Ford", vehicle.Make);
Assert.AreEqual("Mustang", vehicle.Model);
}
public void CanUpdateVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.VIN = "9870987fhej320nf";
vehicleToAdd.ModelID = 1;
vehicleToAdd.ConditionID = 1;
vehicleToAdd.VehicleTypeID = 1;
vehicleToAdd.Year = "2018";
vehicleToAdd.TransmissionTypeID = 1;
vehicleToAdd.CarColor = 1;
vehicleToAdd.Interior = 1;
vehicleToAdd.Mileage = "567";
vehicleToAdd.MSRP = 28000M;
vehicleToAdd.SalesPrice = 26500M;
vehicleToAdd.Description = "Its a green car!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
repo.Insert(vehicleToAdd);
vehicleToAdd.VIN = "9870987fhej320nf";
vehicleToAdd.ModelID = 1;
vehicleToAdd.ConditionID = 1;
vehicleToAdd.VehicleTypeID = 1;
vehicleToAdd.Year = "2018";
vehicleToAdd.TransmissionTypeID = 1;
vehicleToAdd.CarColor = 3;
vehicleToAdd.Interior = 4;
vehicleToAdd.Mileage = "567";
vehicleToAdd.MSRP = 31000M;
vehicleToAdd.SalesPrice = 26500M;
vehicleToAdd.Description = "Beautiful vehicle!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
repo.Update(vehicleToAdd);
var updatedVehicle = repo.GetById(9);
Assert.AreEqual(3, updatedVehicle.CarColor);
Assert.AreEqual(4, updatedVehicle.Interior);
Assert.AreEqual(31000M, updatedVehicle.MSRP);
Assert.AreEqual("Beautiful vehicle!", updatedVehicle.Description);
}
public static void CanCreateVehicle()
{
VehicleRepositoryADO repo = new VehicleRepositoryADO();
Vehicle vehicle = new Vehicle()
{
Vin = "0000000000",
Color = "Blue",
Description = "Notes and stuff",
Style = "Car",
Interior = "Black",
MakeId = 1,
ModelId = 1,
Mileage = 500,
MSRP = 15000M,
SalePrice = 12000M,
Sold = false,
Transmission = "Auto",
Type = "New",
Year = 2015
};
var createdvehicle = repo.Create(vehicle);
Assert.AreNotEqual(null, createdvehicle);
var resultId = createdvehicle.VehicleId;
var resultVehicle = repo.GetById(resultId);
Assert.GreaterOrEqual(resultVehicle.VehicleId, 1);
Assert.AreEqual(vehicle.Vin, resultVehicle.Vin);
Assert.AreEqual(vehicle.Color, resultVehicle.Color);
Assert.AreEqual(vehicle.Style, resultVehicle.Style);
Assert.AreEqual(vehicle.Description, resultVehicle.Description);
Assert.AreEqual(vehicle.Interior, resultVehicle.Interior);
Assert.AreEqual("Subaru", resultVehicle.Make);
Assert.AreEqual("Impreza", resultVehicle.Model);
Assert.AreEqual(vehicle.MSRP, resultVehicle.MSRP);
Assert.AreEqual(vehicle.Mileage, resultVehicle.Mileage);
Assert.AreEqual(vehicle.SalePrice, resultVehicle.SalePrice);
Assert.AreEqual(vehicle.Sold, resultVehicle.Sold);
Assert.AreEqual(vehicle.Transmission, resultVehicle.Transmission);
Assert.AreEqual(vehicle.Type, resultVehicle.Type);
Assert.AreEqual(vehicle.Year, resultVehicle.Year);
}
