public IActionResult Delete(StudentDeleteViewModel model)
{
Student student = _studentRepository.GetStudent(model.Id);
_studentRepository.Delete(model.Id);
return(RedirectToAction("Index"));
}
// GET: Students/Delete/5
public ActionResult Delete(int id)
{
Student student = GetStudentById(id);
if (student == null)
{
return(NotFound());
}
StudentDeleteViewModel viewModel = new StudentDeleteViewModel
{
Student = student
};
return(View(viewModel));
}
// GET: Students/Delete/5
public ActionResult Delete(int id)
{
Student student = GetStudentById(id);
if (student == null)
{
return(NotFound());
}
StudentDeleteViewModel viewModel = new StudentDeleteViewModel
{
FirstName = student.FirstName,
LastName = student.LastName,
SlackHandle = student.SlackHandle,
CohortName = student.Cohort.Name
};
return(View(viewModel));
}
public ActionResult Delete(int id, StudentDeleteViewModel viewModel)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"DELETE FROM Student WHERE id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.ExecuteNonQuery();
}
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
