private void btnLogin_Click(object sender, RoutedEventArgs e) { try { using (DataBaseConnection db = new DataBaseConnection(this.ConnectionString)) { using (IDataReader reader = db.ExecuteSqlCommand("select decode(count(uname),0,'false','true'), passwd_hash from spieler where uname = '" + txtUser.Text + "' group by passwd_hash")) { reader.Read(); if (((String)reader[0]).Equals("false")) { throw new Exception("Login falsch: Name existiert nicht!"); } else { String pw_hashed = ((String)reader["passwd_hash"]); if (!pw_hashed.Equals(MD5hash.GetHashString(txtPassowrd.Password))) { throw new Exception("Login falsch: Passwort falsch!"); } MainWindow mw = new MainWindow(txtUser.Text); mw.Show(); this.Close(); } } } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }
private void btnLogin_Click(object sender, RoutedEventArgs e) { /*try { using (DataBaseConnection db = new DataBaseConnection(this.ConnectionString)) { using (IDataReader reader = db.ExecuteSqlCommand("select decode(count(uname),0,'false','true'), passwd_hash from spieler where uname = '" + txtUser.Text + "' group by passwd_hash")) { reader.Read(); if (((String)reader[0]).Equals("false")) { throw new Exception("Login falsch: Name existiert nicht!"); } else { String pw_hashed = ((String)reader["passwd_hash"]); if (!pw_hashed.Equals(MD5hash.GetHashString(txtPassowrd.Password))) { throw new Exception("Login falsch: Passwort falsch!"); } MainWindow mw = new MainWindow(txtUser.Text); mw.Show(); this.Close(); } } } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); }*/ try { LoginStatus ls = (LoginStatus)new XMLConverter().Request("Credentials/?username="******"&password_md5=" + MD5hash.GetHash(txtPassowrd.Password), typeof(LoginStatus)); //MessageBox.Show(MD5hash.GetHash(txtPassowrd.Password)); if (ls.status.Contains("Username falsch") || ls.status.Contains("Passwort falsch")) { throw new Exception("Login fehlgeschlagen: " + ls.status); } MainWindow mw = new MainWindow(txtUser.Text); mw.Show(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }