private void frmAddBooking_Load(object sender, EventArgs e)
{
InstrumentDBAccess TuitionAccess = new InstrumentDBAccess(db);
TuitionArea = TuitionAccess.getAllInstruments();
// Add tuition to tuition combo box
for (int i = 0; i < TuitionArea.Count; i++)
{
comboBox1.Items.Add(TuitionArea[i].InstrumentName);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
TutorDBAccess TDBAccess = new TutorDBAccess(db);
InstrumentDBAccess IDBAccess = new InstrumentDBAccess(db);
List <Staff> tutors = new List <Staff>();
Staff Selected = new Staff();
Selected = TDBAccess.getTutorByTutorNo(Convert.ToInt32(txtBox1.Text));
tutors.Add(Selected);
CreateTableResults(tutors);
}
private void frmShowBooking_Load(object sender, EventArgs e)
{
BookingDBAccess BDBAccess = new BookingDBAccess(db);
InstrumentDBAccess IDBAccess = new InstrumentDBAccess(db);
PupilDBAccess PDBAccess = new PupilDBAccess(db);
selection = cBox.SelectedIndex;
lbl1.Visible = false;
lbl2.Visible = false;
btnSearch.Visible = false;
txtBox1.Visible = false;
txtBox2.Visible = false;
}
private void frmShowPupils_Load(object sender, EventArgs e)
{
PupilDBAccess PDBAccess = new PupilDBAccess(db);
BookingDBAccess BDBAccess = new BookingDBAccess(db);
InstrumentDBAccess IDBAccess = new InstrumentDBAccess(db);
selection = cBox.SelectedIndex;
lbl1.Visible = false;
lbl2.Visible = false;
txtBoxID.Visible = false;
txtBoxName.Visible = false;
btn1.Visible = false;
}
private void cBox1_SelectedIndexChanged(object sender, EventArgs e)
{
PupilDBAccess PDBAccess = new PupilDBAccess(db);
BookingDBAccess BDBAccess = new BookingDBAccess(db);
InstrumentDBAccess IDBAccess = new InstrumentDBAccess(db);
switch (cBox.SelectedIndex)
{
case 0: CreateTableResults(BDBAccess.getAllBookings(), IDBAccess.getAllInstruments(), PDBAccess.getAllPupils()); break;
case 1: lbl1.Visible = true;
lbl2.Visible = true;
btnSearch.Visible = true;
txtBox1.Visible = true;
txtBox2.Visible = true; break;
}
}
private void btn1_Click(object sender, EventArgs e)
{
PupilDBAccess PDBAccess = new PupilDBAccess(db);
BookingDBAccess BDBAccess = new BookingDBAccess(db);
InstrumentDBAccess IDBAccess = new InstrumentDBAccess(db);
List <Pupil> pupils = new List <Pupil>();
Pupil Selected = new Pupil();
if (string.IsNullOrWhiteSpace(txtBoxID.Text))
{
pupils = PDBAccess.getPupilByPupilName(txtBoxName.Text);
}
else
{
Selected = PDBAccess.getPupilByPupilNo(Convert.ToInt32(txtBoxID.Text));
pupils.Add(Selected);
}
CreateTableResults(pupils);
}
