public static Task <IEnumerable <PublicClassifiedAdListItem> > Query(
this DbConnection connection,
QueryModels.GetPublishedClassifiedAds query)
=> connection.QueryAsync <PublicClassifiedAdListItem>(
"SELECT \"ClassifiedAdId\", \"Price_Amount\" price, \"Title_Value\" title " +
"FROM \"ClassifiedAds\" WHERE \"State\"=@State LIMIT @PageSize OFFSET @Offset",
new
{
State = (int)ClassifiedAdState.Active,
PageSize = query.PageSize,
Offset = Offset(query.Page, query.PageSize)
});
public static Task <List <ReadModels.PublicClassifiedAdListItem> > Query(
this IAsyncDocumentSession session,
QueryModels.GetPublishedClassifiedAds query)
=>
session.Query <Domain.ClassifiedAd.ClassifiedAd>()
.Where(x => x.State == Domain.ClassifiedAd.ClassifiedAd.ClassifiedAdState.Active)
.Select(x =>
new ReadModels.PublicClassifiedAdListItem
{
ClassifiedAdId = x.Id.Value,
Price = x.Price.Amount,
Title = x.Title.Value,
CurrencyCode = x.Price.Currency.CurrencyCode
})
.PagedList(query.Page, query.PageSize);
public Task <IActionResult> Get(QueryModels.GetPublishedClassifiedAds request) => RequestHandler.HandleQuery(() => _session.Query(request), _log);