public async Task <IntegrationReadListResponse> GetIntegrations(IntegrationReadListRequest request) { var response = new IntegrationReadListResponse(); var currentUser = _cacheManager.GetCachedCurrentUser(request.CurrentUserId); Expression <Func <Integration, bool> > filter = x => x.OrganizationId == currentUser.OrganizationId; Expression <Func <Integration, object> > orderByColumn = x => x.Id; if (request.SearchTerm.IsNotEmpty()) { filter = x => x.OrganizationId == currentUser.OrganizationId && x.Name.Contains(request.SearchTerm); } List <Integration> entities; if (request.PagingInfo.Skip < 1) { entities = await _integrationRepository.SelectAfter(filter, request.PagingInfo.LastUid, request.PagingInfo.Take, orderByColumn, request.PagingInfo.IsAscending); } else { entities = await _integrationRepository.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 = _integrationFactory.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 _integrationRepository.Count(filter); response.Status = ResponseStatus.Success; return(response); }
public async Task <IActionResult> IntegrationListData(Guid id, int skip, int take) { var organizationUid = id; if (organizationUid.IsEmptyGuid()) { return(Forbid()); } var request = new IntegrationReadListRequest(CurrentUser.Id, organizationUid); SetPaging(skip, take, request); var response = await _integrationService.GetIntegrations(request); if (response.Status.IsNotSuccess) { return(NotFound()); } var result = new DataResult(); result.AddHeaders("integration_name", "is_active", "created_at"); for (var i = 0; i < response.Items.Count; i++) { var item = response.Items[i]; var stringBuilder = new StringBuilder(); stringBuilder.Append($"{item.Uid}{DataResult.SEPARATOR}"); stringBuilder.Append($"{result.PrepareLink($"/Integration/Detail/{item.Uid}", item.Name, false)}{DataResult.SEPARATOR}"); stringBuilder.Append($"{item.IsActive}{DataResult.SEPARATOR}"); stringBuilder.Append($"{GetDateTimeAsString(item.CreatedAt)}{DataResult.SEPARATOR}"); result.Data.Add(stringBuilder.ToString()); } result.PagingInfo = response.PagingInfo; result.PagingInfo.Type = PagingInfo.PAGE_NUMBERS; return(Json(result)); }
public static IntegrationReadListRequest GetIntegrationReadListRequest() { var request = new IntegrationReadListRequest(CurrentUserId, OrganizationOneUid); return(request); }