protected void GetProductRequisitionProductListById(string productRequisitionId)
        {
            ProductRequisitionBLL productRequisition = new ProductRequisitionBLL();

            try
            {
                //Need to solve
                DataTable dt = productRequisition.GetProductRequisitionProductListById(productRequisitionId,"");

                if (dt.Rows.Count > 0)
                {
                    productRequisitionProductListGridView.DataSource = dt;
                    productRequisitionProductListGridView.DataBind();

                    if (productRequisitionProductListGridView.Rows.Count > 0)
                    {
                        productRequisitionProductListGridView.UseAccessibleHeader = true;
                        productRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
                    }
                }
                else
                {
                    msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
                }
            }
            catch (Exception ex)
            {
                msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                productRequisition = null;
            }
        }
        protected void GetProductRequisitionProductListById(string productRequisitionId, string reqType)
        {
            ProductRequisitionBLL productRequisition = new ProductRequisitionBLL();

            try
            {
                DataTable dt = productRequisition.GetProductRequisitionProductListById(productRequisitionId, reqType);

                if (dt.Rows.Count > 0)
                {
                    productRequisitionProductListGridView.DataSource = dt;
                    productRequisitionProductListGridView.DataBind();

                    if (productRequisitionProductListGridView.Rows.Count > 0)
                    {
                        approveButton.Enabled = true;
                        productRequisitionProductListGridView.UseAccessibleHeader = true;
                        productRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;

                        TextBox approveQuantityTextBox;

                        for (int i = 0; i < productRequisitionProductListGridView.Rows.Count; i++)
                        {
                            approveQuantityTextBox = (TextBox)productRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox");
                            //approveQuantityTextBox.Text = productRequisitionProductListGridView.Rows[i].Cells[3].Text.ToString();
                            approveQuantityTextBox.Text = dt.Rows[i][3].ToString();
                        }
                    }
                    else
                    {
                        approveButton.Enabled = false;
                    }
                }
                else
                {
                    msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
                }
            }
            catch (Exception ex)
            {
                msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                productRequisition = null;
            }
        }