Challenge Overview
Project Overview
CPR is a web app that will provide great benefit to customers:
- Better product data available online leads to more requests for quotes, more specific inquiries, and a higher likelihood they will complete the transaction
- More catalogs to search from provides more opportunities to buy
- Existing customers calling their salesperson, store or call center with a question will appreciate getting answers on the first call and not be bounced around from person to person
- e-Procurement solution setup and maintenance times will be decreased
Competition Task Overview
For this challenge, we need to update the implementation for JDE sync.
Client has been looking at the data model and working on the JDE sync, they noted that the design of the JDEProduct table currently has ~200 fields but their final mapping only has 47 fields they are pulling from JDE (attached in the forum). So we'd like to copy 7 JDE tables into the CPR database that will contain all the data CPR needs (the attachment - column D shows where to get each value from JDE), get rid of JDEProduct, and update the sync code to the Product table to pull directly from the 7 tables.
Basically JDESyncJob will be revamped to connect to these 7 tables, pull data from them to the CPR Product table, which should be pretty straightforward. Note that we won't need to connect directly to JDE, but that we will have data populated across these 7 tables instead of a single JDEProduct table now.
You can find the definition for the 7 tables in back-end/DB/JdeTables.sql
Please register to download the frontend architecture for details.
Coding Standards
Please follow the coding standards provided by the client.
Bugs
If bugs are found in the provided code, they should be fixed in this assembly as well.
Testing
Unit test are required for this challenge. And please use MS VS test, NOT nunit.
If changes are made to code from previous assembly, make the corresponding unit tests are updated as well.
Timeline
This challenge has quite aggressive timeline, make sure you pay attention!
Base Code
You should use the code in our gitlab repo as base and work off the specified branch.
The winner will be responsible of creating a merge request after final fixes and may also be asked to help with deployment on a VM.
Technology Overview
- .NET Framework 4.0
- WCF
- C#
- Visual Studio 2012
- SQL Server 2012
- ASP.NET MVC
- Razor View
Documentation Provided
Register to download documents from challenge forum.
Final Submission Guidelines
Submission Deliverables
A complete list of deliverables can be viewed in the TopCoder Assembly competition Tutorial at: http://apps.topcoder.com/wiki/display/tc/Assembly+Competition+Tutorials
Below is an overview of the deliverables:
- Fully implemented code that covers all requirements.
- A complete and detailed deployment documented explaining how to deploy the application including configuration information.
Final Submission
For each member, the final submission should be uploaded via the challenge detail page on topcoder.com.