public async Task <ActionResult <IEnumerable <HotelTag> > > AddHotelTag(
[FromQuery] HotelKey hotelKey,
[FromBody] HotelTag hotelTag)
{
hotelTag.SetHotelKey(hotelKey);
if (await _hotelTagStore.CheckExistanceAsync(hotelTag.GetKey()))
{
return(ValidationProblem(
title: "Resource already exists",
detail: string.Format(
"{0} at {1},{2},{3},{4} already exists",
hotelTag.Tag,
hotelTag.HotelChain,
hotelTag.CountryCode,
hotelTag.Town,
hotelTag.Suburb)
));
}
await _hotelTagStore.CreateAsync(hotelTag);
return(CreatedAtAction(
nameof(GetHotelTagDetails),
hotelTag.GetKey(),
hotelTag));
}
public async Task CreateAsync(HotelTag hotelTag)
{
using SqlConnection connection = new SqlConnection(_connectionString);
await connection.OpenAsync();
await connection.ExecuteAsync(
"HotelTag_Add_tr",
hotelTag,
commandType : CommandType.StoredProcedure);
}
public async Task <ActionResult <HotelTag> > GetHotelTagDetails([FromQuery] HotelTagKey hotelTagKey)
{
HotelTag result = await _hotelTagStore.FindDetailsAsync(hotelTagKey);
if (result != null)
{
return(Ok(result));
}
return(NotFound());
}
