public bool Edit(IngredientRequestDetail ingredientRequest)
        {
            IngredientRequestDetail a = dt.IngredientRequestDetails.FirstOrDefault(t => t.IngredientRequestID == ingredientRequest.IngredientRequestID && t.IngredientID == ingredientRequest.IngredientID);

            a.Status = ingredientRequest.Status;
            dt.SubmitChanges();
            return(true);
        }
        private void btnHoaDon_Click(object sender, EventArgs e)
        {
            if (grDaMua.RowCount != 0)
            {
                for (int i = 0; i < grDaMua.RowCount; i++)
                {
                    if ((bool)grDaMua.GetRowCellValue(i, grDaMua.Columns["Status"]) == false)
                    {
                        break;
                    }
                    if (i == grDaMua.RowCount - 1)
                    {
                        return;
                    }
                }
                try
                {
                    OrderDetailDAO dt = new OrderDetailDAO();
                    TCIngredientRequestDetailDAO dc = new TCIngredientRequestDetailDAO();
                    OrderDetailDAO.ListTCOrderDetailViewModle.Clear();
                    for (int i = 0; i < grDaMua.RowCount; i++)
                    {
                        if ((bool)grDaMua.GetRowCellValue(i, grDaMua.Columns["Status"]) == false)
                        {
                            OrderDetail            a = new OrderDetail();
                            TCOrderDetailViewModle b = new TCOrderDetailViewModle();
                            a.IngredientID   = (int)grDaMua.GetRowCellValue(i, grDaMua.Columns["IngredientID"]);
                            a.QuantityOfUnit = (double)grDaMua.GetRowCellValue(i, grDaMua.Columns["Quantity"]);
                            b = dt.OrderDetailViewModle(a);
                            OrderDetailDAO.ListTCOrderDetailViewModle.Add(b);
                        }
                    }
                    FrThanhToanThucPham c = new FrThanhToanThucPham();
                    c.ShowDialog();
                    if (OrderDetailDAO.ThanhToan == true)
                    {
                        for (int i = 0; i < grDaMua.RowCount; i++)
                        {
                            if ((bool)grDaMua.GetRowCellValue(i, grDaMua.Columns["Status"]) == false)
                            {
                                //loại bỏ yêu cầu khi đã thực hiện
                                IngredientRequestDetail a1 = new IngredientRequestDetail();
                                a1.IngredientID        = (int)grDaMua.GetRowCellValue(i, grDaMua.Columns["IngredientID"]);
                                a1.IngredientRequestID = IngredienRequesID;
                                a1.Status = true;
                                dc.Edit(a1);
                            }
                        }
                        LoadIngredienRequesDetailBought(IngredienRequesID);
                    }


                    //nếu hoàn thành yêu cầu
                    if ((bool)grDaMua.GetRowCellValue((grDaMua.RowCount - 1), grDaMua.Columns["Status"]) == true && grChiTietYeuCau.RowCount == 0)
                    {
                        IngredientRequest a2 = new IngredientRequest();
                        a2.IngredientRequestID = IngredienRequesID;
                        a2.Status = true;
                        if (new TCIngredientRequestDAO().Edit(a2) == true)
                        {
                            MessageBox.Show("Đã hoàn thành yêu cầu");
                        }
                        else
                        {
                            MessageBox.Show("Chưa hoàn thành yêu cầu");
                        }
                    }
                }
                catch
                {
                }
            }
        }