public static void AddCourseStatus(string CourseCode, string Session, Boolean Status) { ProjectDB db = new ProjectDB(); Course Course = db.Courses.Where(dp => dp.Course_code == CourseCode).FirstOrDefault(); if (Course == null) { return; } CourseStatus OldCourseStatus = db.CourseStatus.Where(dp => dp.Course_code == Course.Course_code && dp.UnderSession == Session).FirstOrDefault(); if (OldCourseStatus != null) { return; } CourseStatus CourseStatus = new CourseStatus(); CourseStatus.Course_code = Course.Course_code; CourseStatus.Course_title = Course.Course_title; CourseStatus.Credit_hour = Course.Credit_hour; CourseStatus.Semester = Course.Semester; CourseStatus.UnderFaculty = Course.UnderFaculty; CourseStatus.UnderDepartment = Course.UnderDepartment; CourseStatus.CourseTeacherID = Course.CourseTeacherID; CourseStatus.CourseTeacherName = Course.CourseTeacherName; CourseStatus.CourseTeacherDepartment = Course.CourseTeacherDepartment; CourseStatus.CourseTeacherFaculty = Course.CourseTeacherFaculty; CourseStatus.UnderSession = Session; CourseStatus.Status = Status; db.CourseStatus.Add(CourseStatus); db.SaveChanges(); }
public static Boolean UpdateCourseStatus(string CourseCode, string Session, Boolean Status) { ProjectDB db = new ProjectDB(); CourseStatus CourseStatus = db.CourseStatus.Where(dp => dp.Course_code == CourseCode && dp.UnderSession == Session).FirstOrDefault(); if (CourseStatus == null) { return(false); } CourseStatus.Status = Status; db.Entry(CourseStatus).State = EntityState.Modified; db.SaveChanges(); return(true); }
public static Boolean IsMarkSubmitted(Course Course, string Session) { if (Course == null || Session == null) { return(false); } ProjectDB db = new ProjectDB(); CourseStatus CourseStatus = db.CourseStatus.Where(cs => cs.Course_code == Course.Course_code && cs.UnderSession == Session).FirstOrDefault(); if (CourseStatus == null || CourseStatus.Status == false) { return(false); } return(true); }