RESTful ASP.Net Core Web API application SQL Server 2017 or 2019 for LONG TERM PROJECT

Job ID: 35890806

Budget: $10 – $30 USD

IF you can complete this assignment, we will hire you for very long term contract. We have great clients and ready to hire top .NET talent! SEE WORD Attachment FOR MORE INFORMATION


Coding Assignment

Requirement
Candidate should have the appropriate IDE installed.
• Visual Studio 2019 or later (Windows), Visual Studio for Mac 2019 or later (MacOS)

Assignment - 1
Develop a very simple RESTful application that demonstrates the ability to
• Add a new Task
• Update Tasks that already exist. 

Overall Requirements
• Visual Studio 2019 or Visual Studio 2022 should be used to build the application
• The application should be written as an ASP.Net Core Web API application (ASP.Net Core 6)
• If a database is used, please use SQL Server 2017 or 2019
• Use stored procedures not an ORM such as entity framework.
• Unit tests should be used to run the application (create or update)

Task Requirements
• When creating a Task, the Due Date cannot be in the past
• The due date cannot be on a Holiday or weekend.
• The system should not have more than 100 High Priority tasks which have the same due date and are not finished
• The domain should include the following:
o Id
o Name
o Description
o Due Date
o Start Date
o End Date
o Sni
o Priority (High, Medium, Low)
o Status (New, In Progress, Finished)

Concepts to Consider
• Test Driven Development (TDD)
• Dependency Injection (DI)
• Domain Driven Design (DDD)

Submitting the Application
• Within 48 hours, please send me the zip file which should contain the source code.  Please do not include object or bin folders.
• Please include a README file with the application that explains how to compile, configure, and run the application – including how to initialize the DB with SQL scripts if used.
• Once we receive the zip file and unzip, we should be able to open the solution with Visual Studio, compile and run the unit tests.
Related categories: .NET C# Programming ASP.NET Microsoft SQL Server