protected void Page_Load(object sender, EventArgs e) { DataTable NumVisitasForAsesor, NumVisitasForTeacher; int NumAcomp, NumSesiones, contador; double porcNumAcomp, NumAcompParcial; LogicaNegocio.AconpanaClase acompClases = new LogicaNegocio.AconpanaClase(); if (Request.Params["opcion"] == "asesor") { NumAcomp = acompClases.countRowsAconpanaClase(); lblNumAcomp.Text = Convert.ToString(NumAcomp); NumVisitasForAsesor = acompClases.getCountAcompForAgent(); foreach (DataRow fila in NumVisitasForAsesor.Rows) { ModeloNegocio.Asesor asesorMN = new ModeloNegocio.Asesor(); LogicaNegocio.Asesor asesorLN = new LogicaNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(Convert.ToInt32(fila["asesor_id"])); NumAcompParcial = Convert.ToInt32(fila["Cantidad"]); porcNumAcomp = (NumAcompParcial / NumAcomp) * 100; lblNumAcompaForAsesor.Text += "<tr>"; lblNumAcompaForAsesor.Text += "<td>" + asesorMN.FullName + "</td>"; lblNumAcompaForAsesor.Text += "<td>" + fila["Cantidad"].ToString() + "</td>"; lblNumAcompaForAsesor.Text += "<td>" + String.Format("{0:0.00}", porcNumAcomp) + "</td>"; lblNumAcompaForAsesor.Text += "</tr>"; } } if (Request.Params["opcion"] == "profesor") { contador = 0; NumAcomp = acompClases.countRowsAconpanaClase(); lblNumAcomProfe.Text = Convert.ToString(NumAcomp); NumVisitasForTeacher = acompClases.getCountAcompForTeacher(); foreach (DataRow fila in NumVisitasForTeacher.Rows) { contador++; lblNumAcompaForProfesor.Text += "<tr>"; lblNumAcompaForProfesor.Text += "<td>" + Convert.ToString(contador) + "</td>"; lblNumAcompaForProfesor.Text += "<td>" + fila["codigo"] + "</td>"; lblNumAcompaForProfesor.Text += "<td>" + fila["name"] + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["Num_fichas"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["numtemas"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["numsesiones"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["intervenciones"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "</tr>"; } } if (Request.Params["opcion"] == "temas") { contador = 0; DataTable countSchoolsTeachers = acompClases.getCountSchoolTeachersJuego(); foreach (DataRow fila0 in countSchoolsTeachers.Rows) { NumColJuego.Text = Convert.ToString(fila0["Num_colegios"]); NumProfJuego.Text = Convert.ToString(fila0["Num_docentes"]); } NumVisitasForTeacher = acompClases.getCountTeachersForTema(); foreach (DataRow fila in NumVisitasForTeacher.Rows) { contador++; lblNumAcompaForTema.Text += "<tr>"; lblNumAcompaForTema.Text += "<td>" + Convert.ToString(contador) + "</td>"; lblNumAcompaForTema.Text += "<td>" + fila["tema"] + "</td>"; lblNumAcompaForTema.Text += "<td class=\"text-right\">" + fila["Num_fichas"] + "</td>"; lblNumAcompaForTema.Text += "<td class=\"text-right\">" + fila["numdocentes"].ToString() + "</td>"; lblNumAcompaForTema.Text += "</tr>"; } } }
protected void Page_Load(object sender, EventArgs e) { DataTable NumVisitasForAsesor, NumVisitasForTeacher; int NumAcomp,NumSesiones,contador; double porcNumAcomp, NumAcompParcial; LogicaNegocio.AconpanaClase acompClases = new LogicaNegocio.AconpanaClase(); if (Request.Params["opcion"] == "asesor") { NumAcomp = acompClases.countRowsAconpanaClase(); lblNumAcomp.Text = Convert.ToString(NumAcomp); NumVisitasForAsesor = acompClases.getCountAcompForAgent(); foreach (DataRow fila in NumVisitasForAsesor.Rows) { ModeloNegocio.Asesor asesorMN = new ModeloNegocio.Asesor(); LogicaNegocio.Asesor asesorLN = new LogicaNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(Convert.ToInt32(fila["asesor_id"])); NumAcompParcial = Convert.ToInt32(fila["Cantidad"]); porcNumAcomp = (NumAcompParcial / NumAcomp) * 100; lblNumAcompaForAsesor.Text += "<tr>"; lblNumAcompaForAsesor.Text += "<td>" + asesorMN.FullName + "</td>"; lblNumAcompaForAsesor.Text += "<td>" + fila["Cantidad"].ToString() + "</td>"; lblNumAcompaForAsesor.Text += "<td>" + String.Format("{0:0.00}", porcNumAcomp) + "</td>"; lblNumAcompaForAsesor.Text += "</tr>"; } } if (Request.Params["opcion"] == "profesor") { contador = 0; NumAcomp = acompClases.countRowsAconpanaClase(); lblNumAcomProfe.Text = Convert.ToString(NumAcomp); NumVisitasForTeacher = acompClases.getCountAcompForTeacher(); foreach (DataRow fila in NumVisitasForTeacher.Rows) { contador ++; lblNumAcompaForProfesor.Text += "<tr>"; lblNumAcompaForProfesor.Text += "<td>" + Convert.ToString(contador) + "</td>"; lblNumAcompaForProfesor.Text += "<td>" + fila["codigo"] + "</td>"; lblNumAcompaForProfesor.Text += "<td>" + fila["name"] + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["Num_fichas"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["numtemas"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["numsesiones"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "<td class=\"text-right\">" + fila["intervenciones"].ToString() + "</td>"; lblNumAcompaForProfesor.Text += "</tr>"; } } if (Request.Params["opcion"] == "temas") { contador = 0; DataTable countSchoolsTeachers = acompClases.getCountSchoolTeachersJuego(); foreach (DataRow fila0 in countSchoolsTeachers.Rows) { NumColJuego.Text = Convert.ToString(fila0["Num_colegios"]); NumProfJuego.Text = Convert.ToString(fila0["Num_docentes"]); } NumVisitasForTeacher = acompClases.getCountTeachersForTema(); foreach (DataRow fila in NumVisitasForTeacher.Rows) { contador++; lblNumAcompaForTema.Text += "<tr>"; lblNumAcompaForTema.Text += "<td>" + Convert.ToString(contador) + "</td>"; lblNumAcompaForTema.Text += "<td>" + fila["tema"] + "</td>"; lblNumAcompaForTema.Text += "<td class=\"text-right\">" + fila["Num_fichas"] + "</td>"; lblNumAcompaForTema.Text += "<td class=\"text-right\">" + fila["numdocentes"].ToString() + "</td>"; lblNumAcompaForTema.Text += "</tr>"; } } }