protected void GetSalesOrderById(string salesOrderId)
        {
            SalesOrderBLL salesOrder = new SalesOrderBLL();

            try
            {
                DataTable dt = salesOrder.GetSalesOrderById(salesOrderId);

                if (dt.Rows.Count > 0)
                {
                    orderIdLabel.Text = dt.Rows[0]["SalesOrderId"].ToString();
                    orderDateLabel.Text = dt.Rows[0]["OrderDate"].ToString();
                    salesPersonIdLabel.Text = dt.Rows[0]["SalesPersonId"].ToString();
                    salesPersonNameLabel.Text = dt.Rows[0]["SalesPersonName"].ToString();
                    salesCenterIdLabel.Text = dt.Rows[0]["SalesCenterId"].ToString();
                    salesCenterNameLabel.Text = dt.Rows[0]["SalesCenterName"].ToString();
                    customerIdLabel.Text = dt.Rows[0]["CustomerId"].ToString();
                    customerNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
                    customerContactNumberLabel.Text = dt.Rows[0]["CustomerContactNumber"].ToString();
                    customerAddressLabel.Text = dt.Rows[0]["CustomerAddress"].ToString();
                    narrationLabel.Text = dt.Rows[0]["Narration"].ToString();
                    statusLabel.Text = dt.Rows[0]["Status"].ToString();
                    transportTypeLabel.Text = dt.Rows[0]["TransportType"].ToString();
                    shippingAddressLabel.Text = dt.Rows[0]["ShippingAddress"].ToString();
                    billingAddressLabel.Text = dt.Rows[0]["BillingAddress"].ToString();
                    paymentModeLabel.Text = dt.Rows[0]["PaymentMode"].ToString();
                    chequeNumberLabel.Text = dt.Rows[0]["ChequeNumber"].ToString();
                    chequeDateLabel.Text = dt.Rows[0]["ChequeDate"].ToString();
                    bankLabel.Text = dt.Rows[0]["Bank"].ToString();
                    bankBranchLabel.Text = dt.Rows[0]["BankBranch"].ToString();
                    deliveryDateLabel.Text = dt.Rows[0]["DeliveryDate"].ToString();
                    lcNumberLabel.Text = dt.Rows[0]["LCNumber"].ToString();
                    transportDateLabel.Text = dt.Rows[0]["TransportDate"].ToString();
                    totalAmountLabel.Text = dt.Rows[0]["TotalAmount"].ToString();
                    vatLabel.Text = dt.Rows[0]["VAT"].ToString();
                    totalReceivableLabel.Text = dt.Rows[0]["TotalReceivable"].ToString();
                    receivedAmountLabel.Text = dt.Rows[0]["ReceivedAmount"].ToString();
                }
                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
            {
                salesOrder = null;
            }
        }