public ActionResult RecommendCourses(int id) { StudentsContext dbCourses = new StudentsContext(); CrousesDBContext db1 = new CrousesDBContext(); TakenCoursesDBContext db2 = new TakenCoursesDBContext(); Student student = dbCourses.Students.Find(id); student.SetStudentCourses(db2, db1); return(View(student.SetCoursePriority(db1))); }
public ActionResult TakenCourses(int id) { StudentsContext db1 = new StudentsContext(); Student students = db1.Students.Find(id); CrousesDBContext dbCoruses = new CrousesDBContext(); List <Courses> courses = db.Courses.ToList(); TakenCoursesDBContext dbTaken1 = new TakenCoursesDBContext(); List <TakenCourse> TakenCourses1 = new List <TakenCourse>(); List <Courses> TakenCourses2 = new List <Courses>(); foreach (TakenCourse course in dbTaken1.TakenCourses) { if (course.studentId == students.id) { TakenCourses1.Add(course); } } for (int i = 0; i < courses.Count(); i++) { for (int j = 0; j < TakenCourses1.Count(); j++) { if (courses[i].ID == TakenCourses1[j].courseId) { TakenCourses2.Add(courses[i]); } if (courses[i].ID == courses.Count() - 1) { if (courses[i + 1].ID == TakenCourses1[j].courseId) { TakenCourses2.Add(courses[i]); } } } } StudentAndCourses studentAndCourses = new StudentAndCourses(); studentAndCourses.Courses = TakenCourses2; students.SetStudentCourses(dbTaken, db); studentAndCourses.Student = students; return(View(studentAndCourses)); }