private void refreshCurrentlyScheduledDates() { using (var Dbconnection = new MCDEntities()) { //CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum //Dbconnection.CurriculumCourseEnrollments.Attach(CurrentSelectedCurriculumCourseEnrollment); //Dbconnection.Entry(CurrentSelectedCurriculumCourseEnrollment).Reference("CurriculumCourse.CurriculumCourseMinimumMaximum").Load(); int MaxPerCourse = 0; if (CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum != 0) { MaxPerCourse = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum; } //CurrentlyScheduledCourses List <CurrentlyScheduledCourses> CSC = new List <CurrentlyScheduledCourses>(); switch (CurrentScheduleConfiguration.ScheduleLocationID) { case (int)Common.Enum.EnumScheduleLocations.Onsite: List <GetAllOnSiteScheduledCourses_Result> AOSSC_Onsite = Dbconnection.GetAllOnSiteScheduledCourses( scheduleLocationID: CurrentScheduleConfiguration.ScheduleLocationID, curriculumCourseID: CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CurriculumCourseID, startDate: EnsureSchedulableDate(dtScheduleFromCustomStartDateSelector.SelectionStart.Date),// dtScheduleFromCustomStartDateSelector.SelectionStart.Date, endDate: dtScheduleFromCustomStartDateSelector.SelectionStart.Date.AddMonths((int)CurrentPeriodAhead)) .ToList <GetAllOnSiteScheduledCourses_Result>(); foreach (GetAllOnSiteScheduledCourses_Result item in AOSSC_Onsite.Where(a => a.AmountEnrolled < MaxPerCourse)) { CSC.Add(new CurrentlyScheduledCourses() { CourseStartDate = item.ScheduleStartDate.Date, CourseEndDate = item.ScheduleCompletionDate.Date, CourseName = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.Course.CourseName, CourseID = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CourseID, FacilitatorID = item.IndividualID, FacilitatorName = item.FacilitatorName, VenueID = item.VenueID, VenueName = item.VenueName, AmountEnrolled = Convert.ToInt32(item.AmountEnrolled) }); } currentlyScheduledCoursesBindingSource.DataSource = CSC.ToList(); break; case (int)Common.Enum.EnumScheduleLocations.OffSite: List <GetAllOffSiteScheduledCourses_Result> AOSSC_OffSite = Dbconnection.GetAllOffSiteScheduledCourses( scheduleLocationID: CurrentScheduleConfiguration.ScheduleLocationID, curriculumCourseID: CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CurriculumCourseID, startDate: EnsureSchedulableDate(dtScheduleFromCustomStartDateSelector.SelectionStart.Date), // dtScheduleFromCustomStartDateSelector.SelectionStart.Date, endDate: dtScheduleFromCustomStartDateSelector.SelectionEnd.Date).ToList <GetAllOffSiteScheduledCourses_Result>(); //CurrentlyScheduledCourses // List<CurrentlyScheduledCourses> CSC = new List<CurrentlyScheduledCourses>(); foreach (GetAllOffSiteScheduledCourses_Result item in AOSSC_OffSite.Where(a => a.AmountEnrolled < MaxPerCourse)) { CSC.Add(new CurrentlyScheduledCourses() { CourseStartDate = item.ScheduleStartDate.Date, CourseEndDate = item.ScheduleCompletionDate.Date, CourseName = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.Course.CourseName, CourseID = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse.CourseID, FacilitatorID = item.IndividualID, FacilitatorName = item.FacilitatorName, VenueID = item.VenueID, VenueName = item.VenueName, AmountEnrolled = Convert.ToInt32(item.AmountEnrolled) }); } currentlyScheduledCoursesBindingSource.DataSource = CSC.ToList(); break; } //CurrentlyScheduledCourses }; }