Skip to content

PlVasilev/MDMS-Maintenance-Department-Management-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
 
 
 
 
 
 

Repository files navigation

MDMS-Maintenance-Department-Management-System

ASP .NET Core MVC SQL

System For management a maintenace department in a company

Description

This is a simple Maintenance Department Management System Mostly for tracing cost repairs of the company's vehicles.

Administrator is equivalent to - Maintenance Department Manager

User is equivalent to - Mechanic

Guest Role

  1. Guests can Register and Login but need authorization from Admin to be able to use app functionality at first they can access only their profile

User Role - When guests they get authorization:

  1. User can create Internal Repair - User can have only One Active repair;
  2. User can View all repairs, view all parts and use available parts on repair.
  3. User can view vehicle details.

The administrator is the first registered user

  1. The administrator can add Vehicle, edit vehicle or remove a vehicle.
  2. The administrator can view all Users and give or remove authorization and Remove Users.
  3. The administrator can Add MontySalary to a User and edit Paymen.
  4. The administrator can create Part, add the parts to stock, edit Part.
  5. The Administrator can create multiple External Repairs.
  6. The administrator can view Reports, create custom Report.

Administrator is the user who gives authorization other users to use the app functionality

Entities:

User (Admin - Department Manager, User - Mechanic)

  • Id (string)
  • Username (string)
  • Password (string)
  • Email (string)
  • FirstName (string)
  • LastName (string)
  • Phone Number (string)
  • BaseSalary (decimal)
  • AdditionalPaymentPerHour (decimal)
  • IsAuthorized (bool)
  • IsDeleted (bool)

MonthlySalary

  • Month (Int)
  • Year (Int)
  • AdditionalOnHourPayment (decimal)
  • BaseSalary (decimal)
  • TotalSalary (decimal)
  • HoursWorked (double)
  • Mechanic (user)

Vehicle

  • Id (string)
  • Model (string)
  • Make (string)
  • VSN (string)
  • Pricture (string)
  • Engine Number (string)
  • Registration Number (string)
  • AccuiredBy (VehicleProvider)
  • AccuiredOn (DateTime)
  • Depreciation (decimal)
  • Price (decimal)
  • Mileage (int)
  • VehicleType (enum) (Truck/Loader/Lift/Trailer/Car etc . . .)
  • VehicleProvider (enum)
  • ManufacturedOn (dateTime)
  • Repairs List
  • Is Active (bool)
  • Is In Repair (bool)

Part

  • Id (string)
  • Name (string)
  • Price (Desimal)
  • AcquiredFrom (Provider)
  • UsedOn (InternalRepairPart)
  • Stock (int)
  • UsedCount (int)

Repair

  • Id (string)
  • Name (string)
  • Description (string)
  • Vehicle (Vehicle)
  • RepairedSystem (Engine, GearBox, Electrical, Hydraulic, Chassis, Breaking, BodyWork)
  • Mileage (int) (km, motor hours)
  • Mechanic (User)
  • Started (DateTime)
  • Finished (DateTime)
  • Internal Repair - UsedParts (List), HoursWorked
  • External Repair - External Repair Provider, Labor Cost, Parts Cost
  • RepairCost

Report

  • Id (string)
  • Name (string)
  • StartYear (int)
  • EndYear (int)
  • StartMonth (int)
  • EndMonth (int)
  • ReportType (enum) (Month,Quarter,Year,Custom)
  • VehicleInReport (List)
  • SalariesINREport (List)

About

ASP .NET Core MVC + SQL

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published