public JsonResult GetStudentDetails(int studentId) { var studentdata = studentManager.GetAllStudentWithDepartmentNames(); var selectedStudent = studentdata.Find(s => s.StudentId == studentId); var coursesData = courseManager.GetAllCourses(); var coursesOfSelectedStudent = coursesData.Where(c => c.DepartmentId == selectedStudent.DepartmentId).ToList(); StudentAndCourses studentAndCourses = new StudentAndCourses(); studentAndCourses.Student = selectedStudent; studentAndCourses.Courses = coursesOfSelectedStudent; return(Json(studentAndCourses)); }
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)); }