A prestigious hotel wants to carry out a system for the computerization of the reserves of its different rooms that it has available. Each room has an identification number, the floor where it is located, a name according to its theme, the type (single, double, triple or multiple) and the price per night. In order to make a reservation of a room it is necessary to have the check-in date (entry to the hotel) and Check-Out date. Before confirming a reservation, the system must verify that the requested room is not reserved in the period of time that has been chosen. For example, if the room is reserved from 07/14 to 07/21 and the new reservation is from 12/07 to 15/07 should not allow it to perform the same, since the Check-Out date interferes with dates in which the room is occupied. From the amount of days that the person and the type of room you have chosen, the system must return the total amount of the stay; At the same time, it should be verified that the number of people who will stay does not exceed the amount established by the type of room; These amounts are detailed below:
In addition to verifying the reservation dates, the number of people to be staying, etc., it is necessary to register the data of the host that will take care of the reservation. Among these data it is necessary to request: DNI, name, surname, date of birth, address and profession. Due to the privacy of the hotel, the data of the companions will not be recorded. The system is designed to be used only by hotel employees, so the graphic interface and use must be thought in this way (not as an online reservation system). For employee administration, each of them will have a user and password that will allow you to enter the system; To do this, each of them must be registered in the system with their corresponding personal data (DNI, name, surname, date of birth, address and position). It should be noted that employees receive monetary bonuses for the amount of reservations made per day, so each reservation must have assigned the user who discharged it. On the other hand, the system must be able to visualize the following consultations/reports: a. All reserves made on a certain day. b. All guests recorded in the system. c. List of reservations made by a certain employee. d. Lists of all reserves made by a certain guest in a period from/to.
Here is the database modeling that was then mapped with JPA
UML of the database
Here is the screen that allows the user to admit by default the key is admin
Login screen
Here the initial screen is shown where the reserves are shown, since it is an important operation only allows you to register new reservation also ready all reservations and finally allow the operation to be eliminated
Reserve screen
Here the screen is shown where a new reserve can be registered, once all the fields are filled correctly, if everything is valid, it will allow you
Reservations - Record
Here is the screen where the rooms are shown, allows you to register new room also ready all rooms, you can edit the room and finally allow you to remove the room
Room screen
Here is the screen where guests are shown, allows you to register new guest also ready all the guests, you can edit the guest and finally allow the host to be eliminated
Guest screen
Here is the screen where users are shown, allows you to register new user also ready all users, you can edit the user and finally allow the user
User screen
To finish throughout the execution of the application, the data of the logging user persists and allows to close session at any time.
Made by: Sammy Gigi Cantoral Montejo (SGCM14)