Train Station

📙 overview
💻 Get Started
🔨 Built Using
📷 Demo Screenshots
📽 GIF Demo
🧱 File Structure
✨ Contributors

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

Clone the repository

git clone https://github.com/EslamAsHhraf/Train-Station

you will need to download SQL Server Management Studio (SSMS)
Excute CreateDatabaseQuery to create Data Base
Excute InsertValues to fill Data Base
Do stepsAccessing DB from C# App to link Data Base with application
Excute all files in Stored Procedures
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