DataAccess Layer Class Diagrams by ias80075

VIEWS: 120 PAGES: 9

									DataAccess Layer
 Class Diagrams

      Matt Hinds
     Paul Lagasse
     Matt Menard




        CS509
        4/11/06
               Retreiving Orders from the
                        Database
This sequence shows how
                                                                     DataAccess             RequestBuilder       DatabaseAccess
the BusinessLogic Layer                    :
                                                                                                                                            : Database
(BLL) receives open orders      SW_Business_Logic_Layer
from the DataAccess Layer,                      1: Get open orders
and how that event
                                                             If connection does not exist
propagates to the database.                                                2: Create connection

First, the DataAccess object
receives an event from the                                                  3: Build get request

BLL to get open orders.                                                       4: Get request


Next, the DataAccess Layer                                                        5: Get open orders from database
creates a ‘Get’ request using                                                                                              6: Get open orders
the information supplied by
                                                             If connection is not being used.
the BLL.                                                                                                                   7: Request response
                                                                           8: Destroy connection

That request is sent to the
DatabaseAccess object,                                                                          9: Orders
where it uses the request to
retreive the information
from the database.

Finally, the DataAccess                            10: Orders
object packages the
information up into an
Order object, and returns it
to the BLL.
                    DataAccess Class


These are the
methods that the
BusinessLogic
Layer will use to
communicate with
the DataAccess
Layer
                             Menu Class

Both the BusinessLogic
Layer and the
DataAccessLayer will use
this class. The DataAccess
Layer will construct this
object when the
BusinessLogic Layer
requests to receive a menu
                       MenuItem Class

Both the BusinessLogic
Layer and the
DataAccessLayer will use
this class. The DataAccess
Layer will construct this
object when the
BusinessLogic Layer
requests to receive a
menu. The MenuItem
class will be part of the
Menu object.
                                  Order Class

Both the BusinessLogic Layer
and the DataAccessLayer will
use this class. The
BusinessLogic Layer will pass
this to the DataAccess Layer to
create an Order, and the
DataAccess Layer will pass this
to the BusinessLogic Layer
when the BusinessLogic Layer
requests an order
           CustomerOrder Class

Both the
BusinessLogic
Layer and the
DataAccessLayer
will use this class. A
list of
CustomerOrders
will be embedded in
the Order object.
            Database Schema
             Menu
             ItemID          Price            Description
             …               …                …




             CustomerOrderList
             CustomerOrderID         MenuItemList (CSV)
             …                       …




OrderList
OrderID      CustomerOrderList       OrderStatus            DeliveryMode
               Database Schema (cont)
                                              ItemID           Price      Description

                                              Small Pizza      9.99       Comes with cheese

CustomerOrderID    MenuItemList               Pepperone        .50
JDoe1              Small                      Medium Coke      1.25
                   Pizza,Pepperone,Sa
                   usage                      Large Salad      5.25       Comes with house
                                                                          dressing
JDoe2              Medium Coke
JDoe3              Large Salad
JQPublic1          Small Pizza




        OrderID           CustomerOrderList      OrderStatus   Delivery
                                                               Mode
        JDoe              JDoe1, JDoe2,          Open          Pick-up
                          JDoe3
        JQPublic          JQPublic1              Open          Delivery

								
To top