public bool WriteAbsence(StudentAbsence studentAbsence) { try { SaveAbsence(studentAbsence); return(true); } catch (MySqlException e) { Console.WriteLine(e.StackTrace); return(false); } }
private void SaveAbsence(StudentAbsence studentAbsence) { using (IDbConnection db = new MySqlConnection(ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString)) { const string sqlQuery = "INSERT INTO absenz(datum, grund, FK_Schueler, FK_Fach, FK_Lehrperson) " + "VALUES (@Date, @Reason, " + "(SELECT id_schueler FROM schueler WHERE vorname = @studentFirstname AND nachname = @studentLastname), " + "(SELECT id_fach FROM fach WHERE name = @Subject)," + "(SELECT id_lehrperson FROM lehrperson WHERE vorname = @teacherFirstname AND nachname = @teacherLastname))"; db.Execute(sqlQuery, new { studentAbsence.Date, studentAbsence.Reason, studentFirstname = SplitName(studentAbsence.Student)[0], studentLastname = SplitName(studentAbsence.Student)[1], studentAbsence.Subject, teacherFirstname = SplitName(studentAbsence.Teacher)[0], teacherLastname = SplitName(studentAbsence.Teacher)[1] }); } }
private void SaveAbsenceButton_Click(object sender, EventArgs e) { _studentAbsence = new StudentAbsence(studentTextField.Text, teacherTextField.Text, subjectTextField.Text, reasonTextField.Text, dateTextField.Text); _studentRepository.WriteAbsence(_studentAbsence); }