private void populateFacilitators() { if (currentlyScheduledCoursesBindingSource.Count > 0) { CustomSortableBindingList <Schedules> l = (CustomSortableBindingList <Schedules>)currentlyScheduledCoursesBindingSource.List; individualBindingSource.DataSource = (from a in l select new Individual() { IndividualID = a.FacilitactorID, IndividualFirstName = a.FacilitatorName }).Distinct <Individual>(new individualComparer()).ToList <Individual>(); } ; }
private void populateVenues() { if (currentlyScheduledCoursesBindingSource.Count > 0) { CustomSortableBindingList <Schedules> l = (CustomSortableBindingList <Schedules>)currentlyScheduledCoursesBindingSource.List; venueBindingSource.DataSource = (from a in l select new Venue() { VenueID = a.VenueID, VenueName = a.VenueName }).Distinct <Venue>(new VenueComparer()).ToList <Venue>(); } ; }
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(); }; }