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