A User Interface for handling Capacity Matrix of TATA STEEL.

A web based project on "User Interface for Master Data Maintenance"

Abstract

For different plants inside the TATA STEEL company, we have different plant codes for each. Also an individual plant has different process codes like HM, CPL, DS. For a particular year week each plant will produce certain quantity of material ordered by the industry in tons. But the plant also has it's own capacity to produce in a particular year week. ATP will give us the difference between the plant_capacity and ordered_quantity. To record this, User Interface for Master Data Maintenance has been developed.

You can download the working video here.

You can check the screenshots of User Interface here.

Core Features

• User Login will have username and password(in hidden format) of 8-digits.
• Dashboard will contain master data management.
• Under master data management we'll have Capacity Matrix.
• Capacity Matrix will have fields like plant code, process code, year week from-to.
• Display button will show us the entire Data Table.
• On clicking each field of the data table we can have Edit Table option.

Additional Features

• If login credentials are wrong then an error popup will appear.

• Dashboard will contain a logout field.

• In Capacity matrix plant code and process code will be the necessary fields.

• Display will show the Data Table containing attributes:- Plant_code, Process_code, Year_week, Plant_capacity, Order_quantity, ATP.

• You can only edit two fields:- Year_week and Plant_capacity.

Technology Stack Used

• Front End - Bootstrap
• Back End - C#
• Database - MySql

Requirements

The source code of this project is written in C#. So, you'll require Windows .NET framework to run this project.

Installing

• Download .NET Framework
• Download Visual Studio
• Download Microsoft SQL Server Management Studio

How to run?

1. Download this repo and extract WebProject.zip file in your system.
2. Import the [database] from WebProject.zip folder.
3. Make Sqlconnection with the cs files.
4. Run Capacitymatrix.sln

Thanks!

I am extremely grateful for the practical hands-on experience along with the theoretical knowledge by the mentors in the web development summer internship at tatasteel though being in the onset of global pandemic time.