public void Atualizar(BLL.Torcedor TO)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"UPDATE Torcedor
SET
NOME = @Nome,
RG = @Rg
CPF = @cpf,
ETEC = @Etec,
EMAIL = @Email,
RM = @Rm,
DataNas = @DataNas,
AnoLetivo = @AnoLetivo,
SENHA = @Senha
WHERE
ID = @Id";
cmd.Parameters.AddWithValue("@nome", TO.Nome);
cmd.Parameters.AddWithValue("@Rg", TO.RG);
cmd.Parameters.AddWithValue("@Cpf", TO.CPF);
cmd.Parameters.AddWithValue("@Etec", TO.Etec);
cmd.Parameters.AddWithValue("@Email", TO.Email);
cmd.Parameters.AddWithValue("@Rm", TO.RM);
cmd.Parameters.AddWithValue("@DataNas", TO.DataNas);
cmd.Parameters.AddWithValue("@AnoLetivo", TO.AnoLetivo);
cmd.Parameters.AddWithValue("@senha", TO.Senha);
cmd.ExecuteNonQuery();
con.Desconectar();
}
public void Cadastrar(BLL.Torcedor TO)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"Insert into Torcedor(Nome,Rg,Cpf,Etec,Email,Rm,DataNas,AnoLetivo,senha)
Values(@Nome,@Rg,@Cpf,@Etec,@Email,@Rm,@DataNas,@AnoLetivo,@senha)";
cmd.Parameters.AddWithValue("@nome", TO.Nome);
cmd.Parameters.AddWithValue("@Rg", TO.RG);
cmd.Parameters.AddWithValue("@Cpf", TO.CPF);
cmd.Parameters.AddWithValue("@Etec", TO.Etec);
cmd.Parameters.AddWithValue("@Email", TO.Email);
cmd.Parameters.AddWithValue("@Rm", TO.RM);
cmd.Parameters.AddWithValue("@DataNas", TO.DataNas);
cmd.Parameters.AddWithValue("@AnoLetivo", TO.AnoLetivo);
cmd.Parameters.AddWithValue("@senha", TO.Senha);
cmd.ExecuteNonQuery();
con.Desconectar();
}
protected void btnCadA_Click(object sender, EventArgs e)
{
BLL.Torcedor Torc = new BLL.Torcedor();
Torc.Nome = txtNomeT.Text;
Torc.RG = txtRGT.Text;
Torc.CPF = txtCPFT.Text;
Torc.DataNas = DateTime.Parse(txtDataNascT.Text);
Torc.Email = txtEmailT.Text;
Torc.AnoLetivo = ddlAN.SelectedValue;
Torc.Etec = ddlETEC.SelectedValue;
Torc.RM = txtRMT.Text;
Torc.Senha = txtSenhaT.Text;
DAL.TorcedorDAL TorcDAL = new DAL.TorcedorDAL();
TorcDAL.Cadastrar(Torc);
Response.Write("<script>alert('Cadastro Efetuado')</script>");
Response.Redirect("Index.aspx");
}
public BLL.Torcedor Login(BLL.Torcedor tor)
{
SqlDataReader dr;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"select CodT, Nome,Rg,Cpf,Etec,Email,Rm,DataNas,AnoLetivo,senha from Torcedor Where Email = @email and Senha = @senha";
cmd.Parameters.AddWithValue("@email", tor.Email);
cmd.Parameters.AddWithValue("@senha", tor.Senha);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
tor.CodT = Convert.ToInt32(dr["CodT"]);
tor.Nome = dr["Nome"].ToString();
tor.RG = dr["Rg"].ToString();
tor.CPF = dr["Cpf"].ToString();
tor.Etec = dr["Etec"].ToString();
tor.Email = dr["Email"].ToString();
tor.RM = dr["Rm"].ToString();
tor.DataNas = Convert.ToDateTime(dr["DataNas"]);
tor.AnoLetivo = dr["AnoLetivo"].ToString();
tor.Senha = dr["Senha"].ToString();
}
else
{
tor.CodT = 0;
}
return(tor);
}
protected void btnEntrar_Click(object sender, EventArgs e)
{
BLL.Atleta AT = new BLL.Atleta();
BLL.Professor PF = new BLL.Professor();
BLL.Torcedor TO = new BLL.Torcedor();
//FAZ UM DESSE DE ADMINISTRADOR
string ca = ddlgn.SelectedValue;
if (ca == "Professor")
{
BLL.Professor pro = new BLL.Professor();
pro.Email = txtEmail.Text;
pro.Senha = txtSenha.Text;
DAL.ProfessorDAL proDAL = new DAL.ProfessorDAL();
pro = proDAL.Login(pro);
if (pro.CodProf == 0)
{
Response.Write("<script>alert('Login inválido')</script>");
txtEmail.Text = "";
txtSenha.Text = "";
txtEmail.Focus();
}
else
{
Response.Redirect("Home.aspx");
}
}
else if (ca == "Atleta")
{
BLL.Atleta atl = new BLL.Atleta();
atl.Email = txtEmail.Text;
atl.Senha = txtSenha.Text;
DAL.AtletaDAL atlDAL = new DAL.AtletaDAL();
atl = atlDAL.Login(atl);
if (atl.CodA == 0)
{
Response.Write("<script>alert('Login inválido')</script>");
txtEmail.Text = "";
txtSenha.Text = "";
txtEmail.Focus();
}
else
{
Response.Redirect("Home.aspx");
}
}
else if (ca == "Torcedor")
{
BLL.Torcedor tor = new BLL.Torcedor();
tor.Email = txtEmail.Text;
tor.Senha = txtSenha.Text;
DAL.TorcedorDAL torDAL = new DAL.TorcedorDAL();
tor = torDAL.Login(tor);
if (tor.CodT == 0)
{
Response.Write("<script>alert('Login inválido')</script>");
txtEmail.Text = "";
txtSenha.Text = "";
txtEmail.Focus();
}
else
{
Response.Redirect("Home.aspx");
}
}
else if (ca == "Administrador")
{
//FAZER O MESMO QUE OS OUTROS SÓ QUE PARA ADMIN
}
else
{
Response.Write("<script>alert('Categoria inválida!')</script>");
}
}
