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