private void CarregaFormPrincipal() { FormPrincipal FormPrincipal = new FormPrincipal(); FormPrincipal.Show(); this.Hide(); }
public void Login() { try { using (var conn = new SQLiteConnection(@"Data Source=CaoMedor.db; Version = 3")) { conn.Open(); using (var cmd = new SQLiteCommand("SELECT username,password FROM users WHERE username=@Username AND password=@Password", conn)) { cmd.Parameters.AddWithValue("@Username", metroTextBoxUsuario.Text); cmd.Parameters.AddWithValue("@Password", metroTextBoxSenha.Text); using (var reader = cmd.ExecuteReader()) { var count = 0; while (reader.Read()) { count = count + 1; } if (count == 1 && metroTextBoxSenha.Text == "admin") { FormAlteraSenha FormAlteraSenha = new FormAlteraSenha(); FormAlteraSenha.Show(); this.Hide(); } else if (count == 1 && metroTextBoxSenha.Text != "admin") { FormPrincipal FormPrincipal = new FormPrincipal(); FormPrincipal.Show(); this.Hide(); } else if (count == 0) { MessageBox.Show("Usuário e/ou senha inválidos!", "CãoMedor", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } } conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }