A CLR Project with .NET Framework in C++ with SQL Server Database connected. Receptionists, streamline check-ins, customer data, reservations, and billing effortlessly through the application. Admins take control with intuitive room management, analytics on bookings, sales data and occupancy, and employee management.
This project was made for our Database Systems course where we explored SQL queries, stored procedures, triggers, transactions as well as Database creation, normalization and more.
- Log-in: Access system securely with personal credentials.
- Sign-up: Access system by creating a new account via admin approval.
- Guest management: Maintain records of guest information and stay history.
- Reserve/Book room(s): Secure rooms for guests, managing availability and preferences.
- Edit booking: Allow modification to reservation details based on guest needs.
- Cancel booking: Allow cancellation of reservations.
- Check-in/Check-out: Facilitate transitions for guests arriving and departing.
- Generate bills/late fees: Generate an invoice or receipt for guests.
- View payments: Display and maintain records of payments made for room accommodations.
- View booking: Display information on current and upcoming reservations.
- View Schedule: Display room occupancy, allocations, and availability status.
- Log-in: Access with authorized credentials.
- Room management: Administer room inventory, including addition, deletion, and updation of rooms and room types.
- Analytics Sales: Analyze payment data to track revenue and performance trends. Price over a time period (e.g 1 week). We get this from the Payments table.
- Analytics Booking: Analyze booking data and patterns to optimize room allocation. Which rooms have been booked how many times (freq) over the last month/year etc.
- Reports on Occupancy duration: Generate insights into customer occupancy durations over specified periods.
- Employee Management: Decide who can access the system and approve employees sign-up requests.