public async Task BookSeatAsync(SeatBookEntity bookInfo)
{
using SqlConnection db = new SqlConnection(_dalSettings.ConnectionString);
await db.ExecuteAsync(
"BookSeat",
new
{
SeatId = bookInfo.SeatId,
Cost = bookInfo.Cost,
FlightBookInfoId = bookInfo.FlightBookInfoId
},
commandType : CommandType.StoredProcedure);
}
public async Task <AddResult> BookForTimeAsync(FlightBookInfo bookInfo)
{
FlightEntity flight = await _flightRepository.GetByIdAsync(bookInfo.FlightId);
if (flight == null)
{
return(new AddResult(ResultTypes.NotFound, null));
}
for (int seatBookIndex = 0; seatBookIndex < bookInfo.SeatBooks.Length; seatBookIndex++)
{
SeatBook seatBook = bookInfo.SeatBooks[seatBookIndex];
AirplaneSeatEntity seat = await _airplaneRepository.GetSeatById(seatBook.SeatId);
if (seat == null)
{
return(new AddResult(ResultTypes.NotFound, null));
}
bool canBook = await _flightRepository.CheckSeatBookAvailabilityAsync(
bookInfo.FlightId,
seatBook.SeatId
);
if (!canBook)
{
return(new AddResult(ResultTypes.Duplicate, null));
}
}
bookInfo.BookType = BookType.AwaitingPayment;
bookInfo.BookTime = DateTimeOffset.Now;
bookInfo.AccountId = _accountId;
FlightBookInfoEntity bookInfoDal = _mapper.Map <FlightBookInfoEntity>(bookInfo);
int accountFlightInfoId = await _flightRepository.AddAccountFlightInfoAsync(bookInfoDal);
foreach (SeatBook seatBook in bookInfo.SeatBooks)
{
seatBook.FlightBookInfoId = accountFlightInfoId;
SeatBookEntity seatBookDal = _mapper.Map <SeatBookEntity>(seatBook);
await _flightRepository.BookSeatAsync(seatBookDal);
}
return(new AddResult(ResultTypes.Ok, accountFlightInfoId));;
}
public async Task <bool> CheckSeatBookAvailabilityAsync(int flightId, int seatId)
{
SeatBookEntity seat = _flightSeatsInfo.FirstOrDefault(x => x.SeatId == seatId);
if (seat == null)
{
return(true);
}
FlightBookInfoEntity bookInfo = _flightBooksInfo.FirstOrDefault(
x => x.FlightId == flightId &&
DateTimeOffset.Now - x.BookTime <= _bookingSettings.ExpirationTime &&
x.Id == seat.FlightBookInfoId
);
return(bookInfo == null);
}
public async Task BookSeatAsync(SeatBookEntity seatBook)
{
// implementation
}
