Northwind Trading Company

 

 

 

Northwind Trading Company

 

 

 

 

 

 

E-Commerce Enhancement Application

 

Version 1.0.0

 

June 9, 2005

 

 

 

Author:

Daniel Dorval,

.NET Developer

 

 

 

 

 

 

 

 

 

 

OpenBOXTechnologies

 

125 Whipple Street
Providence, RI 02908
Phone: [phone]

 

 

Revision & Sign-off Sheet

Change Record

Date

Author

Version

Change Reference

6/09/2005

Daniel Dorval

1.0.0

Initial Release

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Reviewers

Name

Version Approved

Position

Date

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Document Properties

Item

Details

Document Title

Northwind E-Commerce

Author

Daniel Dorval

Creation Date

6/09/2005

Last Updated

6/09/2005

 

 

Table of Contents

Revision & Sign-off Sheet 2

Table of Contents 1

1.    Introduction. 2

1.1.    Current System.. 2

1.2.    Proposed System.. 2

1.2.1  Phase I 2

1.2.2  Phase 2. 2

1.2.3  Phase 3. 2

2.    Technology and Architecture. 2

 

 

1.  Introduction

 

1.1.            Current System

Northwind Trading Company is currently using a Window’s based application that requires customers to call in to place there orders. We have already built for them an Inventory Control System (ICS) for their customers to use and will be adding the place order ability at a later time. The ICS produces an XML file which they currently are emailing in to place there order.

 

 

1.2.            Proposed System

Northwind would like us to build for them an e-commerce web application for both customers and sales reps. Customers need to be able to login, places orders, cancel orders, and view status of orders. Sales Reps need to be able to login, check the status of orders placed by them, modify orders, and cancel orders.

1.2.1          Phase I

In phase 1 Customers will be able to login and upload the xml file containing there order. While logged in they can also view past orders, modify them or cancel them.

1.2.2                            Phase 2

Phase 2 will allow new Customers to register and upload orders. It will also allow Sales Reps to login and view, modify, and delete Orders assigned to them. Sales Reps can also upload orders for Customers. If the Sales Rep is also a Manager they can see the Orders of the Sales Reps who report to them.

1.2.3          Phase 3

Phase 3 will add a Web Service for use with the ICS application to submit an order from the users desktop.

 

2.  Technology and Architecture

2.1. Northwind E-Commerce System will be built using the .NET Framework v. 1.1

2.2. User Interfaces will be created using ASP.NET and code should be written in C#

2.3. It should use multi-tiered, object oriented and layered architecture and be able to easily support changes.

2.4. There should be at least 3 layers: Presentation, Business Logic, Data Access.

3.  Business Rules

3.1. When a customer places an Order the Sales Rep(Employee) assigned to that order is the Sales Rep assigned to the majority of that customers orders. If the Customer has no Orders follow Rule 3.2, in the event of a tie between sales reps use the sales rep of that customer’s most recent previous order.

3.2. If a new Customer places an Order assign the Sale Rep with the fewest Orders to that Order.

3.3. An Order cannot be canceled once it is shipped, to cancel an order set the OrderDate to null.

3.4. The CustomerID in the uploaded XML file must match the logged in Customer for Customer Upload.

3.5.  A Sales Rep can upload a single file containing multiple Orders from multiple Customers. Their EmployeeID is assigned to the Orders regardless of what Sales Rep is determined by Business Rule 3.1 or 3.2.

 

4.  Northwind Database Assumptions

4.1. All Employees are Sales Reps.

4.2. If a Sales Rep ReportsTo someone, that Employee is a Manager and a Sales Rep.

 

5.  Assignment

You will be using the Northwind Database available in Access or SQL Server (SQL Server is preferred). Make no changes to the Database other than actual data. Follow the spec and produce all 3 phases. For simplicity the login for Customers will be the CustomerID and the login for the Sales Reps will be the EmployeeID. To test Phase 3 create a Windows Application in .NET that uses your web service to upload the same XMLl files used before. An XML file will be provided to you, you may create addition files for testing and are encouraged to do so. Take you time and plan ahead, you will be judged more on your object design, layout, and code quality than level of completion. Your solution should be layered; you may create additional layers of abstraction to those suggested above as they are just the minimum.