public AdvertisementDetail Query(GetActiveAdvertisement query)
{
string sqlQuery = "Select Top 1 a.Id as 'AdvertisementId'," +
" a.Title,a.Text,p.Location as 'photoUrls' " +
" FROM Advertisments a " +
" Inner Join Picture p on a.Id = p.AdvertismentId " +
//" Inner Join UserProfiles up on a.OwnerId = up.Id" +
" Where State = 2 and " +
" a.Id = @AdvertisementId " +
" Order By p.[Order]";
return(sqlConnection.QuerySingleOrDefault <AdvertisementDetail>(sqlQuery, new { query.AdvertisementId }));
}
public AdvertisementDetail Query(GetActiveAdvertisement query)
{
string sqlQuery = "Select Top 1 a.Id as 'AdvertisementId'," +
" a.Title,a.Description,p.Location as 'photoUrls', up.DisplayName as 'SellersDisplayName' " +
" FROM Advertisements a " +
" Inner Join Picture p on a.Id = p.AdvertisementId " +
" Inner Join UserProfiles up on a.OwnerId = up.Id" +
" Where State = 2 and " +
" a.Id = @AdvertisementId " +
" Order By p.[Order]";
var result = _sqlConnection.QuerySingleOrDefault <AdvertisementDetail>(sqlQuery,
new { query.AdvertisementId });
return(result);
}
public IActionResult Get([FromQuery] GetActiveAdvertisement request)
{
return(new OkObjectResult(_service.Query(request)));
}
