Hotel Booking Management System with Kiosk – VB.NET + SQL Server

Hotel Booking Management System

Fully editable and developer-friendly source code. Suitable for customization.

VistaInn is a complete desktop-based hotel reservation and booking system built using VB.NET (WinForms) and Microsoft SQL Server. It includes an Admin Panel for hotel staff and a Kiosk Interface for walk-in customers. Ideal for small to mid-sized hotels, inns, student projects, or anyone looking to digitize a booking workflow.

Problem Statement

Many hotels still rely on manual reservation systems, which can result in overbookings, missed reservations, and poor customer experience. Lack of automation leads to lost revenue, confusion among staff, and inefficient service.

Proposed Solution

VistaInn offers a user-friendly interface for both hotel staff and guests. It enables hotels to streamline bookings, cancellations, and payments while ensuring accurate room availability and reservation tracking.

Key Features

Admin Panel

• Role-Based Login: Admin, Manager, Staff
• Forgot Password with OTP Email Verification
• Dashboard Analytics
• Manage:
  • Rooms (Available, Maintenance, Out of Service)
  • Bookings (check for Paid, Partially Paid, Pending)
  • Payments and Downpayments (50% required for advance bookings)
  • Order Extras and Item Extras
  • Accounts (staff users and roles)
• Profile Management

Kiosk Interface

• Start Page and Room Selection
• Extras Selection (with quantity adjustment)
• Customer Details Form with validation
• Review and Confirmation
• Invoice Generation

Scope

• Supports single-property hotel management
• Uses Microsoft SQL Server (vistainnMSDB) as backend
• Accurate availability checking using reservation statuses
• Price calculated based on PHP 300/hour with duration-based logic
• Prevents double bookings by blocking Paid, Partially Paid, or Pending dates
• Data validation for name, phone, email, and booking fields
• Built entirely for Windows; runs offline with no internet dependency

Limitations

• Designed for single-hotel setup (no multi-property support)
• No online payment integration (e.g., GCash, PayPal)
• No SMS functionality (email-based only)
• Not optimized for mobile or tablet use
• No guest login or tracking account system (one-time booking only)

System Preview

Below is a preview of the Hotel Booking Management System interface:

Support

If you need help with setup, customization, or updates, feel free to contact:
Email: peterjohndones112@gmail.com