/// <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(); }