96h! Dragonet - Worksheet API Implementation Challenge

Challenge Objectives
The purpose of this challenge is to implement the REST API defined for a web app, tasks include:

• Implement all the designed REST API endpoints
• You’ll be following an existing database schema
• The app currently has no roles, and all endpoints will be public

 
Project Background

• Our customer has a legacy app built in 1998 and it’s time to re-write this application to a modern web app. For this project, we are going to rewrite a small part of the application called FOBO Worksheet.
• The app consists of two parts
  • The Angular based web app
  • The REST API backend

Please note this challenge has shorted timeline for submission, review and appeals phases!!
 
Challenge Scope
For this challenge, you need to finish the following tasks:

1. Implement all REST API endpoints defined in Swagger documentation
2. Your implementation must use the provided database schema, the implementation is supposed to work with Sybase 15.7 (we’ll provide a docker image and some test data for this).
3. Provide postman files to test the REST API
4. Keep Swagger documentation in sync with the code

 
Technology Stack
The following technology stack will be used as part of this challenge:

• .NET
• ASP.NET Web API
• Sybase 15.7
• REST
• SQL
• JSON

 
Documentation
Register to download the following documents we provided in the forum

• Swagger Documentation
• API Implementation Details Document
• Docker Image for Sybase 15.7
• Test Data (in SQL script format)
• Prototype (for your reference)

Final Submission Guidelines

What To Submit

• Full code that covers all requirements
• Swagger Documentation (in sync with your code)
• Postman files to test the API
• A readme in markdown format that clearly explains how to configure, run and verify the code