Skip to content

Build a system that contractors can upload their activity for highway maintenance, validate the GPS locations, provide summary reports. The system is to reject invalid uploads.

License

AdvSol-Darrel/HMCR

 
 

Repository files navigation

img

HMCR

As part of the Highway Maintenance Contract Renewal (HMCR) process the business area defined the reporting requirements for the Maintenance Contractors (MCs). The contracts outlined the fields that have to be reported on and the format that it needs to be reported in.

This presents a problem on how to best collect the data being provided by the MCs and ensure its quality, so that it can be put to use for the Program and Ministry needs. Through this project the program wants to meet the need to automate the data gathering, as well as data validation process then capture the successfully validated data in a database which can then be immediately available to HQ and District Offices.

Prerequisites

  • .Net Core 3.1 SDK
  • Node.JS v10.0 or newer
  • Microsoft SQL Server 2017 or newer

Dependencies

  • Working KeyCloak Realm with BC Gov IDIR and BCeID
  • Ministry of Transportation and Infrastructure GeoServer access
  • IDIR service account with access to BC Gov BceID WebService

Local Development

Configuration

Use the following steps to configure the local development environment

  1. Clone the repository

    git clone https://github.com/bcgov/HMCR.git
    
  2. Create the HMR_DEV database in MS SQL Server

    • Delete all existing tables
    • Run scripts in database/V01.1 directory
    • Apply incremental scripts (V14.1 to Vxx.x) in ascending order
    • Create the first admin user in HMR_SYSTEM_USER table and assign the SYSTEM_ADMIN role in the HMR_USER_ROLE table
  3. Configure API Server settings

    • Copy api/Hmcr.API/appsettigns.json to api/Hmcr.API/appsettigns.Development.json
    • Update the placeholder values with real values, eg., replace the <app-id> with actual KeyCloak client id in the { "JWT": { "Audience": "<app-id>" } } field
    • Update the connection string to match the database
    • Make note of or update the port for the API Server in Visual Studio or through the properties/launchSettings.json file.
  4. Configure Hangfire Server settings

    • Copy api/Hmcr.Hangfire/appsettigns.json to api/Hmcr.Hangfire/appsettigns.Development.json
    • Update the placeholder values with real values, eg., replace the <ServiceAccount:User> with actual IDIR service account in the { "ServiceAccount": { "User": "<ServiceAccount:User>" } } field
    • Update the connection string to match the database
  5. Configure the React development settings

    • Create the client/.env.development.local file and add the following content
     # use port value from step 3
     REACT_APP_API_HOST=http://localhost:<api-port>
    
     REACT_APP_SSO_HOST=https://dev.oidc.gov.bc.ca/auth
     REACT_APP_SSO_CLIENT=<client-id>
     REACT_APP_SSO_REALM=<realm-id>
    
     REACT_APP_DEFAULT_PAGE_SIZE_OPTIONS=25,50,100,200
     REACT_APP_DEFAULT_PAGE_SIZE=25
    
     # Optional, default port is 3000
     # PORT=3001
    
    • Replace the placeholder values

Run

Use the following steps to run the local development environment

  1. Run the API Server

    • F5 in Visual Studio
    • Or from console
    cd api/Hmcr.Api
    dotnet restore
    dotnet build
    dotnet run
    
  2. Run the Hangfire Server. It's only neccessary to run the Hangfire Server if debugging Hangfire jobs

    • F5 in Visual Studio
    • Or from console
    cd api/Hmcr.Hangfire
    dotnet restore
    dotnet build
    dotnet run
    
  3. Run the React frontend

    cd client
    npm install
    npm start
    

OpenShift Deployment

Refer to this document for OpenShift Deployment and Pipeline related topics

About

Build a system that contractors can upload their activity for highway maintenance, validate the GPS locations, provide summary reports. The system is to reject invalid uploads.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • TSQL 55.3%
  • C# 36.9%
  • JavaScript 7.2%
  • SCSS 0.3%
  • Groovy 0.2%
  • HTML 0.1%