C# Program

Customer/Item ASP .NET Ordering System

In this project, youre going to create an ordering system for a restaurant. The system will be for the workers at the restaurant so only they will see the application. Imagine that its the employee answering the phones.

Your restaurant sells six items. No substitutions. Cheese Pizza,

Stromboli, Hot Chicken Wings (dozen), BBQ Chicken Wings (dozen) Spaghetti Dinner Salad

This system will have seven screens.

1) Default.asx (Welcome screen for the app. Set this as the start page.) 2) CustomerEntryScreen 3) Customer View All (List to select from) 4) Customer View One Screen (When a selection is made from View All Customers Screen) 5) Order Entry Screen

6) Order View All 7) Order View One Screen (When a selection is made from the View All Orders Screen)

There is a database component to this project. Make two tables:

Customer

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

Orders

Id, custId, orderdate, ordertime, prod1Qty, prod2Qty, prod3Qty, prod4Qty, prod5Qty, prod6Qty, subtotal, taxAmt, grandtotal

Inside of the prod1Qty field will be how many of product 1 (lets say cheese pizza) the customer

ordered in that order. Simple. Then you wont need composite or bridge tables.

Screens:

Default.aspx

This will be the entry point for the application and will give a little description about your restaurant. Make up all this stuff. Have fun with it. Put some pics up there and say stuff like Just like mama used to make...

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.] The fields in red are required fields. 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. Let it be the auto-incremented number the database starts with, probably 1.

There will be an add customer button and a clear button to clear the form. When they press the add customer button validate the form fields to make sure all of the data has been entered. If data is missing tell them what is missing and dont add the record. If the data is complete then add the data to the database clearing the fields so another customer can be added.

CustomerViewAll.aspx:

This page will show a table or gridview of all of the customers (with the following columns, customer id,first name, last name) and some way for the user to select a row or customer which will then redirect to the Customer View Screen which will get that customer from the database and display all of the customer information. Pass the id through the URL and when you get to the Customer View page use that to query the database.

If no customers have been added then hide the grid and tell the user that no customers have been added.

Customer View Screen will only be accessible from the Customer View All screen when you choose a row. Dont put a button or link to this page on your navigation.

OrderEntry.aspx:

The fields for orders entry will be: Customer ID: Customer First Name Customer Last Name, (From a drop down populated from the Database, Value=customer id, text=customer id: First and Last Name), There will be the six items (with pictures, description, and price) and a quantity text box for each. Initially set the quantity for each item to 0. There will be a calculate order button and finally a submit order button which will initially be disabled. The calculate order button when pressed will somehow display on the page the order total, tax (.08%) and the order grand total (subtotal plus tax). When the user presses the calculate order button you will validate that the user has selected at least one item and if they havent you will tell the user that they need to add

at least one item. If they have added at least one of any item then the submit order button will be enabled and when they press the button you will add the order to the database, clear out all of the errors and fields and allow the user to enter another order.

When you add the order also add the date and time it was created.

OrderViewAll.aspx:

This screen is like the customers view all screen. The fields to show in the grid will be order date, time, id, customer id, and order grand total. When they select a row redirect them to the Order View screen to view all of the order details either in text boxes that are read only or in a neatly formatted way. Dont include a link to this page from your navigation.

If no orders have been added then hide the grid and tell the user that no orders have been added.

OrderView.aspx

This is the page that will display all of the details for the order including customer id, full name, items ordered (quantities) order date, time, subtotal, tax, grand total.

Notice that you have to show the order details and the customer full name. That means two different database queries, or a join on customer ID for the result set. Hmmm....

Navigation:

The navigation can be links or buttons. There will only be four buttons/links

Customer Entry

View All Customers

Order Entry

View all Orders

Diagram:

Ths site should have a Master page with the links CustomerEntry.aspx, CustomerViewAll.aspx OrderEntry.aspx, and OrderViewAll.aspx that applyes to all the pages. Default.aspx CustomerEntry.aspx CustomerViewAll.aspx OrderEntry.aspx OrderViewAll.aspx CustomerOrderView.aspx OrderView.aspx This page will have buttons on each record on the grid or table that with redirect to Cus where it will display the customer's info based on that specific customer ID This page will have buttons on each record on the grid or table that with redirect to OrderView,aspx where it wil display the order info based on that specific order ID aspx, Ths site should have a Master page with the links CustomerEntry.aspx, CustomerViewAll.aspx OrderEntry.aspx, and OrderViewAll.aspx that applyes to all the pages. Default.aspx CustomerEntry.aspx CustomerViewAll.aspx OrderEntry.aspx OrderViewAll.aspx CustomerOrderView.aspx OrderView.aspx This page will have buttons on each record on the grid or table that with redirect to Cus where it will display the customer's info based on that specific customer ID This page will have buttons on each record on the grid or table that with redirect to OrderView,aspx where it wil display the order info based on that specific order ID aspx