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