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),
)
go
create table tblPizzasize
(
dID int identity(1,1)primary key,
dSize varchar(15),
dPrice varchar (5),
)
go
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