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(); }; }