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