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