private void MudarSenhas_FormClosed(object sender, FormClosedEventArgs e) { conexao.Close(); telaP.Show(); }
private void Logar() { string email = ""; SQLiteCommand Login = new SQLiteCommand("SELECT `email` FROM `usuario` WHERE `usuario` = '" + tbUsuario.Text + "' AND `senha` = '" + tbSenha.Text + "'", conexao); SQLiteCommand checar = new SQLiteCommand("SELECT `tipo` FROM `usuario` WHERE `usuario` = '" + tbUsuario.Text + "'", conexao); SQLiteDataReader myReader; conexao.Open(); myReader = Login.ExecuteReader(); int count = 0; while (myReader.Read()) { email = myReader["email"].ToString(); count += 1; } if (count == 1) { string nome = ""; myReader = checar.ExecuteReader(); while (myReader.Read()) { tipo = myReader["tipo"].ToString(); count += 1; } if (tipo == "True") { SQLiteCommand cliente = new SQLiteCommand("SELECT `nome` FROM `clientes` WHERE `email` = '" + email + "'", conexao); SQLiteDataReader myReader2; myReader2 = cliente.ExecuteReader(); while (myReader2.Read()) { nome = myReader2["nome"].ToString(); } } if (tipo == "False") { SQLiteCommand func = new SQLiteCommand("SELECT `nome` FROM `funcionarios` WHERE `email` = '" + email + "'", conexao); SQLiteDataReader myReader3; myReader3 = func.ExecuteReader(); while (myReader3.Read()) { nome = myReader3["nome"].ToString(); } } TelaPrincipal tela = new TelaPrincipal(this, nome, email); tela.Show(); tbUsuario.Focus(); tbUsuario.Text = ""; tbSenha.Text = ""; conexao.Close(); this.Hide(); } else if (count == 0) { MessageBox.Show("Usuário ou senha inválidos", "Erro"); conexao.Close(); } }