public void CanAddVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.VehicleYear = 2016;
vehicleToAdd.MakeID = 3;
vehicleToAdd.ModelID = 1;
vehicleToAdd.Price = 24000;
vehicleToAdd.Mileage = 1000;
vehicleToAdd.Vin = "1GNDU23W27D181467";
vehicleToAdd.MSRP = 26000;
vehicleToAdd.VehicleDescription = "Beauty";
vehicleToAdd.VehicleType = "New";
vehicleToAdd.ImageFileName = "placeholder.png";
vehicleToAdd.BodyStyleID = 1;
vehicleToAdd.TransmissionID = 2;
vehicleToAdd.BodyColorID = 3;
vehicleToAdd.InteriorColorID = 2;
vehicleToAdd.SaleStatus = true;
vehicleToAdd.IsFeatured = true;
repo.Insert(vehicleToAdd);
Assert.AreEqual(9, vehicleToAdd.VehicleID);
}
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 void CanDeleteVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.Year = 2018;
vehicleToAdd.Mileage = 0;
vehicleToAdd.MSRP = 50011;
vehicleToAdd.SalesPrice = 49875;
vehicleToAdd.Description = "The meanest on the streets!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
vehicleToAdd.VIN = "KMHHT6KD1CU079023";
//vehicleToAdd.MakeID = 2;
vehicleToAdd.BodyID = 5;
vehicleToAdd.ModelID = 3;
vehicleToAdd.ColorID = 2;
vehicleToAdd.TypeID = 1;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.InteriorID = 3;
vehicleToAdd.UserID = "00000000-1111-1111-0000-000000000000";
repo.Insert(vehicleToAdd);
var loaded = repo.GetByID(9);
Assert.IsNotNull(loaded);
repo.Delete(9);
loaded = repo.GetByID(9);
Assert.IsNull(loaded);
}
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 ActionResult AddVehicle(AddVehicleViewModel model)
{
if (ModelState.IsValid)
{
var repo = new VehicleRepositoryADO();
try
{
var savePath = Server.MapPath("~/Images");
string fileName = Path.GetFileNameWithoutExtension(model.PictureUpload.FileName);
string extension = Path.GetExtension(model.PictureUpload.FileName);
var filePath = Path.Combine(savePath, fileName + extension);
int counter = 1;
while (System.IO.File.Exists(filePath))
{
filePath = Path.Combine(savePath, fileName + counter.ToString() + extension);
counter++;
}
model.PictureUpload.SaveAs(filePath);
model.Vehicle.Picture = Path.GetFileName(filePath);
repo.Insert(model.Vehicle);
return(RedirectToAction("EditVehicle", "Admin", new { id = model.Vehicle.VehicleID }));
}
catch (Exception ex)
{
throw ex;
}
}
else
{
var vehicleModel = new AddVehicleViewModel();
var makeRepo = new MakeRepositoryADO();
var modelRepo = new ModelRepositoryADO();
var typeRepo = new TypeRepositoryADO();
var bodystyleRepo = new BodyStyleRepositoryADO();
var transmissionRepo = new TransmissionRepositoryADO();
var colorRepo = new ColorRepositoryADO();
var interiorRepo = new InteriorRepositoryADO();
vehicleModel.Makes = new SelectList(makeRepo.GetAll(), "MakeID", "MakeName");
vehicleModel.Models = new SelectList(modelRepo.GetAll(), "ModelID", "ModelName");
vehicleModel.Types = new SelectList(modelRepo.GetAll(), "TypeID", "TypeName");
vehicleModel.BodyStyles = new SelectList(modelRepo.GetAll(), "BodyID", "BodyStyleName");
vehicleModel.Transmissions = new SelectList(modelRepo.GetAll(), "TransmissionID", "TransmissionType");
vehicleModel.Colors = new SelectList(modelRepo.GetAll(), "ColorID", "ColorName");
vehicleModel.Interiors = new SelectList(modelRepo.GetAll(), "InteriorID", "InteriorColor");
return(View(vehicleModel));
}
}
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 void CanAddVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.Year = 2018;
vehicleToAdd.Mileage = 0;
vehicleToAdd.MSRP = 50011;
vehicleToAdd.SalesPrice = 49875;
vehicleToAdd.Description = "The meanest on the streets!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
vehicleToAdd.VIN = "KMHHT6KD1CU079023";
//vehicleToAdd.MakeID = 2;
vehicleToAdd.BodyID = 5;
vehicleToAdd.ModelID = 3;
vehicleToAdd.ColorID = 2;
vehicleToAdd.TypeID = 1;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.InteriorID = 3;
vehicleToAdd.UserID = "00000000-1111-1111-0000-000000000000";
repo.Insert(vehicleToAdd);
Assert.AreEqual(9, vehicleToAdd.VehicleID);
Assert.AreEqual(2018, vehicleToAdd.Year);
Assert.AreEqual(0, vehicleToAdd.Mileage);
Assert.AreEqual(50011, vehicleToAdd.MSRP);
Assert.AreEqual(49875, vehicleToAdd.SalesPrice);
Assert.AreEqual("The meanest on the streets!", vehicleToAdd.Description);
Assert.AreEqual("placeholder.png", vehicleToAdd.Picture);
Assert.AreEqual(true, vehicleToAdd.Featured);
Assert.AreEqual("KMHHT6KD1CU079023", vehicleToAdd.VIN);
Assert.AreEqual(5, vehicleToAdd.BodyID);
Assert.AreEqual(3, vehicleToAdd.ModelID);
Assert.AreEqual(2, vehicleToAdd.ColorID);
Assert.AreEqual(1, vehicleToAdd.TypeID);
Assert.AreEqual(1, vehicleToAdd.TransmissionID);
Assert.AreEqual(3, vehicleToAdd.InteriorID);
Assert.AreEqual("00000000-1111-1111-0000-000000000000", vehicleToAdd.UserID);
}
public void CanEditVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.Year = 2018;
vehicleToAdd.Mileage = 0;
vehicleToAdd.MSRP = 50011;
vehicleToAdd.SalesPrice = 49875;
vehicleToAdd.Description = "The meanest on the streets!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
vehicleToAdd.VIN = "KMHHT6KD1CU079023";
//vehicleToAdd.MakeID = 2;
vehicleToAdd.BodyID = 5;
vehicleToAdd.ModelID = 3;
vehicleToAdd.ColorID = 2;
vehicleToAdd.TypeID = 1;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.InteriorID = 3;
vehicleToAdd.UserID = "00000000-1111-1111-0000-000000000000";
repo.Insert(vehicleToAdd);
vehicleToAdd.Year = 2010;
vehicleToAdd.Mileage = 30000;
vehicleToAdd.MSRP = 12654;
vehicleToAdd.SalesPrice = 11632;
vehicleToAdd.Description = "Baddest on the streets!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = false;
vehicleToAdd.VIN = "KMHHR6K21CU0A9023";
//vehicleToAdd.MakeID = 2;
vehicleToAdd.BodyID = 3;
vehicleToAdd.ModelID = 2;
vehicleToAdd.ColorID = 1;
vehicleToAdd.TypeID = 2;
vehicleToAdd.TransmissionID = 2;
vehicleToAdd.InteriorID = 1;
vehicleToAdd.UserID = "00000000-1111-1111-0000-000000000000";
repo.Update(vehicleToAdd);
var updatedVehicle = repo.GetByID(9);
Assert.AreEqual(2010, vehicleToAdd.Year);
Assert.AreEqual(30000, vehicleToAdd.Mileage);
Assert.AreEqual(12654, vehicleToAdd.MSRP);
Assert.AreEqual(11632, vehicleToAdd.SalesPrice);
Assert.AreEqual("Baddest on the streets!", vehicleToAdd.Description);
Assert.AreEqual("placeholder.png", vehicleToAdd.Picture);
Assert.AreEqual(false, vehicleToAdd.Featured);
Assert.AreEqual("KMHHR6K21CU0A9023", vehicleToAdd.VIN);
Assert.AreEqual(3, vehicleToAdd.BodyID);
Assert.AreEqual(2, vehicleToAdd.ModelID);
Assert.AreEqual(1, vehicleToAdd.ColorID);
Assert.AreEqual(2, vehicleToAdd.TypeID);
Assert.AreEqual(2, vehicleToAdd.TransmissionID);
Assert.AreEqual(1, vehicleToAdd.InteriorID);
Assert.AreEqual("00000000-1111-1111-0000-000000000000", vehicleToAdd.UserID);
}
public void ADOCanUpdateVehicle()
{
var vehicle = new Vehicle();
var repo = new VehicleRepositoryADO();
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);
vehicle.ModelId = 28;
vehicle.BodyStyleId = 1;
vehicle.InteriorColorId = 1;
vehicle.ExteriorColorId = 4;
vehicle.SaleId = null;
vehicle.IsUsed = false;
vehicle.IsAutomatic = true;
vehicle.IsFeatured = true;
vehicle.UserId = "11111111-1111-1111-1111-111111111111";
vehicle.VIN = "0123456789ABCDEFG";
vehicle.Description = "Updated vehicle";
vehicle.Image = "updated.jpg";
vehicle.SalePrice = 38000m;
vehicle.MSRP = 40000m;
vehicle.Mileage = 800m;
repo.Update(vehicle);
var updatedVehicle = repo.GetDetailById(3);
Assert.AreEqual("Tesla", updatedVehicle.Make);
Assert.AreEqual("3", updatedVehicle.Model);
Assert.AreEqual("Car", updatedVehicle.BodyStyle);
Assert.AreEqual("Black", updatedVehicle.InteriorColor);
Assert.AreEqual("Gray", updatedVehicle.ExteriorColor);
Assert.AreEqual("11111111-1111-1111-1111-111111111111", updatedVehicle.UserId);
Assert.AreEqual("0123456789ABCDEFG", updatedVehicle.VIN);
Assert.AreEqual("Updated vehicle", updatedVehicle.Description);
Assert.AreEqual("updated.jpg", updatedVehicle.Image);
Assert.AreEqual(null, updatedVehicle.SaleId);
Assert.AreEqual(false, updatedVehicle.IsUsed);
Assert.AreEqual(true, updatedVehicle.IsAutomatic);
Assert.AreEqual(true, updatedVehicle.IsFeatured);
Assert.AreEqual(2018, updatedVehicle.Year);
Assert.AreEqual(38000m, updatedVehicle.SalePrice);
Assert.AreEqual(40000m, updatedVehicle.MSRP);
Assert.AreEqual(800m, updatedVehicle.Mileage);
}
