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