public IHttpActionResult GetAll()
        {
            int activo = Convert.ToInt16(BusinessEnumerations.Estatus.ACTIVO);
            var mdl    = service.GetAll(c => c.RC_ESTATUS_LOTE == activo).Select(c => new {
                Registro = c.RC_REGISTRO_CONTROL,
                Area     = c.CA_ID_AREA
            });

            if (mdl == null)
            {
                return(NotFound());
            }
            return(Ok(mdl));
        }
        public IHttpActionResult GenerateRegistro()
        {
            var registro = registroService.GetAll();

            reporterService.CreateReport <RegistroControlModel>(new List <string[]>(), registro, $"reportRoles{System.DateTime.Now.ToString(dateFormat)}");

            return(Ok());
        }
Ejemplo n.º 3
0
        public async Task <IHttpActionResult> GetUsuarioCapturadorOD()
        {
            IdentityUser user = await UserManager.FindByIdAsync(User.Identity.GetUserId());

            var userArea = usuarioAreaService.GetAll(d => d.US_ID_USUARIO == user.Id && d.UA_ESTATUS == 1, null, includes: c => c.AspNetUsers).ToList();


            //string vCapturador = "Capturador anulador";
            //string vConciliador = "Conciliador";
            //var rolUsuario = AspNetUserRolesService.Query(x => x.RoleId == "").Select(y => y.UserId);
            //var objUsrRole = AspNetUserRolesService.GetAll(c => c.AspNetRoles.Name.ToLower() == vCapturador.ToLower() || c.AspNetRoles.Name.ToLower() == vConciliador.ToLower(), null, includes: c => c.AspNetUsers);

            var aprobado = Convert.ToInt16(BusinessEnumerations.EstatusCarga.APROBADO);
            var lisUsr   = userService.GetAll(x => x.Estatus == 1, null, includes: a => a.SAX_AREA_OPERATIVA).ToList();
            //var RegistroControl = RegConSrv.GetAll(g=> g.RC_ESTATUS_LOTE == aprobado ).Select(h => h.RC_COD_USUARIO).Distinct().ToList();
            //List<string> LisUserCarga
            List <RegistroControlModel> LisUserCarga = RegConSrv.GetAll(g => g.RC_ESTATUS_LOTE == aprobado, null, includes: b => b.SAX_PARTIDAS).ToList();


            List <string>          categories     = LisUserCarga.Select(m => m.RC_USUARIO_CREACION).Distinct().ToList();
            List <AspNetUserModel> listCapturador = new List <AspNetUserModel>();

            foreach (var reg in categories)
            {
                foreach (AspNetUserModel usr in lisUsr)
                {
                    if (reg.Contains(usr.Id))
                    {
                        listCapturador.Add(usr);
                    }
                }
            }

            List <AspNetUserModel> listCapturadorbyArea = new List <AspNetUserModel>();

            foreach (var f in listCapturador)
            {
                foreach (var g in userArea)
                {
                    var userAreacod = usuarioAreaService.GetAll(d => d.US_ID_USUARIO == f.Id);

                    foreach (var v in userAreacod)
                    {
                        if (v.CA_ID_AREA == g.CA_ID_AREA)
                        {
                            if (listCapturadorbyArea.Count(j => j.Id == f.Id) > 0)
                            {
                            }
                            else
                            {
                                listCapturadorbyArea.Add(f);
                            }
                        }
                    }
                }
            }
            if (listCapturadorbyArea != null)
            {
                return(Ok(listCapturadorbyArea.Select(c => new
                {
                    Id = c.Id,
                    FirstName = c.FirstName,
                    LastName = c.LastName,
                    UserName = c.UserName,
                    Email = c.Email
                })));
            }
            return(BadRequest("No se encontró ningún usuario con el rol de Capturador."));
        }