Skip to content

EslamAsHhraf/Train-Station

Repository files navigation

🚂 Train Station

logo


📝 Table of Contents


📙 overview

  • A windows application for a train station DBMS. A train station DBMS that imitates a real transportation system. It is made to overcome manual errors of booking and make it into a computerized system. The train station manager can easily manage the station through the system, manage employees and schedule trips.
  • It has all the schedules of the trains available. From which passengers, who wish to travel, can go to the booking employee to book a ticket or book it through the application.
  • Passengers can also view, cancel or upgrade their ticket, address complaints...etc.
  • The database system helps to maintain all the records of different train trips, available seats and passengers in an easy way.

🚀 Get Started

  1. Clone the repository
    git clone https://github.com/EslamAsHhraf/Train-Station
    
  2. you will need to download SQL Server Management Studio (SSMS)
  3. Excute CreateDatabaseQuery to create Data Base
  4. Excute InsertValues to fill Data Base
  5. Do stepsAccessing DB from C# App to link Data Base with application
  6. Excute all files in Stored Procedures
  7. Read Report to undertand well how to use application

🧱 Built Using

  • Windows form application
  • my sql

📸 Demo Screenshots










🎥 GIF Demo


🗃️ File Structure

Train-Station
├── Stored Procedures
│   ├── Change_Department.sql
│   ├── Change_Rate.sql
│   ├── Change_Salary.sql
│   ├── Dno_Department.sql
│   ├── Employee_data.sql
│   ├── ID_Station.sql
│   ├── Insert_Trip.sql
│   ├── SSN_Employee.sql
│   ├── SSN_Passenger.sql
│   ├── get_tele_E.sql
│   └── get_tele_psql.sql
├── images
│   ├── cover.jpg
│   └── cover.png
├── TrainStation
│   ├── Admin_forms
│   │   ├── Add_admin.Designer.cs
│   │   ├── Add_admin.cs
│   │   ├── Add_admin.resx
│   │   ├── Block_.Designer.cs
│   │   ├── Block_.cs
│   │   ├── Block_.resx
│   │   ├── Remove_admin.Designer.cs
│   │   ├── Remove_admin.cs
│   │   └── Remove_admin.resx
│   ├── Employee_forms
│   │   ├── CancelTicket.Designer.cs
│   │   ├── CancelTicket.cs
│   │   ├── CancelTicket.resx
│   │   ├── TicketBooking.Designer.cs
│   │   ├── TicketBooking.cs
│   │   ├── TicketBooking.resx
│   │   ├── TrainStatus.Designer.cs
│   │   ├── TrainStatus.cs
│   │   ├── TrainStatus.resx
│   │   ├── UpdateMyData.Designer.cs
│   │   ├── UpdateMyData.cs
│   │   ├── UpdateMyData.resx
│   │   ├── UpgradeTicket.Designer.cs
│   │   ├── UpgradeTicket.cs
│   │   ├── UpgradeTicket.resx
│   │   ├── ViewPassengerData.Designer.cs
│   │   ├── ViewPassengerData.cs
│   │   ├── ViewPassengerData.resx
│   │   ├── ViewSeats.Designer.cs
│   │   ├── ViewSeats.cs
│   │   ├── ViewSeats.resx
│   │   ├── ViewTicketDetails.Designer.cs
│   │   ├── ViewTicketDetails.cs
│   │   ├── ViewTicketDetails.resx
│   │   ├── ViewTrips.Designer.cs
│   │   ├── ViewTrips.cs
│   │   ├── ViewTrips.resx
│   │   ├── updatePassengerData.Designer.cs
│   │   ├── updatePassengerData.cs
│   │   └── updatePassengerData.resx
│   ├── Manager_forms
│   │   ├── Change_Deb.Designer.cs
│   │   ├── Change_Deb.cs
│   │   ├── Change_Deb.resx
│   │   ├── Change_Salary.Designer.cs
│   │   ├── Change_Salary.cs
│   │   ├── Change_Salary.resx
│   │   ├── Change_rate.Designer.cs
│   │   ├── Change_rate.cs
│   │   ├── Change_rate.resx
│   │   ├── Employees_data.Designer.cs
│   │   ├── Employees_data.cs
│   │   ├── Employees_data.resx
│   │   ├── Fire_employee.Designer.cs
│   │   ├── Fire_employee.cs
│   │   ├── Fire_employee.resx
│   │   ├── Hire_Employee.Designer.cs
│   │   ├── Hire_Employee.cs
│   │   ├── Hire_Employee.resx
│   │   ├── Passengers_data.Designer.cs
│   │   ├── Passengers_data.cs
│   │   ├── Passengers_data.resx
│   │   ├── Schedule_trips.Designer.cs
│   │   ├── Schedule_trips.cs
│   │   └── Schedule_trips.resx
│   ├── Passenger forms
│   │   ├── Add_PhoneNumber.Designer.cs
│   │   ├── Add_PhoneNumber.cs
│   │   ├── Add_PhoneNumber.resx
│   │   ├── Book_Ticket.Designer.cs
│   │   ├── Book_Ticket.cs
│   │   ├── Book_Ticket.resx
│   │   ├── Cancel_Ticket.Designer.cs
│   │   ├── Cancel_Ticket.cs
│   │   ├── Cancel_Ticket.resx
│   │   ├── Change_Email.Designer.cs
│   │   ├── Change_Email.cs
│   │   ├── Change_Email.resx
│   │   ├── Change_Password.Designer.cs
│   │   ├── Change_Password.cs
│   │   ├── Change_Password.resx
│   │   ├── Change_PhoneNumber.Designer.cs
│   │   ├── Change_PhoneNumber.cs
│   │   ├── Change_PhoneNumber.resx
│   │   ├── Edit_Profile.Designer.cs
│   │   ├── Edit_Profile.cs
│   │   ├── Edit_Profile.resx
│   │   ├── Make_Complaint.Designer.cs
│   │   ├── Make_Complaint.cs
│   │   ├── Make_Complaint.resx
│   │   ├── Ticket_Details.Designer.cs
│   │   ├── Ticket_Details.cs
│   │   ├── Ticket_Details.resx
│   │   ├── Upgrade_Ticket.Designer.cs
│   │   ├── Upgrade_Ticket.cs
│   │   └── Upgrade_Ticket.resx
│   ├── Properties
│   │   ├── AssemblyInfo.cs
│   │   ├── Resources.Designer.cs
│   │   ├── Resources.resx
│   │   ├── Settings.Designer.cs
│   │   └── Settings.settings
│   ├── Resources
│   │   ├── 1419767.jpg
│   │   ├── Back-Ground.jpg
│   │   ├── 6108b580.jpg
│   │   ├── michal-parzuchowski-dmH3NWhYTHQ-unsplash.jpg
│   │   ├── michal-parzuchowski-dmH3NWhYTHQ-unsplash1.jpg
│   │   └─railway-station-platform-with-modern-high-speed-trains-clock_273525-355.jpg
│   ├── Admin.Designer.cs
│   ├── Admin.cs
│   ├── Admin.resx
│   ├── App.config
│   ├── Controller.cs
│   ├── Create_acc.Designer.cs
│   ├── Create_acc.cs
│   ├── Create_acc.resx
│   ├── DBManager.cs
│   ├── Employee.Designer.cs
│   ├── Employee.cs
│   ├── Employee.resx
│   ├── Handle.cs
│   ├── Manager.Designer.cs
│   ├── Manager.cs
│   ├── Manager.resx
│   ├── Passenger.Designer.cs
│   ├── Passenger.cs
│   ├── Passenger.resx /9/1419767
│   ├── Program.cs
│   ├── StoredProcedures.cs
│   ├── TrainStation.csproj
│   ├── TrainStation.csproj.user
│   ├── TrainStation.sln
│   ├── UserLog.Designer.cs
│   ├── UserLog.cs
│   └── UserLog.resx
├── Accessing DB from C# App.pdf
├── CreateDatabaseQuery.sql
├──  InsertValues.sql
├── Lincense
├── README.md
├── Report .pdf
└── Schema.png

👑 Contributors


Sarah Elzayat


Yasmine Ghanem


Yasmin Elgendi


Eslam Ashraf

About

✅ A windows application for a train station DBMS

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •