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