public static Task <ClassifiedAdDetails> Query( this DbConnection connection, QueryModels.GetPublicClassifiedAd query) => connection.QuerySingleOrDefaultAsync <ClassifiedAdDetails>( "SELECT \"ClassifiedAdId\", \"Price_Amount\" price, \"Title_Value\" title, " + "\"Text_Value\" description, \"DisplayName_Value\" sellersdisplayname " + "FROM \"ClassifiedAds\", \"UserProfiles\" " + "WHERE \"ClassifiedAdId\" = @Id AND \"OwnerId_Value\"=\"UserProfileId\"", new { Id = query.ClassifiedAdId });
public static Task <ReadModels.ClassifiedAdDetails> Query( this IAsyncDocumentSession session, QueryModels.GetPublicClassifiedAd query) => (from ad in session.Query <Domain.ClassifiedAd.ClassifiedAd>() where ad.Id.Value == query.ClassifiedAdId let user = RavenQuery .Load <Domain.UserProfile.UserProfile>("UserProfile/" + ad.OwnerId.Value) select new ReadModels.ClassifiedAdDetails { ClassifiedAdId = ad.Id.Value, Title = ad.Title.Value, Description = ad.Text.Value, Price = ad.Price.Amount, CurrencyCode = ad.Price.Currency.CurrencyCode, SellersDisplayName = user.DisplayName.Value }).SingleAsync();
public static ReadModels.ClassifiedAdDetails Query( this IEnumerable <ReadModels.ClassifiedAdDetails> items, QueryModels.GetPublicClassifiedAd query) => items.FirstOrDefault(x => x.ClassifiedAdId == query.ClassifiedAdId);
public Task <IActionResult> Get(QueryModels.GetPublicClassifiedAd request) => RequestHandler.HandleQuery(() => _session.Query(request), _log);
public static Task <ReadModels.ClassifiedAdDetails> Query( this IAsyncDocumentSession session, QueryModels.GetPublicClassifiedAd query) => session.LoadAsync <ReadModels.ClassifiedAdDetails>( query.ClassifiedAdId.ToString());