// #3 Method updates TUTOR drop-down with available tutors
private void CB_AvailTimes_SelectedIndexChanged(object sender, EventArgs e)
{
CB_AvailTutors.Items.Clear();
TutorAccessLayer TAL = new TutorAccessLayer(Session.Database);
_tutors = TAL.GetAvailableTutorsInstrument(_instruments[CB_Instrument.SelectedIndex], _periods[CB_AvailTimes.SelectedIndex], _terms[LB_Terms.SelectedIndex], _day);
foreach (Tutor t in _tutors)
{
CB_AvailTutors.Items.Add(t.Forename + " " + t.Surname + " - " + TAL.CalculateTutorEfficiency(t, _terms[LB_Terms.SelectedIndex]) + "% booked");
}
}
private void B_Logon_Click(object sender, EventArgs e)
{
TutorAccessLayer TAL = new TutorAccessLayer(Session.Database);
if (TAL.Login(TB_Username.Text, TB_Password.Text))
{
TutorHome TutorWin = new TutorHome();
TutorWin.Show();
}
else
{
MessageBox.Show("Your credientials are invalid.", "Invalid Login");
}
}
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();
}