// GET: Exercises/Delete/5 public ActionResult Delete(int id) { Exercise exercise = GetExerciseById(id); if (exercise == null) { return(NotFound()); } ExerciseDeleteViewModel viewModel = new ExerciseDeleteViewModel { Exercise = exercise }; return(View(viewModel)); }
public ActionResult Delete(int id, ExerciseDeleteViewModel viewModel) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"DELETE FROM exercise WHERE id = @id;"; cmd.Parameters.Add(new SqlParameter("@id", id)); cmd.ExecuteNonQuery(); } } return(RedirectToAction(nameof(Index))); } catch { return(View()); } }