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