/// <summary>
/// Opens the faculty informations window when the admin selects a teacher
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TeacherList_SelectedIndexChanged_1(object sender, EventArgs e)
{
string[] teacherInfo = this.TeacherList.Text.Split(' ');
String query = "Select * from users Where userID = '" + teacherInfo[2] + "'";
MySqlDataAdapter SDA = new MySqlDataAdapter(query, connection);
DataTable teacherTable = new DataTable();
SDA.Fill(teacherTable);
Faculty selectedTeacher = new Faculty(Convert.ToInt32(teacherTable.Rows[0]["userID"]));
FacultyInformationsWindows TeacherInfoWin = new FacultyInformationsWindows(connection, selectedTeacher, "Admin");
TeacherInfoWin.Show();
}
/// <summary>
/// Open the Faculty Information window (Teacher's environment)
/// </summary>
/// <param name="id"></param>
public static void RunTeacher(string id)
{
String query = "Select * from users Where userID = ' " + id + "'";
MySqlDataAdapter SDA = new MySqlDataAdapter(query, connection);
DataTable userTable = new DataTable();
SDA.Fill(userTable);
string classes = userTable.Rows[0]["className"].ToString();
string[] list = classes.Split(' ');
List <Class> listClasses = new List <Class>();
foreach (string classe in list)
{
Class c = new Class(classe);
listClasses.Add(c);
}
Faculty teacher = new Faculty(Convert.ToInt32(userTable.Rows[0]["userID"]));
FacultyInformationsWindows facWin = new FacultyInformationsWindows(connection, teacher, "Teacher");
facWin.Show();
}
