private void populateCourseSchedule()
{
currentlyScheduledCoursesBindingSource.Clear();
using (var Dbconnection = new MCDEntities())
{
switch (CurrentScheduleToDisplay)
{
case ScheduleToDisplay.CompletedCourses:
currentlyScheduledCoursesBindingSource.DataSource = (from a in Dbconnection.GetAllCourseSchedulesWhichHavePassedCompletionDate()
select new CurrentlyScheduledCourses()
{
CourseStartDate = a.StartDate,
CourseEndDate = a.EndDate,
CourseID = a.CourseID,
CourseName = a.CourseName,
FacilitatorID = a.FacilitatorID,
FacilitatorName = a.FacilitatorName,
VenueID = a.VenueID,
VenueName = a.Venue,
AmountEnrolled = (int)a.AmountEnrolled,
CurriculumCourseID = a.CurriculumCourseID,
ScheduleLocationID = a.ScheduleLocationID,
ScheduleLocation = a.ScheduleLocation
}).ToList <CurrentlyScheduledCourses>();
break;
case ScheduleToDisplay.CoursesInProgress:
currentlyScheduledCoursesBindingSource.DataSource = (from a in Dbconnection.GetAllCourseSchedulesWhichCurrentlyInProgress()
select new CurrentlyScheduledCourses()
{
CourseStartDate = a.StartDate,
CourseEndDate = a.EndDate,
CourseID = a.CourseID,
CourseName = a.CourseName,
FacilitatorID = a.FacilitatorID,
FacilitatorName = a.FacilitatorName,
VenueID = a.VenueID,
VenueName = a.Venue,
AmountEnrolled = (int)a.AmountEnrolled,
CurriculumCourseID = a.CurriculumCourseID,
ScheduleLocationID = a.ScheduleLocationID,
ScheduleLocation = a.ScheduleLocation
}).ToList <CurrentlyScheduledCourses>();
break;
case ScheduleToDisplay.CoursesNotYetStarted:
currentlyScheduledCoursesBindingSource.DataSource = (from a in Dbconnection.GetAllCourseSchedulesWhichHaveNotStartedYet()
select new CurrentlyScheduledCourses()
{
CourseStartDate = a.StartDate,
CourseEndDate = a.EndDate,
CourseID = a.CourseID,
CourseName = a.CourseName,
FacilitatorID = a.FacilitatorID,
FacilitatorName = a.FacilitatorName,
VenueID = a.VenueID,
VenueName = a.Venue,
AmountEnrolled = (int)a.AmountEnrolled,
CurriculumCourseID = a.CurriculumCourseID,
ScheduleLocationID = a.ScheduleLocationID,
ScheduleLocation = a.ScheduleLocation
}).ToList <CurrentlyScheduledCourses>();
break;
}
refershFacilitators();
refresfVenues();
};
}
