public List <ExtendedHomeworkPlan> GetExtendedHomeworkPlan(int id) { try { List <Assignment> assignments = new AssignmentRepo().GetAllAssignments(); List <Homework> homeworks = new HomeworkRepo().GetAllHomework(); List <HomeworkPlan> homeworkPlans = new HomeworkPlanRepo().GetHomeworkPlans() .Where(homeworkPlan => homeworkPlan.StudentID == id).ToList(); var result = from plan in homeworkPlans join homework in homeworks on plan.HomeworkID equals homework.HomeworkID select new ExtendedHomeworkPlan { StudentID = id, HomeworkID = homework.HomeworkID, Description = homework.Description, Deadline = homework.Deadline, ReqTime = homework.ReqTime, PriorityLevel = plan.PriorityLevel, isCompleted = plan.isCompleted }; if (result.Any()) { return(result.ToList()); } else { throw new PrometheusException("No Plans Found!"); //DeviseHomeworkPlanByDeadline(id); } } catch (Exception) { throw; } }
public List <AssignedHomework> GetAssignedHomework(int id) { try { List <EnrolledCourse> enrolledCourses = GetCoursesByStudentID(id); List <Assignment> assignments = new AssignmentRepo().GetAllAssignments(); List <Homework> homeworks = new HomeworkRepo().GetAllHomework(); var result = from course in enrolledCourses join assignment in assignments on course.CourseID equals assignment.CourseID join homework in homeworks on assignment.HomeWorkID equals homework.HomeworkID select new AssignedHomework { AssignmentID = assignment.AssignmentID, Description = homework.Description, Deadline = homework.Deadline, ReqTime = homework.ReqTime, LongDescription = homework.LongDescription, CourseName = course.Name, HomeworkID = homework.HomeworkID }; if (result.Any()) { return(result.ToList()); } else { throw new PrometheusException("No Assignments Found !"); } } catch (Exception) { throw; } }