protected void SetContextToNewCustomer()
        {
            SearchCustomerPanel.Visible = false;
            CustomerIDPanel.Visible     = false;

            CustomerID.Text = String.Empty;
            FirstName.Text  = String.Empty;
            LastName.Text   = String.Empty;
            EMail.Text      = String.Empty;
            Phone.Text      = String.Empty;
            RadioButtonList1.SelectedIndex = 0;
            Over13.Checked = true;

            BillingFirstName.Text = String.Empty;
            BillingLastName.Text  = String.Empty;
            BillingPhone.Text     = String.Empty;
            BillingCompany.Text   = String.Empty;
            BillingResidenceType.ClearSelection();
            BillingResidenceType.SelectedIndex = 1;
            BillingAddress1.Text = String.Empty;
            BillingAddress2.Text = String.Empty;
            BillingSuite.Text    = String.Empty;
            BillingCity.Text     = String.Empty;
            BillingState.ClearSelection();
            BillingState.SelectedIndex = 0;
            BillingZip.Text            = String.Empty;
            BillingCountry.ClearSelection();
            BillingCountry.SelectedIndex = 0;

            ShippingFirstName.Text = String.Empty;
            ShippingLastName.Text  = String.Empty;
            ShippingPhone.Text     = String.Empty;
            ShippingCompany.Text   = String.Empty;
            ShippingResidenceType.ClearSelection();
            ShippingResidenceType.SelectedIndex = 1;
            ShippingAddress1.Text = String.Empty;
            ShippingAddress2.Text = String.Empty;
            ShippingSuite.Text    = String.Empty;
            ShippingCity.Text     = String.Empty;
            ShippingCountry.ClearSelection();
            ShippingCountry.SelectedIndex = -1;
            ShippingState.ClearSelection();
            ShippingState.SelectedIndex = -1;
            ShippingZip.Text            = String.Empty;

            try
            {
                AffiliateList.SelectedIndex = -1;
                AffiliateList.ClearSelection();
            }
            catch { }
            try
            {
                CustomerLevelList.SelectedIndex = -1;
                CustomerLevelList.ClearSelection();
            }
            catch { }

            CreateCustomer.Visible         = true;
            UseCustomer.Visible            = false;
            UpdateCustomer.Visible         = false;
            CreateNewCustomerPanel.Visible = true;
            CustomerStatsPanel.Visible     = false;
            ImpersonationPanel.Visible     = false;
            Panel3.Visible = false;
            Panel2.Visible = false;
        }
        protected void SetContextToCustomerID(int iCustomerID)
        {
            CustomerID.Text = iCustomerID.ToString();
            using (SqlConnection conn = DB.dbConn())
            {
                conn.Open();
                using (IDataReader rs = DB.GetRS("select * from Customer  with (NOLOCK)  where deleted=0 and IsAdmin=0 and CustomerID=" + iCustomerID.ToString(), conn))
                {
                    if (rs.Read())
                    {
                        FirstName.Text = DB.RSField(rs, "FirstName");
                        LastName.Text  = DB.RSField(rs, "LastName");
                        EMail.Text     = DB.RSField(rs, "EMail").ToLowerInvariant().Trim();
                        Phone.Text     = DB.RSField(rs, "Phone");
                        Over13.Checked = DB.RSFieldBool(rs, "Over13Checked");
                        RadioButtonList1.SelectedIndex = CommonLogic.IIF(DB.RSFieldBool(rs, "OkToEMail"), 0, 1);

                        Address BillingAddress = new Address();
                        BillingAddress.LoadByCustomer(iCustomerID, AddressTypes.Billing);
                        BillingFirstName.Text = BillingAddress.FirstName;
                        BillingLastName.Text  = BillingAddress.LastName;
                        BillingPhone.Text     = BillingAddress.Phone;
                        BillingCompany.Text   = BillingAddress.Company;
                        try
                        {
                            BillingResidenceType.ClearSelection();
                            if (BillingAddress.ResidenceType != ResidenceTypes.Unknown)
                            {
                                BillingResidenceType.Items.FindByValue(((int)BillingAddress.ResidenceType).ToString()).Selected = true;
                            }
                        }
                        catch { }
                        BillingAddress1.Text = BillingAddress.Address1;
                        BillingAddress2.Text = BillingAddress.Address2;
                        BillingSuite.Text    = BillingAddress.Suite;
                        BillingCity.Text     = BillingAddress.City;
                        try
                        {
                            BillingState.SelectedIndex = -1;
                            BillingState.ClearSelection();
                            BillingState.Items.FindByValue(BillingAddress.State).Selected = true;
                        }
                        catch { }
                        BillingZip.Text = BillingAddress.Zip;
                        try
                        {
                            BillingCountry.SelectedIndex = -1;
                            BillingCountry.ClearSelection();
                            BillingCountry.Items.FindByValue(BillingAddress.Country).Selected = true;
                        }
                        catch { }

                        Address ShippingAddress = new Address();
                        ShippingAddress.LoadByCustomer(iCustomerID, AddressTypes.Shipping);
                        ShippingFirstName.Text = ShippingAddress.FirstName;
                        ShippingLastName.Text  = ShippingAddress.LastName;
                        ShippingPhone.Text     = ShippingAddress.Phone;
                        ShippingCompany.Text   = ShippingAddress.Company;
                        try
                        {
                            ShippingResidenceType.ClearSelection();
                            if (ShippingAddress.ResidenceType != ResidenceTypes.Unknown)
                            {
                                ShippingResidenceType.Items.FindByValue(((int)ShippingAddress.ResidenceType).ToString()).Selected = true;
                            }
                        }
                        catch { }
                        ShippingAddress1.Text = ShippingAddress.Address1;
                        ShippingAddress2.Text = ShippingAddress.Address2;
                        ShippingSuite.Text    = ShippingAddress.Suite;
                        ShippingCity.Text     = ShippingAddress.City;
                        try
                        {
                            ShippingState.SelectedIndex = -1;
                            ShippingState.ClearSelection();
                            ShippingState.Items.FindByValue(ShippingAddress.State).Selected = true;
                        }
                        catch { }
                        ShippingZip.Text = ShippingAddress.Zip;
                        try
                        {
                            ShippingCountry.SelectedIndex = -1;
                            ShippingCountry.ClearSelection();
                            ShippingCountry.Items.FindByValue(ShippingAddress.Country).Selected = true;
                        }
                        catch { }
                        try
                        {
                            AffiliateList.SelectedIndex = -1;
                            AffiliateList.ClearSelection();
                            AffiliateList.Items.FindByValue(DB.RSFieldInt(rs, "AffiliateID").ToString()).Selected = true;
                        }
                        catch { }
                        try
                        {
                            CustomerLevelList.SelectedIndex = -1;
                            CustomerLevelList.ClearSelection();
                            CustomerLevelList.Items.FindByValue(DB.RSFieldInt(rs, "CustomerLevelID").ToString()).Selected = true;
                        }
                        catch { }
                    }
                }
            }
        }