Help me with my university theme project - C# / Web / SQL assignment
Budget: €8 – €30 EUR
Scenario
Build a console application that asks for the user’s first and last name. It then outputs the numbers 1 to 100 in ascending order. However, when the number can be divided by 3, it will be replaced with the user’s first name, and when it can be divided by 5 it’s replaced by the user’s last name. If the number can be divided by both 3 and 5, it outputs both first and last name.
Implementation 1:
Start by implementing this in C#.
Also build as many unit tests as needed to prove that your logic works.
Implementation 2:
Rewrite the code in such a way that the console app will be using SQL stored procedure(s) and/or SQL functions to perform the calculation and output the result to a table. The console app will retrieve the results and display it.
Make sure to prove that your code works by creating SQL unit tests.
Replace the console app with a single page Web App, preferably in Blazor.
Implementation 3:
Transform the calculation logic into a Web API, which consists of 2 methods:
a. Guid StartCalculation(firstName, lastName) immediately returns the identifier for the process as a Guid and then performs the calculation, but takes its time, somewhere between 20 seconds and 1 minute. Sometimes it should randomly fail.
b. StatusObject GetStatus(Guid) can be called to get a (JSON) status object back. This object should contain the status (i.e. ‘running’, ‘failed’, ‘completed’), progress(10%, 20% etc) and – when completed – the outcome of the calculation.
Change the Web App to use this Web API. Make the progress of the calculation visible on the page (knock yourself out!), as well as possible failures.
In the solution, use the following components:
- Visual Studio (2019 or up) C# console and test projects
- Visual Studio Database Project
- Database Unit test project that:
o Tests the stored procedures and/or functions
o Tests the function
- Single page web application project
Build a console application that asks for the user’s first and last name. It then outputs the numbers 1 to 100 in ascending order. However, when the number can be divided by 3, it will be replaced with the user’s first name, and when it can be divided by 5 it’s replaced by the user’s last name. If the number can be divided by both 3 and 5, it outputs both first and last name.
Implementation 1:
Start by implementing this in C#.
Also build as many unit tests as needed to prove that your logic works.
Implementation 2:
Rewrite the code in such a way that the console app will be using SQL stored procedure(s) and/or SQL functions to perform the calculation and output the result to a table. The console app will retrieve the results and display it.
Make sure to prove that your code works by creating SQL unit tests.
Replace the console app with a single page Web App, preferably in Blazor.
Implementation 3:
Transform the calculation logic into a Web API, which consists of 2 methods:
a. Guid StartCalculation(firstName, lastName) immediately returns the identifier for the process as a Guid and then performs the calculation, but takes its time, somewhere between 20 seconds and 1 minute. Sometimes it should randomly fail.
b. StatusObject GetStatus(Guid) can be called to get a (JSON) status object back. This object should contain the status (i.e. ‘running’, ‘failed’, ‘completed’), progress(10%, 20% etc) and – when completed – the outcome of the calculation.
Change the Web App to use this Web API. Make the progress of the calculation visible on the page (knock yourself out!), as well as possible failures.
In the solution, use the following components:
- Visual Studio (2019 or up) C# console and test projects
- Visual Studio Database Project
- Database Unit test project that:
o Tests the stored procedures and/or functions
o Tests the function
- Single page web application project