public BLL.Pergunta PreencherPeloID1(BLL.Pergunta pe)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Pergunta, Questao, Res1, Res2, Res3, Res4, Certa, Id_Quizz, Id_Adm FROM Pergunta WHERE Id_Pergunta LIKE @idpergunta";
cmd.Parameters.AddWithValue("@idpergunta", pe.IdPergunta);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
pe.IdPergunta = Convert.ToInt32(dr["Id_Pergunta"]);
pe.Questao = dr["Questao"].ToString();
pe.Res1 = dr["Res1"].ToString();
pe.Res2 = dr["Res2"].ToString();
pe.Res3 = dr["Res3"].ToString();
pe.Res4 = dr["Res4"].ToString();
pe.Certa = dr["Certa"].ToString();
pe.IdQuizz = Convert.ToInt32(dr["Id_Quizz"]);
pe.IdAdm = Convert.ToInt32(dr["Id_Adm"]);
dr.Close();
}
else
{
pe.IdPergunta = 0;
}
con.Desconectar();
return(pe);
}
public void Excluir(BLL.Pergunta pe)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"DELETE FROM Pergunta WHERE Id_Pergunta = @idpergunta";
cmd.Parameters.AddWithValue("@idpergunta", pe.IdPergunta);
cmd.ExecuteNonQuery();
con.Desconectar();
}
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);*/
zz.IdQuizz = 1002;
zz = zzDAL.PreencherPeloID(zz);
lblNome.Text = zz.Nome;
pe.IdQuizz = zz.IdQuizz;
pe = peDAL.PreencherPeloID2(pe);
lblQuestao.Text = pe.Questao;
lblRes1.Text = pe.Res1;
lblRes2.Text = pe.Res2;
lblRes3.Text = pe.Res3;
lblRes4.Text = pe.Res4;
}
else
{
Response.Redirect("../EXTERNO/Login.aspx");
}
}
else
{
Response.Redirect("../EXTERNO/Login.aspx");
}
}
}
public DataTable Listar3(BLL.Pergunta pe)
{
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"SELECT Id_Pergunta, Questao, Res1, Res2, Res3, Res4, Certa, Id_Quizz, Id_Professor FROM Pergunta WHERE Id_Quizz = @idquizz";
cmd.Parameters.AddWithValue("@idquizz", pe.IdQuizz);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
con.Desconectar();
return(dt);
}
public void Cadastrar1(BLL.Pergunta pe)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"INSERT INTO Pergunta(Questao, Res1, Res2, Res3, Res4, Certa, Id_Quizz, Id_Adm) VALUES (@questao, @res1, @res2, @res3, @res4, @certa, @idquizz, @idadm)";
cmd.Parameters.AddWithValue("@questao", pe.Questao);
cmd.Parameters.AddWithValue("@RES1", pe.Res1);
cmd.Parameters.AddWithValue("@res2", pe.Res2);
cmd.Parameters.AddWithValue("@res3", pe.Res3);
cmd.Parameters.AddWithValue("@res4", pe.Res4);
cmd.Parameters.AddWithValue("certa", pe.Certa);
cmd.Parameters.AddWithValue("idquizz", pe.IdQuizz);
cmd.Parameters.AddWithValue("idadm", pe.IdAdm);
cmd.ExecuteNonQuery();
con.Desconectar();
}
public void Atualizar(BLL.Pergunta pe)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.Conectar();
cmd.CommandText = @"UPDATE Pergunta SET Questao = @questao, Res1 = @res1, Res2 = @res2, Res3 = @res3, Res4 = @res4, Certa = @Certa WHERE Id_Pergunta = @idpergunta";
cmd.Parameters.AddWithValue("idpergunta", pe.IdPergunta);
cmd.Parameters.AddWithValue("@questao", pe.Questao);
cmd.Parameters.AddWithValue("@res1", pe.Res1);
cmd.Parameters.AddWithValue("@res2", pe.Res2);
cmd.Parameters.AddWithValue("@res3", pe.Res3);
cmd.Parameters.AddWithValue("@res4", pe.Res4);
cmd.Parameters.AddWithValue("@certa", pe.Certa);
cmd.Parameters.AddWithValue("@idquizz", pe.IdQuizz);
cmd.Parameters.AddWithValue("@idprofessr", pe.IdProfessor);
cmd.Parameters.AddWithValue("@idadm", pe.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)
{
if (Request.QueryString["id"] != null)
{
if (Request.QueryString["id"].ToString() != "")
{
int idRecebido;
int.TryParse(Request.QueryString["id"], out idRecebido);
pe.IdProfessor = Convert.ToInt32(Session["idprof"]);
pe.IdQuizz = idRecebido;
gvQuestoes.DataSource = peDAL.Listar1(pe);
gvQuestoes.DataBind();
lblIdQ.Text = pe.IdQuizz.ToString();
lblIdP.Text = Session["idprof"].ToString();
if (Request.QueryString["idp"] != null)
{
if (Request.QueryString["idp"].ToString() != "")
{
int idRecebido1;
int.TryParse(Request.QueryString["idp"], out idRecebido1);
pe.IdPergunta = idRecebido1;
pe = peDAL.PreencherPeloID(pe);
if (pe.IdPergunta != 0)
{
lblAtu.Visible = true;
lblCad.Visible = false;
btnAtualizar.Visible = true;
btnEnviar.Visible = false;
btnVoltar.Visible = false;
lblPer.Visible = true;
gvQuestoes.Visible = false;
txtFiltro.Visible = false;
btnFiltrar.Visible = false;
lblIdQ.Text = pe.IdQuizz.ToString();
lblPer.Text = pe.IdPergunta.ToString();
lblIdP.Text = Session["idprof"].ToString();
txtPergunta.Text = pe.Questao;
txtRes1.Text = pe.Res1;
txtRes2.Text = pe.Res1;
txtRes3.Text = pe.Res1;
txtRes4.Text = pe.Res1;
ddlCerta.SelectedValue = pe.Certa;
}
/*else
* {
* lblCurso.Text = "CURSO INVÁLIDO";
* }*/
}
/*else
* {
* lblCurso.Text = "CURSO INVÁLIDO"; //FAZRER ESQUEMA PARA CARREGAR CODIGO DE ERRO NO ID E EXIBIR NO LOAD
* }*/
}
/*else
* {
* lblCurso.Text = "CURSO INVÁLIDO";
* }*/
}
// <<<<<<<<<<<<<<TALVEZ REDIRECIONAR DE VOLTA A QUIZZ>>>>>>>>>>>>>>>>>>>>>>>>>>>
}
}
else
{
Response.Redirect("../ADMINISTRADOR/LoginAdm.aspx");
}
}
else
{
Response.Redirect("../ADMINISTRADOR/LoginAdm.aspx");
}
}
}
