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