private void btnSetMeal_Click(object sender, EventArgs e)
{
using (dialogGetSetMeal d = new dialogGetSetMeal())
{
if (d.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
dish set = d.getDish();
dgvOrder.Rows.Add(set.getId(), 1, set.getName(), set.getOtherName(), "", set.getPrice());
dgvOrder.Rows[dgvOrder.Rows.Count - 1].DefaultCellStyle.BackColor = Color.GreenYellow;
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
SqlCommand getSetDish = new SqlCommand("GetSetDish", sqlCon);
getSetDish.CommandType = CommandType.StoredProcedure;
getSetDish.Parameters.AddWithValue("@setId", set.getId());
using (SqlDataReader reader = getSetDish.ExecuteReader())
{
while (reader.Read())
{
dgvOrder.Rows.Add(reader["dishNo"].ToString(), reader["QTY"].ToString(), reader["foodName"].ToString(),
reader["foodOtherName"].ToString(), "", reader["price"].ToString());
dgvOrder.Rows[dgvOrder.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Gold;
}
}
sqlCon.Close();
}
lblTotal.Text = "£ " + calculateTotal();
}
}
}
private void btnAddDish_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(lblDishName.Text))
{
MessageBox.Show("Please select a dish use Get Dish button", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else if (Convert.ToInt32(txtQTY.Text) < 1)
{
MessageBox.Show("Please set Quantity of dish", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
bool repeate = false;
foreach (DataGridViewRow row in dgvSetDish.Rows)
{
if ((int)row.Cells[0].Value == food.getId())
{
row.Cells[3].Value = txtSetDishPrice.Text;
row.Cells[4].Value = txtQTY.Text;
repeate = true;
break;
}
}
if (!repeate)
{
if (dgvSetDish.DataSource == null)
{
dgvSetDish.Rows.Add(food.getId(), lblDishName.Text, lblDishOther.Text, txtSetDishPrice.Text, txtQTY.Text);
}
else
{
DataRow r = dt.NewRow();
r["dishNo"] = food.getId();
r["foodName"] = lblDishName.Text;
r["foodOtherName"] = lblDishOther.Text;
r["price"] = txtSetDishPrice.Text;
r["QTY"] = txtQTY.Text;
dt.Rows.Add(r);
}
}
}
}