// GET: Cohort/Create public ActionResult Create() { CohortCreateViewModel viewModel = new CohortCreateViewModel(); return(View(viewModel)); }
public ActionResult Create(CohortCreateViewModel viewModel) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"INSERT INTO cohort ([Name]) VALUES (@cohortName)"; cmd.Parameters.Add(new SqlParameter("@cohortName", viewModel.Cohort.Name)); cmd.ExecuteNonQuery(); return(RedirectToAction(nameof(Index))); } } } catch { viewModel.Cohorts = GetAllCohorts(); return(View(viewModel)); } }
public async Task <ActionResult> Create(CohortCreateViewModel model) { string sql = $@"INSERT INTO Cohort (Name) VALUES ( '{model.cohort.Name}' );"; using (IDbConnection conn = Connection) { var newId = await conn.ExecuteAsync(sql); return(RedirectToAction(nameof(Index))); } }
public ActionResult Create(CohortCreateViewModel viewModel) { try { // TODO: Add insert logic here using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = $@"INSERT INTO Cohort(CohortName) VALUES(@cohortname);"; cmd.Parameters.Add(new SqlParameter("@cohortname", viewModel.Cohort.CohortName)); cmd.ExecuteNonQuery(); return(RedirectToAction(nameof(Index))); } } } catch { return(View()); } }
// GET: Cohorts/Create public ActionResult Create() { var viewModel = new CohortCreateViewModel(_config.GetConnectionString("DefaultConnection")); return(View(viewModel)); }