I served as the sole developer on this project, constructing it as a C#.NET web application with Entity Framework utilised for database access. AngularJS was used for the front-end functionality of the application.
Tag: MS SQL
NHS UHNM Active Directory security in PHP
This project was another part of my role supporting the internal PHP systems at Royal Stoke Hospital.
HOPS Linux Server
HOPS required a reliable server to host essential business applications. This server was crucial for hosting the client portal, generating nightly management reports, and facilitating an authorisation API to the MS SQL server.
HOPS Customer Portal
HOPS operated an MS SQL database on Microsoft Small Business Server which had fallen out of support. The database was overly complex, housing over 100 tables and more than 400 stored procedures and functions.
HOPS Nightly Excel Reports
Key personnel at HOPS rely on daily management reports to monitor daily operations, particularly as much of their work occurs off-site. To meet this need, they requested automated nightly generation and distribution of these reports to designated staff members via email.
HOPS Website
The HOPS website required modernisation to include specific legal compliance information. I proposed using WordPress to create a basic brochure site, utilising its CMS capabilities to empower existing staff to update the required pages.