HotelCore is a single-hotel booking and management system built on ASP.NET WebForms(VB.NET), SQL Server, and Bootstrap 4. The system introduces "Flexible Stays & Smart Ops" - Supporting micro-stays(hourly bookings), configurable room setups, integrated housekeeping scheduling, and intelligent upsell suggestions.
- Visual Studio 2019 or later (with ASP.NET and web development workload)
- SQL Server 2019 or later (Express edition is sufficient)
- SQL Server Management Studio (SSMS) (optional, for database management)
- .NET Framework 4.8
| Layer | Technology | Version |
|---|---|---|
| Server Framework | ASP.NET WebForms | 4.8.1 |
| Database | SQL Server | 2022 |
| Data Access | ADO.NET | Native |
| UI Framework | Bootstrap | 4.6.2 |
| Client Scripting | jQuery | 3.6.0 |
git clone https://github.com/mdnayanmia31/HotelCore.git
cd HotelCore- Open SQL Server Management Studio (SSMS)
- Create a new database named
HotelCore - Execute the stored procedures from
HotelCore.Database/dbo/Stored Procedures/folder - Execute the table scripts from
HotelCore.Database/dbo/Tables/folder
Update the connection string in HotelCore.Web/Web.config:
<connectionStrings>
<add name="HotelCore"
connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=HotelCore;Integrated Security=True;Encrypt=False"
providerName="System.Data.SqlClient" />
</connectionStrings>Replace .\SQLEXPRESS with your SQL Server instance name if different.
- Open
HotelCore.slnin Visual Studio - Restore NuGet packages (right-click solution > Restore NuGet Packages)
- Build the solution (Ctrl + Shift + B)
- Set
HotelCore.Webas the startup project - Press F5 to run the application
For testing purposes:
Admin User:
- Email: [email protected]
- Password: Admin@123
- Role: Admin
Guest User:
- Email: [email protected]
- Password: Guest@123
- Role: Guest
HotelCore/
├── HotelCore.Web/ # Presentation Layer (ASP.NET WebForms)
│ ├── Account/ # User authentication pages
│ ├── Admin/ # Admin management pages
│ ├── App_Start/ # Configuration files
│ ├── Booking/ # Booking-related pages
│ ├── Content/ # CSS, images, fonts
│ ├── Scripts/ # JavaScript files
│ └── Shared/ # Master pages, shared components
├── HotelCore.BLL/ # Business Logic Layer
│ ├── Models/ # Data Transfer Objects
│ ├── Services/ # Business services
│ └── Common/ # Shared utilities
├── HotelCore.DAL/ # Data Access Layer
│ ├── Interface/ # Repository interfaces
│ └── Repositories/ # Repository implementations
└── HotelCore.Database/ # SQL Server Database Project
└── dbo/
├── Stored Procedures/
└── Tables/
- Home Page - Hero section with booking form, featured rooms, services
- Room Search - Filter and search available rooms
- Room Details - View room information and pricing
- Facilities - Hotel amenities and services showcase
- Contact - Contact form and information
- User registration and authentication
- Profile management
- Booking history
- Booking cancellation
- Dashboard with statistics
- Booking management (check-in/check-out)
- Room status management
- Booking search and filters
- Primary Color: Sage Green (#7fa185)
- Text on Primary: Cream (#efe8dd)
- Dark Text: #333333
- Font: Montserrat (Google Fonts)
System Flow and Entity Relationship Diagram (ERD): https://lucid.app/lucidchart/9a1762ff-58c7-4bc7-8b02-398f0f4fd30d/view
System Design: https://app.eraser.io/workspace/vCjBrquzEDEyJMkqBQhr?origin=share
UI Figma Design: https://www.figma.com/design/MUxH6I2aHMisNaZ6bjgxcX/HotelCore-Website-Wireframe-Design?node-id=0-1&t=iqkPuq0J2S7GC3Hy-1
Figma Website Prototype: https://www.figma.com/proto/MUxH6I2aHMisNaZ6bjgxcX/HotelCore-Website-Wireframe-Design?node-id=1-2&starting-point-node-id=1%3A2&t=K0xE670yJGuxS7eE-1
Project Planning: https://github.com/users/mdnayanmia31/projects/2
This project is licensed under the MIT License - see the LICENSE file for details.