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;
}
}