public void ResetConn()
{
try
{
if (Connection != null)
{
string connstring = string.Format("Server=mysql-jtechgame.alwaysdata.net; database=jtechgame_hack; UID=jtechgame_backup; password=Th1s1s@b@ckup");
connection = new MySqlConnection(connstring);
if (Connection == null || connection.State == ConnectionState.Closed)
{
connection.Open();
}
}
}
catch (Exception ex)
{
this.msgHandler.CreateMessage("Connection Error", ex.ToString());
if (msgHandler.IsAgreed())
{
ResetConn();
}
}
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
this.username = txtUsername.Text;
this.password = txtPassword.Password;
try
{
if (dbh.IsConnect())
{
//suppose col0 and col1 are defined as VARCHAR in the DB
string query = "SELECT username, password FROM tbl_users WHERE username=@username";
MySqlCommand cmd = new MySqlCommand(query, dbh.Connection);
cmd.Parameters.AddWithValue("@username", this.username);
cmd.Prepare();
MySqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
MessageBox.Show("The username and/or password is invalid.");
txtUsername.Text = "";
txtPassword.Password = "";
}
else
{
while (reader.Read())
{
if (validate(reader.GetString(1)))
{
//statusWindow stats = new statusWindow();
//MainMenu mm = new MainMenu();
//mm.Show();
//stats.Show();
//this.Hide();
/*MsgBox msg = new MsgBox("Logged In", "You are now logged in!");
* msg.ShowDialog();*/
Desktop dk = new Desktop(txtUsername.Text);
dk.Show();
this.Hide();
}
else
{
MessageBox.Show("The username and/or password is invalid.");
txtUsername.Text = "";
txtPassword.Password = "";
}
}
}
reader.Close();
}
}
catch (Exception ex)
{
this.msgHandler.CreateMessage("Connection Error", ex.ToString());
if (msgHandler.IsAgreed())
{
dbh.ResetConn();
}
}
}
