public void DeleteExamPeriod(int examPeriodId) { using (StudentDbEntities dbContext = new StudentDbEntities()) { var findExamPeriod = dbContext.tblExamPeriods.Find(examPeriodId); if (dbContext.tblExams.Any(x => x.ExamPeriodId == examPeriodId)) { DeleteFault fault = new DeleteFault() { Result = false, Message = "Unable to delete!", Description = "Exam Period is referenced in Exam." }; throw new FaultException <DeleteFault>(fault); } if (findExamPeriod != null) { dbContext.tblExamPeriods.Remove(findExamPeriod); dbContext.SaveChanges(); } } }
public void DeleteDepartment(int departmentId) { using (StudentDbEntities dbContext = new StudentDbEntities()) { var findDepartment = dbContext.tblDepartments.Find(departmentId); if (dbContext.tblStudyPrograms.Any(x => x.DepartmentId == departmentId)) { DeleteFault fault = new DeleteFault() { Result = false, Message = "Unable to delete!", Description = "Department is referenced in Study Program." }; throw new FaultException <DeleteFault>(fault); } if (findDepartment != null) { dbContext.tblDepartments.Remove(findDepartment); dbContext.SaveChanges(); } } }
public void DeleteProfessor(int professorId) { using (StudentDbEntities dbContext = new StudentDbEntities()) { var findProfessor = dbContext.tblProfessors.Find(professorId); if (dbContext.tblCourses.Any(x => x.ProfessorId == professorId)) { DeleteFault fault = new DeleteFault() { Result = false, Message = "Unable to delete!", Description = "Professor is referenced in Course." }; throw new FaultException <DeleteFault>(fault); } if (findProfessor != null) { dbContext.tblProfessors.Remove(findProfessor); dbContext.SaveChanges(); } } }
public void DeleteStudyProgram(int studyProgramId) { using (StudentDbEntities dbContext = new StudentDbEntities()) { var findStudyProgram = dbContext.tblStudyPrograms.Find(studyProgramId); if (dbContext.tblStudents.Any(x => x.StudyProgramId == studyProgramId)) { DeleteFault fault = new DeleteFault() { Result = false, Message = "Unable to delete!", Description = "Study Program is referenced in Student." }; throw new FaultException <DeleteFault>(fault); } if (findStudyProgram != null) { dbContext.tblStudyPrograms.Remove(findStudyProgram); dbContext.SaveChanges(); } } }