Loadstack

College project · full-stack build

Sixth Form CRM

Relationship management for a sixth-form college's partner organisations

A staff-only CRM built as a college project for Notre Dame Catholic Sixth Form College. It keeps the organisations, contacts, visits and events behind the college's employer links in one secure place.

The challenge

Staff needed one place to see which organisations the college works with, who the contacts are, and what visits and events are coming up, instead of piecing it together from spreadsheets and inboxes.

The approach

A Blazor Server application on ASP.NET Core with Entity Framework Core and MySQL, behind JWT sign-in. Organisations are checked against the Companies House API, staff message each other in real time over SignalR, and any data can be exported to a spreadsheet for reporting.

Features

  • Companies House lookups: Organisations are matched to the government's Companies House register, so records carry real registered company details.
  • Live team chat: A SignalR message hub gives staff real-time conversations without leaving the CRM.
  • Visits and events: Staff schedule visits and events, and the dashboard surfaces what's coming up next.
  • Excel reports: Pick the data you need and export it straight to a spreadsheet, generated with ClosedXML.
  • Verified accounts: Email and SMS verification, password resets and an activity log of who changed what.
  • Employer reviews and compliance: Staff rate each placement employer, and every organisation carries its compliance and health and safety dates, so expiring checks don't slip.

Outcomes

  • About 40 screens covering organisations, contacts, visits, events, news, reports and administration
  • Staff-only by design: registration behind a rate-limited PIN, JWT sign-in, and an activity log of who did what
  • Built and demonstrated as a college project; the screenshots here use fictional staff and employers

Built with

  • Blazor Server
  • ASP.NET Core
  • EF Core
  • MySQL
  • SignalR
  • MudBlazor

Screenshots

  • Dashboard: companies registered, upcoming visits and events, active users and quick actions
  • CRM welcome page with the college crest and a Login button
  • CRM portal sign-in
  • Dashboard cards for upcoming events and visits, plus the team communications hub
  • Company details: basic and contact information, with reviews and ratings
  • Upcoming visits, filterable by type and date, as cards with details and edit actions

All work