Challenge Overview
Aftermarket Service Products (ASP) Telematics Operations is developing a website which needs a specific set of WebServices to be developed. In this challenge we want you to develop a web service to retrieve a set of information (list of VINs) related to a CAN provided as input (Request) by the user. The data will be sourced from Services database(DB2). This webservice will return -
- All the VINs associated with the input CAN.
- Customer / Company Level Info
- Primary Telematics Contact info
- Terms and Conditions Status
The objective of this challenge is only developing the webservice, and no integration with the website. Data output is a set of data outlined in the provided document. Please review the detailed requirements in the document provided in the forums.
Webservice
The Webservice should take a CAN (Customer Account Number) input parameter, and return all the related VINs list in JSON
We want you to build a RESTful Web Service with DOT.Net 4.5 , and would be deployed on IIS 8.0
Please refer to the provided document in the Challenge forum for the complete and detailed requirements.
Use URI Template to rename URI to this format <host>/Services/rest/RelatedVINsList
Architecture
The webservice should be added to an existing code base that includes some pre-existing web services.
The Code base will be provided in the forums.
To define your new webservice you should follow a multi layer architecture with separate Database Access Layer and Business Logic , which is already present in the code base.
Error Handling
If the web service gets any error (for instance, no CAN in input, or errors in the database), the exceptions should be logged as a log event using log4net.
Database
Download and install DB2 Express-C on your development machine.
Scripts to create the database tables and sample data are provided in forums
Code Quality:
You need to strictly follow the coding conventions.
Follow the coding conventions described in the "Coding Conventions 1.3.pdf" provided in forums
Development Enviornment:
- IBM DB2
- Visual Studio 2013
- Dot.Net 4.5
- Web API
- Entity Framework
- IIS 8.0
- JSON
Final Submission Guidelines
Submission Deliverable
-
Upload entire Source Code (Entire VS 2013 project workspace) as your submission. No changes would be accepted after submission end date/time.
-
Deployment Guide with detailed steps to deploy on IIS and verify the deployment
-
Provide detailed guide to configure the Webservice ( Database connection strings, URI Templates)
- Video Demo of your solution and Code walk through
-
Technology
- IBM DB2
- Visual Studio 2013
- Dot.Net 4.5
- Web API
- Entity Framework
- IIS 8.0
- JSON