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