public static Task <ClassifiedAdDetails> Query(
this IAsyncDocumentSession session,
GetPublicClassifiedAd query
) =>
session.LoadAsync <ClassifiedAdDetails>(
query.ClassifiedAdId.ToString()
);
public static Task <ReadModels.PublicClassifiedAdDetails> Query(this IAsyncDocumentSession session,
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.PublicClassifiedAdDetails
{
Price = ad.Price.Amount,
Title = ad.Title.Value,
Description = ad.Text.Value,
CurrencyCode = ad.Price.Currency.CurrencyCode,
Id = ad.Id.Value.ToString(),
SellersDisplayName = user.DisplayName.Value
}).SingleAsync();
public async Task <ClassifiedAdDetailsViewModel> Query(GetPublicClassifiedAd query)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var result = await connection.QueryFirstOrDefaultAsync <ClassifiedAdDetailsViewModel>(
@"select c.ClassifiedAdId as id,
c.Title as title,
c.Text as description,
c.Amount as price,
c.CurrencyCode,
u.DisplayName as sellersdisplayname
from ClassifiedAds c
left join UserProfiles u on c.OwnerId=u.UserProfileId
where c.ClassifiedAdId=@id"
, new { id = query.ClassifiedAdId }
);
return(result);
}
}
public static ClassifiedAdDetailsViewModel Query(this IEnumerable <ClassifiedAdDetailsViewModel> items, GetPublicClassifiedAd query) => items.FirstOrDefault(x => x.ClassifiedAdId == query.ClassifiedAdId);
public IActionResult Get([FromQuery] GetPublicClassifiedAd request) => RequestHandler.HandleQuery(() => _items.Query(request), Log);
public async Task <ClassifiedAdDetailsViewModel> GetAsync([FromRoute] GetPublicClassifiedAd request) => await _queries.Query(request);
public static Task <ClassifiedAdDetails> Query(this IEnumerable <ClassifiedAdDetails> items,
GetPublicClassifiedAd query) => Task.FromResult(
items.FirstOrDefault(item => item.ClassifiedAdId == query.classifiedAdId));
