public async Task <ActionResult <HotelTag> > GetHotelTagDetails([FromQuery] HotelTagKey hotelTagKey)
{
HotelTag result = await _hotelTagStore.FindDetailsAsync(hotelTagKey);
if (result != null)
{
return(Ok(result));
}
return(NotFound());
}
public async Task <HotelTag> FindDetailsAsync(HotelTagKey hotelTagKey)
{
using SqlConnection connection = new SqlConnection(_connectionString);
await connection.OpenAsync();
var result = await connection.QuerySingleOrDefaultAsync(
@"SELECT * FROM HotelTag WHERE
HotelChain = @HotelChain AND
CountryCode = @CountryCode AND
Town = @Town AND
Suburb = @Suburb AND
Tag = @Tag",
hotelTagKey
);
return(result);
}
public async Task <bool> CheckExistanceAsync(HotelTagKey hotelTagKey)
{
using SqlConnection connection = new SqlConnection(_connectionString);
await connection.OpenAsync();
var result = await connection.ExecuteScalarAsync(
@"SELECT 1 FROM HotelTag WHERE
HotelChain = @HotelChain AND
CountryCode = @CountryCode AND
Town = @Town AND
Suburb = @Suburb AND
Tag = @Tag",
hotelTagKey
);
if (result != null)
{
return(true);
}
return(false);
}
