public IQueryable <AppUser> FilterAppUsers(IQueryable <AppUser> query, AdminTableFilterRequest adminTableFilterRequest)
{
if (!string.IsNullOrWhiteSpace(adminTableFilterRequest.Search))
{
query = query.Where(x => x.Username.ToLower().Contains(adminTableFilterRequest.Search.ToLower()));
}
return(query);
}
private IQueryable <Tag> FilterAdminTags(IQueryable <Tag> query, AdminTableFilterRequest adminTableFilterRequest)
{
if (!string.IsNullOrWhiteSpace(adminTableFilterRequest.Search))
{
query = query.Where(x => x.Name.ToLower().Contains(adminTableFilterRequest.Search.ToLower()));
}
return(query);
}
public async Task <ServerResponse <PageResult <TagAdminResponse> > > GetAdminTagsByPageAsync(AdminTableFilterRequest adminTableFilterRequest)
{
return(await _tagService.GetAdminTagsByPageAsync(adminTableFilterRequest));
}
public async Task <ServerResponse <PageResult <AppUserViewModel> > > GetAdminTagsByPageAsync(AdminTableFilterRequest adminTableFilterRequest)
{
return(await _appUserService.GetAdminUsersByPageAsync(adminTableFilterRequest));
}
public async Task <ServerResponse <PageResult <TagAdminResponse> > > GetAdminTagsByPageAsync(AdminTableFilterRequest adminTableFilterRequest)
{
return(await BaseInvokeAsync(async() =>
{
var query = DbContext.Tags.AsQueryable();
query = FilterAdminTags(query, adminTableFilterRequest);
var tagsCount = query.Count();
query = SortItems(query, adminTableFilterRequest);
query = FetchItems(query, adminTableFilterRequest);
var pageResult = new PageResult <TagAdminResponse>
{
Items = query.Select(x => new TagAdminResponse()
{
Id = x.Id,
Name = x.Name,
Notes = x.NoteTags.Select(y => y.Note.Name).ToArray(),
Tasks = x.MhTaskTags.Select(z => z.MhTask.Name).ToArray()
}).ToList(),
TotalCount = tagsCount
};
return ServerResponseBuilder.Build(await Task.FromResult(pageResult));
}));
}
public async Task <ServerResponse <PageResult <AppUserViewModel> > > GetAdminUsersByPageAsync(AdminTableFilterRequest adminTableFilterRequest)
{
return(await BaseInvokeAsync(async() =>
{
var query = DbContext.AppUsers.AsQueryable();
query = FilterAppUsers(query, adminTableFilterRequest);
var usersCount = query.Count();
query = SortItems(query, adminTableFilterRequest);
query = FetchItems(query, adminTableFilterRequest);
var pageResult = new PageResult <AppUserViewModel>
{
Items = query.Select(x => new AppUserViewModel
{
Id = x.Id,
UserName = x.Username,
UserRole = x.UserRole,
CreatedDate = x.CreatedDate,
Email = x.Email
}).ToList(),
TotalCount = usersCount
};
return ServerResponseBuilder.Build(await Task.FromResult(pageResult));
}));
}
