Hotel Management System

A web-based application built using ASP.NET and C# to manage hotel operations efficiently.

Features

• Room Booking: Manage room availability and guest reservations.
• Billing System: Automatic calculation of stay duration and total costs.
• Guest Records: Maintain a history of guest information and check-in/out status.
• SQL Database: Relational database design for optimized data storage.

Tech Stack

• Frontend: HTML5, CSS3, Bootstrap
• Backend: ASP.NET, C#
• Database: Microsoft SQL Server
• Tools: Visual Studio, SQL Server Management Studio (SSMS)

Database Design

The project uses a structured SQL Server database with the following key tables:

• Guests - Stores guest personal and contact details.
• Rooms - Manages room types, pricing, and availability.
• Bookings - Links guests to rooms with check-in/out dates.
• Many Others Tables..

How to Run

1. Clone this repository.
2. Open the .sln file in Visual Studio.
3. Import the provided .sql script into your SQL Server instance.
4. Update the connection string in web.config.
5. Run the project (F5).