protected void GetProductTransferRequisitionProductListById(string transferRequisitionId)
        {
            ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL();

            try
            {
                DataTable dt = productTransferRequisition.GetProductTransferRequisitionProductListById(transferRequisitionId);

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

                    if (productTransferRequisitionProductListGridView.Rows.Count > 0)
                    {
                        productTransferRequisitionProductListGridView.UseAccessibleHeader = true;
                        productTransferRequisitionProductListGridView.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
            {
                productTransferRequisition = null;
            }
        }
        protected void GetProductTransferRequisitionProductListById(string transferRequisitionId)
        {
            ProductTransferRequisitionBLL productTransferRequisition = new ProductTransferRequisitionBLL();

            try
            {
                DataTable dt = productTransferRequisition.GetProductTransferRequisitionProductListById(transferRequisitionId);

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

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

                        TextBox approveQuantityTextBox;

                        for (int i = 0; i < productTransferRequisitionProductListGridView.Rows.Count; i++)
                        {
                            approveQuantityTextBox = (TextBox)productTransferRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox");
                            //approveQuantityTextBox.Text = productTransferRequisitionProductListGridView.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
            {
                productTransferRequisition = null;
            }
        }