C# (CSharp) Marketplace.ClassifiedAd QueryModels.GetOwnersClassifiedAd Examples

Example #1

File: Queries.cs Project: wagnerhsu/packt-Hands-On-Domain-Driven-Design-with-.NET-Core

 public static Task <IEnumerable <PublicClassifiedAdListItem> > Query(
     this DbConnection connection,
     QueryModels.GetOwnersClassifiedAd query)
 => connection.QueryAsync <PublicClassifiedAdListItem>(
     "SELECT \"ClassifiedAdId\", \"Price_Amount\" price, \"Title_Value\" title " +
     "FROM \"ClassifiedAds\" WHERE \"OwnerId_Value\"=@OwnerId LIMIT @PageSize OFFSET @Offset",
     new
 {
     OwnerId  = query.OwnerId,
     PageSize = query.PageSize,
     Offset   = Offset(query.Page, query.PageSize)
 });

Example #2

File: Queries.cs Project: itpreneur/Hands-On-Domain-Driven-Design-with-.NET

 public static Task <List <ReadModels.PublicClassifiedAdListItem> > Query(
     this IAsyncDocumentSession session,
     QueryModels.GetOwnersClassifiedAd query)
 =>
 session.Query <Domain.ClassifiedAd.ClassifiedAd>()
 .Where(x => x.OwnerId.Value == query.OwnerId)
 .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);

Example #3

File: ClassifiedAdsQueryApi.cs Project: panospd/marketplace-ddd-example

 public Task <IActionResult> Get(QueryModels.GetOwnersClassifiedAd request) =>
 RequestHandler.HandleQuery(() => _session.Query(request), _log);