public void DeleteInstructors(int[] instructorIds) { using (ClassAdministrationEntityContext context = new ClassAdministrationEntityContext(BUTEClassAdministrationService.Properties.Resources.connectionString)) { var instructors = context.InstructorSet.Where(instructor => instructorIds.Contains(instructor.Id)); foreach (var instructor in instructors) { context.DeleteObject(instructor); } context.SaveChanges(); } }
public void DeleteStudents(int[] studentIds) { using (ClassAdministrationEntityContext context = new ClassAdministrationEntityContext(BUTEClassAdministrationService.Properties.Resources.connectionString)) { var students = context.StudentSet.Where(student => studentIds.Contains(student.Id)); foreach (var student in students) { context.DeleteObject(student); } context.SaveChanges(); } }
public void DeleteGroups(int semesterId) { using (ClassAdministrationEntityContext context = new ClassAdministrationEntityContext(BUTEClassAdministrationService.Properties.Resources.connectionString)) { var groups = context.GroupSet.Where(group => group.Semester.Id == semesterId); foreach (var group in groups) { foreach (var student in group.Student) { student.Group = null; } } foreach (var group in groups) { foreach (var student in group.Student) { context.DeleteObject(group); } } context.SaveChanges(); } }