private void btnpicFileSearch_Click(object sender, EventArgs e)
{
using (frmCompanySearch frm = new frmCompanySearch())
{
frm.ShowDialog();
if (frm.CurrentCompany != null)
{
OfProgressFiles.VerifyCompanyProgressFile(frm.CurrentCompany.CompanyID);
this.CurrentlySelectedCompany = frm.CurrentCompany;
this.refreshCompanyFile();
}
}
}
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();
};
}
private void populateEnrolments()
{
using (var Dbconnection = new MCDEntities())
{
getAllEnrollmentsPerCompany_ResultBindingSource.DataSource =
new CustomSortableBindingList <GetAllEnrollmentsPerCompany_Result>(Dbconnection.GetAllEnrollmentsPerCompany(OfProgressFiles.VerifyCompanyProgressFile(this.CurrentlySelectedCompany.CompanyID)).ToList <GetAllEnrollmentsPerCompany_Result>());
};
}
