protected void Page_Load(object sender, EventArgs e) { DataTable NumVisitasForAsesor; int NumAcomp; double porcNumAcomp, NumAcompParcial; LogicaNegocio.Microred microredes = new LogicaNegocio.Microred(); NumAcomp = microredes.countRowsMicroredes(); lblNumMicroredes.Text = Convert.ToString(NumAcomp); NumVisitasForAsesor = microredes.getCountMicroredesForAgent(); 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; lblNumMicroredesForAsesor.Text += "<tr>"; lblNumMicroredesForAsesor.Text += "<td>" + asesorMN.FullName + "</td>"; lblNumMicroredesForAsesor.Text += "<td>" + fila["Cantidad"].ToString() + "</td>"; lblNumMicroredesForAsesor.Text += "<td>" + String.Format("{0:0.00}", porcNumAcomp) + "</td>"; lblNumMicroredesForAsesor.Text += "</tr>"; } }
protected void btnReport_Click(object sender, EventArgs e) { LogicaNegocio.Microred microred = new LogicaNegocio.Microred(); // List<ModeloNegocio.Asesor> listUsuario = new List<ModeloNegocio.Asesor>(); // NOW ASSIGN DATA TO A DATAGRID. DataGrid dg = new DataGrid(); dg.DataSource = microred.getReportAllMicroredes(); dg.DataBind(); // THE EXCEL FILE. string sFileName = "Microredes-" + System.DateTime.Now.Date + "-.xls"; sFileName = sFileName.Replace("/", ""); // SEND OUTPUT TO THE CLIENT MACHINE USING "RESPONSE OBJECT". Encoding encoding = Encoding.UTF8; Response.ClearContent(); Response.Buffer = true; //Response.Charset = encoding.EncodingName; //Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Charset = encoding.EncodingName; Response.ContentEncoding = System.Text.Encoding.GetEncoding("Windows-1252"); Response.AddHeader("content-disposition", "attachment; filename=" + sFileName); Response.ContentType = "application/vnd.ms-excel"; //Response.ContentType = "application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; //Response.AppendHeader("content-disposition", "attachment; filename=myfile.xlsx"); EnableViewState = false; System.IO.StringWriter objSW = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter objHTW = new System.Web.UI.HtmlTextWriter(objSW); dg.HeaderStyle.Font.Bold = true; // SET EXCEL HEADERS AS BOLD. dg.HeaderStyle.ForeColor = Color.White; dg.HeaderStyle.BackColor = Color.Blue; dg.RenderControl(objHTW); // STYLE THE SHEET AND WRITE DATA TO IT. Response.Write("<style> TABLE { border:solid 1px #999; } " + "TD { border:solid 1px #000000; text-align:center } </style>"); Response.Write(objSW.ToString()); // ADD A ROW AT THE END OF THE SHEET SHOWING A RUNNING TOTAL OF PRICE. //Response.Write("<table><tr><td><b>Total: </b></td><td></td><td><b>" + //dTotalPrice.ToString("N2") + "</b></td></tr></table>"); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { DataTable NumVisitasForSchool; int NumColegios,NumMicroredes,NumClase,NumVisitas; LogicaNegocio.School colegios = new LogicaNegocio.School(); LogicaNegocio.Microred microredes = new LogicaNegocio.Microred(); LogicaNegocio.AconpanaClase clase = new LogicaNegocio.AconpanaClase(); LogicaNegocio.VisitaIE visitas = new LogicaNegocio.VisitaIE(); NumColegios = colegios.countRowsSchool(); lblNumColegios.Text = Convert.ToString(NumColegios); NumMicroredes = microredes.countRowsMicroredes(); lblQFichasMicroredes.Text = Convert.ToString(NumMicroredes); NumClase = clase.countRowsAconpanaClase(); lblQFichasAcomClase.Text = Convert.ToString(NumClase); NumVisitas = visitas.countRowsVisitas(); lblQFichasVisitas.Text = Convert.ToString(NumVisitas); NumVisitasForSchool = visitas.getCountVisitsForSchool(); lblQIEVisits.Text = Convert.ToString(NumVisitasForSchool.Rows.Count); }
protected void Page_Load(object sender, EventArgs e) { DataTable NumVisitasForSchool; int NumColegios, NumMicroredes, NumClase, NumVisitas; LogicaNegocio.School colegios = new LogicaNegocio.School(); LogicaNegocio.Microred microredes = new LogicaNegocio.Microred(); LogicaNegocio.AconpanaClase clase = new LogicaNegocio.AconpanaClase(); LogicaNegocio.VisitaIE visitas = new LogicaNegocio.VisitaIE(); NumColegios = colegios.countRowsSchool(); lblNumColegios.Text = Convert.ToString(NumColegios); NumMicroredes = microredes.countRowsMicroredes(); lblQFichasMicroredes.Text = Convert.ToString(NumMicroredes); NumClase = clase.countRowsAconpanaClase(); lblQFichasAcomClase.Text = Convert.ToString(NumClase); NumVisitas = visitas.countRowsVisitas(); lblQFichasVisitas.Text = Convert.ToString(NumVisitas); NumVisitasForSchool = visitas.getCountVisitsForSchool(); lblQIEVisits.Text = Convert.ToString(NumVisitasForSchool.Rows.Count); }
protected void Page_Load(object sender, EventArgs e) { LogicaNegocio.Microred microredes = new LogicaNegocio.Microred(); List <ModeloNegocio.Microred> listMicrored = new List <ModeloNegocio.Microred>(); int NumRegistrosEmpezar; if (Request.Params["asesor_id"] != null) { int asesor_id = Convert.ToInt32(Request.Params["asesor_id"]); NumRegistrosEmpezar = 0; listMicrored = microredes.getAllMicroredesPorAsesor(asesor_id, 200, UscPaginador.RegistrosAEmpezar); } else { //-------------Inicio Paginador UscPaginador.caragaPaginador(100, Convert.ToInt32(Request.Params["pagina"]), microredes.countRowsMicroredes()); //---------------Fin Paginador NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar; listMicrored = microredes.getAllMicroredes(100, UscPaginador.RegistrosAEmpezar); } foreach (ModeloNegocio.Microred Micro in listMicrored) { ModeloNegocio.Asesor asesorMN = new ModeloNegocio.Asesor(); LogicaNegocio.Asesor asesorLN = new LogicaNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(Micro.User_id); NumRegistrosEmpezar++; FilasListaMicroredes.Text += "<tr id='" + Micro.Id + "'>"; FilasListaMicroredes.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>"; FilasListaMicroredes.Text += "<td>" + Micro.Id + "</td>"; FilasListaMicroredes.Text += "<td>" + asesorMN.FullName + "</td>"; FilasListaMicroredes.Text += "<td>" + Micro.MicroredName + "</td>"; FilasListaMicroredes.Text += "<td>" + Micro.Fecha.ToString("dd-MM-yyyy") + "</td>"; FilasListaMicroredes.Text += "<td>"; //FilasListaMicroredes.Text += "<a href='" + "Admin-SeguiEditMicroredes.aspx?microred_id=" + Micro.Id + "&id=1'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar Microred'></span></a>"; FilasListaMicroredes.Text += "<a href='" + "Admin-SeguiViewMicroredes.aspx?microred_id=" + Micro.Id + "&id=1'><span class='glyphicon glyphicon glyphicon-zoom-in' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver datos de la Microred'></span></a>"; FilasListaMicroredes.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar a <b>" + Micro.MicroredName + "</b> ','" + Micro.Id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar Microred'></span></a>"; FilasListaMicroredes.Text += "</td></tr>"; } //lblPaginador.Text +="<nav>"; //lblPaginador.Text +="<ul class=\"pagination\">" ; //lblPaginador.Text +="</li>"; //for (int i = 1; i <= PagUlt; i++) //{ // string activate = ""; // if (Convert.ToInt32(PagAct) == i) // { // activate = "active"; // } // lblPaginador.Text +="<li class='"+ activate +"'><a href=\"Admin-SeguiMicroredes.aspx?pagina=" + i + "&id=1\">" + i + "</a></li>"; //} //lblPaginador.Text += "</ul>"; //lblPaginador.Text += "</nav>"; }
protected void Page_Load(object sender, EventArgs e) { Page.Response.ContentType = "application/json;"; Page.Response.Charset = "utf-8"; Page.Response.Cache.SetCacheability(HttpCacheability.NoCache); if (Request.Params["tipo"] == "deleteAsesor") { int iduser = Convert.ToInt32(Request.Params["iduser"]); LogicaNegocio.Asesor Asesor = new LogicaNegocio.Asesor(); LogicaNegocio.UserSchool userSchool = new LogicaNegocio.UserSchool(); LogicaNegocio.UserTeacher userTeacher = new LogicaNegocio.UserTeacher(); //Response.Write("{success:1}"); if (Asesor.deleteAsesor(iduser)) { ModeloNegocio.Asesor AsesorMN = new ModeloNegocio.Asesor(); foreach (ModeloNegocio.School listSchool in AsesorMN.Schools) { userSchool.updateSelectSchoolForIduser(listSchool.id, 0); } // userSchool.updateSelectSchoolForIduser(iduser); userSchool.deleteSchoolsForUserId(iduser); userTeacher.deleteTeachersForUserId(iduser); Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteDocente") { int iduser = Convert.ToInt32(Request.Params["iduser"]); LogicaNegocio.Docente Docente = new LogicaNegocio.Docente(); //Response.Write("{success:1}"); if (Docente.deleteDocente(iduser)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteSchool") { int idSchool = Convert.ToInt32(Request.Params["idSchool"]); LogicaNegocio.School School = new LogicaNegocio.School(); //Response.Write("{success:1}"); if (School.deleteSchool(idSchool)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteMicrored") { int idMicrored = Convert.ToInt32(Request.Params["idmicrored"]); LogicaNegocio.Microred microred = new LogicaNegocio.Microred(); //Response.Write("{success:1}"); if (microred.deleteMicrored(idMicrored)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteAconpanaClase") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.AconpanaClase aconpanaClase = new LogicaNegocio.AconpanaClase(); //Response.Write("{success:1}"); if (aconpanaClase.deleteMicrored(idMicrored)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteVisitasIE") { int idVisita = Convert.ToInt32(Request.Params["idVisita"]); LogicaNegocio.VisitaIE visita = new LogicaNegocio.VisitaIE(); //Response.Write("{success:1}"); if (visita.deleteVisitaIE(idVisita)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "allSchoolAsesor") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.UserSchool shool = new LogicaNegocio.UserSchool(); //Response.Write("{success:1}"); int idAsesor = Convert.ToInt32(Request.Params["idAsesor"]); List <ModeloNegocio.Docente> listUsuario = new List <ModeloNegocio.Docente>(); //listUsuario = shool.getAllDocenteSchool(idSchool); //foreach (ModeloNegocio.Docente Docentes in listUsuario) //{ // Response.Write("{success:1}"); //} var json = new JavaScriptSerializer().Serialize(shool.getAllSchoolForUser(idAsesor)); Response.Write(json); //if (aconpanaClase.deleteMicrored(idMicrored)) //{ // Response.Write("{success:1}"); //} } if (Request.Params["tipo"] == "allDocenteSchool") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.School shool = new LogicaNegocio.School(); //Response.Write("{success:1}"); int idSchool = Convert.ToInt32(Request.Params["idSchool"]); List <ModeloNegocio.Docente> listUsuario = new List <ModeloNegocio.Docente>(); //listUsuario = shool.getAllDocenteSchool(idSchool); //foreach (ModeloNegocio.Docente Docentes in listUsuario) //{ // Response.Write("{success:1}"); //} var json = new JavaScriptSerializer().Serialize(shool.getAllDocenteSchool(idSchool)); Response.Write(json); //if (aconpanaClase.deleteMicrored(idMicrored)) //{ // Response.Write("{success:1}"); //} } if (Request.Params["tipo"] == "allGradeSectionForTeacher") { int idDocente = Convert.ToInt32(Request.Params["idDocente"]); List <ModeloNegocio.TeacherGrade> lista1 = new List <ModeloNegocio.TeacherGrade>(); LogicaNegocio.TeacherGrade teacherGrade = new LogicaNegocio.TeacherGrade(); lista1 = teacherGrade.getAllTeacherGradeForUser(idDocente); var json = new JavaScriptSerializer().Serialize(lista1); Response.Write(json); } if (Request.Params["tipo"] == "allDirectorSchool") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.School shool = new LogicaNegocio.School(); int idSchool = Convert.ToInt32(Request.Params["idSchool"]); var json = new JavaScriptSerializer().Serialize(shool.getDirectorSchool(idSchool)); Response.Write(json); } //Franco allTemForGrade if (Request.Params["tipo"] == "allTemForGrade") { LogicaNegocio.Tema tema = new LogicaNegocio.Tema(); //Response.Write("{success:1}"); string grade = Convert.ToString(Request.Params["grade"]); List <ModeloNegocio.Tema> listTemas = new List <ModeloNegocio.Tema>(); var json = new JavaScriptSerializer().Serialize(tema.getAllTemaForGrade(grade)); Response.Write(json); } if (Request.Params["tipo"] == "allNumSesionForTem") { LogicaNegocio.Sesion sesion = new LogicaNegocio.Sesion(); //Response.Write("{success:1}"); int tema_id = Convert.ToInt32(Request.Params["tema_id"]); var json = new JavaScriptSerializer().Serialize(sesion.getAllSesionsForTem(tema_id)); Response.Write(json); } }
protected void Page_Load(object sender, EventArgs e) { Page.Response.ContentType = "application/json;"; Page.Response.Charset = "utf-8"; Page.Response.Cache.SetCacheability(HttpCacheability.NoCache); if (Request.Params["tipo"] == "deleteAsesor") { int iduser = Convert.ToInt32(Request.Params["iduser"]); LogicaNegocio.Asesor Asesor = new LogicaNegocio.Asesor(); LogicaNegocio.UserSchool userSchool = new LogicaNegocio.UserSchool(); LogicaNegocio.UserTeacher userTeacher = new LogicaNegocio.UserTeacher(); //Response.Write("{success:1}"); if (Asesor.deleteAsesor(iduser)) { ModeloNegocio.Asesor AsesorMN = new ModeloNegocio.Asesor(); foreach (ModeloNegocio.School listSchool in AsesorMN.Schools) { userSchool.updateSelectSchoolForIduser(listSchool.id, 0); } // userSchool.updateSelectSchoolForIduser(iduser); userSchool.deleteSchoolsForUserId(iduser); userTeacher.deleteTeachersForUserId(iduser); Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteDocente") { int iduser = Convert.ToInt32(Request.Params["iduser"]); LogicaNegocio.Docente Docente = new LogicaNegocio.Docente(); //Response.Write("{success:1}"); if (Docente.deleteDocente(iduser)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteSchool") { int idSchool = Convert.ToInt32(Request.Params["idSchool"]); LogicaNegocio.School School = new LogicaNegocio.School(); //Response.Write("{success:1}"); if (School.deleteSchool(idSchool)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteMicrored") { int idMicrored = Convert.ToInt32(Request.Params["idmicrored"]); LogicaNegocio.Microred microred = new LogicaNegocio.Microred(); //Response.Write("{success:1}"); if (microred.deleteMicrored(idMicrored)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteAconpanaClase") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.AconpanaClase aconpanaClase = new LogicaNegocio.AconpanaClase(); //Response.Write("{success:1}"); if (aconpanaClase.deleteMicrored(idMicrored)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "deleteVisitasIE") { int idVisita = Convert.ToInt32(Request.Params["idVisita"]); LogicaNegocio.VisitaIE visita = new LogicaNegocio.VisitaIE(); //Response.Write("{success:1}"); if (visita.deleteVisitaIE(idVisita)) { Response.Write("{success:1}"); } } if (Request.Params["tipo"] == "allSchoolAsesor") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.UserSchool shool = new LogicaNegocio.UserSchool(); //Response.Write("{success:1}"); int idAsesor = Convert.ToInt32(Request.Params["idAsesor"]); List<ModeloNegocio.Docente> listUsuario = new List<ModeloNegocio.Docente>(); //listUsuario = shool.getAllDocenteSchool(idSchool); //foreach (ModeloNegocio.Docente Docentes in listUsuario) //{ // Response.Write("{success:1}"); //} var json = new JavaScriptSerializer().Serialize(shool.getAllSchoolForUser(idAsesor)); Response.Write(json); //if (aconpanaClase.deleteMicrored(idMicrored)) //{ // Response.Write("{success:1}"); //} } if (Request.Params["tipo"] == "allDocenteSchool") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.School shool = new LogicaNegocio.School(); //Response.Write("{success:1}"); int idSchool = Convert.ToInt32(Request.Params["idSchool"]); List<ModeloNegocio.Docente> listUsuario = new List<ModeloNegocio.Docente>(); //listUsuario = shool.getAllDocenteSchool(idSchool); //foreach (ModeloNegocio.Docente Docentes in listUsuario) //{ // Response.Write("{success:1}"); //} var json = new JavaScriptSerializer().Serialize(shool.getAllDocenteSchool(idSchool)); Response.Write(json); //if (aconpanaClase.deleteMicrored(idMicrored)) //{ // Response.Write("{success:1}"); //} } if (Request.Params["tipo"] == "allGradeSectionForTeacher") { int idDocente = Convert.ToInt32(Request.Params["idDocente"]); List<ModeloNegocio.TeacherGrade> lista1 = new List<ModeloNegocio.TeacherGrade>(); LogicaNegocio.TeacherGrade teacherGrade = new LogicaNegocio.TeacherGrade(); lista1 = teacherGrade.getAllTeacherGradeForUser(idDocente); var json = new JavaScriptSerializer().Serialize(lista1); Response.Write(json); } if (Request.Params["tipo"] == "allDirectorSchool") { int idMicrored = Convert.ToInt32(Request.Params["idAconpanaClase"]); LogicaNegocio.School shool = new LogicaNegocio.School(); int idSchool = Convert.ToInt32(Request.Params["idSchool"]); var json = new JavaScriptSerializer().Serialize(shool.getDirectorSchool(idSchool)); Response.Write(json); } //Franco allTemForGrade if (Request.Params["tipo"] == "allTemForGrade") { LogicaNegocio.Tema tema = new LogicaNegocio.Tema(); //Response.Write("{success:1}"); string grade = Convert.ToString(Request.Params["grade"]); List<ModeloNegocio.Tema> listTemas = new List<ModeloNegocio.Tema>(); var json = new JavaScriptSerializer().Serialize(tema.getAllTemaForGrade(grade)); Response.Write(json); } if (Request.Params["tipo"] == "allNumSesionForTem") { LogicaNegocio.Sesion sesion = new LogicaNegocio.Sesion(); //Response.Write("{success:1}"); int tema_id = Convert.ToInt32(Request.Params["tema_id"]); var json = new JavaScriptSerializer().Serialize(sesion.getAllSesionsForTem(tema_id)); Response.Write(json); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { microredMN = new ModeloNegocio.Microred(); microredLN = new LogicaNegocio.Microred(); int microred_id = Convert.ToInt32(Request.Params["microred_id"]); microredMN = microredLN.getMicroredId(microred_id); txtFecha.Text = microredMN.Fecha.ToString("yyyy-MM-dd"); asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(microredMN.User_id); txtAsesor.Text = asesorMN.FullName; microredDocenteMN = new ModeloNegocio.MicroredDocente(); microredDocenteLN = new LogicaNegocio.MicroredDocente(); List<ModeloNegocio.MicroredDocente> listaMicroredDocente =new List<ModeloNegocio.MicroredDocente>(); listaMicroredDocente = microredDocenteLN.getAllMicroredDocenteForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredDocente microredDocente in listaMicroredDocente) { docenteLN = new LogicaNegocio.Docente(); docenteMN = new ModeloNegocio.Docente(); docenteMN = docenteLN.getDocenteId(microredDocente.Docente_id); ddlDocente.Items.Add(new ListItem(docenteMN.FullName,docenteMN.id.ToString() )); } microredSchoolMN = new ModeloNegocio.MicroredSchool(); microredSchoolLN = new LogicaNegocio.MicroredSchool(); List<ModeloNegocio.MicroredSchool> listaMicroredSchool = new List<ModeloNegocio.MicroredSchool>(); listaMicroredSchool = microredSchoolLN.getAllMicroredSchoolForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredSchool microredSchool in listaMicroredSchool) { schoolLN = new LogicaNegocio.School(); schoolMN = new ModeloNegocio.School(); schoolMN = schoolLN.getSchool(microredSchool.School_id); ddlSchool.Items.Add(new ListItem(schoolMN.Nombre, schoolMN.id.ToString())); } txtMircrored.Text = microredMN.MicroredName; txtSesion.Text = microredMN.Lugar_sesion; txtInicio.Text = microredMN.H_inicio.ToString("hh:mm:ss"); txtTermino.Text = microredMN.H_termino.ToString("hh:mm:ss"); txtParticipante.Text = Convert.ToString(microredMN.Num_participantes); txtEducacion.Text = microredMN.Educ_financiera; txtEnfoque.Text = microredMN.Enfoques_edu; txtProgramacion.Text = microredMN.Programacion_ped; txtHabilidades.Text = microredMN.Habilidad_ped; txtTrabajo.Text = microredMN.Trabajo_grupal; txtParticipativo.Text = microredMN.Participativo; txtExpositivo.Text = microredMN.Expositivo; txtDinamicas.Text = microredMN.Dinamicas_ludicas; txtRecursos.Text = microredMN.Recursos_informaticos; txtAudiovisuales.Text = microredMN.Recursos_audiovisuales; txtMateriales.Text = microredMN.Materiales_didaticos; txtObservacion.Text = microredMN.Observacion; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { microredMN = new ModeloNegocio.Microred(); microredLN = new LogicaNegocio.Microred(); int microred_id = Convert.ToInt32(Request.Params["microred_id"]); microredMN = microredLN.getMicroredId(microred_id); txtFecha.Text = microredMN.Fecha.ToString("yyyy-MM-dd"); asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(microredMN.User_id); txtAsesor.Text = asesorMN.FullName; microredDocenteMN = new ModeloNegocio.MicroredDocente(); microredDocenteLN = new LogicaNegocio.MicroredDocente(); List <ModeloNegocio.MicroredDocente> listaMicroredDocente = new List <ModeloNegocio.MicroredDocente>(); listaMicroredDocente = microredDocenteLN.getAllMicroredDocenteForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredDocente microredDocente in listaMicroredDocente) { docenteLN = new LogicaNegocio.Docente(); docenteMN = new ModeloNegocio.Docente(); docenteMN = docenteLN.getDocenteId(microredDocente.Docente_id); ddlDocente.Items.Add(new ListItem(docenteMN.FullName, docenteMN.id.ToString())); } microredSchoolMN = new ModeloNegocio.MicroredSchool(); microredSchoolLN = new LogicaNegocio.MicroredSchool(); List <ModeloNegocio.MicroredSchool> listaMicroredSchool = new List <ModeloNegocio.MicroredSchool>(); listaMicroredSchool = microredSchoolLN.getAllMicroredSchoolForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredSchool microredSchool in listaMicroredSchool) { schoolLN = new LogicaNegocio.School(); schoolMN = new ModeloNegocio.School(); schoolMN = schoolLN.getSchool(microredSchool.School_id); ddlSchool.Items.Add(new ListItem(schoolMN.Nombre, schoolMN.id.ToString())); } txtMircrored.Text = microredMN.MicroredName; txtSesion.Text = microredMN.Lugar_sesion; txtInicio.Text = microredMN.H_inicio.ToString("hh:mm:ss"); txtTermino.Text = microredMN.H_termino.ToString("hh:mm:ss"); txtParticipante.Text = Convert.ToString(microredMN.Num_participantes); txtEducacion.Text = microredMN.Educ_financiera; txtEnfoque.Text = microredMN.Enfoques_edu; txtProgramacion.Text = microredMN.Programacion_ped; txtHabilidades.Text = microredMN.Habilidad_ped; txtTrabajo.Text = microredMN.Trabajo_grupal; txtParticipativo.Text = microredMN.Participativo; txtExpositivo.Text = microredMN.Expositivo; txtDinamicas.Text = microredMN.Dinamicas_ludicas; txtRecursos.Text = microredMN.Recursos_informaticos; txtAudiovisuales.Text = microredMN.Recursos_audiovisuales; txtMateriales.Text = microredMN.Materiales_didaticos; txtObservacion.Text = microredMN.Observacion; } }
protected void Page_Load(object sender, EventArgs e) { LogicaNegocio.Microred microredes = new LogicaNegocio.Microred(); List<ModeloNegocio.Microred> listMicrored = new List<ModeloNegocio.Microred>(); int NumRegistrosEmpezar; if (Request.Params["asesor_id"] != null) { int asesor_id = Convert.ToInt32(Request.Params["asesor_id"]); NumRegistrosEmpezar = 0; listMicrored = microredes.getAllMicroredesPorAsesor(asesor_id, 200, UscPaginador.RegistrosAEmpezar); } else { //-------------Inicio Paginador UscPaginador.caragaPaginador(100, Convert.ToInt32(Request.Params["pagina"]), microredes.countRowsMicroredes()); //---------------Fin Paginador NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar; listMicrored = microredes.getAllMicroredes(100, UscPaginador.RegistrosAEmpezar); } foreach (ModeloNegocio.Microred Micro in listMicrored) { ModeloNegocio.Asesor asesorMN = new ModeloNegocio.Asesor(); LogicaNegocio.Asesor asesorLN = new LogicaNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(Micro.User_id); NumRegistrosEmpezar++; FilasListaMicroredes.Text += "<tr id='" + Micro.Id + "'>"; FilasListaMicroredes.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>"; FilasListaMicroredes.Text += "<td>" + Micro.Id + "</td>"; FilasListaMicroredes.Text += "<td>" + asesorMN.FullName + "</td>"; FilasListaMicroredes.Text += "<td>" + Micro.MicroredName + "</td>"; FilasListaMicroredes.Text += "<td>" + Micro.Fecha.ToString("dd-MM-yyyy") + "</td>"; FilasListaMicroredes.Text += "<td>"; //FilasListaMicroredes.Text += "<a href='" + "Admin-SeguiEditMicroredes.aspx?microred_id=" + Micro.Id + "&id=1'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar Microred'></span></a>"; FilasListaMicroredes.Text += "<a href='" + "Admin-SeguiViewMicroredes.aspx?microred_id=" + Micro.Id + "&id=1'><span class='glyphicon glyphicon glyphicon-zoom-in' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver datos de la Microred'></span></a>"; FilasListaMicroredes.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar a <b>" + Micro.MicroredName + "</b> ','" + Micro.Id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar Microred'></span></a>"; FilasListaMicroredes.Text += "</td></tr>"; } //lblPaginador.Text +="<nav>"; //lblPaginador.Text +="<ul class=\"pagination\">" ; //lblPaginador.Text +="</li>"; //for (int i = 1; i <= PagUlt; i++) //{ // string activate = ""; // if (Convert.ToInt32(PagAct) == i) // { // activate = "active"; // } // lblPaginador.Text +="<li class='"+ activate +"'><a href=\"Admin-SeguiMicroredes.aspx?pagina=" + i + "&id=1\">" + i + "</a></li>"; //} //lblPaginador.Text += "</ul>"; //lblPaginador.Text += "</nav>"; }