|
|
|
|
|
|
|
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.
|
|
|