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);
}
}
