public async Task <ActionResult> Create(InstructorsClassCreateViewModel model)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO InstructorsClass
( Id,FirstName, LastName, SlackHandle, CohortOneId )
VALUES
( @Id, @FirstName, @LastName, @SlackHandle, @CohortOneId )";
cmd.Parameters.Add(new SqlParameter("@Id", model.instructorsClass.Id));
cmd.Parameters.Add(new SqlParameter("@FirstName", model.instructorsClass.FirstName));
cmd.Parameters.Add(new SqlParameter("@LastName", model.instructorsClass.LastName));
cmd.Parameters.Add(new SqlParameter("@SlackHandle", model.instructorsClass.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@CohortOneId", model.instructorsClass.CohortOneId));
await cmd.ExecuteNonQueryAsync();
return(RedirectToAction(nameof(Index)));
}
}
}
// GET: InstructorsClass/Create
public ActionResult Create()
{
InstructorsClassCreateViewModel viewModel = new InstructorsClassCreateViewModel();
return(View());
}
