Header photo

CSE 3055 Project - Technical Service Database & Interface

A technical service management system built with React, NextJS, NodeJS, ExpressJS and Microsoft Azure Database

Table of Contents

About The Project

The main idea of the project is provide a wide range database system to a technical service who needs the store information about their customers, employee, repairment process and the parts being physically stored in their building etc. This business model is created in order to simplify the information storage and keep the operation of repairment work effective and quick.

Database project that we implemented is responsible for managing a technical service of mobile devices and storing the repairing process information of them. This database will be used by the workers of the technical service.

Built With

Front-End
Back-End
Database

Screenshots

Login

Login Image

Dashboard

Dashboard Image

Repairment List

Repairment List Image

Repairment Details

Repairment Details Image

Create Repairment

Repairment Create Image

Order List

Order List Image

Part List

Part List Image

Employee List

Employee List Image

Employee Details

Employee Details Image

Payment List

Payment List Image

Settings

Settings Image

Getting Started

Prerequisites

Installation

  1. You need to create a MSSQL database with this structure

  2. Clone the repo and change directory

git clone https://github.com/anilsenay/Technical-Service-Management-System.git
cd Technical-Service-Management-System
  1. Install NPM packages for both server and client by running this command:
cd server && npm install && cd ../client && npm install
  1. Create your .env.local file on server's root folder for with this content. Put your private keys. (server/.env)
PORT=5000
SERVER=database_server_url
DATABASE=database_name
DB_USERNAME=db_username
DB_PASSWORD=db_password
  1. Create your .env.local file on clients's root folder for with this content. Put your private keys. (client/.env)
NEXT_PUBLIC_API_URL=api_url
  1. Run in development mode both server and client
cd server
npm run dev
cd client
npm run dev

Issues

  • We had not provide any security for back-end, so use it only in development.

License

Distributed under the GPL License. See LICENSE for more information.

Contact

Project Link: https://github.com/anilsenay/Technical-Service-Management-System