public void getAsesor(ref ModeloNegocio.Asesor ObjAsesor)
{
AccesoDatos.User user = new AccesoDatos.User();
ModeloNegocio.User ObjUser = new ModeloNegocio.User();
ObjUser = user.getUser(ObjAsesor.id);
ObjAsesor.FullName = ObjUser.FullName;
ObjAsesor.Codigo = ObjUser.Codigo;
ObjAsesor.Email = ObjUser.Email;
ObjAsesor.Telefono = ObjUser.Telefono;
ObjAsesor.FechaCreado = ObjUser.FechaCreado;
ObjAsesor.FechaActualizado = ObjUser.FechaActualizado;
ObjAsesor.typeUser = ObjUser.typeUser;
ObjAsesor.Grupo = ObjUser.Grupo;
List <ModeloNegocio.School> lista = new List <ModeloNegocio.School>();
LogicaNegocio.UserSchool asesorSchool = new LogicaNegocio.UserSchool();
lista = asesorSchool.getAllSchoolForUser(ObjAsesor.id);
ObjAsesor.Schools = lista;
List <ModeloNegocio.User> lista1 = new List <ModeloNegocio.User>();
LogicaNegocio.UserTeacher asesorTeacher = new LogicaNegocio.UserTeacher();
lista1 = asesorTeacher.getAllTeacherForUser(ObjAsesor.id);
ObjAsesor.Teachers = lista1;
}
public bool deleteAsesor(int iduser)
{
AccesoDatos.Asesor asesor;
AccesoDatos.UserTeacher userTeacher;
AccesoDatos.UserSchool userSchool;
List <ModeloNegocio.School> lista = new List <ModeloNegocio.School>();
List <ModeloNegocio.User> lista1 = new List <ModeloNegocio.User>();
ModeloNegocio.Asesor Asesor = new ModeloNegocio.Asesor();
LogicaNegocio.UserSchool asesorSchool = new LogicaNegocio.UserSchool();
LogicaNegocio.UserTeacher asesorTeacher = new LogicaNegocio.UserTeacher();
lista = asesorSchool.getAllSchoolForUser(iduser);
lista1 = asesorTeacher.getAllTeacherForUser(iduser);
foreach (ModeloNegocio.School schoolLista in lista)
{
userSchool = new AccesoDatos.UserSchool();
userSchool.updateSelectSchoolForIduser(schoolLista.id, 0);
}
foreach (ModeloNegocio.User teacherLista in lista1)
{
userTeacher = new AccesoDatos.UserTeacher();
userTeacher.updateSelectTeacherForIduser(teacherLista.id, 0);
}
//Asesor = asesor.getAsesorId(iduser);
asesor = new AccesoDatos.Asesor();
asesor.deleteAsesor(iduser);
userTeacher = new AccesoDatos.UserTeacher();
userTeacher.deleteTeachersForUserId(iduser);
userSchool = new AccesoDatos.UserSchool();
userSchool.deleteSchoolsForUserId(iduser);
return(true);
}
protected void cmdGuardar_Click(object sender, EventArgs e)
{
LogicaNegocio.UserTeacher userTeacher;
LogicaNegocio.UserSchool userSchool;
ModeloNegocio.UserSchool ObjUserSchoolMN;
ModeloNegocio.UserTeacher ObjUserDocenteMN;
AsesorMN = new ModeloNegocio.Asesor();
AsesorLN = new LogicaNegocio.Asesor();
AsesorMN.id = Convert.ToInt32(Request.Params["asesor_id"]);
AsesorLN.getAsesor(ref AsesorMN);
userSchool = new LogicaNegocio.UserSchool();
foreach (ModeloNegocio.School listSchool in AsesorMN.Schools)
{
userSchool.updateSelectSchoolForIduser(listSchool.id, 0);
}
userSchool.deleteSchoolsForUserId(AsesorMN.id);
foreach (ListItem item in lblEscuelaACargo.Items)
{
if (item.Selected == true)
{
ObjUserSchoolMN = new ModeloNegocio.UserSchool();
userSchool = new LogicaNegocio.UserSchool();
ObjUserSchoolMN.UserAsesorId = AsesorMN.id;
ObjUserSchoolMN.UserSchoolId = Convert.ToInt32(item.Value);
userSchool.insertUserSchool(ObjUserSchoolMN);
}
}
userTeacher = new LogicaNegocio.UserTeacher();
foreach (ModeloNegocio.User teacherLista in AsesorMN.Teachers)
{
userTeacher.updateSelectTeacherForIduser(teacherLista.id, 0);
}
userTeacher.deleteTeachersForUserId(AsesorMN.id);
//foreach (ListItem item in lblDocenteCaCargo.Items)
//{
// if (item.Selected == true)
// {
// ObjUserDocenteMN = new ModeloNegocio.UserTeacher();
// userTeacher = new LogicaNegocio.UserTeacher();
// ObjUserDocenteMN.UserAsesorId = AsesorMN.id;
// ObjUserDocenteMN.UserTeacheId = Convert.ToInt32(item.Value);
// userTeacher.insertUserTeacher(ObjUserDocenteMN);
// }
//}
AsesorMN.Codigo = txtCodigo.Text;
AsesorMN.FullName = txtNombre.Text;
AsesorMN.Telefono = txtTelefono.Text;
AsesorMN.Grupo = Convert.ToString(ddlGrupo.SelectedItem);
AsesorMN.FechaActualizado = DateTime.Now;
AsesorLN = new LogicaNegocio.Asesor();
AsesorLN.updateAsesor(AsesorMN);
string strRedirect;
strRedirect = "Admin-ListAsesor.aspx?id=1";
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 cmdGuardar_Click(object sender, EventArgs e)
{
LogicaNegocio.UserTeacher userTeacher;
LogicaNegocio.UserSchool userSchool;
ModeloNegocio.UserSchool ObjUserSchoolMN;
ModeloNegocio.UserTeacher ObjUserDocenteMN;
AsesorMN = new ModeloNegocio.Asesor();
AsesorLN = new LogicaNegocio.Asesor();
AsesorMN.id = Convert.ToInt32(Request.Params["asesor_id"]);
AsesorLN.getAsesor(ref AsesorMN);
userSchool = new LogicaNegocio.UserSchool();
foreach (ModeloNegocio.School listSchool in AsesorMN.Schools)
{
userSchool.updateSelectSchoolForIduser(listSchool.id, 0);
}
userSchool.deleteSchoolsForUserId(AsesorMN.id);
foreach (ListItem item in lblEscuelaACargo.Items)
{
if (item.Selected == true)
{
ObjUserSchoolMN = new ModeloNegocio.UserSchool();
userSchool = new LogicaNegocio.UserSchool();
ObjUserSchoolMN.UserAsesorId = AsesorMN.id;
ObjUserSchoolMN.UserSchoolId = Convert.ToInt32(item.Value);
userSchool.insertUserSchool(ObjUserSchoolMN);
}
}
userTeacher = new LogicaNegocio.UserTeacher();
foreach (ModeloNegocio.User teacherLista in AsesorMN.Teachers)
{
userTeacher.updateSelectTeacherForIduser(teacherLista.id, 0);
}
userTeacher.deleteTeachersForUserId(AsesorMN.id);
//foreach (ListItem item in lblDocenteCaCargo.Items)
//{
// if (item.Selected == true)
// {
// ObjUserDocenteMN = new ModeloNegocio.UserTeacher();
// userTeacher = new LogicaNegocio.UserTeacher();
// ObjUserDocenteMN.UserAsesorId = AsesorMN.id;
// ObjUserDocenteMN.UserTeacheId = Convert.ToInt32(item.Value);
// userTeacher.insertUserTeacher(ObjUserDocenteMN);
// }
//}
AsesorMN.Codigo = txtCodigo.Text;
AsesorMN.FullName = txtNombre.Text;
AsesorMN.Telefono = txtTelefono.Text;
AsesorMN.Grupo = Convert.ToString(ddlGrupo.SelectedItem);
AsesorMN.FechaActualizado = DateTime.Now;
AsesorLN = new LogicaNegocio.Asesor();
AsesorLN.updateAsesor(AsesorMN);
string strRedirect;
strRedirect = "Admin-ListAsesor.aspx?id=1";
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);
}
}
