// GET: InstructorsClass/Edit/5
public ActionResult Edit(int id)
{
InstructorsClass instructorsClasses = GetInstructorsClassById(id);
List <CohortOne> cohorts = GetAllCohorts();
InstructorsClassEditViewModel viewModel = new InstructorsClassEditViewModel();
viewModel.instructorsClass = instructorsClasses;
viewModel.AvailableCohorts = cohorts;
return(View(viewModel));
}
public ActionResult Edit(int id, InstructorsClassEditViewModel viewModel)
{
InstructorsClass instructorsClasses = viewModel.instructorsClass;
try
{
// TODO: Add update logic here
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
UPDATE InstructorsClass
SET
FirstName = @FirstName,
LastName = @LastName,
SlackHandle = @SlackHandle,
CohortOneId = @CohortOneId
Where Id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@FirstName", instructorsClasses.FirstName));
cmd.Parameters.Add(new SqlParameter("@LastName", instructorsClasses.LastName));
cmd.Parameters.Add(new SqlParameter("@SlackHandle", instructorsClasses.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@CohortOneId", instructorsClasses.CohortOneId));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
