Skip to content

Latest commit

 

History

History
108 lines (73 loc) · 3.94 KB

README.md

File metadata and controls

108 lines (73 loc) · 3.94 KB

FMS

Fleet Manager is an fleet managment system which allows the following activities

  • Register as user
  • Login to the application
  • Update the user profile
  • Create, Read, Delete and Update a Bus(Vehicle Information)
  • Create, Read and Update a Garage entry
  • Create, Read and Update a Maintenance Request Type
  • Create, Read and Update a Maintenance Request on a given bus

User Roles:

  • Admin

  • Employee

  • Technican

    Admin:

    Administrator has the complete access to the system. He has the ability to perform the following actions 
- Create a user
- Update the user profile
- Lock a user out of the system
- Create, Read, Delete and Update a Bus(Vehicle Information)
- Create, Read and Update a Garage entry
- Create, Read and Update a Maintenance Request Type (Master Data)
- Create, Read and Update a Maintenance Request on a given bus

    Employee:

    Employee has a limited access in making changes to the master data in the system. He has the ability to perform the following actions 
- Create a user
- Update the user profile
- Create, Read, Delete and Update a Bus(Vehicle Information)
- Create, Read and Update a Garage entry
- Create, Read and Update a Maintenance Request on a given bus

    Technician:

    Technican only has access to the maintenance requests generated in the system. He has the ability to perform the following actions 
- Create, Read and Update a Maintenance Request on a given bus

Usecases:

  • Bus can be assigned to a garage
  • Bus can be checked out of a garage
    • A bus can only be checked out of the garage if it doesn't have any pending/In progress maintenance requests
  • Maintenance request can be raised on a bus
    • Maintenance request status will be "Waiting for Technican" upon creation and the bus's current status will be updated to "Scheduled for maintenance"
  • Maintenance Request status can be updated
    • If maintenance request status is updated "In Progress" by a user, the corresponding bus's current status will be updated to "Undergoing repairs"
    • If maintenance request status is updated "Complete" by a user and there are no other pending requests, the corresponding bus's current status will be updated to "Ready for Use"
  • Maintenance Request Type status can be updated
    • Only active maintenance request types will be displayed while creating a maintenance request

Technical Aspects:

  • Back end: C#, ASP.Net Core 5.0 MVC
  • ORM Framework: EF Core
  • JS Libraries: JQuery, Datatables
  • CSS: Bootstrap, Datatables
  • Database: SQL Server
  • Code first approach for building the database using EF Core

Future enhancements/updates:

  • Assigning Technician to a garage
  • Show maintenance requests only related to technician
  • Allow multiple closest garages assignment to a garage
  • Only allow Admin to delete bus records
  • Create a Maintenance header entity to envolope all the maintenance requests done at a time
  • Making data tables responsive in the admin section

Assumptions:

  • A garage is only allowed to have one close garage

Database creation/migration:

For running the database migration locally, please follow the below steps

  1. Update the connection string in FleetManagementSystem => appsettings.json with the appropriate details of your server
  2. Run the project
  3. You should now be able to see the database in the SQL Server

Note: Please do not delelte any content from the FleetManagementSystem.DataAccess.Migration folder

Q1: ER diagrams are attached in repository

Q2: Function to implement GetResaleValue

  • FleetManagementSystem => Areas => User => Controllers => BusController.cs => GetResaleValue(int? id) function

Q3: GridView implementation:

  • FleetManagementSystem => Areas => User => Controllers => BusController.cs
  • FleetManagementSystem => wwwroot => js => busDetailsModal.js
  • FleetManagementSystem => Areas => User => Views => Bus => __BusModalPartial.cshtml