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