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