StockFlow API

Overview:

A production-ready RESTful API built with C# and .NET 8, designed to manage products and orders for a retail or distribution business. The system demonstrates backend API architecture, JWT authentication, PostgreSQL database integration, and Docker containerisation. Products and Orders are linked through a relational database, with full CRUD operations protected by JWT authentication. Deployed and live on Render.

Tech Stack:

Language: C#  |  Framework: .NET 8 / ASP.NET Core Web API  |  ORM: Entity Framework Core  |  Database: PostgreSQL (Neon)  |  Auth: JWT  |  Password Hashing: BCrypt  |  Containerisation: Docker  |  Deployment: Render

Key Features:

JWT authentication with register and login endpoints  |  BCrypt password hashing  |  Full CRUD operations for Products and Orders  |  DTOs for request validation  |  Protected endpoints requiring Bearer token  |  Orders linked to Products with full product details returned  |  Automatic order date stamping  |  Auto database migrations on startup  |  PostgreSQL with persistent Docker volumes  |  Deployed and live with Neon PostgreSQL database on Render

Concepts Demonstrated:

REST API Design  |  JWT Authentication  |  BCrypt Password Hashing  |  PostgreSQL  |  Entity Framework Core  |  EF Core Migrations  |  Docker  |  docker-compose  |  DTO Validation  |  Dependency Injection  |  Auto Migrations on Startup  |  Docker Volumes  |  Environment Variables  |  Cloud Deployment