//When a new passenger flight is created, adds the associated seats to the database.
public int CreateSeats(NewFlightSeat newFlight)
{
using (var connection = new SqlConnection(ConnectionString))
{
var queryString = @"Insert into Seat(productId, isPurchased, [type], premium, seatNumber, rowLength)
Select
@productId,
0,
Case
When n.Number <= @NumPremium Then 'First Class'
Else 'Coach'
End,
Case
When n.Number <= @NumPremium Then @Premium
Else 1
End,
Convert(nvarchar(10), (Floor(n.Number / @rowSeats) + 1)) + '-' + Convert(nvarchar(10), (n.Number % @rowSeats) + 1),
@rowSeats
From SeatNumber as n
Where n.Number <= @NumSeats" ;
var Seats = connection.QueryFirstOrDefault <int>(queryString, newFlight);
return(Seats);
}
throw new Exception("Could not create seats");
}
public ActionResult CreateSeats(NewFlightSeat newFlight)
{
var numSeats = _connections.CreateSeats(newFlight);
return(Accepted(numSeats));
}
