protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
LogicaNegocio.AconpanaClase aconpanaClase = new LogicaNegocio.AconpanaClase();
List <ModeloNegocio.AconpanaClase> listAconpanaClase = new List <ModeloNegocio.AconpanaClase>();
int NumRegistrosEmpezar;
if (Request.Params["docente_id"] != null)
{
int docente_id = Convert.ToInt32(Request.Params["docente_id"]);
NumRegistrosEmpezar = 0;
listAconpanaClase = aconpanaClase.getAllAconpanaClasePorDocente(docente_id, 200, NumRegistrosEmpezar);
}
else
{
//-------------Inicio Paginador
UscPaginador.caragaPaginador(100, Convert.ToInt32(Request.Params["pagina"]), aconpanaClase.countRowsAconpanaClase());
//---------------Fin Paginador
NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar;
listAconpanaClase = aconpanaClase.getAllAconpanaClase(100, UscPaginador.RegistrosAEmpezar);
}
foreach (ModeloNegocio.AconpanaClase Aconpana in listAconpanaClase)
{
ModeloNegocio.Asesor asesorMN = new ModeloNegocio.Asesor();
LogicaNegocio.Asesor asesorLN = new LogicaNegocio.Asesor();
ModeloNegocio.Docente docenteMN = new ModeloNegocio.Docente();
LogicaNegocio.Docente docenteLN = new LogicaNegocio.Docente();
asesorMN = asesorLN.getAsesorId(Aconpana.Asesor_id);
docenteMN = docenteLN.getDocenteId(Aconpana.Docente_id);
NumRegistrosEmpezar++;
FilasLista.Text += "<tr id='" + Aconpana.Id + "'>";
FilasLista.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>";
FilasLista.Text += "<td>" + Aconpana.Id + "</td>";
FilasLista.Text += "<td>" + asesorMN.FullName + "</td>";
FilasLista.Text += "<td>" + docenteMN.FullName + "</td>";
FilasLista.Text += "<td>" + Aconpana.Fecha.ToString("dd-MM-yyyy") + "</td>";
FilasLista.Text += "<td>";
// FilasLista.Text += "<a href='" + "Admin-Segui.aspx?asesor_id=" + Aconpana.Id + "'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar seguimiento a clase'></span></a>";
FilasLista.Text += "<a href='" + "Admin-SeguiViewClase.aspx?aconpana_id=" + Aconpana.Id + "&id=2'><span class='glyphicon glyphicon-zoom-in' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver seguimiento a clase'></span></a>";
FilasLista.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar <b>" + Aconpana.Id_Tema_Nombre_sesion + "</b> ','" + Aconpana.Id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar seguimiento a clase'></span></a>";
FilasLista.Text += "</td></tr>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
LogicaNegocio.AconpanaClase aconpanaClase = new LogicaNegocio.AconpanaClase();
List<ModeloNegocio.AconpanaClase> listAconpanaClase = new List<ModeloNegocio.AconpanaClase>();
int NumRegistrosEmpezar;
if (Request.Params["docente_id"]!= null)
{
int docente_id = Convert.ToInt32(Request.Params["docente_id"]);
NumRegistrosEmpezar = 0;
listAconpanaClase = aconpanaClase.getAllAconpanaClasePorDocente(docente_id, 200, NumRegistrosEmpezar);
}
else
{
//-------------Inicio Paginador
UscPaginador.caragaPaginador(100, Convert.ToInt32(Request.Params["pagina"]), aconpanaClase.countRowsAconpanaClase());
//---------------Fin Paginador
NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar;
listAconpanaClase = aconpanaClase.getAllAconpanaClase(100, UscPaginador.RegistrosAEmpezar);
}
foreach (ModeloNegocio.AconpanaClase Aconpana in listAconpanaClase)
{
ModeloNegocio.Asesor asesorMN = new ModeloNegocio.Asesor();
LogicaNegocio.Asesor asesorLN = new LogicaNegocio.Asesor();
ModeloNegocio.Docente docenteMN = new ModeloNegocio.Docente();
LogicaNegocio.Docente docenteLN = new LogicaNegocio.Docente();
asesorMN = asesorLN.getAsesorId(Aconpana.Asesor_id);
docenteMN = docenteLN.getDocenteId(Aconpana.Docente_id);
NumRegistrosEmpezar++;
FilasLista.Text += "<tr id='" + Aconpana.Id + "'>";
FilasLista.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>";
FilasLista.Text += "<td>" + Aconpana.Id + "</td>";
FilasLista.Text += "<td>" + asesorMN.FullName + "</td>";
FilasLista.Text += "<td>" + docenteMN.FullName + "</td>";
FilasLista.Text += "<td>" + Aconpana.Fecha.ToString("dd-MM-yyyy") + "</td>";
FilasLista.Text += "<td>";
// FilasLista.Text += "<a href='" + "Admin-Segui.aspx?asesor_id=" + Aconpana.Id + "'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar seguimiento a clase'></span></a>";
FilasLista.Text += "<a href='" + "Admin-SeguiViewClase.aspx?aconpana_id=" + Aconpana.Id + "&id=2'><span class='glyphicon glyphicon-zoom-in' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver seguimiento a clase'></span></a>";
FilasLista.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar <b>" + Aconpana.Id_Tema_Nombre_sesion + "</b> ','" + Aconpana.Id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar seguimiento a clase'></span></a>";
FilasLista.Text += "</td></tr>";
}
}
protected void btnReport_Click(object sender, EventArgs e)
{
LogicaNegocio.AconpanaClase aconpanaClase = new LogicaNegocio.AconpanaClase();
// List<ModeloNegocio.Asesor> listUsuario = new List<ModeloNegocio.Asesor>();
// NOW ASSIGN DATA TO A DATAGRID.
DataGrid dg = new DataGrid();
dg.DataSource = aconpanaClase.getReportAllAconpanaClase();
dg.DataBind();
// THE EXCEL FILE.
string sFileName = "Segui-Clase-" + 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 btnReport_Click(object sender, EventArgs e)
{
LogicaNegocio.AconpanaClase aconpanaClase = new LogicaNegocio.AconpanaClase();
// List<ModeloNegocio.Asesor> listUsuario = new List<ModeloNegocio.Asesor>();
// NOW ASSIGN DATA TO A DATAGRID.
DataGrid dg = new DataGrid();
dg.DataSource = aconpanaClase.getReportAllAconpanaClase();
dg.DataBind();
// THE EXCEL FILE.
string sFileName = "Segui-Clase-" + 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 cmdGuardar_Click(object sender, EventArgs e)
{
ObjAconpanaClaseMN = new ModeloNegocio.AconpanaClase();
ObjAconpanaClaseLN = new LogicaNegocio.AconpanaClase();
ObjAconpanaClaseMN.Fecha = Convert.ToDateTime(txtFecha.Text);
ObjAconpanaClaseMN.Asesor_id = Convert.ToInt32(ddlAsesor.Text);
ObjAconpanaClaseMN.Docente_id = Convert.ToInt32(Request.Form[ddlDocente.UniqueID]);
ObjAconpanaClaseMN.School_id = Convert.ToInt32(Request.Form[ddlSchool.UniqueID]);
//Request.Form[txtParticipante.UniqueID]
ObjAconpanaClaseMN.Id_Grado_seccion = Convert.ToInt32(Request.Form[lblGradoSeccion.UniqueID]);
ObjAconpanaClaseMN.Id_Tema_Nombre_sesion = Convert.ToInt32(Request.Form[ddlNombSesion.UniqueID]);
ObjAconpanaClaseMN.Id_sesion = Convert.ToInt32(Request.Form[ddlSesion.UniqueID]);
ObjAconpanaClaseMN.Num_estudiante = Convert.ToInt32(txtEstidianteAsistentes.Text);
ObjAconpanaClaseMN.Sesion_planificado = Convert.ToInt32(rblPlanificado.SelectedValue);
ObjAconpanaClaseMN.Motivo = txtMotivo.Text;
ObjAconpanaClaseMN.Desarrollo_innovacion = Convert.ToInt32(rblInnovacion.SelectedValue);
ObjAconpanaClaseMN.Recursos_informaticos = txtRecursosInformáticos.Text;
ObjAconpanaClaseMN.Recursos_audiovisuales = txtRecursosAudiovisuales.Text;
ObjAconpanaClaseMN.Materiales_didacticos = txtMaterialesDidactico.Text;
ObjAconpanaClaseMN.Dinamicas_utilizadas = txtDinamicasUsadas.Text;
ObjAconpanaClaseMN.Otros = TxtOtros.Text;
ObjAconpanaClaseMN.Asesor_intervino = Convert.ToInt32(rblIntervino.SelectedValue);
ObjAconpanaClaseMN.Como_intervino = rblComoIntervino.SelectedValue;
ObjAconpanaClaseMN.Intervencion_colaboradores = Convert.ToInt32(rblOtrosColaboradores.SelectedValue);
ObjAconpanaClaseMN.Colaborador = txtQuien.Text;
ObjAconpanaClaseMN.Como_intervino_colaborador = txtComoIntervino.Text;
ObjAconpanaClaseMN.Participa_juego = Convert.ToInt32(rblParticipaJuego.SelectedValue);
ObjAconpanaClaseMN.Etapa = txtEtapa.Text;
ObjAconpanaClaseMN.Razon = txtRazon.Text;
ObjAconpanaClaseMN.Incidencia = txtInsidencia.Text;
ObjAconpanaClaseLN.insertAconpanaClase(ObjAconpanaClaseMN);
string strRedirect;
strRedirect = "Admin-SeguiClase.aspx?id=1";
Response.Redirect(strRedirect, true);
}
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)
{
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)
{
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)
{
if (!IsPostBack)
{
aconpanaClaseMN = new ModeloNegocio.AconpanaClase();
aconpanaClaseLN = new LogicaNegocio.AconpanaClase();
int aconpana_id = Convert.ToInt32(Request.Params["aconpana_id"]);
aconpanaClaseMN = aconpanaClaseLN.getAconpanaClaseId(aconpana_id);
txtFecha.Text = aconpanaClaseMN.Fecha.ToString("yyyy-MM-dd");
asesorLN = new LogicaNegocio.Asesor();
asesorMN = new ModeloNegocio.Asesor();
asesorMN = asesorLN.getAsesorId(aconpanaClaseMN.Asesor_id);
txtAsesor.Text = asesorMN.FullName;
docenteLN = new LogicaNegocio.Docente();
docenteMN = new ModeloNegocio.Docente();
docenteMN = docenteLN.getDocenteId(aconpanaClaseMN.Docente_id);
txtDocente.Text = docenteMN.FullName;
schoolLN = new LogicaNegocio.School();
schoolMN = new ModeloNegocio.School();
//schoolMN = schoolLN.getDocenteId(visitaMN.Docente_id);
schoolMN = schoolLN.getSchool(aconpanaClaseMN.School_id);
txtSchool.Text = schoolMN.Nombre.ToString();
teacherGradeLN = new LogicaNegocio.TeacherGrade();
teacherGradeMN = new ModeloNegocio.TeacherGrade();
teacherGradeMN = teacherGradeLN.getTeacherGradeId(Convert.ToInt32(aconpanaClaseMN.Id_Grado_seccion));
if (teacherGradeMN.Grade == null)
{
teacherGradeMN.Grade = "";
}
if (teacherGradeMN.Seccion == null)
{
teacherGradeMN.Seccion = "";
}
txtGradoSeccion.Text = "Grado: " + teacherGradeMN.Grade.ToString() + " Seccion: " + teacherGradeMN.Seccion.ToString();
temaLN = new LogicaNegocio.Tema();
temaMN = new ModeloNegocio.Tema();
temaMN = temaLN.getTemaId(Convert.ToInt32(aconpanaClaseMN.Id_Tema_Nombre_sesion));
txtNombSesion.Text = temaMN.Name;
sesionLN = new LogicaNegocio.Sesion();
sesionMN = new ModeloNegocio.Sesion();
sesionMN = sesionLN.getSesionId(Convert.ToInt32(aconpanaClaseMN.Id_sesion));
txtNumSesion.Text = sesionMN.NumSesion;
txtEstidianteAsistentes.Text = aconpanaClaseMN.Num_estudiante.ToString();
if (aconpanaClaseMN.Sesion_planificado == 0)
{
txtSesionPlanificado.Text = "No";
txtMotivo.Text = aconpanaClaseMN.Motivo;
}
else if (aconpanaClaseMN.Sesion_planificado == 1)
{
txtSesionPlanificado.Text = "Si";
}
if (aconpanaClaseMN.Desarrollo_innovacion == 0)
{
txtInnovacion.Text = "No";
}
else if (aconpanaClaseMN.Desarrollo_innovacion == 1)
{
txtInnovacion.Text = "Si";
}
txtRecursosInformáticos.Text = aconpanaClaseMN.Recursos_informaticos;
txtRecursosAudiovisuales.Text = aconpanaClaseMN.Recursos_audiovisuales;
txtMaterialesDidactico.Text = aconpanaClaseMN.Materiales_didacticos;
txtDinamicasUsadas.Text = aconpanaClaseMN.Dinamicas_utilizadas;
TxtOtros.Text = aconpanaClaseMN.Otros;
if (aconpanaClaseMN.Asesor_intervino == 0)
{
txtIntervino.Text = "No";
}
else if (aconpanaClaseMN.Desarrollo_innovacion == 1)
{
txtIntervino.Text = "Si";
}
txtComoIntervinoSesion.Text = aconpanaClaseMN.Como_intervino;
if (aconpanaClaseMN.Intervencion_colaboradores == 0)
{
txtOtrosColaboradores.Text = "No";
}
else if (aconpanaClaseMN.Intervencion_colaboradores == 1)
{
txtOtrosColaboradores.Text = "Si";
}
txtQuien.Text = aconpanaClaseMN.Colaborador;
txtComoIntervino.Text = aconpanaClaseMN.Como_intervino;
if (aconpanaClaseMN.Participa_juego == 0)
{
txtParticipaJuego.Text = "No";
}
else if (aconpanaClaseMN.Participa_juego == 1)
{
txtParticipaJuego.Text = "Si";
}
txtEtapa.Text = aconpanaClaseMN.Etapa;
txtRazon.Text = aconpanaClaseMN.Razon;
txtIncidencia.Text = aconpanaClaseMN.Incidencia;
//txtMotivoVisita.Text = visitaMN.MotivoVisita;
//txtObservacion.Text = visitaMN.Observacion;
//TxtPendientes.Text = visitaMN.Pendientes;
}
}
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)
{
if (!IsPostBack)
{
aconpanaClaseMN = new ModeloNegocio.AconpanaClase();
aconpanaClaseLN = new LogicaNegocio.AconpanaClase();
int aconpana_id = Convert.ToInt32(Request.Params["aconpana_id"]);
aconpanaClaseMN = aconpanaClaseLN.getAconpanaClaseId(aconpana_id);
txtFecha.Text = aconpanaClaseMN.Fecha.ToString("yyyy-MM-dd");
asesorLN = new LogicaNegocio.Asesor();
asesorMN = new ModeloNegocio.Asesor();
asesorMN = asesorLN.getAsesorId(aconpanaClaseMN.Asesor_id);
txtAsesor.Text = asesorMN.FullName;
docenteLN = new LogicaNegocio.Docente();
docenteMN = new ModeloNegocio.Docente();
docenteMN = docenteLN.getDocenteId(aconpanaClaseMN.Docente_id);
txtDocente.Text = docenteMN.FullName;
schoolLN = new LogicaNegocio.School();
schoolMN = new ModeloNegocio.School();
//schoolMN = schoolLN.getDocenteId(visitaMN.Docente_id);
schoolMN = schoolLN.getSchool(aconpanaClaseMN.School_id);
txtSchool.Text = schoolMN.Nombre.ToString();
teacherGradeLN = new LogicaNegocio.TeacherGrade();
teacherGradeMN = new ModeloNegocio.TeacherGrade();
teacherGradeMN = teacherGradeLN.getTeacherGradeId(Convert.ToInt32(aconpanaClaseMN.Id_Grado_seccion));
if (teacherGradeMN.Grade == null)
teacherGradeMN.Grade = "";
if (teacherGradeMN.Seccion == null)
teacherGradeMN.Seccion = "";
txtGradoSeccion.Text = "Grado: " + teacherGradeMN.Grade.ToString() + " Seccion: " + teacherGradeMN.Seccion.ToString();
temaLN = new LogicaNegocio.Tema();
temaMN = new ModeloNegocio.Tema();
temaMN = temaLN.getTemaId(Convert.ToInt32(aconpanaClaseMN.Id_Tema_Nombre_sesion));
txtNombSesion.Text = temaMN.Name;
sesionLN = new LogicaNegocio.Sesion();
sesionMN = new ModeloNegocio.Sesion();
sesionMN = sesionLN.getSesionId(Convert.ToInt32(aconpanaClaseMN.Id_sesion));
txtNumSesion.Text = sesionMN.NumSesion;
txtEstidianteAsistentes.Text = aconpanaClaseMN.Num_estudiante.ToString();
if(aconpanaClaseMN.Sesion_planificado == 0) {
txtSesionPlanificado.Text = "No";
txtMotivo.Text = aconpanaClaseMN.Motivo;
} else if(aconpanaClaseMN.Sesion_planificado == 1) {
txtSesionPlanificado.Text = "Si";
}
if (aconpanaClaseMN.Desarrollo_innovacion == 0)
{
txtInnovacion.Text = "No";
}
else if (aconpanaClaseMN.Desarrollo_innovacion == 1)
{
txtInnovacion.Text = "Si";
}
txtRecursosInformáticos.Text = aconpanaClaseMN.Recursos_informaticos;
txtRecursosAudiovisuales.Text = aconpanaClaseMN.Recursos_audiovisuales;
txtMaterialesDidactico.Text = aconpanaClaseMN.Materiales_didacticos;
txtDinamicasUsadas.Text = aconpanaClaseMN.Dinamicas_utilizadas;
TxtOtros.Text = aconpanaClaseMN.Otros;
if (aconpanaClaseMN.Asesor_intervino == 0)
{
txtIntervino.Text = "No";
}
else if (aconpanaClaseMN.Desarrollo_innovacion == 1)
{
txtIntervino.Text = "Si";
}
txtComoIntervinoSesion.Text = aconpanaClaseMN.Como_intervino;
if (aconpanaClaseMN.Intervencion_colaboradores == 0)
{
txtOtrosColaboradores.Text = "No";
}
else if (aconpanaClaseMN.Intervencion_colaboradores == 1)
{
txtOtrosColaboradores.Text = "Si";
}
txtQuien.Text = aconpanaClaseMN.Colaborador;
txtComoIntervino.Text = aconpanaClaseMN.Como_intervino;
if (aconpanaClaseMN.Participa_juego == 0)
{
txtParticipaJuego.Text = "No";
}
else if (aconpanaClaseMN.Participa_juego == 1)
{
txtParticipaJuego.Text = "Si";
}
txtEtapa.Text = aconpanaClaseMN.Etapa;
txtRazon.Text = aconpanaClaseMN.Razon;
txtIncidencia.Text = aconpanaClaseMN.Incidencia;
//txtMotivoVisita.Text = visitaMN.MotivoVisita;
//txtObservacion.Text = visitaMN.Observacion;
//TxtPendientes.Text = visitaMN.Pendientes;
}
}
