public ActionResult Create(CohortOneCreateViewModel model)
{
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
// TODO: Add insert logic here
cmd.CommandText = @"INSERT INTO CohortOne
( Id, Name ) VALUES ( @Id, @Name)";
cmd.Parameters.Add(new SqlParameter("@Id", model.cohortOne.Id));
cmd.Parameters.Add(new SqlParameter("@Name", model.cohortOne.Name));
cmd.ExecuteNonQueryAsync();
return(RedirectToAction(nameof(Index)));
}
}
}
}
// GET: CohortOne/Create
public ActionResult Create()
{
CohortOneCreateViewModel viewModel = new CohortOneCreateViewModel();
return(View());
}
