public void ShowPendingOrder()
    {
        Object    OrderPending = new Object();
        DataTable dt           = BSLAYER.PendingOrder(OrderPending);

        DdlOrder.DataSource     = dt;
        DdlOrder.DataTextField  = "Order_Id";
        DdlOrder.DataValueField = "Order_Id";
        DdlOrder.DataBind();
        DdlOrder.Items.Insert(0, "Select Pending Orders");
    }
 protected void BtnDelete_Click(object sender, EventArgs e)
 {
     //here we delete the unwaned orders from transaction-details,order-details,order-list//
     DeleteTransaction();
     DeleteOrderDetails();
     DeleteOrderList();
     TxtEmail.Text  = "";
     TxtName.Text   = "";
     TxtPhone.Text  = "";
     TxtAmount.Text = "";
     TxtDate.Text   = "";
     TxtTime.Text   = "";
     TxtStatus.Text = "";
     DdlOrder.ClearSelection();
 }
 protected void BtnStatus_Click(object sender, EventArgs e)
 {
     //here we update the delivery statuswhich was pending//
     StatusUpdate();
     PanelAlert.Visible = true;
     SendAcknowledge();
     TxtEmail.Text  = "";
     TxtName.Text   = "";
     TxtPhone.Text  = "";
     TxtAmount.Text = "";
     TxtDate.Text   = "";
     TxtTime.Text   = "";
     TxtStatus.Text = "";
     DdlOrder.ClearSelection();
 }