public ActionResult Create(InstructorCreateEditViewModel model)
{
try
{
// TODO: Add insert logic here
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor
(FirstName, LastName, SlackHandle, Specialty, CohortId)
VALUES
(@firstName, @lastName, @slackHandle, @specialty, @cohortId)";
cmd.Parameters.AddWithValue("@firstName", model.Instructor.FirstName);
cmd.Parameters.AddWithValue("@lastName", model.Instructor.LastName);
cmd.Parameters.AddWithValue("@slackHandle", model.Instructor.SlackHandle);
cmd.Parameters.AddWithValue("@specialty", model.Instructor.Specialty);
cmd.Parameters.AddWithValue("@cohortId", model.Instructor.CohortId);
cmd.ExecuteNonQuery();
}
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, InstructorCreateEditViewModel model)
{
try
{
// TODO: Add update logic here
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"UPDATE Instructor
SET
FirstName = @firstName,
LastName = @lastName,
SlackHandle = @slackHandle,
Specialty = @specialty,
CohortId = @cohortId
WHERE Id = @id";
cmd.Parameters.AddWithValue("@firstName", model.Instructor.FirstName);
cmd.Parameters.AddWithValue("@lastName", model.Instructor.LastName);
cmd.Parameters.AddWithValue("@slackHandle", model.Instructor.SlackHandle);
cmd.Parameters.AddWithValue("@specialty", model.Instructor.Specialty);
cmd.Parameters.AddWithValue("@cohortId", model.Instructor.CohortId);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
}
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
// GET: Instructors/Create
public ActionResult Create()
{
var cohorts = GetAllCohorts();
var viewModel = new InstructorCreateEditViewModel(cohorts);
return(View(viewModel));
}
// GET: Instructors/Edit/5
public ActionResult Edit(int id)
{
Instructor instructor = GetSingleInstructor(id);
var cohorts = GetAllCohorts();
var viewModel = new InstructorCreateEditViewModel(instructor, cohorts);
return(View(viewModel));
}