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