public async Task <PageResult <AppResponseDTO> > Query([FromBody] AppRequestDTO input)
{
string likevalue = $"%{input.Name}%";
var query = pcontext.App.Where(u => EF.Functions.Like(u.Name, likevalue))
.Select(u => new AppResponseDTO
{
Id = u.Id,
Name = u.Name,
Code = u.Code,
CreateTime = u.CreateTime
});
var count = await query.CountAsync();
var data = await query.OrderBy(o => o.Name).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize)
.ToListAsync();
return(new PageResult <AppResponseDTO>(count, data));
}
public async Task <PageResult <ApiResource> > Query([FromBody] AppRequestDTO input)
{
string likevalue = $"%{input.Name}%";
var query = context.ApiResources.AsNoTracking().Where(u => EF.Functions.Like(u.Name, likevalue) || EF.Functions.Like(u.DisplayName, likevalue));
var count = await query.CountAsync();
var clients = await query
.Include(x => x.Secrets)
.Include(x => x.Scopes)
.ThenInclude(s => s.UserClaims)
.Include(x => x.UserClaims)
.Include(x => x.Properties)
.OrderBy(o => o.Name).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize)
.ToListAsync();
var model = clients.Select(c => c.ToModel()).ToList();
return(new PageResult <ApiResource>(count, model));
}
public async Task <PageResult <Client> > Query([FromBody] AppRequestDTO input)
{
string likevalue = $"%{input.Name}%";
var query = context.Clients.AsNoTracking().Where(u => EF.Functions.Like(u.ClientId, likevalue) || EF.Functions.Like(u.ClientName, likevalue));
var count = await query.CountAsync();
var clients = await query
.Include(x => x.AllowedGrantTypes)
.Include(x => x.RedirectUris)
.Include(x => x.PostLogoutRedirectUris)
.Include(x => x.AllowedScopes)
.Include(x => x.ClientSecrets)
.Include(x => x.Claims)
.Include(x => x.IdentityProviderRestrictions)
.Include(x => x.AllowedCorsOrigins)
.Include(x => x.Properties)
.OrderBy(o => o.ClientId).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize)
.ToListAsync();
var model = clients.Select(c => c.ToModel()).ToList();
return(new PageResult <Client>(count, model));
}
