protected void GetPendingOrderList()
        {
            PurchaseOrderBLL purchaseOrder = new PurchaseOrderBLL();

            try
            {
                DataTable dt = purchaseOrder.GetPendingPurchaseOrdersListByWarehouse(warehouseDropDownList.SelectedValue.Trim());

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

                if (pendingPurchaseOrderListGridView.Rows.Count > 0)
                {
                    pendingPurchaseOrderListGridView.UseAccessibleHeader = true;
                    pendingPurchaseOrderListGridView.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
            {
                purchaseOrder = null;
            }
        }
        protected void pendingOrderListButton_Click(object sender, EventArgs e)
        {
            PurchaseOrderBLL purchaseOrder = new PurchaseOrderBLL();

            try
            {
                if (warehouseDropDownList.SelectedValue == "")
                {
                    msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Warehouse Name field is required.";
                }
                else
                {
                    string warehouseId = warehouseDropDownList.SelectedValue.Trim();

                    DataTable dt = purchaseOrder.GetPendingPurchaseOrdersListByWarehouse(warehouseId);

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

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