// GET: Instructors/Delete/5 public ActionResult Delete(int id) { Instructor instructor = GetInstructorById(id); if (instructor == null) { return(NotFound()); } InstructorDeleteViewModel viewModel = new InstructorDeleteViewModel { Instructor = instructor }; return(View(viewModel)); }
// GET: Instructors/Delete/5 public ActionResult Delete(int id) { Instructor instructor = GetInstructorById(id); if (instructor == null) { return(NotFound()); } InstructorDeleteViewModel viewModel = new InstructorDeleteViewModel { FirstName = instructor.FirstName, LastName = instructor.LastName, SlackHandle = instructor.SlackHandle, CohortName = instructor.Cohort.Name }; return(View(viewModel)); }
public ActionResult Delete(int id, InstructorDeleteViewModel viewModel) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"DELETE FROM Instructor WHERE id = @id"; cmd.Parameters.Add(new SqlParameter("@id", id)); cmd.ExecuteNonQuery(); } } return(RedirectToAction(nameof(Index))); } catch { return(View()); } }