public async Task <ActionResult> DeleteFilteredAssignments([FromQuery] PricelistAssignmentsSearchCriteria criteria)
{
if (criteria == null)
{
criteria = new PricelistAssignmentsSearchCriteria();
}
var result = await _pricingSearchService.SearchPricelistAssignmentsAsync(criteria);
var pricelistAssignmentsIds = result.Results.Select(x => x.Id);
const int BATCH_SIZE = 20;
var skip = 0;
IEnumerable <string> batch;
do
{
batch = pricelistAssignmentsIds.Skip(skip).Take(BATCH_SIZE);
await _pricingService.DeletePricelistsAssignmentsAsync(batch.ToArray());
skip += BATCH_SIZE;
}while (batch.Any());
return(NoContent());
}
public IHttpActionResult SearchPricelistAssignments([FromUri] PricelistAssignmentsSearchCriteria criteria)
{
if (criteria == null)
{
criteria = new PricelistAssignmentsSearchCriteria();
}
var result = _pricingSearchService.SearchPricelistAssignments(criteria);
return(Ok(result));
}
public async Task <IActionResult> SearchPricelistAssignments(PricelistAssignmentsSearchCriteria criteria)
{
if (criteria == null)
{
criteria = new PricelistAssignmentsSearchCriteria();
}
var result = await _pricingSearchService.SearchPricelistAssignmentsAsync(criteria);
return(Ok(result));
}
protected virtual IList <SortInfo> BuildSortExpression(PricelistAssignmentsSearchCriteria criteria)
{
var sortInfos = criteria.SortInfos;
if (sortInfos.IsNullOrEmpty())
{
sortInfos = new[]
{
new SortInfo
{
SortColumn = nameof(PricelistAssignment.Priority)
}
};
}
return(sortInfos);
}
public IHttpActionResult DeleteFilteredAssignments([FromUri] PricelistAssignmentsSearchCriteria criteria)
{
if (criteria == null)
{
criteria = new PricelistAssignmentsSearchCriteria();
}
var result = _pricingSearchService.SearchPricelistAssignments(criteria);
var pricelistAssignmentsIds = result.Results.Select(x => x.Id);
const int BATCH_SIZE = 20;
var skip = 0;
IEnumerable <string> batch;
while ((batch = pricelistAssignmentsIds.Skip(skip).Take(BATCH_SIZE)).Count() > 0)
{
_pricingService.DeletePricelistsAssignments(batch.ToArray());
skip += BATCH_SIZE;
}
return(StatusCode(HttpStatusCode.NoContent));
}
public virtual PricingSearchResult <coreModel.PricelistAssignment> SearchPricelistAssignments(PricelistAssignmentsSearchCriteria criteria)
{
var retVal = new PricingSearchResult <coreModel.PricelistAssignment>();
using (var repository = _repositoryFactory())
{
var query = repository.PricelistAssignments;
if (!criteria.PriceListIds.IsNullOrEmpty())
{
query = query.Where(x => criteria.PriceListIds.Contains(x.PricelistId));
}
if (!string.IsNullOrEmpty(criteria.Keyword))
{
query.Where(x => x.Name.Contains(criteria.Keyword) || x.Description.Contains(criteria.Keyword));
}
var sortInfos = criteria.SortInfos;
if (sortInfos.IsNullOrEmpty())
{
sortInfos = new[] { new SortInfo {
SortColumn = ReflectionUtility.GetPropertyName <coreModel.PricelistAssignment>(x => x.Priority)
} };
}
query = query.OrderBySortInfos(sortInfos);
retVal.TotalCount = query.Count();
query = query.Skip(criteria.Skip).Take(criteria.Take);
var pricelistAssignmentsIds = query.Select(x => x.Id).ToList();
retVal.Results = _pricingService.GetPricelistAssignmentsById(pricelistAssignmentsIds.ToArray())
.OrderBy(x => pricelistAssignmentsIds.IndexOf(x.Id))
.ToList();
}
return(retVal);
}
public virtual async Task <PricelistAssignmentSearchResult> SearchPricelistAssignmentsAsync(PricelistAssignmentsSearchCriteria criteria)
{
var cacheKey = CacheKey.With(GetType(), nameof(SearchPricelistAssignmentsAsync), criteria.GetCacheKey());
return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async cacheEntry =>
{
cacheEntry.AddExpirationToken(PricingSearchCacheRegion.CreateChangeToken());
cacheEntry.AddExpirationToken(PricingCacheRegion.CreateChangeToken());
var retVal = AbstractTypeFactory <PricelistAssignmentSearchResult> .TryCreateInstance();
using (var repository = _repositoryFactory())
{
var query = repository.PricelistAssignments;
if (!criteria.PriceListIds.IsNullOrEmpty())
{
query = query.Where(x => criteria.PriceListIds.Contains(x.PricelistId));
}
if (!string.IsNullOrEmpty(criteria.Keyword))
{
query.Where(x => x.Name.Contains(criteria.Keyword) || x.Description.Contains(criteria.Keyword));
}
var sortInfos = criteria.SortInfos;
if (sortInfos.IsNullOrEmpty())
{
sortInfos = new[] { new SortInfo {
SortColumn = ReflectionUtility.GetPropertyName <PricelistAssignment>(x => x.Priority)
} };
}
query = query.OrderBySortInfos(sortInfos);
retVal.TotalCount = await query.CountAsync();
if (criteria.Take > 0)
{
query = query.Skip(criteria.Skip).Take(criteria.Take);
var pricelistAssignmentsIds = await query.Select(x => x.Id).ToListAsync();
retVal.Results =
(await _pricingService.GetPricelistAssignmentsByIdAsync(pricelistAssignmentsIds.ToArray()))
.OrderBy(x => pricelistAssignmentsIds.IndexOf(x.Id))
.ToList();
}
}
return retVal;
}));
}
protected virtual IQueryable <PricelistAssignmentEntity> BuildQuery(IPricingRepository repository, PricelistAssignmentsSearchCriteria criteria)
{
var query = repository.PricelistAssignments;
if (!criteria.PriceListIds.IsNullOrEmpty())
{
query = query.Where(x => criteria.PriceListIds.Contains(x.PricelistId));
}
if (!string.IsNullOrEmpty(criteria.Keyword))
{
query = query.Where(x => x.Name.Contains(criteria.Keyword) || x.Description.Contains(criteria.Keyword));
}
if (!criteria.CatalogIds.IsNullOrEmpty())
{
query = query.Where(x => criteria.CatalogIds.Contains(x.CatalogId));
}
return(query);
}
public virtual async Task <PricelistAssignmentSearchResult> SearchPricelistAssignmentsAsync(PricelistAssignmentsSearchCriteria criteria)
{
var cacheKey = CacheKey.With(GetType(), nameof(SearchPricelistAssignmentsAsync), criteria.GetCacheKey());
return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async cacheEntry =>
{
cacheEntry.AddExpirationToken(PricingSearchCacheRegion.CreateChangeToken());
cacheEntry.AddExpirationToken(PricingCacheRegion.CreateChangeToken());
var result = AbstractTypeFactory <PricelistAssignmentSearchResult> .TryCreateInstance();
using (var repository = _repositoryFactory())
{
var query = BuildQuery(repository, criteria);
var sortInfos = BuildSortExpression(criteria);
result.TotalCount = await query.CountAsync();
if (criteria.Take > 0)
{
var pricelistAssignmentsIds = await query.OrderBySortInfos(sortInfos).ThenBy(x => x.Id)
.Select(x => x.Id)
.Skip(criteria.Skip).Take(criteria.Take)
.AsNoTracking()
.ToArrayAsync();
var unorderedResults = await _pricingService.GetPricelistAssignmentsByIdAsync(pricelistAssignmentsIds);
result.Results = unorderedResults.OrderBy(x => Array.IndexOf(pricelistAssignmentsIds, x.Id)).ToList();
}
}
return result;
}));
}
public virtual PricingSearchResult <coreModel.PricelistAssignment> SearchPricelistAssignments(PricelistAssignmentsSearchCriteria criteria)
{
var result = new PricingSearchResult <coreModel.PricelistAssignment>();
using (var repository = _repositoryFactory())
{
repository.DisableChangesTracking();
var query = GetPricelistAssignmentsQuery(repository, criteria);
var sortInfos = criteria.SortInfos;
if (sortInfos.IsNullOrEmpty())
{
sortInfos = new[] { new SortInfo {
SortColumn = ReflectionUtility.GetPropertyName <coreModel.PricelistAssignment>(x => x.Priority)
} };
}
query = query.OrderBySortInfos(sortInfos).ThenBy(x => x.Id);
result.TotalCount = query.Count();
query = query.Skip(criteria.Skip).Take(criteria.Take);
var pricelistAssignmentsIds = query.Select(x => x.Id).ToList();
result.Results = _pricingService.GetPricelistAssignmentsById(pricelistAssignmentsIds.ToArray())
.OrderBy(x => pricelistAssignmentsIds.IndexOf(x.Id))
.ToList();
}
return(result);
}
