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);
}
