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)); }