protected void GetPurchaseRequisitionsApprovalListByWarehouse(string warehouseId)
        {
            PurchaseRequisitionBLL purchaseRequisition = new PurchaseRequisitionBLL();

            try
            {
                DataTable dt = purchaseRequisition.GetPurchaseRequisitionsApprovalListByWarehouse(warehouseId);

                purchaseRequisitionApprovalListGridView.DataSource = dt;
                purchaseRequisitionApprovalListGridView.DataBind();

                if (purchaseRequisitionApprovalListGridView.Rows.Count > 0)
                {
                    purchaseRequisitionApprovalListGridView.UseAccessibleHeader = true;
                    purchaseRequisitionApprovalListGridView.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
            {
                purchaseRequisition = null;
            }
        }