public ActionResult ConfirmDeleteStudent(int id) { //Deletes relation between parent & student Guardianship delete = db.Guardianships.Find(id); if (delete == null) { return(RedirectToAction("ManageStudent", "Students")); } db.Guardianships.Remove(delete); db.SaveChanges(); return(RedirectToAction("ManageStudent", "Students")); }
public ActionResult AddStudent(Student viewModel) //Get entered Student information and query it against Students, if student exists in Students, add Guardianship entity { List <int> StudentList = new List <int>(); var parent = User.Identity.GetUserId(); var F_Name = viewModel.Stud_F_Name; var L_Name = viewModel.Stud_L_Name; var DOB = viewModel.Date_Of_Birth; bool added = false; var existingStudent = from m in db.Students where m.Stud_F_Name == F_Name && m.Stud_L_Name == L_Name select m; var dateCheck = from m in existingStudent where DOB.Equals(m.Date_Of_Birth) select m.Student_Number; foreach (int s in dateCheck) { Guardianship guardianship = new Guardianship(); guardianship.UserName = parent; guardianship.Student_Number = s; db.Guardianships.Add(guardianship); added = true; } db.SaveChanges(); if (!added) { return(RedirectToAction("AddStudent", "Students")); } return(RedirectToAction("ManageStudent", "Students")); }