protected void Page_Load(object sender, EventArgs e) { DAL.DALModulo dalmod = new DAL.DALModulo(); Modelo.Modulo mod = new Modelo.Modulo(); mod = dalmod.Select(Convert.ToInt32(Session["idModulo"]))[0]; Label5.Text = mod.titulo; DAL.DALRespostaDoAlunoExercicio dalresp = new DAL.DALRespostaDoAlunoExercicio(); int[] aux = dalresp.SelectAllCertaIdModulo(Convert.ToInt32(Session["idModulo"]), Session["Nome"].ToString()); Label3.Text = aux[0].ToString(); Label4.Text = aux[1].ToString(); }
protected void Page_Load(object sender, EventArgs e) { DAL.DALDisciplina daldis = new DAL.DALDisciplina(); Modelo.Disciplina dis = new Modelo.Disciplina(); int aux1 = Convert.ToInt32(Session["idDisciplina"]); dis = daldis.Select(aux1)[0]; Label5.Text = dis.nome; DAL.DALRespostaDoAlunoExercicio dalresp = new DAL.DALRespostaDoAlunoExercicio(); int[] aux = dalresp.SelectAllCertaIdDisciplina(Convert.ToInt32(Session["idDisciplina"]), Session["Nome"].ToString()); Label3.Text = aux[0].ToString(); Label4.Text = aux[1].ToString(); }
public int[] SelectAllCertaIdDisciplina(int idDisciplina, string nome) { int[] cont = new int[2]; DAL.DALModulo dalmod = new DAL.DALModulo(); List <Modelo.Modulo> mod = new List <Modelo.Modulo>(); mod = dalmod.SelectAllIdDisciplina(idDisciplina); foreach (Modelo.Modulo modulo in mod) { DALMateria dalmat = new DALMateria(); List <Modelo.Materia> mat = new List <Modelo.Materia>(); mat = dalmat.SelectAllIdModulo(Convert.ToInt32(modulo.idModulo)); foreach (Modelo.Materia materia in mat) { DALExercicio dalexer = new DALExercicio(); List <Modelo.Exercicio> exer = new List <Modelo.Exercicio>(); exer = dalexer.SelectAllIdMateria(materia.idMateria); foreach (Modelo.Exercicio exercicio in exer) { DALAlternativaExercicio dalalterna = new DALAlternativaExercicio(); List <Modelo.alternativaExercicio> alterna = new List <Modelo.alternativaExercicio>(); alterna = dalalterna.SelectAll(exercicio.idExercicio); foreach (Modelo.alternativaExercicio alternativa in alterna) { DALRespostaDoAlunoExercicio dalresp = new DALRespostaDoAlunoExercicio(); List <Modelo.RespostaDoAlunoExercicio> resp = new List <Modelo.RespostaDoAlunoExercicio>(); resp = dalresp.Select(alternativa.idAlternativa, nome); if (resp.Count > 0) { if (alternativa.correta) { cont[0]++; } else { cont[1]++; } } } } } } return(cont); }
protected void Page_Load(object sender, EventArgs e) { if ((Session["Nome"] != null) && (Session["Senha"] != null)) { DAL.DALAluno dalalu = new DAL.DALAluno(); if (!dalalu.verifADM(Session["Nome"], Session["Senha"])) { Label user = new Label(); user.Text = "Bem-vindo, " + Session["nome"]; div1.Controls.Add(user); } else { HyperLink adm = new HyperLink(); adm.Text = "Página do Administrador"; adm.NavigateUrl = "~/WebFormAdministrador.aspx"; Label nomeadm = new Label(); nomeadm.Text = "Bem-vindo, " + Session["nome"] + "<br />"; div1.Controls.Add(nomeadm); div1.Controls.Add(adm); } } else { Response.Redirect("~/WebFormAutenticar.aspx"); } double Qfacil = 0; double QMedio = 0; double QDificil = 0; double QTotal = 0; List <Modelo.Exercicio> exercicios = new List <Modelo.Exercicio>(); DAL.DALExercicio dalexe = new DAL.DALExercicio(); exercicios = dalexe.SelectAllIDdif(1); List <Modelo.RespostaDoAlunoExercicio> resp = new List <Modelo.RespostaDoAlunoExercicio>(); DAL.DALRespostaDoAlunoExercicio dalresp = new DAL.DALRespostaDoAlunoExercicio(); resp = dalresp.SelectAllIdDif(1, Session["Nome"].ToString()); int aux1 = 0; int aux2 = 0; aux1 += resp.Count; aux2 += exercicios.Count; Qfacil = Math.Round(((1.0 * resp.Count / exercicios.Count) * 100), 2); exercicios = dalexe.SelectAllIDdif(2); resp = dalresp.SelectAllIdDif(2, Session["Nome"].ToString()); aux1 += resp.Count; aux2 += exercicios.Count; QMedio = Math.Round(((1.0 * resp.Count / exercicios.Count) * 100), 2); exercicios = dalexe.SelectAllIDdif(3); resp = dalresp.SelectAllIdDif(3, Session["Nome"].ToString()); aux1 += resp.Count; aux2 += exercicios.Count; QDificil = Math.Round(((1.0 * resp.Count / exercicios.Count) * 100), 2); QTotal = Math.Round(((1.0 * aux1 / aux2) * 100), 2); Label1.Text = Qfacil.ToString() + "%"; Label2.Text = QMedio.ToString() + "%"; Label3.Text = QDificil.ToString() + "%"; Label4.Text = QTotal.ToString() + "%"; }