public async Task <DynamicContentItemSearchResult> SearchContentItemsAsync(DynamicContentItemSearchCriteria criteria)
{
var cacheKey = CacheKey.With(GetType(), nameof(SearchContentItemsAsync), criteria.GetCacheKey());
return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async (cacheEntry) =>
{
cacheEntry.AddExpirationToken(DynamicContentItemCacheRegion.CreateChangeToken());
var result = AbstractTypeFactory <DynamicContentItemSearchResult> .TryCreateInstance();
using (var repository = _repositoryFactory())
{
var sortInfos = BuildSortExpression(criteria);
var query = BuildQuery(criteria, repository);
result.TotalCount = await query.CountAsync();
if (criteria.Take > 0)
{
var ids = await query.OrderBySortInfos(sortInfos).ThenBy(x => x.Id)
.Select(x => x.Id)
.Skip(criteria.Skip).Take(criteria.Take)
.ToArrayAsync();
result.Results = (await _dynamicContentService.GetContentItemsByIdsAsync(ids))
.OrderBy(x => Array.IndexOf(ids, x.Id)).ToList();
}
}
return result;
}));
}
public async Task <DynamicContentItemSearchResult> SearchContentItemsAsync(DynamicContentItemSearchCriteria criteria)
{
var cacheKey = CacheKey.With(GetType(), "SearchContentItemsAsync", criteria.GetCacheKey());
return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async (cacheEntry) =>
{
cacheEntry.AddExpirationToken(DynamicContentItemCacheRegion.CreateChangeToken());
var retVal = AbstractTypeFactory <DynamicContentItemSearchResult> .TryCreateInstance();
using (var repository = _repositoryFactory())
{
var query = repository.Items;
if (!string.IsNullOrEmpty(criteria.FolderId))
{
query = query.Where(x => x.FolderId == criteria.FolderId);
}
if (!string.IsNullOrEmpty(criteria.Keyword))
{
query = query.Where(q => q.Name.Contains(criteria.Keyword));
}
var sortInfos = criteria.SortInfos;
if (sortInfos.IsNullOrEmpty())
{
sortInfos = new[] { new SortInfo {
SortColumn = ReflectionUtility.GetPropertyName <DynamicContentItem>(x => x.Name), SortDirection = SortDirection.Ascending
} };
}
query = query.OrderBySortInfos(sortInfos);
retVal.TotalCount = await query.CountAsync();
if (criteria.Take > 0)
{
var ids = await query.Select(x => x.Id).Skip(criteria.Skip).Take(criteria.Take).ToArrayAsync();
retVal.Results = await _dynamicContentService.GetContentItemsByIdsAsync(ids);
}
}
return retVal;
}));
}
