private void LoadControls(SqlInt32 CustomerID)
    {
        CustomerENT entCustomer = new CustomerENT();
        CustomerBAL balCustomer = new CustomerBAL();

        entCustomer = balCustomer.SelectByPK(CustomerID);

        if (!entCustomer.CustomerName.IsNull)
        {
            txtCustomerName.Text = entCustomer.CustomerName.Value.ToString();
        }

        if (!entCustomer.MobileNo.IsNull)
        {
            txtMobileNo.Text = entCustomer.MobileNo.Value.ToString();
        }

        if (!entCustomer.Address.IsNull)
        {
            txtCustomerAddress.Text = entCustomer.Address.Value.ToString();
        }

        if (!entCustomer.BranchID.IsNull)
        {
            ddlBranchID.SelectedValue = entCustomer.BranchID.Value.ToString();
        }

        if (!entCustomer.DistributorID.IsNull)
        {
            ddlDistributorID.SelectedValue = entCustomer.DistributorID.Value.ToString();
        }

        if (!entCustomer.ProductID.IsNull)
        {
            ddlProductID.SelectedValue = entCustomer.ProductID.Value.ToString();
        }

        if (!entCustomer.Quantity.IsNull)
        {
            txtQuantity.Text = entCustomer.Quantity.Value.ToString();
        }

        if (!entCustomer.BottlePrice.IsNull)
        {
            txtAmount.Text = entCustomer.BottlePrice.Value.ToString();
        }
    }
    private void LoadControls(SqlInt32 CustomerID)
    {
        CustomerENT entCustomer = new CustomerENT();
        CustomerBAL balCustomer = new CustomerBAL();

        entCustomer = balCustomer.SelectByPK(CustomerID);

        if (!entCustomer.CustomerName.IsNull)
        {
            txtCustomerName.Text = entCustomer.CustomerName.Value.ToString();
        }
        if (!entCustomer.EmailID.IsNull)
        {
            txtEmailAddress.Text = entCustomer.EmailID.Value.ToString();
        }
        if (!entCustomer.MobileNo.IsNull)
        {
            txtMobileNo.Text = entCustomer.MobileNo.Value.ToString();
        }
        if (!entCustomer.Address.IsNull)
        {
            txtAddress.Text = entCustomer.Address.Value.ToString();
        }
    }