10. Purchase Order Tracker
A purchase order tracker manages vendor purchases, line items, approvals, receiving status, and payment status.
Why employers care
Employers care because purchasing workflows show approval logic, vendor records, status tracking, and operations-focused database design.
Main build outline
- Create vendor, purchase order, purchase order line item, approval status, and receiving status records.
- Add create/edit screens for purchase orders and line items.
- Add statuses for draft, submitted, approved, ordered, partially received, received, and closed.
- Add filters for vendor, status, requested date, expected date, and overdue orders.
- Add a receiving view that compares ordered quantity to received quantity.
Modern .NET stack
- Blazor Server or ASP.NET Core MVC/Razor Pages for the web UI.
- C# services for validation, workflow rules, and business logic.
- Entity Framework Core with SQL Server locally, then SmarterASP SQL Server or Azure SQL.
- SmarterASP for practical hosting, with Azure App Service or AWS as cloud stretch paths.
- Optional GitHub Actions, Docker, dashboard reporting, and small AI helper features.
Portfolio proof
- README with the business problem, screenshots, setup steps, and tech stack.
- Database schema or diagram that explains the main tables and relationships.
- Screenshots of list, detail, create/edit, search, filtering, and status workflows.
- Small commit history showing steady feature work and clean fixes.
- Secret-safety note confirming connection strings and API keys are not committed.