// #2a Method updates PERIODS drop-down with available periods private void LB_Day_SelectedIndexChanged(object sender, EventArgs e) { CB_AvailTimes.Items.Clear(); _day = _days[LB_Day.SelectedIndex]; PeriodAccessLayer PAL = new PeriodAccessLayer(Session.Database); _periods = PAL.GetFreePeriods(_instruments[CB_Instrument.SelectedIndex], _terms[LB_Terms.SelectedIndex], _day); foreach (Period p in _periods) { CB_AvailTimes.Items.Add(p.Id); } }
// #2b occurs if picking a custom date private void DTP_StartDate_ValueChanged(object sender, EventArgs e) { CB_AvailTimes.Items.Clear(); if (DTP_StartDate.Value < _terms[LB_Terms.SelectedIndex].StartDate || DTP_StartDate.Value > _terms[LB_Terms.SelectedIndex].EndDate) { MessageBox.Show("The selected date is not within the selected term."); } else { _day = DTP_StartDate.Value.DayOfWeek; CB_AvailTimes.Items.Clear(); PeriodAccessLayer PAL = new PeriodAccessLayer(Session.Database); _periods = PAL.GetFreePeriods(_instruments[CB_Instrument.SelectedIndex], _terms[LB_Terms.SelectedIndex], _day); foreach (Period p in _periods) { CB_AvailTimes.Items.Add(p.Id); } } }
private void FillLists() { InstrumentAccessLayer IAL = new InstrumentAccessLayer(Session.Database); _instruments = IAL.GetAllInstruments(); TermAccessLayer TAL = new TermAccessLayer(Session.Database); _terms = TAL.GetAllTerms(); DayAccessLayer DAL = new DayAccessLayer(Session.Database); _days = DAL.GetAllDays(); PeriodAccessLayer PAL = new PeriodAccessLayer(Session.Database); _periods = PAL.GetAllPeriods(); TutorAccessLayer TuAL = new TutorAccessLayer(Session.Database); _tutors = TuAL.GetAllTutors(); RoomAccessLayer RAL = new RoomAccessLayer(Session.Database); _rooms = RAL.GetAllRooms(); }