Challenge Overview

Welcome to the Mercury Access Admin Backend API Challenge. Our goal here is to implement REST APIs from the provided swagger definition using .NET Core 3, SQL Server.

Project Overview

Please check the project background here

Technology Stack

C# 8, .NET Core 3.1, MS SQL Server 2019, Entity Framework Core, Azure 

Assets

Following are shared on the forum

  • Swagger definition
  • Implementation guide on each endpoint
  • Database design

Individual requirements

Implement following endpoints from the swagger

  • Lookups: all endpoints
  • Authentication: all endpoints
  • Account Management: all endpoints
  • Authentication Code: all endpoints
  • Administrators: all endpoints
  • ���Keyholder: GET /location/{locationId}/keyholder
  • Access Historyall endpoints
  • Configurations: all endpoints


���General Requirements

  • Good unit tests with minimum code coverage of 80% are required
  • Postman scripts for each endpoint are required
  • C# best practices should be followed, please check here https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/inside-a-program/coding-conventions
  • Provide SQL Script to 
  • initial seed data
  • Test data to verify API.
  • Please handle exceptions graciously 
  • Please add detail code documentation
  • Logging should be done using client’s library “LittleLogger” shared on the forum
  • Please confirm any third party library you want to use.


Final Submission Guidelines

Final Submission

Please submit the zip file containing

  • Source code with detail readme on how to deploy locally and verify endpoints
  • SQL scripts to prepare the test data
  • Deployment guide on the deployment of Backend in Azure.

ELIGIBLE EVENTS:

2020 Topcoder(R) Open

REVIEW STYLE:

Final Review:

Community Review Board

Approval:

User Sign-Off

SHARE:

ID: 30128757