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