private void populateAllScheduledCourses_CURRENTLY_COMPLETED_REQUIRE_rEPORT_FEEDBACK() { //using (var Dbconnection = new MCDEntities()) //{ // rEPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_ResultBindingSource1.DataSource = // new Common.CustomSortableBindingList<REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result>( // Dbconnection.REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate().ToList<REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result>() // ); //}; CurrentlyAvailableVenues.Clear(); CurrentlyAvailableFacilitators.Clear(); CurrentlySelectedCourses.Clear(); using (var Dbconnection = new MCDEntities()) { foreach (REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result x in Dbconnection.REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate()) { CurrentlySelectedCourses.Add(new SectionalView() { AmountEnrolled = (int)x.AmountEnrolled, CostCode = x.CostCode, CourseID = x.CourseID, CourseName = x.CourseName, CurriculumCourseID = x.CurriculumCourseID, CurriculumName = x.CurriculumName, DepartmentID = x.DepartmentID, DepartmentName = x.DepartmentName, EndDate = x.EndDate, //EnrollmentProgressCurrentState = ( DateTime) x.EndDate, FacilitatorID = x.FacilitatorID, FacilitatorName = x.FacilitatorName, //LookupEnrollmentProgressStateID = x., LookupScheduleLocationID = x.LookupScheduleLocationID, StartDate = x.StartDate, VenueName = x.VenueName, VenueID = (int)x.VenueID }); CurrentlyAvailableVenues.Add(new Venue() { VenueID = (int)x.VenueID, VenueName = x.VenueName }); CurrentlyAvailableFacilitators.Add(new Individual() { IndividualID = (int)x.FacilitatorID, IndividualFirstName = x.FacilitatorName }); } rEPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_ResultBindingSource1.DataSource = new Common.CustomSortableBindingList <SectionalView>(CurrentlySelectedCourses); }; this.refresfVenues(); this.refershFacilitators(); }
private void loadReport() { rptScheduleSectionalView rpt = new rptScheduleSectionalView(); List <SectionalView> x = new List <SectionalView>(); //ds.ForEach(GetAllEnrollmentsCompanyAndStudent_Result GAECASR in ) using (var Dbconnection = new MCDEntities()) { switch (SectioanlViewToDisplay) { case enumScheduleSectionialViewToDisplay.NotYetConfirmed: foreach (REPORTS_GetAll_NOT_YET_CONFIRMED_CourseSchedules_Result GSR in Dbconnection.REPORTS_GetAll_NOT_YET_CONFIRMED_CourseSchedules()) { x.Add(new SectionalView() { AmountEnrolled = (int)GSR.AmountEnrolled, CostCode = GSR.CostCode, //CourseID = GSR.CourseID, CourseName = GSR.CourseName, //CurriculumCourseID = GSR.CurriculumCourseID, CurriculumName = GSR.CurriculumName, // DepartmentID = GSR.DepartmentID, DepartmentName = GSR.DepartmentName, EndDate = GSR.EndDate, EnrollmentProgressCurrentState = GSR.EnrollmentProgressCurrentState, //FacilitatorID = GSR.FacilitatorID, FacilitatorName = GSR.FacilitatorName, LookupEnrollmentProgressStateID = GSR.LookupEnrollmentProgressStateID, LookupScheduleLocationID = GSR.LookupScheduleLocationID, ReportHeading = "Enrollment Which Have Not Yet Been Scheduled.", StartDate = GSR.StartDate, //VenueID = (int)GSR.VenueID, VenueName = GSR.VenueName }); } break; case enumScheduleSectionialViewToDisplay.Confirmed_NotYetStarted: foreach (REPORTS_GetAll_CONFIRMED_CourseSchedulesWhichHaveNotStartedYet_Result GSR in Dbconnection.REPORTS_GetAll_CONFIRMED_CourseSchedulesWhichHaveNotStartedYet()) { x.Add(new SectionalView() { AmountEnrolled = (int)GSR.AmountEnrolled, CostCode = GSR.CostCode, //CourseID = GSR.CourseID, CourseName = GSR.CourseName, //CurriculumCourseID = GSR.CurriculumCourseID, CurriculumName = GSR.CurriculumName, // DepartmentID = GSR.DepartmentID, DepartmentName = GSR.DepartmentName, EndDate = GSR.EndDate, //EnrollmentProgressCurrentState = GSR.EnrollmentProgressCurrentState, //FacilitatorID = GSR.FacilitatorID, FacilitatorName = GSR.FacilitatorName, //LookupEnrollmentProgressStateID = GSR.LookupEnrollmentProgressStateID, LookupScheduleLocationID = GSR.LookupScheduleLocationID, ReportHeading = "All Scheduled Courese which have not Yet Started", StartDate = GSR.StartDate, //VenueID = (int)GSR.VenueID, VenueName = GSR.VenueName }); } break; case enumScheduleSectionialViewToDisplay.Confirmed_InProgress: foreach (REPORTS_GetAll_CONFIRMED_CourseSchedulesWhichCurrentlyInProgress_Result GSR in Dbconnection.REPORTS_GetAll_CONFIRMED_CourseSchedulesWhichCurrentlyInProgress()) { x.Add(new SectionalView() { AmountEnrolled = (int)GSR.AmountEnrolled, CostCode = GSR.CostCode, //CourseID = GSR.CourseID, CourseName = GSR.CourseName, //CurriculumCourseID = GSR.CurriculumCourseID, CurriculumName = GSR.CurriculumName, // DepartmentID = GSR.DepartmentID, DepartmentName = GSR.DepartmentName, EndDate = GSR.EndDate, // EnrollmentProgressCurrentState = GSR.EnrollmentProgressCurrentState, //FacilitatorID = GSR.FacilitatorID, FacilitatorName = GSR.FacilitatorName, // LookupEnrollmentProgressStateID = GSR.LookupEnrollmentProgressStateID, LookupScheduleLocationID = GSR.LookupScheduleLocationID, ReportHeading = "Scheduled Courses Which Are Currently Inprogress", StartDate = GSR.StartDate, //VenueID = (int)GSR.VenueID, VenueName = GSR.VenueName }); } break; case enumScheduleSectionialViewToDisplay.Confirmed_REquireReports: foreach (REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result GSR in Dbconnection.REPORTS_GetAll_CONFIRMED_AND_NOT_YET_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate()) { x.Add(new SectionalView() { AmountEnrolled = (int)GSR.AmountEnrolled, CostCode = GSR.CostCode, //CourseID = GSR.CourseID, CourseName = GSR.CourseName, //CurriculumCourseID = GSR.CurriculumCourseID, CurriculumName = GSR.CurriculumName, // DepartmentID = GSR.DepartmentID, DepartmentName = GSR.DepartmentName, EndDate = GSR.EndDate, // EnrollmentProgressCurrentState = GSR.EnrollmentProgressCurrentState, //FacilitatorID = GSR.FacilitatorID, FacilitatorName = GSR.FacilitatorName, // LookupEnrollmentProgressStateID = GSR.LookupEnrollmentProgressStateID, LookupScheduleLocationID = GSR.LookupScheduleLocationID, ReportHeading = "Courses Which Require Reports Feed Back From Facilitator.", StartDate = GSR.StartDate, //VenueID = (int)GSR.VenueID, VenueName = GSR.VenueName }); } break; case enumScheduleSectionialViewToDisplay.Confirmed_Complete: foreach (REPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result GSR in Dbconnection.REPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate()) { x.Add(new SectionalView() { AmountEnrolled = (int)GSR.AmountEnrolled, CostCode = GSR.CostCode, //CourseID = GSR.CourseID, CourseName = GSR.CourseName, //CurriculumCourseID = GSR.CurriculumCourseID, CurriculumName = GSR.CurriculumName, // DepartmentID = GSR.DepartmentID, DepartmentName = GSR.DepartmentName, EndDate = GSR.EndDate, // EnrollmentProgressCurrentState = GSR.EnrollmentProgressCurrentState, //FacilitatorID = GSR.FacilitatorID, FacilitatorName = GSR.FacilitatorName, // LookupEnrollmentProgressStateID = GSR.LookupEnrollmentProgressStateID, LookupScheduleLocationID = GSR.LookupScheduleLocationID, ReportHeading = "Completed Course - Archieved.(History)", StartDate = GSR.StartDate, //VenueID = (int)GSR.VenueID, VenueName = GSR.VenueName }); } break; } }; rpt.SetDataSource(x); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.RefreshReport(); }