Railway-Management-System

Railway management system is my CS219-Database Systems course project. In this project I have tried to automate the complete management process of railways. It is a desktop application developed in c# programming language.

Tools:

• For IDE, I have used visual studio 2019 community version. The .sln file attached with the project
• For database and database managemnt system, I have used Micreosoft SQL Server Management Studio.

Setup Guide:

1. Clone or download the project from github and place the folder in your desired file location.
2. Open visual studio and select Open a project or solution.
3. Select folder you have cloned/downloaded in step # 1 and click open. This will load the project in visual studio.
4. Now open SQL server management and create a new database.
5. You can check SQL Configrations folder to run all sql scripts. Most of these scripts are stored procedures for DDL commands to create necessary schema tables. You can execute these stored procedure by running spExecutionScript.sql.
6. Now connect database from SQL server management studio to frontend in visual studio
   • Go to sql_connection.cs and update connection string by adding your local data source name and catalog name.
   • Data source name is same as server name you can find it in the properties manual of you SQL server management studio.
   • Catalog name is the name of you database.

Demo Screens

Splash screen

Login screen

Sign Up screen

Employee Registration screen