/// <summary> /// Delete discipline /// </summary> /// <param name="id"></param> /// <returns></returns> public bool DeleteDiscipline(int id) { using (var context = new CoursesOfChoiceEntities()) { var discipline = context.Disciplines.SingleOrDefault(disc => disc.id == id); if (discipline == null) { return(false); } else { var singleOrDefault = discipline.Group.SingleOrDefault(gr => gr.Deleted == false && gr.Wave == 1); var groups = discipline.Group.ToList(); foreach (var gr in groups) { var sigs = gr.StudentsInGroups; context.Set <StudentsInGroups>().RemoveRange(sigs); context.Set <Group>().Remove(gr); } context.Set <Disciplines>().Remove(discipline); context.SaveChanges(); return(true); } } }
public void DeleteStudentInGroups(StudentsInGroups sig) { using (var context = new CoursesOfChoiceEntities()) { var elToRemove = context.Set <StudentsInGroups>().SingleOrDefault(el => el.id == sig.id); context.Set <StudentsInGroups>().Remove(elToRemove); deleteAmountStudent(sig.groupID); context.SaveChanges(); } }