public async Task <ProjectReadListResponse> GetProjects(ProjectReadListRequest request) { var response = new ProjectReadListResponse(); var currentUser = _cacheManager.GetCachedCurrentUser(request.CurrentUserId); if (request.OrganizationUid != currentUser.OrganizationUid) { response.SetInvalid(); return(response); } Expression <Func <Project, bool> > filter = x => x.OrganizationId == currentUser.OrganizationId; Expression <Func <Project, object> > orderByColumn = x => x.Id; if (request.SearchTerm.IsNotEmpty()) { filter = x => x.Name.Contains(request.SearchTerm) && x.OrganizationId == currentUser.OrganizationId; } List <Project> entities; if (request.PagingInfo.Skip < 1) { entities = await _projectRepository.SelectAfter(filter, request.PagingInfo.LastUid, request.PagingInfo.Take, orderByColumn, request.PagingInfo.IsAscending); } else { entities = await _projectRepository.SelectMany(filter, request.PagingInfo.Skip, request.PagingInfo.Take, orderByColumn, request.PagingInfo.IsAscending); } if (entities != null) { for (var i = 0; i < entities.Count; i++) { var entity = entities[i]; var dto = _projectFactory.CreateDtoFromEntity(entity); response.Items.Add(dto); } } response.PagingInfo.Skip = request.PagingInfo.Skip; response.PagingInfo.Take = request.PagingInfo.Take; response.PagingInfo.LastUid = request.PagingInfo.LastUid; response.PagingInfo.IsAscending = request.PagingInfo.IsAscending; response.PagingInfo.TotalItemCount = await _projectRepository.Count(filter); response.Status = ResponseStatus.Success; return(response); }