C# ASP.NET Program: Create ordering system for a restaurant.

The restaurant sells: Cheese Pizza, Stromboli, Hot Chicken Wings, BBQ Chicken Wings, Spaghetti Dinner, Salad.

Database component:

Customer: Id, first, last, street, city, state, zip, phone, phonetype

Orders: Id, custId, prod1Qty, prod2Qty, prod3Qty, prod4Qty, prod5Qty, prod6Qty, grandtotal

Forms:

Default.aspx- Make buttons that navigate to Customer Entry, View All Customers, Order Entry, View all Orders

CustomerEntry.aspx- The fields for customers entry are: First Name [text box], Last Name [text box], Street Address [text box],City [text box], State [text box], Zip Code[text box], Phone Number [text box], Phone Number Type [dropdown with the following selections, Choose a type, Home, Mobile.] When a customer is added they will be given an ID from the database and this will be their customer ID when they are viewed. Make a add button and clear button to clear the fields.

CustomerViewAll.aspx- This will show a table of all he customers. The columns will be customer id, first name, last name, street, city, state, zip, phone, phonetype.

OrderEntry.aspx- This will have a drop down to select a customer from the database. There will be a list of each of the foods that are sold with the price next to it and a text box for entering the quantity ordered. There will be a button for calculating the order total with tax(.08%), which will be displayed. Then there will be a button for submitting the order, which will add the order to the database.

OrderViewAll.aspx- This will show a table of all the orders. The columns will be id, customer id, customer first name, customer last name. order grand total.