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