private void btnExcluir_Click(object sender, EventArgs e) { SqlConnection conexao = new SqlConnection(Banco.enderecoBanco()); SqlCommand query = new SqlCommand(); query.Connection = conexao; conexao.Open(); query.Parameters.AddWithValue("@pkAluno", pkAluno); //query.CommandText = "UPDATE aluno SET statusCadastro = 999 where pkAluno = @pkAluno"; //query.ExecuteNonQuery(); query.CommandText = "UPDATE usuario SET statusCadastro = 999 where fkAluno = @pkAluno"; int cont = query.ExecuteNonQuery(); if (cont > 0) { MessageBox.Show("Removido com sucesso"); } else { MessageBox.Show("Erro ao remover"); } FormCadastroAluno_Load(null, null); conexao.Close(); Limpar.limparComponentes(this); }
private void btnEntrar_Click(object sender, EventArgs e) { SqlConnection conexao = new SqlConnection(Banco.enderecoBanco()); SqlCommand comando = new SqlCommand(); comando.Connection = conexao; comando.CommandType = CommandType.Text; comando.CommandText = "select * from usuario where usuario = @usuario and senha = @senha and statusCadastro=0"; comando.Parameters.AddWithValue("@usuario", txtUsuario.Text); comando.Parameters.AddWithValue("@senha", txtSenha.Text); conexao.Open(); SqlDataReader consulta = comando.ExecuteReader(CommandBehavior.CloseConnection); if (!consulta.Read()) { MessageBox.Show("Usuário ou senha inválido"); Limpar.limparComponentes(this); } else { consulta.Close(); conexao.Open(); comando.CommandText = "SELECT levelPermissao, fkprofessor, fkaluno FROM usuario WHERE usuario = '" + txtUsuario.Text + "' and senha = '" + txtSenha.Text + "'"; SqlDataAdapter adaptador = new SqlDataAdapter(comando); DataTable tabela = new DataTable(); adaptador.Fill(tabela); //string lvl = tabela.Rows[0]["levelPermissao"].ToString(); //int levelPermissao = Convert.ToInt32(lvl); Autenticacao.levelPermissao = Convert.ToInt32(tabela.Rows[0]["levelPermissao"].ToString()); if (Autenticacao.levelPermissao == 1) //professor { Autenticacao.pkProfessorLogado = Convert.ToInt32(tabela.Rows[0]["fkProfessor"].ToString()); } else if (Autenticacao.levelPermissao == 2) //aluno { Autenticacao.pkAlunoLogado = Convert.ToInt32(tabela.Rows[0]["fkAluno"].ToString()); } //Autenticacao.levelPermissao = Convert.ToInt32(consulta.GetValue(3)); Limpar.limparComponentes(this); Principal formMenu = new Principal(); formMenu.Show(); this.Hide(); } conexao.Close(); }
private void btnLimpar_Click(object sender, EventArgs e) { Limpar.limparComponentes(this); }