private void btnAddIncident_Click(object sender, EventArgs e) { String givenName = tBStudentGN.Text; String sureName = tBStudentSN.Text; Student currentStudent; Class currentClass; Teacher currentTeacher; try { currentStudent = UtilityDB.getStudent(givenName, sureName); currentClass = UtilityDB.getClass(currentStudent.class_ID); currentTeacher = UtilityDB.getTeacher(currentClass.teacher_ID); } catch (Exception) { // Fehlerhafte Eingabe. currentTeacher = new Teacher(0, "", "nicht", "gefunden", "nope"); currentClass = new Class(0, 0, "nicht gefunden"); } lBClassFilled.Text = currentClass.className; lbTeacherFilled.Text = currentTeacher.givenName + " " + currentTeacher.surname; }
/// <summary> /// Gets a class object by ClassName. /// </summary> /// <param name="className">The Name of the class.</param> /// <returns>Returns a class object or null</returns> public static Class getClass(String className) { try { openconnection(); cmd = new OleDbCommand("SELECT * FROM Class WHERE ClassName = @ClassName", connection); cmd.Parameters.AddWithValue("@ClassName", className); dr = cmd.ExecuteReader(); dr.Read(); int class_ID = Convert.ToInt32(dr[0].ToString()); int teacher_ID = Convert.ToInt32(dr[1].ToString()); className = dr[2].ToString(); Class c = new Class(class_ID, teacher_ID, className); closeconnection(); return c; } catch { return null; } }