Travel Experts WinForms Workshop

Our Workshop 4 project and Tasks. We will check them off once we know we have completed them. Please put your name beside the stuff you do, on this file and in the code. Thanks!

Travel Experts Admin Page (if there is time, we can add a users/login page)

Manage Packages

• Edit
• Add
• Delete
• (Package ID/Package Name/ Info/ Commission/etc)
• (Package Id/ ProductSupplierID)

Manage Products

• Add products (Product ID/ProdName)
• Edit products
• Delete

Manage Supplier

• Add supplier
• Edit supplier
• Delete
• (SupplierContactID/Name/Company/Address/etc)
• (SupplierID/SupplierName)

Validations

• Agency Commission cannot be greater than the Base Price
• Package End Date must be later than the Package Start Date
• Package Name and package Description cannot be null
• If time, add validations for numbers/letters/zipcode etc

OTHER TABLES USED IN PROJECT IGNORE FOR NOW

Products/Suppliers

• (ProductSupplier ID/ProductID/SupplierID)

Packages/Products/Suppliers

• (PackageID/ProductSupplierID)