public RegionCollectionResponse Fetch(RegionQueryCollectionRequest request)
{
base.FixupLimitAndPagingOnRequest(request);
var totalItemCount = 0;
var sortExpression = RepositoryHelper.ConvertStringToSortExpression(EntityType, request.Sort);
var includeFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
var predicateBucket = RepositoryHelper.ConvertStringToRelationPredicateBucket(EntityType, request.Filter, request.Relations);
EntityCollection <RegionEntity> entities;
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeFetchRegionQueryCollectionRequest(adapter, request, sortExpression, includeFields, prefetchPath, predicateBucket,
request.PageNumber, request.PageSize, request.Limit);
entities = base.Fetch(adapter, sortExpression, includeFields, prefetchPath, predicateBucket,
request.PageNumber, request.PageSize, request.Limit, request.RCache, out totalItemCount);
OnAfterFetchRegionQueryCollectionRequest(adapter, request, entities, sortExpression, includeFields, prefetchPath, predicateBucket,
request.PageNumber, request.PageSize, request.Limit, totalItemCount);
}
var response = new RegionCollectionResponse(entities.ToDtoCollection(), request.PageNumber,
request.PageSize, totalItemCount);
return(response);
}
public EmployeesByRegionAndTerritoryCollectionResponse Fetch(EmployeesByRegionAndTerritoryQueryCollectionRequest request)
{
base.FixupLimitAndPagingOnRequest(request);
var typedList = new EmployeesByRegionAndTerritoryTypedList();
var totalItemCount = 0;
var sortExpression = RepositoryHelper.ConvertStringToSortExpression(TypedListType, request.Sort);
var includedFieldNames = RepositoryHelper.ConvertStringToExcludedIncludedFields(request.Select);
var predicateBucket = RepositoryHelper.ConvertStringToRelationPredicateBucket(TypedListType, typedList.GetRelationInfo(), request.Filter);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeFetchEmployeesByRegionAndTerritoryQueryCollectionRequest(adapter, request, sortExpression, includedFieldNames, predicateBucket,
request.PageNumber, request.PageSize, request.Limit);
totalItemCount = (int)adapter.GetDbCount(typedList.GetFieldsInfo(), predicateBucket, null, false);
adapter.FetchTypedList(typedList.GetFieldsInfo(), typedList, predicateBucket, request.Limit, sortExpression, true, null, request.PageNumber, request.PageSize);
OnAfterFetchEmployeesByRegionAndTerritoryQueryCollectionRequest(adapter, request, typedList, sortExpression, includedFieldNames, predicateBucket,
request.PageNumber, request.PageSize, request.Limit, totalItemCount);
}
var dtos = new EmployeesByRegionAndTerritoryCollection();
var enumerator = typedList.GetEnumerator();
while (enumerator.MoveNext())
{
dtos.Add(Map(enumerator.Current, includedFieldNames));
}
var response = new EmployeesByRegionAndTerritoryCollectionResponse(dtos, request.PageNumber,
request.PageSize, totalItemCount);
return(response);
}
public CustomerDemographicResponse Fetch(CustomerDemographicPkRequest request)
{
var entity = new CustomerDemographicEntity();
entity.CustomerTypeId = request.CustomerTypeId;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeFetchCustomerDemographicPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
if (adapter.FetchEntity(entity, prefetchPath, null, excludedIncludedFields))
{
OnAfterFetchCustomerDemographicPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
return(new CustomerDemographicResponse(entity.ToDto()));
}
}
return(new CustomerDemographicResponse(null));
}
public SupplierResponse Fetch(SupplierUcSupplierNameRequest request)
{
var entity = new SupplierEntity();
entity.CompanyName = request.CompanyName;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
var predicate = entity.ConstructFilterForUCCompanyName();
OnBeforeFetchSupplierUcSupplierNameRequest(adapter, request, entity, predicate, prefetchPath, excludedIncludedFields);
if (adapter.FetchEntityUsingUniqueConstraint(entity, predicate, prefetchPath, null, excludedIncludedFields))
{
OnAfterFetchSupplierUcSupplierNameRequest(adapter, request, entity, predicate, prefetchPath, excludedIncludedFields);
return(new SupplierResponse(entity.ToDto()));
}
}
return(new SupplierResponse(null));
}
public RegionResponse Fetch(RegionUcRegionDescriptionRequest request)
{
var entity = new RegionEntity();
entity.RegionDescription = request.RegionDescription;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
var predicate = entity.ConstructFilterForUCRegionDescription();
OnBeforeFetchRegionUcRegionDescriptionRequest(adapter, request, entity, predicate, prefetchPath, excludedIncludedFields);
if (adapter.FetchEntityUsingUniqueConstraint(entity, predicate, prefetchPath, null, excludedIncludedFields))
{
OnAfterFetchRegionUcRegionDescriptionRequest(adapter, request, entity, predicate, prefetchPath, excludedIncludedFields);
return(new RegionResponse(entity.ToDto()));
}
}
return(new RegionResponse(null));
}
public OrderDetailResponse Fetch(OrderDetailPkRequest request)
{
var entity = new OrderDetailEntity();
entity.OrderId = request.OrderId;
entity.ProductId = request.ProductId;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeFetchOrderDetailPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
if (adapter.FetchEntity(entity, prefetchPath, null, excludedIncludedFields))
{
OnAfterFetchOrderDetailPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
return(new OrderDetailResponse(entity.ToDto()));
}
}
return(new OrderDetailResponse(null));
}
public EmployeeTerritoryResponse Fetch(EmployeeTerritoryPkRequest request)
{
var entity = new EmployeeTerritoryEntity();
entity.EmployeeId = request.EmployeeId;
entity.TerritoryId = request.TerritoryId;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeFetchEmployeeTerritoryPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
if (adapter.FetchEntity(entity, prefetchPath, null, excludedIncludedFields))
{
OnAfterFetchEmployeeTerritoryPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
return(new EmployeeTerritoryResponse(entity.ToDto()));
}
}
return(new EmployeeTerritoryResponse(null));
}
public RegionResponse Fetch(RegionPkRequest request)
{
var entity = new RegionEntity();
entity.RegionId = request.RegionId;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
OnBeforeFetchRegionPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
var pkPredicate = adapter.CreatePrimaryKeyFilter(entity.Fields.PrimaryKeyFields);
entity = base.Fetch(adapter, pkPredicate, prefetchPath, excludedIncludedFields, request.RCache);
if (entity != null)
{
OnAfterFetchRegionPkRequest(adapter, request, entity, prefetchPath, excludedIncludedFields);
return(new RegionResponse(entity.ToDto()));
}
}
return(new RegionResponse(null));
}
public ProductResponse Fetch(ProductUcProductNameRequest request)
{
var entity = new ProductEntity();
entity.ProductName = request.ProductName;
var excludedIncludedFields = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
var prefetchPath = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
{
var ucPredicate = entity.ConstructFilterForUCProductName();
OnBeforeFetchProductUcProductNameRequest(adapter, request, entity, ucPredicate, prefetchPath, excludedIncludedFields);
entity = base.Fetch(adapter, ucPredicate, prefetchPath, excludedIncludedFields, request.RCache);
if (entity != null)
{
OnAfterFetchProductUcProductNameRequest(adapter, request, entity, ucPredicate, prefetchPath, excludedIncludedFields);
return(new ProductResponse(entity.ToDto()));
}
}
return(new ProductResponse(null));
}