public int AcharAdm(BLL.Administrador adm) { int la = 1; DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"SELECT Id_Adm, Nome, Email, Foto, Id_Login from Administrador WHERE Id_Login LIKE @idlogin"; cmd.Parameters.AddWithValue("@idlogin", adm.IdLogin); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); adm.IdAdm = Convert.ToInt32(dr["Id_Adm"]); adm.Nome = dr["Nome"].ToString(); adm.Email = dr["Email"].ToString(); adm.Foto = dr["Foto"].ToString(); adm.IdLogin = Convert.ToInt32(dr["Id_login"]); dr.Close(); } else { adm.IdAdm = 0; } con.Desconectar(); return(la); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["usuario"] != null) { if (Session["usuario"].ToString() != string.Empty) { Response.Write("<script>alert('Bem-vindo, " + Session["usuario"] + "')</script>"); adm.IdLogin = Convert.ToInt32(Session["idlogin"]); adm.IdAdm = admDAL.AcharAdm(adm); adm = admDAL.PreencherPeloID(adm); Session.Add("idadm", adm.IdAdm); Session.Add("nome", adm.Nome); Session.Add("email", adm.Email); Session.Add("foto", adm.Foto); } else { Response.Redirect("LoginAdm.aspx"); } } else { Response.Redirect("LoginAdm.aspx"); } } }
public BLL.Administrador PreencherPeloID(BLL.Administrador adm) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"SELECT Id_Adm, Nome, Email, Foto, Id_Login from Administrador Where Id_Adm = @idadm"; cmd.Parameters.AddWithValue("@idadm", adm.IdAdm); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); adm.IdAdm = Convert.ToInt32(dr["Id_Adm"]); adm.Nome = dr["Nome"].ToString(); adm.Email = dr["Email"].ToString(); adm.Foto = dr["Foto"].ToString(); adm.IdLogin = Convert.ToInt32(dr["Id_login"]); dr.Close(); } else { adm.IdAdm = 0; } con.Desconectar(); return(adm); }
public BLL.Administrador Login(BLL.Administrador adm) { SqlDataReader dr; SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"SELECT Id_Adm, Usuario, Senha from Administrador Where Usuario = @usuario and Senha = @senha"; cmd.Parameters.AddWithValue("@usuario", adm.Usuario); cmd.Parameters.AddWithValue("@senha", adm.Senha); dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); adm.IdAdm = Convert.ToInt32(dr["Id_Adm"]); adm.Usuario = dr["Usuario"].ToString(); adm.Senha = dr["Senha"].ToString(); } else { adm.IdAdm = 0; } return(adm); }
public BLL.Administrador PreencherPeloID(BLL.Administrador adm) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"SELECT Id_Adm, Usuario, Senha from Administrador Where Id_Adm = @idadm"; cmd.Parameters.AddWithValue("@idadm", adm.IdAdm); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); adm.IdAdm = Convert.ToInt32(dr["Id_Adm"]); adm.Usuario = dr["Usuario"].ToString(); adm.Senha = dr["Senha"].ToString(); dr.Close(); } else { adm.IdAdm = 0; } con.Desconectar(); return(adm); }
protected void btnLogar_Click(object sender, EventArgs e) { adm.Usuario = txtUsuario.Text; adm.Senha = txtSenha.Text; adm = admDAL.Login(adm); if (adm.IdAdm == 0) { Response.Write("<script>alert('Login inválido')</script>"); txtUsuario.Text = ""; txtSenha.Text = ""; txtUsuario.Focus(); } else { Response.Write("<script>alert('Acesso permitido!')</script>"); Session.Add("idadm", adm.IdAdm); Session.Add("usuario", adm.Usuario); Response.Redirect("NoticiaAdm.aspx"); } }
public void Excluir(BLL.Administrador adm) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"DELETE FROM Administrador WHERE Id_adm = @idadm"; cmd.Parameters.AddWithValue("@idadm", adm.IdAdm); cmd.ExecuteNonQuery(); con.Desconectar(); }
public void Atualizar(BLL.Administrador adm) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"UPDATE Administradoor SET Usuario = @usuario, Senha = @senha WHERE Id_Adm = @idadm"; cmd.Parameters.AddWithValue("@usuario", adm.Usuario); cmd.Parameters.AddWithValue("@senha", adm.Senha); cmd.ExecuteNonQuery(); con.Desconectar(); }
public void Atualizar(BLL.Administrador adm) { SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"UPDATE Administrador SET Nome = @nome, Email = @email, Foto = @foto WHERE Id_Adm = @idadm"; cmd.Parameters.AddWithValue("idadm", adm.IdAdm); cmd.Parameters.AddWithValue("@nome", adm.Nome); cmd.Parameters.AddWithValue("@email", adm.Email); cmd.Parameters.AddWithValue("@foto", adm.Foto); cmd.ExecuteNonQuery(); con.Desconectar(); }
public DataTable Listar(BLL.Administrador adm) { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con.Conectar(); cmd.CommandText = @"SELECT Id_Adm, Nome, Email, Foto, Id_Login from Administrador WHERE Nome LIKE @nome"; cmd.Parameters.AddWithValue("@nome", "%" + adm.Nome + "%"); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); con.Desconectar(); return(dt); }
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"); } } }