public override Task <RoleList> PageSerachRole(SearchRole request, ServerCallContext context)
{
var query = _role.GetAll().AsNoTracking();
if (SearchFilter(request) != null)
{
query = query.Where(SearchFilter(request));
}
query = OrderFilter() != null
? query.OrderByDescending(OrderFilter())
: query.OrderByDescending(item => item.Id);
var total = query.Count();
var result = query.Skip(request.PageMax * (request.PageIndex - 1))
.Take(request.PageMax)
.ToList();
var date = new RoleList {
Total = total
};
ConvertToEntities(result).ForEach(item => { date.Datas.Add(item); });
return(Task.FromResult(date));
}
protected Expression <Func <SysRole, bool> > SearchFilter(SearchRole search)
{
Expression <Func <SysRole, bool> > getFilter = item => true;
if (!string.IsNullOrEmpty(search.RoleName))
{
getFilter = getFilter.And(item => item.Name.Contains(search.RoleName));
}
return(getFilter);
}
public IEnumerable <RoleDto> Execute(SearchRole search)
{
var query = _context.Roles.AsQueryable();
if (!string.IsNullOrEmpty(search.Name) || !string.IsNullOrWhiteSpace(search.Name))
{
query = query.Where(x => x.Name.ToLower().Contains(search.Name.ToLower()));
}
return(_mapper.Map <List <RoleDto> >(query.ToList()));
}
public IActionResult SearchRole(SearchRole searchRole)
{
RoleGrid roleGrid = new RoleGrid();
roleGrid.ID = "1";
roleGrid.Description = "This is testing one";
roleGrid.CreatedBy = "Osama";
roleGrid.RoleName = "Yasir";
roleGrid.Status = "Rejected";
List <RoleGrid> roleGrids = new List <RoleGrid>();
roleGrids.Add(roleGrid);
roleGrid = new RoleGrid();
roleGrid.ID = "2";
roleGrid.Description = "this is two";
roleGrid.CreatedBy = "Nuaman";
roleGrid.RoleName = "Tariq";
roleGrid.Status = "Pending";
roleGrids.Add(roleGrid);
roleGrid = new RoleGrid();
roleGrid.ID = "3";
roleGrid.Description = "this is two";
roleGrid.CreatedBy = "dgn";
roleGrid.RoleName = "dgn";
roleGrid.Status = "Approved";
roleGrids.Add(roleGrid);
if (searchRole.Role.Status.ToLower() == "all")
{
return(Ok(roleGrids));
}
return(Ok(roleGrids.Where(x => x.Status.ToLower() == searchRole.Role.Status.ToLower()).ToList()));
}
public IActionResult Get([FromQuery] SearchRole search, [FromServices] IRolesGet query)
{
return(Ok(executor.ExecuteQuery(query, search)));
}
