Programming Homework Help

CSCI 4140 Dalhousie University Advanced Database Systems HTML Project

 

Client UI ( Requirements for A4 )
The client user is able to make a purchase order and to list the status for her/his company’s purchase orders. For the client
to make a purchase order:
The UI should enable a client user to:
 Log in and log out (simple credentials, consisting of username and password will suffice, wherein you may assume
that the client company name may serve as the username)
 Enter/insert a purchase order, including its lines.
 List the client’s purchase orders (without showing details of lines associated with a purchase order, but showing
the PO of information that applies to all lines (e.g., PO number and money owed by the company)).
 List details about a purchase order for which the client enters a PO number (status of the purchase order should be
shown also).
Further details on UI to fill-in and submit a PO include:
i. Input info about a purchase order (when available, this information should be prepared by the system automatically
using the client information stored in the DB (client agents need to be logged-in and hence the client company
information may be retrieved automatically the UI).
ii. Input information about purchase order lines, where the line numbers are filled in automatically by your software.
iii. For each line, after the part number is entered by the user, the system should automatically fill-in the purchase
price (retrieve currentPrice from the Parts table and store it in the field priceOrdered of the purchase order line).
iv. Once the agent is finished with inputting order lines, a message should be displayed that indicates whether the
purchase order was successfully placed (stored in the DB)