public void Login_Click(object sender, RoutedEventArgs e)
{
dbConnection.Open();
List <string> matrikelnummern = dbConnection.GetColumn("SELECT S_Matrikelnummer,S_Passwort FROM tbl_schueler;", 0);
List <string> passwoerter = dbConnection.GetColumn("SELECT S_Matrikelnummer,S_Passwort FROM tbl_schueler;", 1);
List <string> lkuerzel = dbConnection.GetColumn("SELECT L_Kuerzel,L_Passwort FROM tbl_lehrer;", 0);
List <string> lpasswoerter = dbConnection.GetColumn("SELECT L_Kuerzel,L_Passwort FROM tbl_lehrer;", 1);
if (Int64.TryParse(txtMatrikelnummer.Text, out long l))
{
for (int i = 0; i < matrikelnummern.Count; i++)
{
if (matrikelnummern[i] == txtMatrikelnummer.Text && passwoerter[i] == txtPasswort.Password)
{
loginSchueler(matrikelnummern[i]);
return;
}
}
}
else
{
for (int i = 0; i < lkuerzel.Count; i++)
{
if (lkuerzel[i] == txtMatrikelnummer.Text && lpasswoerter[i] == txtPasswort.Password)
{
loginLehrer(lkuerzel[i]);
return;
}
}
}
MessageBox.Show("Matrikelnummer oder Passwort falsch", "Fehler");
dbConnection.Close();
}