public ActionResult Edit(int id, CohortOneEditViewModel viewModel)
{
CohortOne cohortOne = viewModel.cohorts;
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
UPDATE CohortOne
SET
Id = @id,
Name = @Name
Where Id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@Name", cohortOne.Name));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
// GET: CohortOne/Edit/5
public ActionResult Edit(int id)
{
CohortOne cohortOne = GetCohortOneById(id);
List <CohortOne> cohorts = GetAllCohortOnes();
CohortOneEditViewModel viewModel = new CohortOneEditViewModel();
viewModel.cohorts = cohortOne;
viewModel.AvailableCohorts = cohorts;
return(View(viewModel));
}
