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