Auto Spare Parts Tracking Business System

Please note that this code and the app itself is not for production purposes, I made it for the Database Course Project at my University.

About Project

In this project, we have developed a bussines system for Yavuz Otomotiv. Company sells car spare parts, to control stock and to keep supplier and customer information in the system. The database was made for the company’s employees to use it comfortably with MSSQL.

---

FrontEnd

• EJS - CSS

BackEnd

• NodeJS - Express

Database

• MSSQL

Running Project

1. First you have to install NPM packages for both API-server and Client separately:

Database Api:API

npm install

2. After step 1, you have to create your own .env file inside server API files with example below.

DB_HOST=yourHost
DB_USER=yourUserName
DB_NAME=yourDatabaseName
DB_PASSWORD=yourPassword
DB_PORT=yourPort

3. After these steps run this commands in terminal both Client and Server-API:

npm start

---

UML diagram for MSSQL Database

---

Example Runs:

Login page

---

Admin Menu

---

Employee Menu

---

Adding A New Part To System

---

All Products in Storage

---

Viewing A Single Part

---

Creating An Order

---

Manage All Active Orders

---

Creating A Bill For Order

---

Viewing All Bills

---

Editing User Information

---

Editing Admin Messages

 

Designed and Coded with ❤️ by snndmnsz