I need help creating a view that will display the pizza size and the toppings. I got both in a SQL table. They need to be selected by using a checkbox. Then when they are done designing the pizza, they need to press a button that will redirect them to the checkout page where they can review their order.
create table tblIntgredients
dID int identity(1,1) primary key,
dIngredient varchar (25),
dCost decimal (25),
create table tblPizzasize
dID int identity(1,1)primary key,
dPrice varchar (5),
Now, How can I display the Ingredient name with the price, and how can I display the size with the price?( got a model for each of these tables)
Then, how can I make a shopping cart model that will fit these two models? How can I add the selected items to the cart for checkout? If anyone can help me, it will be much appreciated.
What I have tried:
I tried following book tutorials and youtube tutorials, but they are hard to follow as they only do one table and I need two tables. Some of the tutorials are hard to follow because they don't explain. Or I have a hard time implementing my code like they are