aha1215 / traffic-citation-backend

.NET 6 Web API for Capstone Fall 2022

Introduction

A .NET 6 Web API to be used with our Angular application

Frameworks: Entity Framework Core (Object Database Mapper)
Database: PostgreSQL
CI/CD pipeline. Deployed on Heroku. Using Jincod .NET Core Buildpack

Database ERD

---

API Endpoints

https://traffic-citation-backend.herokuapp.com

Citation

GET - Retrieve all citations
/api/Citation

GET - Retrieve list of citations for pagination based on page number, page size, user id, and user role
/api/Citation/{pageNumber}/{pageSize}/{userId}/{userRole}

POST - Create a citation with violations
/api/CitationWithViolations

POST - Create a citation
/api/Citation

PUT - Update a citation
/api/Citation

DELETE - Delete a citation by id
/api/Citation/{id}

---

Driver

GET - Retrieve all drivers
/api/Driver

POST - Create a driver
/api/Driver

PUT - Update a driver
/api/Driver

GET - Retrieve driver by license number
/api/Driver/license/{license_no}

GET - Retrieve driver by id
/api/Driver/{id}

DELETE - Delete a driver by id
/api/Driver/{id}

---

Violation

GET - Retrieve all violations
/api/Violation

POST - Create a violation
/api/Violation

PUT - Update a violation
/api/Violation

GET - Get violation by citation id
/api/Violation/{citation_id}

PUT - Update a list of violations
/api/Violation/violations

DELETE - Delete a list of violations
/api/Violation/violations

DELETE - Delete a violation by id
/api/Violation/{id}

---

Learning Resources

• CRUD with Angular 14 & .NET 6 Web API, EF Core & SQL Server