public async Task <PagedQueryResult <ImageAssetSummary> > ExecuteAsync(SearchImageAssetSummariesQuery query, IExecutionContext executionContext)
{
IQueryable <ImageAsset> dbQuery = _dbContext
.ImageAssets
.AsNoTracking()
.Include(i => i.Creator)
.Include(i => i.Updater)
.Include(i => i.ImageAssetTags)
.ThenInclude(i => i.Tag);
// Filter by tags
if (!string.IsNullOrEmpty(query.Tags))
{
var tags = TagParser.Split(query.Tags).ToList();
foreach (string tag in tags)
{
// See http://stackoverflow.com/a/7288269/486434 for why this is copied into a new variable
string localTag = tag;
dbQuery = dbQuery.Where(p => p.ImageAssetTags
.Select(t => t.Tag.TagText)
.Contains(localTag)
);
}
}
// Filter Dimensions
if (query.Height > 0)
{
dbQuery = dbQuery.Where(p => p.HeightInPixels == query.Height);
}
else if (query.MinHeight > 0)
{
dbQuery = dbQuery.Where(p => p.HeightInPixels >= query.MinHeight);
}
if (query.Width > 0)
{
dbQuery = dbQuery.Where(p => p.WidthInPixels == query.Width);
}
else if (query.MinWidth > 0)
{
dbQuery = dbQuery.Where(p => p.WidthInPixels >= query.MinWidth);
}
var dbPagedResults = await dbQuery
.OrderByDescending(p => p.CreateDate)
.ToPagedResultAsync(query);
var mappedResults = dbPagedResults
.Items
.Select(_imageAssetSummaryMapper.Map)
.ToList();
return(dbPagedResults.ChangeType(mappedResults));
}
public async Task <IHttpActionResult> Get([FromUri] SearchImageAssetSummariesQuery query, [FromUri] GetByIdRangeQuery <ImageAssetRenderDetails> rangeQuery)
{
if (rangeQuery != null && rangeQuery.Ids != null)
{
var rangeResults = await _queryExecutor.ExecuteAsync(rangeQuery);
return(_apiResponseHelper.SimpleQueryResponse(this, rangeResults.ToFilteredAndOrderedCollection(rangeQuery.Ids)));
}
if (query == null)
{
query = new SearchImageAssetSummariesQuery();
}
var results = await _queryExecutor.ExecuteAsync(query);
return(_apiResponseHelper.SimpleQueryResponse(this, results));
}
public async Task <IActionResult> Get([FromQuery] SearchImageAssetSummariesQuery query, [FromQuery] GetImageAssetRenderDetailsByIdRangeQuery rangeQuery)
{
if (rangeQuery != null && rangeQuery.ImageAssetIds != null)
{
var rangeResults = await _queryExecutor.ExecuteAsync(rangeQuery);
return(_apiResponseHelper.SimpleQueryResponse(this, rangeResults.FilterAndOrderByKeys(rangeQuery.ImageAssetIds)));
}
if (query == null)
{
query = new SearchImageAssetSummariesQuery();
}
var results = await _queryExecutor.ExecuteAsync(query);
return(_apiResponseHelper.SimpleQueryResponse(this, results));
}
public async Task <JsonResult> Get(
[FromQuery] SearchImageAssetSummariesQuery query,
[FromQuery] GetImageAssetRenderDetailsByIdRangeQuery rangeQuery
)
{
if (rangeQuery != null && rangeQuery.ImageAssetIds != null)
{
return(await _apiResponseHelper.RunWithResultAsync(async() =>
{
return await _domainRepository
.WithQuery(rangeQuery)
.FilterAndOrderByKeys(rangeQuery.ImageAssetIds)
.ExecuteAsync();
}));
}
if (query == null)
{
query = new SearchImageAssetSummariesQuery();
}
ApiPagingHelper.SetDefaultBounds(query);
return(await _apiResponseHelper.RunQueryAsync(query));
}
public IEnumerable <IPermissionApplication> GetPermissions(SearchImageAssetSummariesQuery query)
{
yield return(new ImageAssetReadPermission());
}
public IDomainRepositoryQueryContext <PagedQueryResult <ImageAssetSummary> > AsSummaries(SearchImageAssetSummariesQuery query)
{
return(DomainRepositoryQueryContextFactory.Create(query, ExtendableContentRepository));
}
