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