private void populateAllScheduledCourses_CURRENTLY_COMPLETED_AND_ACRHIVED()
{
//using (var Dbconnection = new MCDEntities())
//{
// rEPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_ResultBindingSource1.DataSource =
// new Common.CustomSortableBindingList<REPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result>(
// Dbconnection.REPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate()
// .ToList<REPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result>()
// );
//};
CurrentlyAvailableVenues.Clear();
CurrentlyAvailableFacilitators.Clear();
CurrentlySelectedCourses.Clear();
using (var Dbconnection = new MCDEntities())
{
foreach (REPORTS_GetAll_CONFIRMED_AND_COMPLETED_CourseSchedulesWhichHavePassedCompletionDate_Result x in Dbconnection.REPORTS_GetAll_CONFIRMED_AND_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_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();
}
