Charge A Booking

Function Number: 11

Function Name: Charge A Booking

Function Type: Insert and query

Description: This function accepts the following inputs: Current Time, Billed Item ID, and Booking ID. These parameters are used to insert a new record into the table 'charge' linking a charge to a booking ID at a specific date and time.

Primary Users: Resort staff responsible for posting transactions.

Tables Affected: charge

Sample Input: Current Time = 2021-4-9 10:53:25, Billed Item ID = 9, Booking ID = 3

Sample Output: A table displays all charges debited to the Booking ID provided

Notes: This function inserts a new record into the table 'charge' containing provided information. If errors are encountered, they are displayed to the user. After record insertion, a query is performed on the table 'charge' to retrieve all records for the Booking ID provided.