All work

Rockstars Health Check

A web app to create and e-mail health-check questionnaires, for Rockstars IT. In our student team I led the rebuild into layers with interfaces and wrote almost all of the unit tests.

Database, e-mail, rebuild into layers, unit testsstudent teamFeb – Jun 2024C#, ASP.NET MVC, MySQL, JavaScriptFinished

Statistics page of the health check with a bar chart of answers (demo data).

The problem

Rockstars IT, the client of our semester, wanted a web app for health checks: questionnaires for their teams, sent by e-mail, with the answers shown in charts. Several student groups worked on the same database.

My part

  • The database layer and a message logger, and the backend of the login.
  • E-mail: sending health checks with a fixed layout, also to every member of a team, in the background.
  • The rebuild. Halfway through I led the rebuild into layers with interfaces and dependency injection. I practised it first, then walked the group through it on my laptop.
  • Almost all of the unit tests, with mock databases. Nobody else wanted to write them.
  • Smaller features: copying questions, editing questionnaires, logging out, deleting categories, resetting a password by e-mail, and one attribute for pages that need a login.
Entity-relationship model with tables for surveys, questions, answers, users and companies.
The database model, made together with teammates.

What went wrong

We rebuilt the app halfway because the dependencies pointed the wrong way, which taught me how to set up interfaces properly. Working together in Git also went much better after the first round, with fewer merge problems.

Status

Finished. We presented it at Rockstars IT in ’s-Hertogenbosch.