public async Task <IEnumerable <ClassifiedAdListItemViewModel> > Query(GetPendingReviewClassifiedAds query)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var result = await connection.QueryAsync <ClassifiedAdListItemViewModel>(
@"select ClassifiedAdId as id,
Title as title,
Amount as price,
CurrencyCode
from ClassifiedAds c
where c.state=@state"
, new { state = (int)ClassifiedAdState.PendingReview }
);
if (result.AsList().Count == 0)
{
throw new KeyNotFoundException();
}
// return MapClassifiedAdListItem(result);
return(result);
};
}
public async Task <IEnumerable <ClassifiedAdListItemViewModel> > Get(
[FromQuery] GetPendingReviewClassifiedAds request)
=> await _queries.Query(request);
