Esempi in C# (CSharp) per JustPizza.sql PizzaDb.GetPizza

Esempio n. 1

        public List <PizzaMenu> GetMenu()
        {
            PizzaDb pizDb = new PizzaDb();

            string           menuCmd = "SELECT * FROM Menu";
            List <PizzaMenu> tmpMenu = new List <PizzaMenu>();

            DataTable menuDt = this.GetData(menuCmd);

            for (int i = 0; i < menuDt.Rows.Count; i++)
            {
                Pizza curPiz = pizDb.GetPizza(Int32.Parse(menuDt.Rows[i][1].ToString()));

                int menuid = Int32.Parse(menuDt.Rows[i][0].ToString());

                PizzaMenu pizMenu = new PizzaMenu(menuid, curPiz.Id, curPiz.Name, curPiz.Toppings);

                tmpMenu.Add(pizMenu);
            }

            return(tmpMenu);
        }