private void refreshPossibleSchedulingDates(List <int> FacilitatorFilterList = null, List <int> OnSiteVenueFilterList = null, List <int> OffSiteFitlerList = null, int OffSiteID = 0) { Common.EnumPreLoadType TypeOfLoading = Common.EnumPreLoadType.PreloadingOnSite; if (CurrentScheduleConfiguration.ScheduleLocationID == (int)EnumScheduleLocations.OffSite) { TypeOfLoading = Common.EnumPreLoadType.PreLoadingOffSite; } CourseAvailablePeriod ScheduleAlgorthim = new CourseAvailablePeriod( CourseSearchPeriodStartDate: dtScheduleFromCustomStartDateSelector.SelectionRange.Start.Date, CourseSearchPeriodEndDate: dtScheduleFromCustomStartDateSelector.SelectionRange.Start.AddMonths((int)CurrentPeriodAhead).Date, CourseID: CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CourseID, CourseDescription: CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.Course.CourseName, CourseDuration: CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.Duration, SetOfDaysOfWeekCourseCanBeScheulded: GetDayThatCurriculumCourseCanBeScheduled(), PreLoadingType: TypeOfLoading, FacilitatorFilterList: FacilitatorFilterList, OnSiteFilterList: OnSiteVenueFilterList, OffSiteFilterList: OffSiteFitlerList, OffSiteID: OffSiteID);//Company ID switch ((EnumScheduleLocations)CurrentScheduleConfiguration.ScheduleLocationID) { case (EnumScheduleLocations.Onsite): availableOnSitePeriodsBindingSource.DataSource = ScheduleAlgorthim.GetAllAvailableOnStiePeriods().OrderBy(a => a.CourseStartDate).ThenBy(a => a.FacilitatorName).ToList(); populateOnsiteFilters(ScheduleAlgorthim); break; case (EnumScheduleLocations.OffSite): availableOffSitePeriodsBindingSource.DataSource = ScheduleAlgorthim.GetAllAvailableOffSitePeriods().OrderBy(a => a.CourseStartDate).ThenBy(a => a.FacilitatorName).ToList(); populateOffSiteFilters(ScheduleAlgorthim); break; } }
private void frmPreCalculationTest_Load(object sender, EventArgs e) { DateTime dt = new DateTime(2017, 07, 19); //dt = dt.AddDays(-30); //CourseAvailablePeriodByFacilitator xxx = new CourseAvailablePeriodByFacilitator(SearchTimeAhead.OneMonth,dt.Date,4); CourseAvailablePeriod xx = new CourseAvailablePeriod(dt, new DateTime(2017, 08, 01), 4, "Orientation", 2, EnumPreLoadType.PreloadingOnSite , new List <EnumDayOfWeeks> { EnumDayOfWeeks.Monday, EnumDayOfWeeks.Tuesday, EnumDayOfWeeks.Wednesday, EnumDayOfWeeks.Thursday, EnumDayOfWeeks.Friday }, null, null, null, 2004); txtOutput.Text += "Booked Facilitator Dates:\n\n"; foreach (FacilitatorPeriod aa in xx.FacilitatorBookedPeriods) { txtOutput.Text += "Facilitator ID : " + aa.FacillitatorID.ToString() + " Facilitator Name " + aa.FacilitatorName + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; } txtOutput.Text += "\nAvailalble Facilitator Dates:\n\n"; foreach (FacilitatorPeriod aa in xx.FacilitatorAvailablePeriods) { txtOutput.Text += "Facilitator ID : " + aa.FacillitatorID.ToString() + " Facilitator Name " + aa.FacilitatorName + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; } txtOutput.Text += "\n Booked OnSiteVenue Dates:\n\n"; foreach (OnSiteVenuePeriod aa in xx.OnSiteVenueBookedPeriods) { txtOutput.Text += "Venue ID : " + aa.VenueID.ToString() + " Venue Name " + aa.VenueName + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; } txtOutput.Text += "\n Available OnSite Venue Dates:\n\n"; foreach (OnSiteVenuePeriod aa in xx.OnSiteVenueAvailablePeriods) { txtOutput.Text += "Venue ID : " + aa.VenueID.ToString() + " Venue Name " + aa.VenueName + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; } txtOutput.Text += "\n Booked OffSiteVenue Dates:\n\n"; foreach (OffSiteVenuePeriod aa in xx.OffSiteVenueBookedPeriods) { txtOutput.Text += "Venue ID : " + aa.VenueID.ToString() + " Venue Name " + aa.VenueName + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; } txtOutput.Text += "\n Available OffSite Venue Dates:\n\n"; foreach (OffSiteVenuePeriod aa in xx.OffSiteVenueAvailablePeriods) { txtOutput.Text += "Venue ID : " + aa.VenueID.ToString() + " Venue Name " + aa.VenueName + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; } //txtOutput.Text += "\n Available Dates that Each Ailitator Can Be Scheduled For a Course:\n\n"; //foreach (AvailableCoursePeriodByFacilitatorResultSet aa in xx.ListOfAvailableCoursePeriodByFacilitator) //{ // txtOutput.Text += "Facilitator ID : " + aa.FacilitatorID.ToString() + " Facilitator Name " + aa.FacilitatorName + "Course ID " + aa.CourseID + " Course Name " + aa.CourseName + " - StartDate: " + aa.CourseStartDate + " - EndDate: " + aa.CourseEndDate + "\n"; //} txtOutput.Text += "\nFINAL OUTPUT DATA SET: Available Facilitator Dates For Course Filtered by - FACILITATOR, Course : \n\n"; foreach (AvailableCoursePeriodByFacilitatorResultSet ACPBFRS in xx.ListOfAvailableCoursePeriodByFacilitator) { txtOutput.Text += "Facilitator ID : " + ACPBFRS.FacilitatorID.ToString() + " Facilitator Name " + ACPBFRS.FacilitatorName + "\nCourse ID " + ACPBFRS.CourseID + " Course Name " + ACPBFRS.CourseName + "\nStartDate: " + ACPBFRS.CourseStartDate + "\nEndDate: " + ACPBFRS.CourseEndDate + "\n-------------------------------------\n"; } txtOutput.Text += "\nFINAL OUTPUT DATA SET: Available Course Filtered by - FACILITATOR, VENUE : \n\n"; foreach (AvailableOnSitePeriods AOSP in xx.GetAllAvailableOnStiePeriods()) { txtOutput.Text += "Facilitator ID : " + AOSP.FacilitatorID.ToString() + " Facilitator Name " + AOSP.FacilitatorName + "\nCourse ID " + AOSP.CourseID + " Course Name " + AOSP.CourseName + "\nStartDate: " + AOSP.CourseStartDate + "\nEndDate: " + AOSP.CourseEndDate + "\nVenue ID : " + AOSP.VenueID.ToString() + " Venue Name " + AOSP.VenueName + "\n-------------------------------------\n"; } //SchedulingDateSearchAlgorithms ScheduleAlgorthim = new SchedulingDateSearchAlgorithms( // CourseIDBookingFor: 4, // InitialDateToStartFrom: dt.Date, // AmountOfSearchTimeAhead: SearchTimeAhead.OneMonth, // CurriculumCourseID: 4117, // ScheduleLocation: Common.Enum.EnumScheduleLocations.Onsite // ); //List<AvailableOnSitePeriods> kkkkk = xx.GetAllAvailableOnStiePeriodsV1(); dataGridView1.DataSource = xx.GetAllAvailableOnStiePeriods() .OrderBy(a => a.FacilitatorName) //.ThenBy(a => a.CourseEndDate) .ThenBy(a => a.CourseStartDate).ToList(); dataGridView2.DataSource = xx.GetAllAvailableOffSitePeriods() .OrderBy(a => a.FacilitatorName) //.ThenBy(a => a.CourseEndDate) .ThenBy(a => a.CourseStartDate).ToList(); CourseAvailablePeriod ScheduleAlgorthim = new CourseAvailablePeriod( CourseSearchPeriodStartDate: Common.CustomDateTime.getCustomDateTime( CurrentDate: new DateTime(2017, 07, 01), AmountDaysToAdd: 2, DaysCanSchedule: new List <EnumDayOfWeeks> { EnumDayOfWeeks.Monday, EnumDayOfWeeks.Tuesday, EnumDayOfWeeks.Wednesday, EnumDayOfWeeks.Thursday }), CourseSearchPeriodEndDate: new DateTime(2017, 08, 01), CourseID: 4, CourseDescription: "Orientation", CourseDuration: 2, PreLoadingType: EnumPreLoadType.PreloadingOnSite, SetOfDaysOfWeekCourseCanBeScheulded: new List <EnumDayOfWeeks> { EnumDayOfWeeks.Monday, EnumDayOfWeeks.Tuesday, EnumDayOfWeeks.Wednesday, EnumDayOfWeeks.Thursday }, OffSiteID: 2004); //availableOnSitePeriodsBindingSource.DataSource = ScheduleAlgorthim.GetAllAvailableOnStiePeriods(); //dataGridView1.DataSource = aa.CourseByFacilitatorAvailableDateSets; //txtOutput.Text += "Booked Facilitator Dates:\n\n"; //foreach (FacilitatorBookedDateSet aa in ScheduleAlgorthim.FacilitatorBookedDateSets) //{ // txtOutput.Text += aa.FacilitatorID.ToString() + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; //} //txtOutput.Text += "Available Facilitator Dates:\n\n"; //foreach (FacilitatorAvailableDateSet aa in ScheduleAlgorthim.FacilitatorAvailableDateSets) //{ // txtOutput.Text += aa.FacilitatorID.ToString() + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; //} //txtOutput.Text += "Booked Venues Dates:\n\n"; //foreach (VenueBookedDateSet aa in ScheduleAlgorthim.VenueBookedDateSets) //{ // txtOutput.Text += aa.VenueID.ToString() + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; //} //txtOutput.Text += "Available Venue Dates:\n\n"; //foreach (VenueAvailableDateSet aa in ScheduleAlgorthim.VenueAvailableDateSets) //{ // txtOutput.Text += aa.VenueID.ToString() + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; //} //txtOutput.Text += "Available Course By Facilitator Dates:\n\n"; //foreach (CourseByFacilitatorAvailableDateSet aa in ScheduleAlgorthim.CourseByFacilitatorAvailableDateSets) //{ // txtOutput.Text += "FacilitatorID: " + aa.FacilitatorID.ToString() + "CurriculumCourseID: " + aa.CurriculumCourseID + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; //} //txtOutput.Text += "Available Course By Facilitator AND Venue Dates:\n\n"; //foreach (CourseByFacilitatorAndVenueAvailableDateSet aa in ScheduleAlgorthim.CourseByFacilitatorAndVenueAvailableDateSets) //{ // txtOutput.Text += "FacilitatorID: " + aa.FacilitatorID.ToString() + " VenueID: " + aa.VenueID.ToString() + "CurriculumCourseID: " + aa.CurriculumCourseID + " - StartDate: " + aa.StartDate + " - EndDate: " + aa.EndDate + "\n"; //} }