Bus Yatra Booking -- Bus Business Management Application

"Developed a bus business management system which solves the problem of bus business owners of managing their booking system and their customers."

Bus Yatra Booking | C#, Dot Net, MVC, ASP.NET and SSMS

AIM: To build a bus business management that follows:

  1. MVC Architecture
  2. Utilization of Stored Procedure
  3. Use Foreign Key
  4. Check Constraint

Tools Used:
  1. Visual Studio Professional 2019
  2. SQL Server Management Studio 19 Express
  3. ASP.NET and DOT NET Framework
  4. HTML, CSS and JavaScript
  5. RDBMS

Theory:
USERS Prospective:

  • Shows all routes and prices to the user.
  • Display all bus information based on locations, capacity and prices. Availabale seats are only shown to logged in users.
  • Users can start booking after creating the account.
  • Users can view their bookings. They can cancel their booking based on locations.
  • User personal background bank is created in which their bookings cost is monitored. It affects the earnings of owner.
  • Users can delete their account. All their related data is vanished once deleted.

ADMIN Prospective:
  • A default admin credential is provided as "admin" and password "12345".
  • Admin create a new credential and delete the existing one. The credential is only deleted when atleast one credential is available.
  • Admin is provided full control with CRUD operations to manage bookings based on username,manage buses, view and manage feedbacks, manage routes.
  • Total earnings is displayed.

Database Information:
  • "busBusinessDatabase" database is created to manage all records.
  • 7 Tables created:
    1. adminlogins
    2. Bookings
    3. Bus_Details
    4. Feedbacks
    5. Route
    6. userbank
    7. userinfo
  • 25 Stored Procedures created to manage all CRUD operations through web application based on conditions applicable.
  • In booking, a check constraint is added if age >=18.
  • Foreign keys added:
    1. If username doesn't exist in userinfo, it cannot be added into bookings.
    2. If routeid is not added in route table, it will not be allowed to be added in bus table.

Technologies Used:
  1. Visual Studio 2019
  2. SQL Server Management Studio 19 Express
  3. ASP.NET web application (.NET Framework)
  4. MVC (Model View Controller)
  5. HTML, CSS and JavaScript
  6. RDBMS (Relational Database Management System)

ER Diagrams:
User Prospective:
Admin Prospective:
Outputs:


View it on my GitHub: Logo: link to github