public async Task <IActionResult> Edit(int id, [Bind("CarMakesId,Make")] CarMakes carMakes) { if (id != carMakes.CarMakesId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(carMakes); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CarMakesExists(carMakes.CarMakesId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(carMakes)); }
public ActionResult InsertCarMake(CarMakes model) { CarMakes make = new CarMakes(); var makeRepo = CarMakesRepositoryFactory.GetRepository(); var repo = CarMakesRepositoryFactory.GetRepository(); var carMakes = makeRepo.GetAll(); make.MakeName = model.MakeName; DateTime today = DateTime.Today; make.DateAdded = today; make.Email = User.Identity.Name; if (make.MakeName == null) { ModelState.AddModelError("MakeName", "Make name cannot be blank"); } if (ModelState.IsValid) { repo.Insert(make); return(View("Makes")); } else { return(View("Makes")); } }
private void GetCarMakes() { CarMakeList = CarMakes.GetAll().ToSvenTechCollection(); CarModelList.Clear(); CarBodyList.Clear(); CarGenerationList.Clear(); CarTrimList.Clear(); CarEngine = null; }
public async Task <IActionResult> Create([Bind("CarMakesId,Make")] CarMakes carMakes) { if (ModelState.IsValid) { _context.Add(carMakes); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(carMakes)); }
public void Insert(CarMakes make) { var repo = GetAll(); CarMakes carMake = new CarMakes(); carMake.MakeName = make.MakeName; carMake.DateAdded = make.DateAdded; carMake.Email = make.Email; repo.Insert(carMake.MakeID, carMake); }
public void CanAddCarMake() { CarMakes make = new CarMakes(); var repo = new CarMakesRepositoryDapper(); make.MakeName = "Buick"; var dateTime = DateTime.Parse("04/20/2020"); make.DateAdded = dateTime; make.Email = "*****@*****.**"; repo.Insert(make); Assert.AreEqual(4, make.MakeID); }
public void Insert(CarMakes make) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { var parameters = new DynamicParameters(); parameters.Add("@MakeID", dbType: DbType.Int32, direction: ParameterDirection.Output); parameters.Add("@MakeName", make.MakeName); parameters.Add("@DateAdded", make.DateAdded); parameters.Add("@Email", make.Email); cn.Execute("MakeInsert", parameters, commandType: CommandType.StoredProcedure); make.MakeID = parameters.Get <int>("@MakeID"); } }