Welcome! Click to reach the link!


About Me
 
In China
 In Germany
 In USA
 My Resume
  
Publications
 
Books
 Technical Papers
 Theses
 Others
 
Info Tech
 
A Move To IT
 
Courses Attended
 Certificates
 Software Projects
 
FEM Simulation
 
Engineering
 
Work and Study
 Courses Attended
 Process Modeling
 
Photo Album
 
China
 Germany
 Ph.D. defence/celeb.
 
Miner Parade
 USA
 Scenic & Architecture
 
Hobbies
 
Resources Links


 

| Home | About Me | Publications | Info Tech | Engineering | Hobbies | Resource Links |

[Resume] [Books] [Technical Papers] [Software Projects] [FEM Simulation] [Process Modeling]

 


COM+ Application on Order and Approval System

This is a Lab project during COM+ training. It is an order-processing application for Northwind Traders. Employees of the organization place orders for office supplies by using an application based on ASP.NET forms. When the orders are placed, they are approved or rejected based on the organization policy by a team of order approval clerks and their managers. The order approval team uses an order-approval application based on Windows forms.




The order-processing application

The order-processing application displays a list of customers and a list of products. The list of customers and the list of products are retrieved from the Customers table and the Products table, respectively, of the NorthwindOrders database. The list of customers and products does not change frequently in the database, so the data is cached to minimize the number of times the database is accessed. Employees can choose an organization from the list of customers, choose a product from the list of products, and enter the order quantity. They then click Place Order to place an order. The order is recorded in the Orders table and the details of the order are recorded in the Order Details table. Both tables are stored in the NorthwindOrders database.

Some of the products that are orderable are not stocked internally. These products are stocked by Contoso Ltd., a Northwind Traders trading partner. When an order is received for a product stocked by Contoso Ltd., Northwind Traders must send that order to Contoso Ltd. Contoso Ltd. has implemented an XML Web service called WebDispatch, which it uses to receive orders from its partners. This XML Web service records the orders in the Contoso Ltd. database.
The application uses a CRM to write an XML file that gives order details. If the transaction is aborted, then the XML file is deleted. If the transaction is committed, then the file is written to a particular directory. An existing Windows NT service called OrderDispatch uses a FileWatcher service to detect the XML order file. When it detects the file, it opens it, loads the XML document, and submits it to Contoso Ltd. by calling a method on Contoso Ltd.'s WebDispatch XML Web service.

The order-approval application

The order-approval application is used by order approval clerks and managers to approve or reject orders that are placed by employees. The order-approval application displays a list of orders waiting for approval. Clerks click Process to process an order. The Order Details dialog box is displayed.

They can either approve or reject an order by clicking Approve or Deny, respectively. They can click Cancel to close the Order Details dialog box without processing the order.

If the order is more than $1000 in value, only a manager can approve or reject the order.

Because there are multiple people who can approve orders, an event system is used to keep the list of pending orders that the client application displays up to date. When an order-approver begins processing an order, an event is fired so that all order-approval clients can remove that order from their screen. If new orders are created over the Internet, or if an order-approver stops processing an order, an event is fired so that all order-approval clients can add the order to their screen. COM+ Events is used to implement this scenario.

The accounting system

Northwind Traders has a separate accounting department that requires a separate accounting database for storing order information when orders are approved. To separate the needs of the accounting department application from the needs of the rest of the order processing application, a Queued Components COM+ application is used to post order information to the accounting database. Periodically, the accounting department starts the queued component COM+ application to process any orders pending in the queue.

 

 

 


  You are welcome to contact me. Send e-mail to me if you want.

 
© Benjamin (Bingji) Li 2000. All rights reserved.