public BLL.Aula PreencherPeloID1(BLL.Aula au)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Aula, Nome, Video, Material, Descricao, Id_Curso, Id_Adm FROM Aula WHERE Id_Aula = @idaula";
cmd.Parameters.AddWithValue("@idaula", au.IdAula);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
au.IdAula = Convert.ToInt32(dr["Id_Aula"]);
au.Nome = dr["Nome"].ToString();
au.Video = dr["Video"].ToString();
au.Material = dr["Material"].ToString();
au.Descricao = dr["Descricao"].ToString();
au.IdCurso = Convert.ToInt32(dr["Id_Curso"]);
au.IdAdm = Convert.ToInt32(dr["Id_Adm"]);
dr.Close();
}
else
{
au.IdAula = 0;
}
con.Desconectar();
return(au);
}
public void Excluir(BLL.Aula au)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"DELETE FROM Aula WHERE Id_Aula = @idaula";
cmd.Parameters.AddWithValue("@idaula", au.IdAula);
cmd.ExecuteNonQuery();
con.Desconectar();
}
public void Cadastrar1(BLL.Aula au)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"INSERT INTO Aula(Nome, Video, Material, Descricao, Id_Curso, Id_Adm) VALUES (@nome, @video, @material, @descricao, @idcurso, @idadm)";
cmd.Parameters.AddWithValue("@nome", au.Nome);
cmd.Parameters.AddWithValue("@video", au.Video);
cmd.Parameters.AddWithValue("@material", au.Material);
cmd.Parameters.AddWithValue("@descricao", au.Descricao);
cmd.Parameters.AddWithValue("@idcurso", au.IdCurso);
cmd.Parameters.AddWithValue("@idadm", au.IdAdm);
cmd.ExecuteNonQuery();
con.Desconectar();
}
public DataTable Listar1(BLL.Aula au)
{
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Aula, Nome, Video, Material, Descricao, Id_Curso, Id_Professor FROM Aula WHERE Id_Professor = @idprofessor";
cmd.Parameters.AddWithValue("@idprofessor", au.IdProfessor); //LISTAR PAGE LOAD PROFESSOR ESPECIFICO
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
con.Desconectar();
return(dt);
}
public DataTable Listar2(BLL.Aula au)
{
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Aula, Nome, Video, Material, Descricao, Id_Curso, Id_Professor, Id_Adm FROM Aula WHERE Nome LIKE @nome";
cmd.Parameters.AddWithValue("@nome", "%" + au.Nome + "%"); // LISTAR DO FILTRAR DE ADM
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
con.Desconectar();
return(dt);
}
public void Atualizar(BLL.Aula au)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"UPDATE Aula SET Nome = @nome, Video = @video, Material = @material, Descricao = @descricao WHERE Id_Aula = @idaula";
cmd.Parameters.AddWithValue("@idaula", au.IdAula);
cmd.Parameters.AddWithValue("@Nome", au.Nome);
cmd.Parameters.AddWithValue("@video", au.Video);
cmd.Parameters.AddWithValue("@material", au.Material);
cmd.Parameters.AddWithValue("@descricao", au.Descricao);
cmd.Parameters.AddWithValue("@idcurso", au.IdCurso);
cmd.Parameters.AddWithValue("@idprofessor", au.IdProfessor);
cmd.Parameters.AddWithValue("@idadm", au.IdAdm);
cmd.ExecuteNonQuery();
con.Desconectar();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["usuario"] != null)
{
if (Session["usuario"].ToString() != string.Empty)
{
DAL.CursoDAL cuDAL = new DAL.CursoDAL();
BLL.Curso cu = new BLL.Curso();
au.IdProfessor = Convert.ToInt32(Session["idprof"]);
cu.IdProfessor = Convert.ToInt32(Session["idprof"]);
ddlCurso.DataSource = cuDAL.Listar1(cu);
ddlCurso.DataTextField = "Nome";
ddlCurso.DataValueField = "Id_Curso";
ddlCurso.DataBind();
gvResultado.DataSource = auDAL.Listar1(au);
gvResultado.DataBind();
if (Request.QueryString["id"] != null)
{
if (Request.QueryString["id"].ToString() != "")
{
int idRecebido;
int.TryParse(Request.QueryString["id"], out idRecebido);
au.IdAula = idRecebido;
au = auDAL.PreencherPeloID(au);
if (au.IdAula != 0)
{
lblAtu.Visible = true;
lblId.Visible = true;
lblIsso.Visible = true;
lblCad.Visible = false;
litPDF.Visible = true;
btnAtualizar.Visible = true;
ddlCurso.Visible = false;
btnCadastrar.Visible = false;
gvResultado.Visible = false;
txtFiltro.Visible = false;
btnFiltrar.Visible = false;
////////////////////////////////////////////////////////////////////////////////////////
string html = "";
html += "<a href='" + au.Material + "' target='_blank'>Material</a>";
litPDF.Text = html;
///////////////////////////////////////////////////////////////////////////////////////
lblId.Text = au.IdAula.ToString();
txtNome.Text = au.Nome;
txtVideo.Text = au.Video;
txtDescricao.Text = au.Descricao;
lblId1.Text = au.IdCurso.ToString();
lblId2.Text = Session["idprof"].ToString();
}
else
{
lblId.Text = "ID INVÁLIDO";
}
}
else
{
lblId.Text = "ID INVÁLIDO";
}
}
}
else
{
Response.Redirect("../ADMINISTRADOR/LoginAdm.aspx");
}
}
else
{
Response.Redirect("../ADMINISTRADOR/LoginAdm.aspx");
}
}
}
