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