public JsonResult GetCoursesWithSelectedUser(int ID)
{
SISEntities db = new SISEntities();
List <Json_Courses> course_list = new List <Json_Courses>();
var dept_id = db.Users.Where(row => row.TableID == ID).FirstOrDefault().u_Departments_TableID;
foreach (var course in db.Courses.Where(row => row.c_Departments_TableID == dept_id).ToList())
{
if (db.Lecturers_Courses.Where(r => r.lc_Users_TableID == ID).Where(r => r.lc_Courses_TableID == course.TableID).Any())
{
continue;
}
else
{
Json_Courses new_course = new Json_Courses
{
CourseID = course.TableID,
CourseName = course.c_Name,
};
course_list.Add(new_course);
}
}
return(Json(course_list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCourses(int ID)
{
SISEntities db = new SISEntities();
List <Json_Courses> course_list = new List <Json_Courses>();
foreach (var dep_ID in db.Deparments.Where(row => row.d_Faculties_TableID == ID).ToList())
{
foreach (var course in db.Courses.Where(row => row.c_Departments_TableID == dep_ID.TableID).ToList())
{
var dep_name = db.Deparments.Where(row => row.TableID == course.c_Departments_TableID).FirstOrDefault().d_Name;
Json_Courses new_course = new Json_Courses
{
CourseID = course.TableID,
CourseName = course.c_Name,
CourseTerm = course.c_Term,
CourseECTS = course.c_ECTS,
DepName = dep_name
};
course_list.Add(new_course);
}
}
return(Json(course_list, JsonRequestBehavior.AllowGet));
}
