protected void Page_Load(object sender, EventArgs e) { LogicaNegocio.VisitaIE visitaIE = new LogicaNegocio.VisitaIE(); List<ModeloNegocio.VisitaIE> listVisitasIE = new List<ModeloNegocio.VisitaIE>(); //-------------Inicio Paginador UscPaginador.caragaPaginador(100, Convert.ToInt32(Request.Params["pagina"]), visitaIE.countRowsVisitas()); //---------------Fin Paginador int NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar; listVisitasIE = visitaIE.getAllVisitas(100, UscPaginador.RegistrosAEmpezar); foreach (ModeloNegocio.VisitaIE VisitasIE in listVisitasIE) { ModeloNegocio.Asesor asesorMN; LogicaNegocio.Asesor asesorLN; asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId( VisitasIE.Asesor_id); NumRegistrosEmpezar++; FilasLista.Text += "<tr id='" + VisitasIE.Id + "'>"; FilasLista.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>"; FilasLista.Text += "<td>" + VisitasIE.Id + "</td>"; FilasLista.Text += "<td>" + asesorMN.FullName + "</td>"; FilasLista.Text += "<td>" + VisitasIE.Fecha.ToString("dd-MM-yyyy") + "</td>"; FilasLista.Text += "<td>"; //FilasLista.Text += "<a href='" + "Admin-SeguiEditVisita.aspx?visita_id=" + VisitasIE.Id + "'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar seguimiento de Visitas a IE'></span></a>"; FilasLista.Text += "<a href='" + "Admin-SeguiViewVisita.aspx?id=3&visita_id=" + VisitasIE.Id + "'><span class='glyphicon glyphicon glyphicon-zoom-in' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver visita a IE'></span></a>"; FilasLista.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar <b>" + VisitasIE.Nombre + "</b> ','" + VisitasIE.Id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar seguimiento de Visita IE'></span></a>"; FilasLista.Text += "</td></tr>"; } }
protected void Page_Load(object sender, EventArgs e) { DataTable NumVisitasForAsesor, NumVisitasForSchool; double NumVisitas, NumVisitAse, PorcAse; int school_id; string nameSchool; LogicaNegocio.VisitaIE visitas = new LogicaNegocio.VisitaIE(); NumVisitas = visitas.countRowsVisitas(); lblNumVisitas.Text = Convert.ToString(NumVisitas); NumVisitasForAsesor = visitas.getCountVisitsForAgent(); lblQAsesor.Text = Convert.ToString(NumVisitasForAsesor.Rows.Count); 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"])); NumVisitAse = Convert.ToInt32(fila["Cantidad"]); PorcAse = (NumVisitAse / NumVisitas) * 100; lblNumVisitsForAsesor.Text += "<tr>"; lblNumVisitsForAsesor.Text += "<td>" + asesorMN.FullName + "</td>"; lblNumVisitsForAsesor.Text += "<td>" + fila["Cantidad"].ToString() + "</td>"; lblNumVisitsForAsesor.Text += "<td>" + String.Format("{0:0.00}", PorcAse) + "</td>"; lblNumVisitsForAsesor.Text += "</tr>"; } NumVisitasForSchool = visitas.getCountVisitsForSchool(); lblQSchoolVisit.Text = Convert.ToString(NumVisitasForSchool.Rows.Count); foreach (DataRow fila1 in NumVisitasForSchool.Rows) { ModeloNegocio.School schoolMN = new ModeloNegocio.School(); LogicaNegocio.School schoolLN = new LogicaNegocio.School(); school_id = Convert.ToInt32(fila1["school_id"]); if (school_id == 0) { nameSchool = "Indeterminado"; } else { schoolMN = schoolLN.getSchool(school_id); nameSchool = schoolMN.Nombre; } NumVisitAse = Convert.ToInt32(fila1["Cantidad"]); PorcAse = (NumVisitAse / NumVisitas) * 100; lblNumVisitForSchool.Text += "<tr>"; lblNumVisitForSchool.Text += "<td>" + nameSchool + "</td>"; lblNumVisitForSchool.Text += "<td>" + fila1["Cantidad"].ToString() + "</td>"; lblNumVisitForSchool.Text += "<td>" + String.Format("{0:0.00}", PorcAse) + "</td>"; lblNumVisitForSchool.Text += "</tr>"; } }
protected void btnReport_Click(object sender, EventArgs e) { LogicaNegocio.VisitaIE aconpanaClase = new LogicaNegocio.VisitaIE(); // List<ModeloNegocio.Asesor> listUsuario = new List<ModeloNegocio.Asesor>(); // NOW ASSIGN DATA TO A DATAGRID. DataGrid dg = new DataGrid(); dg.DataSource = aconpanaClase.getReportAllVisitasIE(); dg.DataBind(); // THE EXCEL FILE. string sFileName = "VisitasIE-" + 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) { if (!IsPostBack) { visitaMN = new ModeloNegocio.VisitaIE(); visitaMN.Id = Convert.ToInt32(Request.Params["visita_id"]); visitaLN = new LogicaNegocio.VisitaIE(); visitaMN = visitaLN.getVisitaId(visitaMN.Id); txtFecha.Text = visitaMN.Fecha.ToString("yyyy-MM-dd");; txtObservacion.Text = visitaMN.Observacion; TxtPendientes.Text = visitaMN.Pendientes; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { visitaMN = new ModeloNegocio.VisitaIE(); visitaMN.Id = Convert.ToInt32(Request.Params["visita_id"]); visitaLN = new LogicaNegocio.VisitaIE(); visitaMN = visitaLN.getVisitaId(visitaMN.Id); txtFecha.Text = visitaMN.Fecha.ToString("yyyy-MM-dd"); ; txtObservacion.Text = visitaMN.Observacion; TxtPendientes.Text = visitaMN.Pendientes; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { visitaMN = new ModeloNegocio.VisitaIE(); visitaLN = new LogicaNegocio.VisitaIE(); visitaMN.Id = Convert.ToInt32(Request.Params["visita_id"]); visitaMN = visitaLN.getVisitaId(visitaMN.Id); txtFecha.Text = visitaMN.Fecha.ToString("yyyy-MM-dd"); asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(visitaMN.Asesor_id); txtAsesor.Text = asesorMN.FullName; directorLN = new LogicaNegocio.Director(); directorMN = new ModeloNegocio.Director(); directorMN = directorLN.getDirectorId(visitaMN.Director_id); txtDirector.Text = directorMN.FullName; docenteLN = new LogicaNegocio.Docente(); docenteMN = new ModeloNegocio.Docente(); docenteMN = docenteLN.getDocenteId(visitaMN.Docente_id); txtDocente.Text = docenteMN.FullName; schoolLN = new LogicaNegocio.School(); schoolMN = new ModeloNegocio.School(); //schoolMN = schoolLN.getDocenteId(visitaMN.Docente_id); schoolMN = schoolLN.getSchool(visitaMN.School_id); txtSchool.Text = schoolMN.Nombre.ToString(); txtMotivoVisita.Text = visitaMN.MotivoVisita; txtObservacion.Text = visitaMN.Observacion; TxtPendientes.Text = visitaMN.Pendientes; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { visitaMN = new ModeloNegocio.VisitaIE(); visitaLN = new LogicaNegocio.VisitaIE(); visitaMN.Id = Convert.ToInt32(Request.Params["visita_id"]); visitaMN = visitaLN.getVisitaId(visitaMN.Id); txtFecha.Text = visitaMN.Fecha.ToString("yyyy-MM-dd"); asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(visitaMN.Asesor_id); txtAsesor.Text = asesorMN.FullName; directorLN = new LogicaNegocio.Director(); directorMN = new ModeloNegocio.Director(); directorMN=directorLN.getDirectorId(visitaMN.Director_id); txtDirector.Text = directorMN.FullName; docenteLN = new LogicaNegocio.Docente(); docenteMN = new ModeloNegocio.Docente(); docenteMN = docenteLN.getDocenteId(visitaMN.Docente_id); txtDocente.Text = docenteMN.FullName; schoolLN = new LogicaNegocio.School(); schoolMN = new ModeloNegocio.School(); //schoolMN = schoolLN.getDocenteId(visitaMN.Docente_id); schoolMN = schoolLN.getSchool(visitaMN.School_id); txtSchool.Text = schoolMN.Nombre.ToString(); txtMotivoVisita.Text = visitaMN.MotivoVisita; txtObservacion.Text = visitaMN.Observacion; TxtPendientes.Text = visitaMN.Pendientes; } }
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.VisitaIE visitaIE = new LogicaNegocio.VisitaIE(); List <ModeloNegocio.VisitaIE> listVisitasIE = new List <ModeloNegocio.VisitaIE>(); //-------------Inicio Paginador UscPaginador.caragaPaginador(100, Convert.ToInt32(Request.Params["pagina"]), visitaIE.countRowsVisitas()); //---------------Fin Paginador int NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar; listVisitasIE = visitaIE.getAllVisitas(100, UscPaginador.RegistrosAEmpezar); foreach (ModeloNegocio.VisitaIE VisitasIE in listVisitasIE) { ModeloNegocio.Asesor asesorMN; LogicaNegocio.Asesor asesorLN; asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(VisitasIE.Asesor_id); NumRegistrosEmpezar++; FilasLista.Text += "<tr id='" + VisitasIE.Id + "'>"; FilasLista.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>"; FilasLista.Text += "<td>" + VisitasIE.Id + "</td>"; FilasLista.Text += "<td>" + asesorMN.FullName + "</td>"; FilasLista.Text += "<td>" + VisitasIE.Fecha.ToString("dd-MM-yyyy") + "</td>"; FilasLista.Text += "<td>"; //FilasLista.Text += "<a href='" + "Admin-SeguiEditVisita.aspx?visita_id=" + VisitasIE.Id + "'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar seguimiento de Visitas a IE'></span></a>"; FilasLista.Text += "<a href='" + "Admin-SeguiViewVisita.aspx?id=3&visita_id=" + VisitasIE.Id + "'><span class='glyphicon glyphicon glyphicon-zoom-in' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver visita a IE'></span></a>"; FilasLista.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar <b>" + VisitasIE.Nombre + "</b> ','" + VisitasIE.Id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar seguimiento de Visita IE'></span></a>"; FilasLista.Text += "</td></tr>"; } }
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 CmdGuardar_Click(object sender, EventArgs e) { ObjVisitaLN = new LogicaNegocio.VisitaIE(); ObjVisitaMN = new ModeloNegocio.VisitaIE(); //otaku_bcp.visitas_ie.observacion, //otaku_bcp.visitas_ie.pendientes, ObjVisitaMN.Fecha = Convert.ToDateTime(txtFecha.Text); ObjVisitaMN.Nombre = ""; ObjVisitaMN.Asesor_id = Convert.ToInt32(ddlAsesor.Text); ObjVisitaMN.School_id = Convert.ToInt32(Request.Form[ddlSchool.UniqueID]); if (chkDocente.Checked == true) { ObjVisitaMN.Docente_id = Convert.ToInt32(Request.Form[ddlDocente.UniqueID]); } else { ObjVisitaMN.Docente_id = 0; } if (chkDirector.Checked == true) { ObjVisitaMN.Director_id = Convert.ToInt32(Request.Form[ddlDirector.UniqueID]); } else { ObjVisitaMN.Director_id = 0; } string strMotivoVisita = ""; if (chkA.Checked == true) { strMotivoVisita += "0:" + chkA.Text + "|"; } if (chkB.Checked == true) { strMotivoVisita += "1:" + chkB.Text + "|"; } if (chkC.Checked == true) { strMotivoVisita += "2:" + chkC.Text + "|"; } if (chkD.Checked == true) { strMotivoVisita += "3:" + chkD.Text + "|"; } ObjVisitaMN.MotivoVisita = strMotivoVisita; ObjVisitaMN.Pendientes = TxtPendientes.Text; ObjVisitaMN.Observacion = txtObservacion.Text; ObjVisitaLN.insertVisitas(ObjVisitaMN); string strRedirect; strRedirect = "Admin-SeguiVisitas.aspx?id=3"; Response.Redirect(strRedirect, true); }
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 CmdGuardar_Click(object sender, EventArgs e) { ObjVisitaLN = new LogicaNegocio.VisitaIE(); ObjVisitaMN = new ModeloNegocio.VisitaIE(); //otaku_bcp.visitas_ie.observacion, //otaku_bcp.visitas_ie.pendientes, ObjVisitaMN.Fecha = Convert.ToDateTime(txtFecha.Text); ObjVisitaMN.Nombre = ""; ObjVisitaMN.Asesor_id = Convert.ToInt32(ddlAsesor.Text); ObjVisitaMN.School_id = Convert.ToInt32(Request.Form[ddlSchool.UniqueID]); if (chkDocente.Checked == true){ ObjVisitaMN.Docente_id = Convert.ToInt32(Request.Form[ddlDocente.UniqueID]); } else { ObjVisitaMN.Docente_id = 0; } if (chkDirector.Checked == true) { ObjVisitaMN.Director_id = Convert.ToInt32(Request.Form[ddlDirector.UniqueID]); } else { ObjVisitaMN.Director_id = 0; } string strMotivoVisita=""; if (chkA.Checked==true) { strMotivoVisita += "0:" + chkA.Text + "|" ; } if (chkB.Checked == true) { strMotivoVisita += "1:" + chkB.Text + "|"; } if (chkC.Checked == true) { strMotivoVisita += "2:" + chkC.Text + "|"; } if (chkD.Checked == true) { strMotivoVisita += "3:" + chkD.Text + "|"; } ObjVisitaMN.MotivoVisita = strMotivoVisita; ObjVisitaMN.Pendientes = TxtPendientes.Text; ObjVisitaMN.Observacion = txtObservacion.Text; ObjVisitaLN.insertVisitas(ObjVisitaMN); string strRedirect; strRedirect = "Admin-SeguiVisitas.aspx?id=3"; Response.Redirect(strRedirect, true); }