public async Task <IResultModel> PageAsync(RoleListInput input)
{
StringBuilder sb = new StringBuilder();
sb.Append("where IsDeleted=0 ");
if (input.Name.NotNull())
{
sb.Append(" and Name=@Name ");
}
if (input.Enabled != null)
{
sb.Append(" and Enabled=@Enabled ");
}
var list = await _roleRepository.GetListPagedAsync(input.Page, input.Limit, sb.ToString(), $"{input.Field} {input.Order}", new { input.Enabled, input.Name });
var total = await _roleRepository.RecordCountAsync(sb.ToString(), new { input.Enabled, input.Name });
var data = new PageOutput <RoleListOutput>()
{
Data = _mapper.Map <List <RoleListOutput> >(list),
Count = total
};
return(ResultModel.Success(data));
}
public async void Should_Get_Roles()
{
var roleListInput = new RoleListInput();
var roleList = await _roleAppService.GetRolesAsync(roleListInput);
Assert.True(roleList.Items.Count > 0);
roleListInput.Filter = ".!1Aa_";
var rolesListEmpty = await _roleAppService.GetRolesAsync(roleListInput);
Assert.True(rolesListEmpty.Items.Count == 0);
}
public async Task <IPagedList <RoleListOutput> > GetRolesAsync(RoleListInput input)
{
var query = _roleManager.Roles.Where(
!input.Filter.IsNullOrEmpty(),
predicate => predicate.Name.ToLowerInvariant().Contains(input.Filter))
.OrderBy(input.Sorting);
var rolesCount = await query.CountAsync();
var roles = query.PagedBy(input.PageIndex, input.PageSize).ToList();
var roleListDtos = _mapper.Map <List <RoleListOutput> >(roles);
return(roleListDtos.ToPagedList(rolesCount));
}
public async Task <ActionResult <IPagedList <RoleListOutput> > > GetRoles([FromQuery] RoleListInput input)
{
return(Ok(await _roleAppService.GetRolesAsync(input)));
}
public async Task <IResultModel> Page([FromQuery] RoleListInput input)
{
return(await _roleServices.PageAsync(input));
}
public async Task <IActionResult> GetPage(RoleListInput input)
{
var result = await _roleServices.PageAsync(input) as ResultModel <PageOutput <RoleListOutput> >;
return(Json(result.Data));
}
