Inventory Management Application

Tech Stack:

• UI: Angular 12 (Components, Form Validation, Services, Interceptors) & Bootstrap 4.0 CSS Framework
• Backend: Spring Boot (2.5.0), Swagger,Spring Security, Spring Data JPA, MySQL 8.0, Junit, Docker
• Code Scan: Sonar Scan used Free Cloud Sonar Scan

Swagger URL for Rest Api Documentation: http://localhost:8080/swagger-ui/

Features:

• User Can Login to Inventory Management Application
• If Login as Admin, then he can Manage DB Inventory & Manage Users
• If Login as User, then he can Test the DB Connectivity
• Admin can Add New Connection
• Admin can Update Connection
• Admin can Delete Connection
• Admin can Test DB Connectivity
• User can Test DB Connectivity
• Logout

Application Security: (Spring Securtity with JWT)

We are using JWT (Json Web Token) to protect our API

Once User is registered and Login to our Application using Username & Password, we will going to first Validate the User in our Backend, Once user is validated we are creating JWT Token which is sent to UI, UI will going to send this Token for each API Call, Backend will validate the Token and on successful validation only API will going to provide the response.

Architecture Diagram:



Jenkins CI/CD:

• Push code to Github, which will invoke Webhook and Start Jenkins Job to Build the Code
• Stage 1 : OWASP Scan (Open Web App Security Project) 3rd Party library scan for Vulnerability
• Stage 2 : Junit Test
• Stage 3 : Build Application
• Stage 4 : Sonar Scan
• Stage 5 : Fortify Scan
• Stage 6 : Docker Build
• Stage 6 : Twistlok Image Scan for Vulnerability
• Stage 7 : Deploy

Login Screen:



Home Screen:



Admin Screen To Manage DB Inventory:



Admin can Update DB Configuration:



Admin can Add DB Configuration:



Admin can Test DB Connectivity:



Admin Users List Screen:



Logout Screen:



Normal User Flow, Home Screen:



Normal User can view DB Connection:



Normal User can Test DB Connection:



DB Architecture on Cloud:



Classes Used :



Database Diagram: