public void pricePerPortion() { DBConnect db = new DBConnect(); cmd = db.con.CreateCommand(); //MessageBox.Show(cmbItemName.SelectedItem.ToString()); string slctName = "SELECT Price_Per_Portion FROM menu_items WHERE Portion = '" + cmbPortion.SelectedItem.ToString() + "'"; cmd = new MySqlCommand(slctName, db.con); MySqlDataReader dr; try { dr = cmd.ExecuteReader(); while (dr.Read()) { txtPricePerPortion.Text = dr.GetInt32("Price_Per_Portion").ToString(); } db.con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void displayMenuID() { DBConnect db = new DBConnect(); cmd = db.con.CreateCommand(); //MessageBox.Show(cmbItemName.SelectedItem.ToString()); string slctName = "SELECT Menu_ID FROM menu_items WHERE Item = '" + cmbMenu.SelectedItem.ToString() + "'"; cmd = new MySqlCommand(slctName, db.con); MySqlDataReader dr; try { dr = cmd.ExecuteReader(); while (dr.Read()) { txtMenuId.Text = dr.GetInt32("Menu_ID").ToString(); } db.con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void fillItemCode() { DBConnect db = new DBConnect(); cmd = db.con.CreateCommand(); //MessageBox.Show(cmbItemName.SelectedItem.ToString()); string slctName = "SELECT ID FROM inventory WHERE Name = '" + cmbItemName.SelectedItem.ToString() + "'"; cmd = new MySqlCommand(slctName, db.con); MySqlDataReader dr; try { dr = cmd.ExecuteReader(); while (dr.Read()) { txtItemCode.Text = dr.GetInt32("ID").ToString(); } db.con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void fillRemQty() { DBConnect db = new DBConnect(); cmd = db.con.CreateCommand(); string slctRemQty = "SELECT Remaining_Quantity FROM inventory WHERE ID = '" + txtItemCode.Text + "'"; cmd = new MySqlCommand(slctRemQty, db.con); MySqlDataReader dr; try { dr = cmd.ExecuteReader(); while (dr.Read()) { nudQtyUpdate.Value = dr.GetInt32("Remaining_Quantity"); } db.con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }