public ActionResult PersonCourses()
{
using (SchoolEntitiesDBContext db = new SchoolEntitiesDBContext())
{
List <OnlineCourse> onlineCourses = new List <OnlineCourse>();
List <OnsiteCourse> onsiteCourses = new List <OnsiteCourse>();
List <PersonCours> allPersonCourses = new List <PersonCours>();
onsiteCourses = db.OnsiteCourses.ToList();
onlineCourses = db.OnlineCourses.ToList();
allPersonCourses = db.PersonCourses.ToList();
SessionData objSession = Session["UserData"] as SessionData;
var lstAllCoursesOfPerson = from objOnlineCourse in onlineCourses
join objOnsiteCourse in onsiteCourses
on objOnlineCourse.CourseID equals objOnsiteCourse.CourseID into Table1
from objOnsiteCourse in Table1.ToList()
join objPersonCourses in allPersonCourses
on objOnsiteCourse.CourseID equals objPersonCourses.CourseID into Table2
from objPersonCourses in Table2.ToList()
where objPersonCourses.PersonID == objSession.PersonID
select new PersonCourses
{
busOnlineCourses = objOnlineCourse,
busOnsiteCourses = objOnsiteCourse,
busPersonCourses = objPersonCourses
};
return(View(lstAllCoursesOfPerson));
}
}
public ActionResult DepartmentCourses()
{
SessionData sessionObj = new SessionData();
sessionObj = this.Session["UserData"] as SessionData;
if (sessionObj != null)
{
ViewBag.UserName = sessionObj.UserName;
}
using (SchoolEntitiesDBContext db = new SchoolEntitiesDBContext())
{
List <Course> lstCourses = db.Courses.ToList();
List <Department> lstDepartments = db.Departments.ToList();
var lstDepartmentCources = from c in lstCourses
join d in lstDepartments on c.DepartmentID equals d.DepartmentID into table1
from d in table1.ToList()
select new DepartmentCourses
{
ObjCourse = c,
ObjDepartment = d
};
return(View(lstDepartmentCources));
}
}
