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