Welcome

More will be added gradually...

The "Transformed Rainfall Data" function queries and displays the rainfall data saved in the Azure SQL database. We also developed a back-end function that can collect data from data file, transform data, and save the post-processed data into database.

The "Locks" function can open an Index page containing locks data that is dynamically queried from Azure SQL database. The page also has links for the user to add and change locks data and save into database.

The system also provides APIs for other application systems to use to query data from database. The APIs are implemented using ASP.NET Core Web API. The APIs can be accessed by other application systems to query data from database. The APIs are also documented using Swagger UI.

The following APIs are available for other application systems to use:

Locks API all locks

Rainfall API Rainfalls - Top 50

The system is developed using ASP.NET Core MVC and Entity Framework Core. The system is hosted on Azure App Service and the database is hosted on Azure SQL Database. The system is also integrated with Azure DevOps for continuous integration and continuous deployment.

The system has been tested and verified to be working as expected. The system is also monitored using Azure Application Insights for performance and availability.

Security: Azure app Authentication has been added so it supports SSO. The system is also secured using Azure Active Directory for authentication and authorization for resources access permissions. The system is also configured to use HTTPS for secure communication.