public BLL.Login Autenticar(BLL.Login l)
{
//l.Autenticado = false;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT
USUARIO,
SENHA
FROM
TB_LOGIN
WHERE
USUARIO = @usuario
AND
SENHA = @senha";
cmd.Parameters.AddWithValue("@usuario", l.Usuario);
cmd.Parameters.AddWithValue("@senha", Embaralhar(l.Senha));
SqlDataReader dr = cmd.ExecuteReader();
l.Autenticado = dr.HasRows;
con.Desconectar();
return(l);
}
protected void btnEntrar_Click(object sender, EventArgs e)
{
BLL.Login lo = new BLL.Login();
lo.Usuario = txtEmail.Text;
lo.Senha = BLL.Criptografia.getMdIHash(txtSenha.Text);
DAL.LoginDAL loginDAL = new DAL.LoginDAL();
lo = loginDAL.Login(lo);
if (lo.IdLogin == 0)
{
Response.Write("<script>alert('Login inválido')</script>");
txtEmail.Text = "";
txtSenha.Text = "";
txtEmail.Focus();
}
else
{
Response.Write("<script>alert('Acesso permitido!')</script>");
Session.Add("idlogin", lo.IdLogin);
Session.Add("usuario", lo.Usuario);
Response.Redirect("../USUARIO/Usuario.aspx");
}
}
public BLL.Login Autenticar(BLL.Login l)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT
Usuario,
Senha,
NivelAcesso
FROM
TB_Login
WHERE
Usuario = @usuario
AND
Senha = @senha";
cmd.Parameters.AddWithValue("@usuario", l.Usuario);
cmd.Parameters.AddWithValue("@senha", (l.Senha));
SqlDataReader dr = cmd.ExecuteReader();
l.Autenticado = dr.HasRows;
con.Desconectar();
Properties.Settings.Default.nivel = l.Usuario;
return(l);
}
public BLL.Login PreencherPeloID1(BLL.Login lo)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Login, Usuario, Senha, Tipo FROM Login WHERE Usuario = @usuario and Tipo = @tipo";
cmd.Parameters.AddWithValue("@usuario", lo.Usuario);
cmd.Parameters.AddWithValue("@tipo", lo.Tipo);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
lo.IdLogin = Convert.ToInt32(dr["Id_Login"]);
lo.Usuario = dr["Usuario"].ToString();
dr.Close();
}
else
{
lo.IdLogin = 0;
}
con.Desconectar();
return(lo);
}
protected void btnFiltrar_Click(object sender, EventArgs e)
{
lo.Usuario = txtFiltro.Text;
lo.Tipo = 1;
lo = loDAL.PreencherPeloID1(lo);
lblId.Text = lo.IdLogin.ToString();
lblUsuario.Text = lo.Usuario;
alu.IdLogin = lo.IdLogin;
alu = aluDAL.PreencherPeloID(alu);
lblCpf.Text = alu.Cpf;
lblUsuario.Visible = true;
lblCpf.Visible = true;
txtSenha.Visible = true;
Label1.Visible = true;
Label2.Visible = true;
Label3.Visible = true;
btnRecuperar.Visible = true;
txtFiltro.Visible = false;
btnFiltrar.Visible = false;
btnCancelar.Visible = true;
}
public BLL.Login Login(BLL.Login lo)
{
SqlDataReader dr;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"select Id_Login, Usuario, Senha, Tipo from Login Where Usuario = @usuario and Senha = @senha";
cmd.Parameters.AddWithValue("@usuario", lo.Usuario);
cmd.Parameters.AddWithValue("@senha", lo.Senha);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
lo.IdLogin = Convert.ToInt32(dr["Id_Login"]);
lo.Usuario = dr["Usuario"].ToString();
lo.Senha = dr["Senha"].ToString();
lo.Tipo = Convert.ToInt32(dr["Tipo"]);
}
else
{
lo.IdLogin = 0;
}
return(lo);
}
public void Excluir(BLL.Login lo)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"DELETE FROM Login WHERE Id_Login = @idlogin";
cmd.Parameters.AddWithValue("@idlogin", lo.IdLogin);
cmd.ExecuteNonQuery();
con.Desconectar();
}
protected void btnLogar_Click(object sender, EventArgs e)
{
try
{
BLL.Login bllLogin = new BLL.Login();
bllLogin.LogarUsuario(txtLogin.Text, txtPass.Text);
Response.Redirect("PerfilAluno.aspx?Nome=" + txtLogin.Text);
}
catch (ApplicationException ex)
{
}
}
protected void btnEntrar_Click(object sender, EventArgs e)
{
BLL.Login lo = new BLL.Login();
lo.Usuario = txtNome.Text;
lo.Senha = BLL.Criptografia.getMdIHash(txtSenha.Text);
DAL.LoginDAL loDAL = new DAL.LoginDAL();
lo = loDAL.Login(lo);
if (lo.IdLogin == 0)
{
Response.Write("<script>alert('Login inválido')</script>");
txtNome.Text = "";
txtSenha.Text = "";
txtNome.Focus();
}
else
{
//Response.Write("<script>alert('Acesso permitido!')</script>");
//NÃO APARECE O ALERT
if (lo.Tipo == 3)
{
Session.Add("idlogin", lo.IdLogin);
Session.Add("usuario", lo.Usuario);
Response.Redirect("PagAdmin.aspx");
}
else if (lo.Tipo == 2)
{
Session.Add("idlogin", lo.IdLogin);
Session.Add("usuario", lo.Usuario);
Response.Redirect("../PROFESSOR/PagAdmComum.aspx");
}
else
{
Response.Write("<script>alert('Login inválido')</script>");
txtNome.Text = "";
txtSenha.Text = "";
txtNome.Focus();
}
}
}
private void btnAutenticar_Click(object sender, EventArgs e)
{
login.Usuario = txtUsuario.Text;
login.Senha = txtSenha.Text;
login = loginDAL.Autenticar(login);
if (login.Autenticado == false)
{
MessageBox.Show("Usuário ou senha inválidos");
}
else
{
MessageBox.Show("Logado");
this.Close();
}
}
public int Cadastrar(BLL.Login lo)
{
int Chave;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"INSERT INTO Login(Usuario, Senha, Tipo) VALUES (@usuario, @senha, @tipo) ; select scope_Identity() as Chave";
cmd.Parameters.AddWithValue("@usuario", lo.Usuario);
cmd.Parameters.AddWithValue("@senha", lo.Senha);
cmd.Parameters.AddWithValue("@tipo", lo.Tipo);
Chave = Convert.ToInt32(cmd.ExecuteScalar());
con.Desconectar();
return(Chave);
}
public DataTable Listar(BLL.Login lo) //ESSA LINHA É A ASSINATURA
{
DataTable dt = new DataTable(); //Tabela de dados padrão C#(int, strin, double...)
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Login, Usuario, Senha, Tipo FROM Login WHERE Usuario LIKE @usuario";
cmd.Parameters.AddWithValue("@usuario", "%" + lo.Usuario + "%");
//Adaptador de dados SQL para C#
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);//Preenche fazendo a adaptação
con.Desconectar();
return(dt);
}
public void Atualizar1(BLL.Login lo)
{
//int Chave1;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"UPDATE Login SET Senha = @senha WHERE Id_Login = @idlogin";
cmd.Parameters.AddWithValue("@idlogin", lo.IdLogin);
cmd.Parameters.AddWithValue("@senha", lo.Senha);
//Chave1 = Convert.ToInt32(cmd.ExecuteScalar());
cmd.ExecuteNonQuery();
con.Desconectar();
//return Chave1;
}
public bool Autenticar(BLL.Login l)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT USUARIO, SENHA
FROM TBLogin
WHERE USUARIO = @usuario
AND SENHA = @senha";
cmd.Parameters.AddWithValue("@usuario", l.Usuario);
cmd.Parameters.AddWithValue("@senha", l.Senha);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
con.Desconectar();
return(true);
}
else
{
con.Desconectar();
return(false);
}
}
public bool UserAuthenticate(LoginUser l)
{
// 这里调用BLL中的逻辑
BLL.Login login = new BLL.Login(l.Username, l.Password);
return(login.Authenticate());
}
/// <summary>
/// 登录按钮，调用BLL中的Login()方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLogin_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtLoginName.Text.Trim()) || string.IsNullOrEmpty(txtPwd.Text))
{
MessageBox.Show("请输入用户名和密码");
LClearAndFocus();
return;
}
BLL.Login login = new BLL.Login();
switch (login.GetName(txtLoginName.Text.Trim(), txtPwd.Text))
{
case BLL.LoginState.OK:
this.DialogResult = DialogResult.OK;
break;
case BLL.LoginState.NoName:
MessageBox.Show("用户名不存在");
LClearAndFocus();
break;
case BLL.LoginState.IncorrectPwd:
MessageBox.Show("密码错误");
LClearAndFocus();
break;
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["usuario"] != null)
{
if (Session["usuario"].ToString() != string.Empty)
{
adm.IdAdm = Convert.ToInt32(Session["idlogin"]);
adm = admDAL.PreencherPeloID(adm);
if (adm.IdAdm.ToString() != null)
{
if (adm.IdAdm.ToString() != "")
{
int idRecebido;
int.TryParse(adm.IdAdm.ToString(), out idRecebido);
lo.IdLogin = Convert.ToInt32(Session["idlogin"]);
lo = loDAL.PreencherPeloID(lo);
if (adm.IdAdm != 0)
{
lblId.Text = adm.IdAdm.ToString();
Image1.ImageUrl = adm.Foto;
txtNome.Text = adm.Nome;
txtEmail.Text = adm.Email;
Image1.ImageUrl = adm.Foto;
lblNome.Text = adm.Nome;
lblEmail.Text = adm.Email;
lblIdL.Text = lo.IdLogin.ToString();
txtUsuario.Text = lo.Usuario;
}
else
{
//lblId.Text = "ID INVÁLIDO";
}
}
else
{
//lblId.Text = "ID INVÁLIDO";
}
}
else
{
//lblId.Text = "ID INVÁLIDO";
}
}
else
{
Response.Redirect("LoginAdm.aspx");
}
}
else
{
Response.Redirect("LoginAdm.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["usuario"] != null)
{
if (Session["usuario"].ToString() != string.Empty)
{
pro.IdLogin = Convert.ToInt32(Session["idlogin"]);
pro = proDAL.PreencherPeloID(pro);
if (pro.IdProfessor.ToString() != null)
{
if (pro.IdProfessor.ToString() != "")
{
int idRecebido;
int.TryParse(pro.IdProfessor.ToString(), out idRecebido);
//pro.IdProfessor = idRecebido;
//pro = proDAL.PreencherPeloID(pro);
lo.IdLogin = Convert.ToInt32(Session["idlogin"]);
lo = loDAL.PreencherPeloID(lo);
if (pro.IdProfessor != 0)
{
lblId.Text = pro.IdProfessor.ToString();
Image1.ImageUrl = pro.Foto;
txtNome.Text = pro.Nome;
txtEmail.Text = pro.Email;
txtTelefone.Text = pro.Telefone;
txtDescricao.Text = pro.Descricao;
txtCpf.Text = pro.Cpf;
Image1.ImageUrl = pro.Foto;
lblNome.Text = pro.Nome;
lblEmail.Text = pro.Email;
lblTelefone.Text = pro.Telefone;
lblDescricao.Text = pro.Descricao;
lblCpf.Text = pro.Cpf;
lblIdL.Text = lo.IdLogin.ToString();
txtUsuario.Text = lo.Usuario;
txtSenha.Text = lo.Senha;
}
else
{
//lblId.Text = "ID INVÁLIDO";
}
}
else
{
//lblId.Text = "ID INVÁLIDO";
}
}
else
{
//lblId.Text = "ID INVÁLIDO";
}
}
else
{
Response.Redirect("../ADMINISTRADOR/LoginAdm.aspx");
}
}
else
{
Response.Redirect("../ADMINISTRADOR/LoginAdm.aspx");
}
}
}
public bool UserLogout(LoginUser l)
{
BLL.Login login = new BLL.Login(l.Username, l.Password);
return(login.Logout());
}
