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);
}
public void addRowToTutor()
{
TutorDBAccess Tdba = new TutorDBAccess(db);
int tutorNo = int.Parse(DGrid1.Rows[numRowsBeforeAdd].Cells[0].Value.ToString());
String tutorTitle = DGrid1.Rows[numRowsBeforeAdd].Cells[1].Value.ToString();
String tutorFirstName = DGrid1.Rows[numRowsBeforeAdd].Cells[2].Value.ToString();
String tutorLastName = DGrid1.Rows[numRowsBeforeAdd].Cells[3].Value.ToString();
String tutorTelNo = DGrid1.Rows[numRowsBeforeAdd].Cells[4].Value.ToString();
String tutorEmail = DGrid1.Rows[numRowsBeforeAdd].Cells[5].Value.ToString();
Tdba.insertTutor(tutorNo, tutorTitle, tutorFirstName, tutorLastName, tutorTelNo, tutorEmail);
MessageBox.Show("The row has been added to the database table Department.", "Success.");
}
private void EditBtn_Click(object sender, EventArgs e)
{
TutorDBAccess TDBAccess = new TutorDBAccess(db);
int num = DGrid1.Rows.Count - 2;
TutorDBAccess Tdba = new TutorDBAccess(db);
int tutorNo = int.Parse(DGrid1.Rows[num].Cells[0].Value.ToString());
String tutorTitle = DGrid1.Rows[num].Cells[1].Value.ToString();
String tutorFirstName = DGrid1.Rows[num].Cells[2].Value.ToString();
String tutorLastName = DGrid1.Rows[num].Cells[3].Value.ToString();
String tutorTelNo = DGrid1.Rows[num].Cells[4].Value.ToString();
String tutorEmail = DGrid1.Rows[num].Cells[5].Value.ToString();
Tdba.updateTutor(tutorNo, tutorTitle, tutorFirstName, tutorLastName, tutorTelNo, tutorEmail);
MessageBox.Show("The row in the database has been updated.", "Success.");
DGrid1.DataSource = null;
CreateTableResults(TDBAccess.getAllTutors());
}
private void frmStaffMenu_Load(object sender, EventArgs e)
{
TutorDBAccess TDBAccess = new TutorDBAccess(db);
CreateTableResults(TDBAccess.getAllTutors());
}
