// placing orders // this populates the menu for the selected restaurant #region Bind Menu GridView private void BindMenuGridView(string restaurant) { DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["OrderistaConnectionString"].ConnectionString); try { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT RestaurantName, Name, Price FROM Menu_Items WHERE Visible = 1 AND InStock = 1 AND RestaurantName = @restaurant"); cmd.Parameters.AddWithValue("@restaurant", restaurant); cmd.Connection = connection; SqlDataAdapter sqlData = new SqlDataAdapter(cmd); sqlData.Fill(dt); if (dt.Rows.Count > 0) { MenuGridView.DataSource = dt; MenuGridView.DataBind(); } } catch (SqlException ex) { string msg = "Fetch Error: "; msg += ex.Message; throw new Exception(msg); } finally { connection.Close(); } } // BindMenuGridView
internal void SelectMenuEntry(string ipAddressString) { int noOfUsers = SocketCommService.GetUserInfoCount(); while (SendMenuSourceDataTable.Rows.Count < noOfUsers) { //Wait Thread.Sleep(100); } string filterExpression = string.Format("{0} = '{1}'", IPAddress, ipAddressString); DataRow[] dataRows = SendMenuSourceDataTable.Select(filterExpression); if (dataRows == null || dataRows.Length == 0) { return; } MenuGridView.ClearSelection(); foreach (DataRow dataRow in dataRows) { foreach (DataGridViewRow dataGridViewRow in MenuGridView.Rows) { if ((dataGridViewRow.DataBoundItem as DataRowView).Row == dataRow) { dataGridViewRow.Selected = true; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MenuController controller = new MenuController(); var stuff = controller.GetRestaurantMenu(); MenuGridView.DataSource = stuff; MenuGridView.DataBind(); MenuRepeter.DataSource = stuff; MenuRepeter.DataBind(); } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { clicknumb++; if (clicknumb % 2 != 0) { MainWindow.form.Width = 463; MainWindow.form.Height = 689; } else { MainWindow.form.Width = 463; MainWindow.form.Height = 480; } MenuGridView.Refresh(); }
private void AddBTN_Click(object sender, EventArgs e) { string name = NameBox?.Text; string type = TypeBox.selectedValue?.ToString(); int ID = new int(); double price = new double(); try { price = double.Parse(PriceBox.Text); ID = int.Parse(IDBox.Text); } catch (Exception) { cMessageBox.Show("პროდუქტი ვერ დაემატა!"); } bool yesorno = false; foreach (var item in Menu.MenuItems) { if (name == item.Name) { yesorno = true; } } if (yesorno == false) { if (name != null && price != 0 && type != null && ID != 0) { Menu.AddInMenu(new MenuItem(NameBox.Text, price, type, ID)); cMessageBox.Show("პროდუქტი დაემატა!"); MenuGridView.Refresh(); NameBox.Text = ""; PriceBox.Text = ""; IDBox.Text = ""; TypeBox.Text = ""; } } else { cMessageBox.Show("მსგავსი პროდუქტი დამატებულია!"); } }