public void ResetAddStudentControl(bool clearLog = true) { /* * This function contains all code that needs to be executed when the control is reloaded * * You need to edit this code. * Example: Emptying textboxes and gridviews * */ phoneNumbers.Clear(); phoneTypes.Clear(); StudentidTextbox.ResetText(); FirstnameTextbox.ResetText(); LastnameTextbox.ResetText(); GenderTextbox.ResetText(); StreetadressTextbox.ResetText(); ZipcodeTextbox.ResetText(); CityTextbox.ResetText(); CountryTextbox.ResetText(); BirthdateDatepicker.Value = BirthdateDatepicker.MaxDate; PhoneNumberTextbox.ResetText(); AddedPhoneNumbers_Readonly.ResetText(); if (clearLog) { RegisterStatusTextbox.ResetText(); } }
private void RegisterNewStudentButton_Click(object sender, EventArgs e) { int exitCodeStudent = dbconn.addStudentToDB( StudentidTextbox.Text, FirstnameTextbox.Text, LastnameTextbox.Text, GenderTextbox.Text, StreetadressTextbox.Text, ZipcodeTextbox.Text, CityTextbox.Text, CountryTextbox.Text, string.Format($"{BirthdateDatepicker.Value.Year + "-" + BirthdateDatepicker.Value.Month + "-" + BirthdateDatepicker.Value.Day}"), StudentTypeCombobox.Text ); int[] exitCodePhoneNumbers = new int[phoneNumbers.Count]; exitCodePhoneNumbers = dbconn.addStudentPhoneNoToDB( StudentidTextbox.Text, phoneNumbers, phoneTypes ); if (exitCodeStudent == -1) { RegisterStatusTextbox.Text += "0 rows updated..."; RegisterStatusTextbox.AppendText(Environment.NewLine); RegisterStatusTextbox.Text += $"An error prevented the new student: {StudentidTextbox.Text} ({FirstnameTextbox.Text} {LastnameTextbox.Text}) from being added to the database."; RegisterStatusTextbox.AppendText(Environment.NewLine); RegisterStatusTextbox.Text += $"Because of this error no phonenumbers where added."; RegisterStatusTextbox.AppendText(Environment.NewLine); } else if (exitCodeStudent == 1) { RegisterStatusTextbox.Text += "1 row updated..."; RegisterStatusTextbox.AppendText(Environment.NewLine); RegisterStatusTextbox.Text += $"The new student: {StudentidTextbox.Text} ({FirstnameTextbox.Text} {LastnameTextbox.Text}) was successfully added to the database!"; RegisterStatusTextbox.AppendText(Environment.NewLine); for (int i = 0; i < exitCodePhoneNumbers.Length; i++) { if (exitCodePhoneNumbers[i] == 1) { RegisterStatusTextbox.Text += $"Phone number {phoneNumbers[i]} - {phoneTypes[i]} added to the database."; RegisterStatusTextbox.AppendText(Environment.NewLine); } else if (exitCodePhoneNumbers[i] == -1) { RegisterStatusTextbox.Text += $"Error. Phone number {phoneNumbers[i]} not added to database."; RegisterStatusTextbox.AppendText(Environment.NewLine); } } ResetAddStudentControl(false); } }