private void populateCourseSchedule() { currentlyScheduledCoursesBindingSource.Clear(); using (var Dbconnection = new MCDEntities()) { switch (CurrentScheduleToDisplay) { case ScheduleToDisplay.CompletedCourses: CurrentlySelectedSchedules = new CustomSortableBindingList <Schedules>((from a in Dbconnection.GetAllScheduledCoursesWhichAreCompletedForSelectedCompany(OfProgressFiles.VerifyCompanyProgressFile(CurrentlySelectedCompany.CompanyID)) select new Schedules() { Department = a.Department, CurriculumName = a.CurriculumName, CourseName = a.CourseName, AmountEnrolled = (int)a.AmountEnrolled, StartDate = a.StartDate, EndDate = a.EndDate, ScheduledLocation = a.ScheduledLocation, VenueName = a.VenueName, FacilitatorName = a.FacilitatorName, VenueID = a.VenueID, FacilitactorID = a.FacilitactorID, LocationID = a.LocationID, CurriculumID = a.CurriculumID }).ToList <Schedules>()); currentlyScheduledCoursesBindingSource.DataSource = CurrentlySelectedSchedules; break; case ScheduleToDisplay.CoursesInProgress: CurrentlySelectedSchedules = new CustomSortableBindingList <Schedules>((from a in Dbconnection.GetAllScheduledCoursesWhichAreCurrentlyInProgressForSelectedCompany(OfProgressFiles.VerifyCompanyProgressFile(CurrentlySelectedCompany.CompanyID)) select new Schedules() { Department = a.Department, CurriculumName = a.CurriculumName, CourseName = a.CourseName, AmountEnrolled = (int)a.AmountEnrolled, StartDate = a.StartDate, EndDate = a.EndDate, ScheduledLocation = a.ScheduledLocation, VenueName = a.VenueName, FacilitatorName = a.FacilitatorName, VenueID = a.VenueID, FacilitactorID = a.FacilitactorID, LocationID = a.LocationID, CurriculumID = a.CurriculumID }).ToList <Schedules>()); currentlyScheduledCoursesBindingSource.DataSource = CurrentlySelectedSchedules; break; case ScheduleToDisplay.CoursesNotYetStarted: CurrentlySelectedSchedules = new CustomSortableBindingList <Schedules>((from a in Dbconnection.GetAllScheduledCoursesWhichAreNotYetStartedForSelectedCompany(OfProgressFiles.VerifyCompanyProgressFile(CurrentlySelectedCompany.CompanyID)) select new Schedules() { Department = a.Department, CurriculumName = a.CurriculumName, CourseName = a.CourseName, AmountEnrolled = (int)a.AmountEnrolled, StartDate = a.StartDate, EndDate = a.EndDate, ScheduledLocation = a.ScheduledLocation, VenueName = a.VenueName, FacilitatorName = a.FacilitatorName, VenueID = a.VenueID, FacilitactorID = a.FacilitactorID, LocationID = a.LocationID, CurriculumID = a.CurriculumID }).ToList <Schedules>()); currentlyScheduledCoursesBindingSource.DataSource = CurrentlySelectedSchedules; break; } refershFacilitators(); refresfVenues(); }; }