.NET C# project with two web service APIs. Use “standard” .NET code architecture – like what is generated in latest MS Visual Studio (Controller, RouteConfig, Models, …). The application code will be delivered as an MS Visual Studio project, ready to deploy in IIS, along with basic IIS configuration and deployment instructions.
Each API will call an MS SQL Server stored procedure, passing in values given in the call to the API, and receiving a DB row set of data (typically around 6 rows, with about 10 to 15 fields).
Each API will have around 4 parameters, and support receiving data via:
• HTTP POST
• HTTP GET
Each API will support returning data as XML and JSON.
Each API will support a few error conditions, mostly based on the data from the stored procedure call.
I will provide a detailed spec:
• Service/class names,
• Parameter names and data types,
• JSON and XML formats / samples, with a mapping between XML and DB fields,
• Stored procedures,
• SQL to create several DB tables, and a small amount of sample DB data.