public CustomerAndSuppliersByCityCollectionResponse Fetch(CustomerAndSuppliersByCityQueryCollectionRequest request) { base.FixupLimitAndPagingOnRequest(request); var totalItemCount = 0; var sortExpression = RepositoryHelper.ConvertStringToSortExpression(TypedViewType, request.Sort); var includedFieldNames = RepositoryHelper.ConvertStringToExcludedIncludedFields(request.Select); var predicateBucket = RepositoryHelper.ConvertStringToRelationPredicateBucket(TypedViewType, request.Filter); var typedView = new CustomerAndSuppliersByCityTypedView(); using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter()) { OnBeforeFetchCustomerAndSuppliersByCityQueryCollectionRequest(adapter, request, sortExpression, includedFieldNames, predicateBucket, request.PageNumber, request.PageSize, request.Limit); totalItemCount = (int)adapter.GetDbCount(typedView.GetFieldsInfo(), predicateBucket, null, false); adapter.FetchTypedView(typedView.GetFieldsInfo(), typedView, predicateBucket, request.Limit, sortExpression, true, null, request.PageNumber, request.PageSize); OnAfterFetchCustomerAndSuppliersByCityQueryCollectionRequest(adapter, request, typedView, sortExpression, includedFieldNames, predicateBucket, request.PageNumber, request.PageSize, request.Limit, totalItemCount); } var dtos = new CustomerAndSuppliersByCityCollection(); var enumerator = typedView.GetEnumerator(); while (enumerator.MoveNext()) { dtos.Add(Map(enumerator.Current, includedFieldNames)); } var response = new CustomerAndSuppliersByCityCollectionResponse(dtos, request.PageNumber, request.PageSize, totalItemCount); return(response); }
/// <summary>Queries 'CustomerAndSuppliersByCity' typed view records using sorting, filtering, paging and more.</summary> public CustomerAndSuppliersByCityCollectionResponse Get(CustomerAndSuppliersByCityQueryCollectionRequest request) { OnBeforeGetCustomerAndSuppliersByCityQueryCollectionRequest(request); var output = Repository.Fetch(request); OnAfterGetCustomerAndSuppliersByCityQueryCollectionRequest(request, output); return(output); }
partial void OnAfterFetchCustomerAndSuppliersByCityQueryCollectionRequest(IDataAccessAdapter adapter, CustomerAndSuppliersByCityQueryCollectionRequest request, CustomerAndSuppliersByCityTypedView typedView, SortExpression sortExpression, string[] includedFieldNames, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, int totalItemCount);
partial void OnBeforeFetchCustomerAndSuppliersByCityQueryCollectionRequest(IDataAccessAdapter adapter, CustomerAndSuppliersByCityQueryCollectionRequest request, SortExpression sortExpression, string[] includedFieldNames, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit);
partial void OnAfterGetCustomerAndSuppliersByCityQueryCollectionRequest(CustomerAndSuppliersByCityQueryCollectionRequest request, CustomerAndSuppliersByCityCollectionResponse response);
partial void OnBeforeGetCustomerAndSuppliersByCityQueryCollectionRequest(CustomerAndSuppliersByCityQueryCollectionRequest request);