Hotel Reservation

Design a “Hotel Booking” Visual C# application, which allows the user to search for
and book hotel rooms. It is required to create a database file that contains at least
three related tables, the first of which contains the hotel’s data with the data fields, such
as:
– hotel ID
– destination country/city
– hotel name
– room number
– check in date
– check out date
– number of rooms available
– price
The second table should contain the customer information, such as:
– customer ID
– first name
– last name
– telephone number
– address
– number of guests
Make up several records in each table and save your database file in the default folder
of your project.
The third table should contain the data of the hotel bookings including the selected
fields from the first two tables. Make up your own table.
Please note that you can create more tables as well as add more data fields, if
necessary.
Your program should contain multiple Windows forms as follows:
– The first form will enable the user to search for a hotel. If a hotel selection has
been made, the second form may provide more info about the hotel that has
been selected, including the hotel description and pictures, and/or videos. Please
note that the Windows Media Player control can be added to the toolbox and
used to play videos. This form will enable the user to book a room in this hotel or
return to the previous form and search for another hotel. If the user decides to
book the selected hotel’s room, the third form will be shown to get the customer
data and process the customer’s booking. This form will also display a receipt,
which contains the customer and the booked hotel room info, as well as the total
Prepared by: Goran Svenk
cost including all taxes. Please note that when a customer’s booking is
processed the database file has to be updated, i.e. new records added into the
third table, as well as the number of rooms available in the first table updated.
It is required to use exception handling to prevent a variety of possible run-time errors.
It is also required to create the project documentation that includes:
1. User manual, i.e. info how to use your application
2. Screen captures of all forms with sample I/O and the source code of each form’s
class
3. Samples of your database tables, including sample data