Example #1
0
    public void AlmacenarMenu(int Id_u, DateTime Fecha, int Id_receta1, int Id_receta2
                              , int Id_receta3, int Id_receta4, int Id_receta5, int Id_receta6)
    //Realizamos la insercion en la BBDD de un menu
    {
        //Creamos el Adaptador de Tabla
        DataSet1TableAdapters.MenuTableAdapter adaptadorMenu = new DataSet1TableAdapters.MenuTableAdapter();

        adaptadorMenu.InsertQueryMenu(Fecha, Id_receta1, Id_receta2
                                      , Id_receta3, Id_receta4, Id_receta5, Id_receta6, Id_u);
    }
Example #2
0
        public static List<menu_items> GetMenu(int Rest_ID)
        {
            List<menu_items> menu_list = new List<menu_items>();
            DataSet1.MenuDataTable orders;
            DataSet1TableAdapters.MenuTableAdapter adapter = new DataSet1TableAdapters.MenuTableAdapter();
            orders = adapter.GetMenuById(Rest_ID);

            for (int i = 0; i < orders.Rows.Count; i++)
            {
                menu_items menuObj = new menu_items(Convert.ToInt32(orders[i][1]), (string)orders[i][2], (string)orders[i][3], (double)orders[i][4], (string)orders[i][5], (string)orders[i][6]);
                //convert my objects into JSON
                menu_list.Add(menuObj);
            }
            return menu_list;
        }
Example #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //creating table in ASP, really should create it in JS to stop the double query, but I'll do it l8r coz im lazy
            int rest = Convert.ToInt32(Request.QueryString["rest"]);
            DataSet1.MenuDataTable orders;
            //The query returns every column, but I only wanna use a few, so I declare those here
            DataSet1TableAdapters.MenuTableAdapter adapter = new DataSet1TableAdapters.MenuTableAdapter();
            orders = adapter.GetMenuById(rest);

            // Get groups
            List<string> tabs = new List<string>();

            for (int i = 0; i < orders.Rows.Count; i++)
            {
                // orders[i]["Category"];
                // Does item belong to new category
                if (!tabs.Contains(orders[i]["Category"]))
                {
                    // Add tab
                    tabs.Add(orders[i]["Category"].ToString());
                    tabsLit.Text += "<paper-tab>" + orders[i]["Category"] + "</paper-tab>";

                   // Add iron page div
                    HtmlGenericControl newDiv = new HtmlGenericControl("div");
                    newDiv.ID = orders[i]["Category"].ToString();
                    newDiv.Attributes["class"] += "menu-cat";
                    menuPH.Controls.Add(newDiv);
                }

                // Locate appropriate iron page div
                HtmlGenericControl foundDiv = (HtmlGenericControl)menuPH.FindControl(orders[i]["Category"].ToString());
                if (foundDiv != null)
                {
                    // Add menu item to div
                    foundDiv.InnerHtml += "<paper-card class=\"menu-item\" heading=\"" + orders[i]["Item_Name"] + "\" onclick=\"AddItem(" + i + ");\"><paper-ripple></paper-ripple><div class=\"card-content\">$" + String.Format("{0:0.00}", orders[i]["Price"]) + "</div></paper-card>";
                }
            }

            // Set title to current Restaurant name
            DataSet1TableAdapters.RestaurantTableAdapter nameLoader = new DataSet1TableAdapters.RestaurantTableAdapter();
            string restName = nameLoader.GetRestNameByID(rest);
            Master.restaurantNameBox.Text = restName;
        }
Example #4
0
 private DataSet1.MenuDataTable GetMenuById(int Rest_ID)
 {
     DataSet1TableAdapters.MenuTableAdapter adapter = new DataSet1TableAdapters.MenuTableAdapter();
         return adapter.GetMenuById(Rest_ID);
 }