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