public ActionResult EditVehicle(int id)
{
var model = new EditVehicleViewModel();
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();
var vehicleRepo = new VehicleRepositoryADO();
model.Makes = new SelectList(makeRepo.GetAll(), "MakeID", "MakeName");
model.Models = new SelectList(modelRepo.GetAll(), "ModelID", "ModelName");
model.Types = new SelectList(modelRepo.GetAll(), "TypeID", "TypeName");
model.BodyStyles = new SelectList(modelRepo.GetAll(), "BodyID", "BodyStyleName");
model.Transmissions = new SelectList(modelRepo.GetAll(), "TransmissionID", "TransmissionType");
model.Colors = new SelectList(modelRepo.GetAll(), "ColorID", "ColorName");
model.Interiors = new SelectList(modelRepo.GetAll(), "InteriorID", "InteriorColor");
model.Vehicle = vehicleRepo.GetByID(id);
return(View(model));
}
public void ADOCanLoadModels()
{
var repo = new ModelRepositoryADO();
var models = repo.GetAll().ToList();
Assert.AreEqual(33, models.Count);
Assert.AreEqual(1, models[0].ModelId);
Assert.AreEqual("A4", models[0].Name);
}
public void CanLoadModels()
{
var repo = new ModelRepositoryADO();
var models = repo.GetModels();
Assert.AreEqual(10, models.Count());
Assert.AreEqual(1, models[2].MakeID);
Assert.AreEqual("Model X", models[8].ModelName);
}
public void CanGetModelById()
{
ModelRepositoryADO repo = new ModelRepositoryADO();
Model Model = repo.GetModelById(3);
Assert.AreEqual(Model.ModelId, 3);
Assert.AreEqual(Model.ModelName, "TLX");
Assert.AreEqual(Model.DateAdded, new DateTime(2020, 7, 2));
}
public void CanGetAllModels()
{
ModelRepositoryADO repo = new ModelRepositoryADO();
List <ModelViewModel> models = repo.GetAll().ToList();
Assert.AreEqual("Subaru", models[0].MakeName);
Assert.AreEqual("Impreza", models[0].ModelName);
Assert.AreEqual("Ford", models[1].MakeName);
}
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 CanLoadModels()
{
var repo = new ModelRepositoryADO();
var models = repo.GetAll();
Assert.AreEqual(10, models.Count);
Assert.AreEqual("Beetle", models[1].ModelName);
Assert.AreEqual("Fiesta", models[4].ModelName);
Assert.AreEqual(5, models[2].ModelID);
}
public void CanGetModelByMakeId()
{
ModelRepositoryADO repo = new ModelRepositoryADO();
List <Model> models = new List <Model>();
models = repo.GetModelsByMakeId(2);
Assert.AreEqual(models[0].ModelId, 3);
Assert.AreEqual(models[0].ModelName, "TLX");
Assert.AreEqual(models[0].DateAdded, new DateTime(2020, 7, 2));
}
public void CanGetAllModels()
{
ModelRepositoryADO repo = new ModelRepositoryADO();
List <Model> Models = repo.GetAll().ToList();
Assert.AreEqual(5, Models.Count);
Assert.AreEqual(Models[2].ModelId, 3);
Assert.AreEqual(Models[2].ModelName, "TLX");
Assert.AreEqual(Models[2].DateAdded, new DateTime(2020, 7, 2));
}
public void CanLoadModel()
{
var repo = new ModelRepositoryADO();
var models = repo.GetAll();
Assert.AreEqual(5, models.Count);
Assert.AreEqual(1, models[0].ModelID);
Assert.AreEqual("Aura", models[4].ModelName);
Assert.AreEqual("2000-03-28", models[2].ModelDateAdded.ToString("yyyy-MM-dd"));
}
public void CanLoadModelList()
{
var repo = new ModelRepositoryADO();
List <ModelListItem> modelList = repo.GetModelList();
Assert.IsNotNull(modelList);
Assert.AreEqual(10, modelList.Count());
Assert.AreEqual(6, modelList[1].ModelID);
Assert.AreEqual("Cruze", modelList[1].ModelName);
Assert.AreEqual("Chevrolet", modelList[2].MakeName);
Assert.AreEqual("*****@*****.**", modelList[2].Email);
}
public void CanGetModelList()
{
var repo = new ModelRepositoryADO();
var models = repo.GetModels().ToList();
Assert.AreEqual(5, models.Count());
Assert.AreEqual(1, models[0].MakeID);
Assert.AreEqual(3, models[2].ModelID);
Assert.AreEqual("Pontiac", models[3].MakeName);
Assert.AreEqual("F150", models[2].ModelName);
Assert.AreEqual("1999-11-05", models[1].ModelDateAdded.ToString("yyyy-MM-dd"));
Assert.AreEqual("*****@*****.**", models[2].Email);
Assert.AreEqual("00000000-1111-1111-0000-000000000000", models[4].UserID);
}
public void CanLoadSelectedModels()
{
var repo = new ModelRepositoryADO();
int makeID = 1;
var models = repo.GetSelected(makeID).ToList();
Assert.AreEqual(3, models.Count);
Assert.AreEqual("A8", models[2].Model);
makeID = 3;
models = repo.GetSelected(makeID).ToList();
Assert.AreEqual(1, models.Count);
Assert.AreEqual("F150", models[0].Model);
}
public void CanAddModel()
{
var repo = new ModelRepositoryADO();
VehicleModels newModel = new VehicleModels()
{
Model = "Citation",
MakeID = 3,
UserName = "******"
};
repo.Add(newModel);
var models = repo.GetAll();
Assert.AreEqual(models.Count(), 6);
}
public void CanFailCreate2Model()
{
ModelRepositoryADO repo = new ModelRepositoryADO();
List <ModelViewModel> modelsBefore = repo.GetAll().ToList();
Model model = new Model()
{
Name = "TestModel",
MakeId = 1,
UserId = "00000000-0000-0000-0000-000002000000"
};
var result = repo.Create(model);
List <ModelViewModel> modelsAfter = repo.GetAll().ToList();
Assert.AreEqual(modelsBefore.Count, modelsAfter.Count);
}
public void CanAddModel()
{
Model modelToAdd = new Model();
var repo = new ModelRepositoryADO();
modelToAdd.MakeID = 1;
modelToAdd.ModelName = "test";
modelToAdd.ModelDateAdded = DateTime.Today;
modelToAdd.UserID = "00000000-1111-1111-0000-000000000000";
repo.Insert(modelToAdd);
Assert.AreEqual(6, modelToAdd.ModelID);
Assert.AreEqual(1, modelToAdd.MakeID);
Assert.AreEqual("test", modelToAdd.ModelName);
Assert.AreEqual("00000000-1111-1111-0000-000000000000", modelToAdd.UserID);
Assert.AreEqual(DateTime.Today, modelToAdd.ModelDateAdded);
}
public void ADOCanAddModel()
{
var repo = new ModelRepositoryADO();
var model = new Model();
model.UserId = "00000000-0000-0000-0000-000000000000";
model.MakeId = 4;
model.Year = 2012;
model.Name = "Mustang";
repo.Insert(model);
Assert.IsNotNull(model);
Assert.AreEqual(34, model.ModelId);
Assert.AreEqual(4, model.MakeId);
Assert.AreEqual(2012, model.Year);
Assert.AreEqual("Mustang", model.Name);
Assert.AreEqual("00000000-0000-0000-0000-000000000000", model.UserId);
}
public void CanAddModel()
{
Model model = new Model
{
MakeId = 2,
ModelName = "TestModel",
DateAdded = DateTime.Now.Date,
Addedby = "*****@*****.**"
};
ModelRepositoryADO repo = new ModelRepositoryADO();
repo.Insert(model);
List <Model> Models = repo.GetAll().ToList();
Assert.AreEqual(6, Models.Count);
Assert.IsNotNull(Models[5].ModelId);
Assert.AreEqual(2, Models[5].MakeId);
Assert.AreEqual(model.ModelName, Models[5].ModelName);
Assert.AreEqual(model.DateAdded, Models[5].DateAdded);
Assert.AreEqual(model.Addedby, Models[5].Addedby);
}
[TestCase(3)] // can get just Tesla Makes
public void CanLoadModelsByMakeID(int makeID)
{
var repo = new ModelRepositoryADO();
var models = repo.GetModelsByMakeID(makeID);
if (makeID == 1)
{
Assert.AreEqual(3, models.Count());
Assert.AreEqual(2, models[1].ModelID);
Assert.AreEqual("MX-5 Miata", models[2].ModelName);
}
else if (makeID == 2)
{
Assert.AreEqual(3, models.Count());
}
else if (makeID == 3)
{
Assert.AreEqual(4, models.Count());
}
else
{
Assert.AreEqual(models.Count(), 0);
}
}
