public static Task <List <PublicClassifiedAdListItem> > Query(
this IAsyncDocumentSession session,
GetOwnersClassifiedAd query)
{
return(session.Query <Domain.ClassifiedAd.ClassifiedAd>()
.Where(x => x.OwnerId.Value == query.OwnerId)
.Select(x => new PublicClassifiedAdListItem
{
ClassifiedAdId = x.Id.Value,
Price = x.Price.Amount,
Title = x.Title.Value,
CurrencyCode = x.Price.Currency.CurrencyCode
})
.PagedList(query.Page, query.PageSize));
}
public async Task <IEnumerable <ClassifiedAdListItemViewModel> > Query(GetOwnersClassifiedAd query)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var result = await connection.QueryAsync <ClassifiedAdListItemViewModel>(
@"select c.ClassifiedAdId as id,
c.Title as title,
c.Amount as price,
c.CurrencyCode
from ClassifiedAds c
where c.OwnerId=@id"
, new { id = query.OwnerId }
);
return(result);
}
}
GetAsync(string ownerId, [FromQuery] int page, [FromQuery] int pageSize)
{
var request = new GetOwnersClassifiedAd(ownerId, page, pageSize);
return(await _queries.Query(request));
}
