protected void btnSubmit_Click(object sender, EventArgs e)
        {
            Models.MenuItemModel menuItemModel = new Models.MenuItemModel();

            MenuItem menuItem = CreateMenuItem();

            lblResult.Text = menuItemModel.InsertMenuItem(menuItem);
        }
        private void FillPage()
        {
            //Get a list of all menu items in DB
            Models.MenuItemModel menuItemModel = new Models.MenuItemModel();
            List <MenuItem>      menuItems     = menuItemModel.GetAllMenuItems();

            //Make sure menu items exist in DB
            if (menuItems != null)
            {
                //Create new panel with labels for each item
                foreach (MenuItem menuItem in menuItems)
                {
                    Panel MenuItemPanel = new Panel();
                    Label lblName       = new Label();
                    Label lblPrice      = new Label();

                    //set child control preoperties (no images for now)
                    lblName.Text     = menuItem.MenuItemName;
                    lblName.CssClass = "itemName";

                    lblPrice.Text     = "R " + menuItem.MenuItemPrice;
                    lblPrice.CssClass = "itemPrice";

                    //Add child controls to panels
                    MenuItemPanel.Controls.Add(lblName);
                    MenuItemPanel.Controls.Add(new Literal {
                        Text = "<br />"
                    });
                    MenuItemPanel.Controls.Add(lblPrice);

                    //Add dynamic panels to static parent panel
                    PnllMenuItems.Controls.Add(MenuItemPanel);
                }
            }
            else
            {
                //no product found
                PnllMenuItems.Controls.Add(new Literal {
                    Text = "No products found!"
                });
            }
        }
        private void FillPage()
        {
            //Get selected products data
            if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
            {
                int id = Convert.ToInt32(Request.QueryString["id"]);
                Models.MenuItemModel menuItemModel = new Models.MenuItemModel();
                MenuItem             menuItem      = menuItemModel.GetMenuItem(id);

                //Fill page with data
                lblprice.Text = "R " + menuItem.MenuItemPrice;
                lblTitle.Text = menuItem.MenuItemName;
                //lblDescription - - - -
                lblItemNumber.Text = id.ToString();
                //image of menu item here

                //Fill Amount Drop Down List with numbers to 1-10
                int[] amount = Enumerable.Range(1, 10).ToArray();
                ddlAmount.DataSource           = amount;
                ddlAmount.AppendDataBoundItems = true;
                ddlAmount.DataBind();
            }
        }