public static List <ListaCompetenciaCapacidadArea> ListarCompetenciaCapadidadArea(int idCurriculaBase) { using (var cn = new InnovaEntities()) { var listaRetorno = new List <ListaCompetenciaCapacidadArea>(); listaRetorno = (from c in cn.CurriculaBaseCompetencia join a in cn.AreaCurricular on c.IdAreaCurricular equals a.IdAreaCurricular join comp in cn.Competencia on c.IdCompetencia equals comp.IdCompetencia //join cap in cn.Capacidad on comp.IdCompetencia equals cap.IdCompetencia into x //from lj in x.DefaultIfEmpty() where c.IdCurriculaBase == idCurriculaBase select new ListaCompetenciaCapacidadArea { idCurriculaBaseCompetencia = c.IdCurriculaBaseCompetencia, idCurriculaBase = idCurriculaBase, areaCurricular = a.Nombre, competencia = comp.Nombre, idAreaCurricula = a.IdAreaCurricular, idCompetencia = comp.IdCompetencia }).ToList(); return(listaRetorno); } }
public static bool RegistrarCurriculaBase(CurriculaBase Base) { using (var cn = new InnovaEntities()) { try { if (Base.IdCurriculaBase > 0) { var baseEdit = cn.CurriculaBase.FirstOrDefault(b => b.IdCurriculaBase == Base.IdCurriculaBase); if (baseEdit != null) { baseEdit.Año = Base.Año; baseEdit.NumeroResolucion = Base.NumeroResolucion; baseEdit.Descripcion = Base.Descripcion; baseEdit.Vigencia = Base.Vigencia; cn.SaveChanges(); } } else { cn.CurriculaBase.Add(Base); cn.SaveChanges(); } return(true); } catch (Exception) { return(false); } } }
public static bool RegistrarCompetenciaArea(CurriculaBaseCompetencia BaseCompetencia) { using (var cn = new InnovaEntities()) { try { var ragistroValidacion = cn.CurriculaBaseCompetencia.FirstOrDefault( c => c.IdAreaCurricular == BaseCompetencia.IdAreaCurricular && c.IdCompetencia == BaseCompetencia.IdCompetencia && c.IdCurriculaBase == BaseCompetencia.IdCurriculaBase); if (ragistroValidacion != null) { return(false); } else { cn.CurriculaBaseCompetencia.Add(BaseCompetencia); cn.SaveChanges(); return(true); } } catch (Exception) { return(false); } } }
public static List <PlanSecundariaModel> ListarPlanSecundaria(int IdCurriculaBase) { using (var cn = new InnovaEntities()) { var lista = (from a in cn.AreaCurricular join p1 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p1.IdAreaCurricular join p2 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p2.IdAreaCurricular join p3 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p3.IdAreaCurricular join p4 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p4.IdAreaCurricular join p5 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p5.IdAreaCurricular where p1.IdCurriculaBase == IdCurriculaBase && p2.IdCurriculaBase == IdCurriculaBase && p3.IdCurriculaBase == IdCurriculaBase && p4.IdCurriculaBase == IdCurriculaBase && p5.IdCurriculaBase == IdCurriculaBase && p1.IdGrado == 9 && p2.IdGrado == 10 && p3.IdGrado == 11 && p4.IdGrado == 12 && p5.IdGrado == 13 select new PlanSecundariaModel { idAreaCurricular = a.IdAreaCurricular, DescAreaCurricular = a.Nombre, HorasGrado1 = p1.Horas, HorasGrado2 = p2.Horas, HorasGrado3 = p3.Horas, HorasGrado4 = p4.Horas, HorasGrado5 = p5.Horas }).ToList(); return(lista); } }
public static bool RegistrarPlanByIdGrado(int idCurriculaBase, int idAreaCurricular, int IdGrado, decimal Horas) { using (var cn = new InnovaEntities()) { try { var PlanEdit = (from c in cn.PlanEstudiosBase where c.IdCurriculaBase == idCurriculaBase && c.IdAreaCurricular == idAreaCurricular && c.IdGrado == IdGrado select c).FirstOrDefault(); if (PlanEdit != null) { PlanEdit.Horas = Horas; cn.SaveChanges(); } else { cn.PlanEstudiosBase.Add(new PlanEstudiosBase { IdCurriculaBase = idCurriculaBase, IdAreaCurricular = idAreaCurricular, IdGrado = IdGrado, Horas = Horas }); cn.SaveChanges(); } return(true); } catch (Exception) { return(false); } } }
public static CurriculaBase ObtenerBase(int idCurriculaBase) { using (var cn = new InnovaEntities()) { return(cn.CurriculaBase.FirstOrDefault(b => b.IdCurriculaBase == idCurriculaBase)); } }
public static List <Empleado> ListarProfesor(int idNivel) { List <Empleado> lista = new List <Empleado>(); int idPuesto = 2; switch (idNivel) { case 0: idPuesto = 2; break; case 1: idPuesto = 3; break; case 2: idPuesto = 4; break; } using (var cn = new InnovaEntities()) { var contrato = (from a in cn.Contrato where a.idPuesto == idPuesto select a).ToList(); lista = (from a in contrato select new Empleado() { idEmpleado = a.idEmpleado, Persona = new Persona() { nombre = a.Empleado.Persona.nombre + " " + a.Empleado.Persona.apellidoPaterno + " " + a.Empleado.Persona.apellidoMaterno } }).ToList(); } return(lista); }
public static List <Capacidad> ListarCapacidad() { using (var cn = new InnovaEntities()) { var lista = cn.Capacidad.ToList(); return(lista); } }
public static List <CurriculaBase> ListarBase() { using (var cn = new InnovaEntities()) { var lista = (from c in cn.CurriculaBase select c).ToList(); return(lista); } }
public static List <AreaCurricular> ListarAreaCurricular() { using (var cn = new InnovaEntities()) { var lista = (from c in cn.AreaCurricular select c).ToList(); return(lista); } }
public static List <Competencia> ListarCompetencia() { using (var cn = new InnovaEntities()) { var lista = (from c in cn.Competencia select c).ToList(); return(lista); } }
public static List <Nivel> ListarNivel() { using (var cn = new InnovaEntities()) { var lista = (from a in cn.Nivel select a).ToList(); return(lista); } }
public static List <AreaCurricular> ListarAreaCurricularById(int id) { using (var cn = new InnovaEntities()) { var lista = (from c in cn.AreaCurricular where c.IdAreaCurricular == id select c).ToList(); return(lista); } }
public static List <Grado> ListarGrado(int idNivel) { using (var cn = new InnovaEntities()) { var lista = (from a in cn.Grado where a.IdNivel == idNivel select a).ToList(); return(lista); } }
public static List <TipoCalificación> ListarTipoCalificacion() { List <TipoCalificación> lista = new List <TipoCalificación>(); using (var cn = new InnovaEntities()) { lista = (from a in cn.TipoCalificación select a).ToList(); } return(lista); }
public static bool RegistrarCurriculaBase(CurriculaBase Base) { using (var cn = new InnovaEntities()) { try { if (Base.IdCurriculaBase > 0) { var baseEdit = cn.CurriculaBase.FirstOrDefault(b => b.IdCurriculaBase == Base.IdCurriculaBase); if (baseEdit != null) { baseEdit.Año = Base.Año; baseEdit.NumeroResolucion = Base.NumeroResolucion; baseEdit.Descripcion = Base.Descripcion; if (Convert.ToBoolean(Base.Vigencia)) { cn.CurriculaBase.ToList().ForEach(s => s.Vigencia = false); baseEdit.Vigencia = Base.Vigencia; } else { baseEdit.Vigencia = Base.Vigencia; } cn.SaveChanges(); } } else { // se valida que una resolución no se registre dos veces. var baseEdit = cn.CurriculaBase.FirstOrDefault(b => b.NumeroResolucion.Trim() == Base.NumeroResolucion.Trim()); if (baseEdit != null) { return(false); } else { if (Convert.ToBoolean(Base.Vigencia)) { cn.CurriculaBase.ToList().ForEach(s => s.Vigencia = false); } cn.CurriculaBase.Add(Base); cn.SaveChanges(); } } return(true); } catch (Exception) { return(false); } } }
public static PlanEstudiosBase ObtenerPlanEstudioBase(int idGrado, int idAreaCurricular) { PlanEstudiosBase planEstudioBase = null; using (var cn = new InnovaEntities()) { planEstudioBase = (from a in cn.PlanEstudiosBase where a.IdGrado == idGrado && a.IdAreaCurricular == idAreaCurricular select a).FirstOrDefault(); } return(planEstudioBase); }
public static bool RegistrarCompetenciaArea(CurriculaBaseCompetencia BaseCompetencia) { using (var cn = new InnovaEntities()) { try { cn.CurriculaBaseCompetencia.Add(BaseCompetencia); cn.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public static List <Unidad> ListarUnidad() { using (var cn = new InnovaEntities()) { List <Unidad> lista = (from a in cn.Unidad select a).ToList(); lista = (from j in lista select new Unidad() { IdUnidad = j.IdUnidad, Nombre = j.Nombre }).ToList(); return(lista); } }
public static List <Competencia> ListarCompetenciaCurriculaBase(int IdCurriculaBase) { using (var cn = new InnovaEntities()) { List <Competencia> lista = (from c in cn.CurriculaBaseCompetencia where c.IdCurriculaBase == IdCurriculaBase select c.Competencia).ToList(); lista = (from j in lista select new Competencia() { IdCompetencia = j.IdCompetencia, Nombre = j.Nombre }).ToList(); return(lista); } }
public static PlanPrimariaModel ListarPlanPrimariaByIdArea(int IdCurriculaBase, int IdAreaCurricular) { List <PlanPrimariaModel> Lista = new List <PlanPrimariaModel>(); using (var cn = new InnovaEntities()) { var lista = (from a in cn.AreaCurricular join p1 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p1.IdAreaCurricular join p2 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p2.IdAreaCurricular join p3 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p3.IdAreaCurricular join p4 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p4.IdAreaCurricular join p5 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p5.IdAreaCurricular join p6 in cn.PlanEstudiosBase on a.IdAreaCurricular equals p6.IdAreaCurricular where p1.IdCurriculaBase == IdCurriculaBase && p2.IdCurriculaBase == IdCurriculaBase && p3.IdCurriculaBase == IdCurriculaBase && p4.IdCurriculaBase == IdCurriculaBase && p5.IdCurriculaBase == IdCurriculaBase && p6.IdCurriculaBase == IdCurriculaBase && p1.IdGrado == 3 && p2.IdGrado == 4 && p3.IdGrado == 5 && p4.IdGrado == 6 && p5.IdGrado == 7 && p6.IdGrado == 8 && a.IdAreaCurricular == IdAreaCurricular select new PlanPrimariaModel { idAreaCurricular = a.IdAreaCurricular, DescAreaCurricular = a.Nombre, HorasGrado1 = p1.Horas, HorasGrado2 = p2.Horas, HorasGrado3 = p3.Horas, HorasGrado4 = p4.Horas, HorasGrado5 = p5.Horas, HorasGrado6 = p6.Horas }).FirstOrDefault(); return(lista); } }
public static List <CurriculaBase> BuscarListaBase(string inicio, string fin, string resolucion) { using (var cn = new InnovaEntities()) { List <CurriculaBase> lista = null; if (inicio != "" && fin == "" && resolucion == "") { int iInicio = Convert.ToInt32(inicio); lista = (from c in cn.CurriculaBase where c.Año >= iInicio select c).ToList(); } if (inicio == "" && fin != "" && resolucion == "") { int iFin = Convert.ToInt32(fin); lista = (from c in cn.CurriculaBase where c.Año <= iFin select c).ToList(); } if (inicio == "" && fin == "" && resolucion != "") { lista = (from c in cn.CurriculaBase where c.NumeroResolucion.Contains(resolucion) select c).ToList(); } if (inicio != "" && fin != "" && resolucion == "") { int iInicio = Convert.ToInt32(inicio); int iFin = Convert.ToInt32(fin); lista = (from c in cn.CurriculaBase where c.Año >= iInicio && c.Año <= iFin select c).ToList(); } return(lista); } }
public static bool EliminarCompetenciaCapadidadArea(int idCurriculaBaseCompetencia) { using (var cn = new InnovaEntities()) { try { var baseCompetencia = cn.CurriculaBaseCompetencia.FirstOrDefault(c => c.IdCurriculaBaseCompetencia == idCurriculaBaseCompetencia); if (baseCompetencia != null) { cn.CurriculaBaseCompetencia.Remove(baseCompetencia); cn.SaveChanges(); } return(true); } catch (Exception) { return(false); } } }
public static List <Persona> ListarPersonaPuesto(int idPuesto) { List <Persona> lista = new List <Persona>(); //idPuesto = 1 -->"Coordinador de Curso"; //idPuesto = 5 -->"Director Academico"; using (var cn = new InnovaEntities()) { var contrato = (from a in cn.Contrato where a.idPuesto == idPuesto select a).ToList(); lista = (from a in contrato select new Persona() { nombre = a.Empleado.Persona.nombre + " " + a.Empleado.Persona.apellidoPaterno + " " + a.Empleado.Persona.apellidoMaterno, correoElectronico = a.Empleado.Persona.correoElectronico }).ToList(); } return(lista); }
public static List <Empleado> ListarCoordinador() { List <Empleado> lista = new List <Empleado>(); using (var cn = new InnovaEntities()) { var contrato = (from a in cn.Contrato where a.idPuesto == 1 select a.Empleado).ToList(); lista = (from a in contrato select new Empleado() { idEmpleado = a.idEmpleado, Persona = new Persona() { nombre = a.Persona.nombre + " " + a.Persona.apellidoPaterno + " " + a.Persona.apellidoMaterno } }).ToList(); } return(lista); }