public static List <Reportes> ObtenerReporteXFechas(UDPUBLISHContext _context, DateTime fechaIni, DateTime fechaFin)
{
var qResult = (from pre in _context.Preregistros
join est in _context.EstadoPrereg
on pre.EstprId equals est.EstprId
join tip in _context.TipoPreregistro
on pre.TipoprId equals tip.TipoprId
join eval in _context.Evaluacion
on pre.PreregId equals eval.PreregId into gj
from x in gj.DefaultIfEmpty()
select new Reportes
{
PreregApellidos = pre.PreregApellidos,
PreregAreaProfesional = pre.PreregAreaProfesional,
preregEditCount = pre.preregEditCount,
PreregEmail = pre.PreregEmail,
PreregFechaCreacion = pre.PreregFechaCreacion,
PreregFechaModificacion = pre.PreregFechaModificacion,
PreregIdentificacion = pre.PreregIdentificacion,
PreregNombres = pre.PreregNombres,
PreregTematica = pre.PreregTematica,
TipoprNombre = tip.TipoprNombre,
EstprNombre = est.EstprNombre,
EvalObservacion = gj.FirstOrDefault().EvalObservacion
}).ToList();
return(qResult);
}
public static async Task <Preregistros> ObtenerPreregistroXId(UDPUBLISHContext _context, int id)
{
return(await _context.Preregistros
.Include(p => p.Estpr)
.Include(p => p.Tipopr)
.Include(p => p.Evaluacion)
.ThenInclude(eval => eval.Usr)
.SingleOrDefaultAsync(m => m.PreregId == id));
}
public UsuariosController(UDPUBLISHContext context)
{
_context = context;
}
public ReportesController(UDPUBLISHContext context, IHostingEnvironment hostingEnvironment)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
}
public static async Task <List <Usuario> > ObtenerListaUsuario(UDPUBLISHContext _context)
{
return(await _context.Usuario.Include(u => u.Rol).ToListAsync());
}
public PreregistrosController(UDPUBLISHContext context)
{
_context = context;
}
public static async Task <List <Preregistros> > ObtenerListadoPreregistros(UDPUBLISHContext _context)
{
return(await _context.Preregistros.Include(p => p.Estpr).Include(p => p.Tipopr).ToListAsync());
}
public LoginController(UDPUBLISHContext context)
{
_context = context;
}
public HomeController(UDPUBLISHContext context)
{
_context = context;
}
