예제 #1
0
        public async Task <List <SecRoles> > GetRoles(vmRoles criteria)
        {
            if (db != null)
            {
                try
                {
                    Expression <Func <SecRoles, bool> > roleName  = res => res.RoleName == criteria.RoleName;
                    Expression <Func <SecRoles, bool> > isActive  = res => res.IsActive == criteria.IsActive;
                    Expression <Func <SecRoles, bool> > createdBy = res => res.CreatedBy == criteria.CreatedBy;
                    IQueryable <SecRoles> filter = db.SecRoles;


                    if (!String.IsNullOrEmpty(criteria.RoleName) && criteria.RoleName != null)
                    {
                        filter = filter.Where(roleName);
                    }
                    if (criteria.IsActive != null)
                    {
                        filter = filter.Where(isActive);
                    }
                    if (criteria.CreatedBy != null && criteria.CreatedBy != -1)
                    {
                        filter = filter.Where(createdBy);
                    }

                    return(await filter.ToListAsync());
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Some Error Acquired" + ex.StackTrace);
                }
            }

            return(null);
        }
예제 #2
0
        public async Task <IActionResult> GetRoles([FromBody] vmRoles roleParam)
        {
            List <SecRoles> roles = new List <SecRoles>();

            try
            {
                roles = await _roleService.GetRoles(roleParam);

                if (roles == null)
                {
                    return(NotFound());
                }
                return(Ok(roles));
            }
            catch (Exception ex)
            {
                Console.WriteLine("Some Error Acquired: ", ex.StackTrace);
            }

            return(BadRequest());
        }