90 likes | 174 Views
DataAccess Layer Class Diagrams. Matt Hinds Paul Lagasse Matt Menard CS509 4/11/06. Retreiving Orders from the Database. This sequence shows how the BusinessLogic Layer (BLL) receives open orders from the DataAccess Layer, and how that event propagates to the database.
E N D
DataAccess Layer Class Diagrams Matt Hinds Paul Lagasse Matt Menard CS509 4/11/06
Retreiving Orders from the Database This sequence shows how the BusinessLogic Layer (BLL) receives open orders from the DataAccess Layer, and how that event propagates to the database. First, the DataAccess object receives an event from the BLL to get open orders. Next, the DataAccess Layer creates a ‘Get’ request using the information supplied by the BLL. That request is sent to the DatabaseAccess object, where it uses the request to retreive the information from the database. Finally, the DataAccess 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