Ejemplo n.º 1
0
        private void SetShippingStateList(string shippingCountry)
        {
            string sql = String.Empty;

            if (shippingCountry.Length > 0)
            {
                sql = "select s.* from dbo.State s  with (NOLOCK)  join dbo.country c on s.countryid = c.countryid where c.name = " + DB.SQuote(shippingCountry) + " order by s.DisplayOrder,s.Name";
            }
            else
            {
                sql = "select * from dbo.State   with (NOLOCK)  where countryid = 222 order by DisplayOrder,Name";
            }

            using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
            {
                con.Open();
                using (IDataReader rs = DB.GetRS(sql, con))
                {
                    ShippingState.DataSource     = rs;
                    ShippingState.DataTextField  = "Name";
                    ShippingState.DataValueField = "Abbreviation";
                    ShippingState.DataBind();
                }
            }

            if (ShippingState.Items.Count == 0)
            {
                ShippingState.Items.Insert(0, new ListItem("state.countrywithoutstates".StringResource(), "--"));
                ShippingState.SelectedIndex = 0;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Response.CacheControl = "private";
            Response.Expires      = 0;
            Response.AddHeader("pragma", "no-cache");

            /****************************************************************************/
            // * WARNING TO DEVELOPERS
            // * The redirect below is a SAFETY feature.  Removing the redirect will not
            // * enable ML-only features on a lower version of AspDotNetStorefront.
            // * Attempting to do so can very easily result in a partially implemented
            // * feature, invalid or incomplete data in your DB, and other serious
            // * conditions that will cause your store to be non-functional.
            // *
            // * If you break your store attempting to enable ML-only features in PRO or
            // * Standard, our staff cannot help you fix it, and it will also invalidate
            // * your AspDotNetStorefront License.
            /***************************************************************************/

            if (AppLogic.ProductIsMLExpress())
            {
                Response.Redirect(AppLogic.AdminLinkUrl("restrictedfeature.aspx"));
            }

            m_OrderNumber = CommonLogic.QueryStringUSInt("OrderNumber");
            GetJavaScriptFunctions();

            if (!IsPostBack)
            {
                saveOrderNumber.Text = m_OrderNumber.ToString();
                if (AppLogic.AppConfigBool("PhoneOrder.EMailIsOptional"))
                {
                    valRegExValEmail.Enabled = false;
                }
                BillingState.ClearSelection();
                BillingState.Items.Clear();
                ShippingState.ClearSelection();
                ShippingState.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from State  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        ShippingState.DataValueField = "Abbreviation";
                        ShippingState.DataTextField  = "Name";
                        ShippingState.DataSource     = rs;
                        ShippingState.DataBind();
                    }
                }

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from State  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        BillingState.DataValueField = "Abbreviation";
                        BillingState.DataTextField  = "Name";
                        BillingState.DataSource     = rs;
                        BillingState.DataBind();
                    }
                }

                ShippingCountry.ClearSelection();
                ShippingCountry.Items.Clear();
                BillingCountry.ClearSelection();
                BillingCountry.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from Country  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        ShippingCountry.DataValueField = "Name";
                        ShippingCountry.DataTextField  = "Name";
                        ShippingCountry.DataSource     = rs;
                        ShippingCountry.DataBind();
                    }
                }

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from Country  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        BillingCountry.DataValueField = "Name";
                        BillingCountry.DataTextField  = "Name";
                        BillingCountry.DataSource     = rs;
                        BillingCountry.DataBind();
                    }
                }

                AffiliateList.ClearSelection();
                AffiliateList.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select AffiliateID,Name,DisplayOrder from Affiliate  with (NOLOCK)  union select 0,'--N/A--', 0 from Affiliate  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        AffiliateList.DataSource = rs;
                        AffiliateList.DataBind();
                        if (AffiliateList.Items.Count == 0)
                        {
                            AffiliateList.Visible   = false;
                            AffiliatePrompt.Visible = false;
                        }
                    }
                }

                CustomerLevelList.ClearSelection();
                CustomerLevelList.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader dr = DB.GetRS("select CustomerLevelID,Name,DisplayOrder from CustomerLevel  with (NOLOCK)  union select 0,'--N/A--', 0 from CustomerLevel  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        while (dr.Read())
                        {
                            CustomerLevelList.Items.Add(new ListItem(DB.RSFieldByLocale(dr, "Name", LocaleSetting), DB.RSFieldInt(dr, "CustomerLevelID").ToString()));
                        }
                    }
                }

                ThisCustomer.ThisCustomerSession.ClearVal("IGD_EDITINGORDER");
                // are we order editing?
                if (m_OrderNumber != 0)
                {
                    ThisCustomer.ThisCustomerSession["IGD_EDITINGORDER"] = m_OrderNumber.ToString();

                    // setup cart to match order:
                    DB.ExecuteSQL("aspdnsf_EditOrder " + m_OrderNumber.ToString());

                    Button89.Visible            = true;
                    Button90.Visible            = true;
                    Button91.Visible            = true;
                    helpphone.Visible           = false;
                    helporderedit.Visible       = true;
                    backtoorderlink.NavigateUrl = AppLogic.AdminLinkUrl("orders.aspx") + "?ordernumber=" + m_OrderNumber.ToString();
                    content.Visible             = false;
                    SearchCustomerPanel.Visible = false;
                    txtordernumber.Text         = m_OrderNumber.ToString();
                    Order ord = new Order(m_OrderNumber);

                    // use customer as is:
                    TopPanel.Visible               = false;
                    SearchCustomerPanel.Visible    = false;
                    CreateNewCustomerPanel.Visible = false;
                    CustomerStatsPanel.Visible     = true;
                    CreateCustomer.Visible         = false;
                    UseCustomer.Visible            = false;
                    UpdateCustomer.Visible         = false;

                    SetContextToCustomerID(ord.CustomerID);

                    UsingCustomerID.Text = CustomerID.Text;
                    UsingFirstName.Text  = FirstName.Text;
                    UsingLastName.Text   = LastName.Text;
                    UsingEMail.Text      = EMail.Text.ToLowerInvariant().Trim();

                    SetToImpersonationPageContext(ord.CustomerID, "../shoppingcart.aspx", false);
                }
            }
            else
            {
                m_OrderNumber = System.Int32.Parse(saveOrderNumber.Text);
            }

            bool RequireEmail = !(AppLogic.AppConfigBool("PasswordIsOptionalDuringCheckout") && !AppLogic.AppConfigBool("AnonCheckoutReqEmail"));

            RequiredEmailValidator.Enabled  = RequireEmail;
            lblRequiredEmailAsterix.Visible = RequireEmail;
        }
Ejemplo n.º 3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Response.CacheControl = "private";
            Response.Expires      = 0;
            Response.AddHeader("pragma", "no-cache");

            m_OrderNumber = CommonLogic.QueryStringUSInt("OrderNumber");
            GetJavaScriptFunctions();

            if (!IsPostBack)
            {
                saveOrderNumber.Text = m_OrderNumber.ToString();
                if (AppLogic.AppConfigBool("PhoneOrder.EMailIsOptional"))
                {
                    valRegExValEmail.Enabled = false;
                }
                BillingState.ClearSelection();
                BillingState.Items.Clear();
                ShippingState.ClearSelection();
                ShippingState.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from State  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        ShippingState.DataValueField = "Abbreviation";
                        ShippingState.DataTextField  = "Name";
                        ShippingState.DataSource     = rs;
                        ShippingState.DataBind();
                    }
                }

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from State  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        BillingState.DataValueField = "Abbreviation";
                        BillingState.DataTextField  = "Name";
                        BillingState.DataSource     = rs;
                        BillingState.DataBind();
                    }
                }

                ShippingCountry.ClearSelection();
                ShippingCountry.Items.Clear();
                BillingCountry.ClearSelection();
                BillingCountry.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from Country  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        ShippingCountry.DataValueField = "Name";
                        ShippingCountry.DataTextField  = "Name";
                        ShippingCountry.DataSource     = rs;
                        ShippingCountry.DataBind();
                    }
                }

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select * from Country  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        BillingCountry.DataValueField = "Name";
                        BillingCountry.DataTextField  = "Name";
                        BillingCountry.DataSource     = rs;
                        BillingCountry.DataBind();
                    }
                }

                AffiliateList.ClearSelection();
                AffiliateList.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("select AffiliateID,Name,DisplayOrder from Affiliate  with (NOLOCK)  union select 0,'--N/A--', 0 from Affiliate  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        AffiliateList.DataSource = rs;
                        AffiliateList.DataBind();
                        if (AffiliateList.Items.Count == 0)
                        {
                            AffiliateList.Visible   = false;
                            AffiliatePrompt.Visible = false;
                        }
                    }
                }

                CustomerLevelList.ClearSelection();
                CustomerLevelList.Items.Clear();

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader dr = DB.GetRS("select CustomerLevelID,Name,DisplayOrder from CustomerLevel  with (NOLOCK)  union select 0,'--N/A--', 0 from CustomerLevel  with (NOLOCK)  order by DisplayOrder,Name", conn))
                    {
                        while (dr.Read())
                        {
                            CustomerLevelList.Items.Add(new ListItem(DB.RSFieldByLocale(dr, "Name", LocaleSetting), DB.RSFieldInt(dr, "CustomerLevelID").ToString()));
                        }
                    }
                }

                ThisCustomer.ThisCustomerSession.ClearVal("IGD_EDITINGORDER");
                // are we order editing?
                if (m_OrderNumber != 0)
                {
                    ThisCustomer.ThisCustomerSession["IGD_EDITINGORDER"] = m_OrderNumber.ToString();

                    // setup cart to match order:
                    DB.ExecuteSQL("aspdnsf_EditOrder " + m_OrderNumber.ToString());

                    Button89.Visible            = true;
                    Button90.Visible            = true;
                    Button91.Visible            = true;
                    helpphone.Visible           = false;
                    helporderedit.Visible       = true;
                    backtoorderlink.NavigateUrl = AppLogic.AdminLinkUrl("orders.aspx") + "?ordernumber=" + m_OrderNumber.ToString();
                    content.Visible             = false;
                    SearchCustomerPanel.Visible = false;
                    txtordernumber.Text         = m_OrderNumber.ToString();
                    Order ord = new Order(m_OrderNumber);

                    // use customer as is:
                    TopPanel.Visible               = false;
                    SearchCustomerPanel.Visible    = false;
                    CreateNewCustomerPanel.Visible = false;
                    CustomerStatsPanel.Visible     = true;
                    CreateCustomer.Visible         = false;
                    UseCustomer.Visible            = false;
                    UpdateCustomer.Visible         = false;

                    SetContextToCustomerID(ord.CustomerID);

                    UsingCustomerID.Text = CustomerID.Text;
                    UsingFirstName.Text  = FirstName.Text;
                    UsingLastName.Text   = LastName.Text;
                    UsingEMail.Text      = EMail.Text.ToLowerInvariant().Trim();

                    SetToImpersonationPageContext(ord.CustomerID, "../shoppingcart.aspx", false);
                }
            }
            else
            {
                m_OrderNumber = System.Int32.Parse(saveOrderNumber.Text);
            }

            bool RequireEmail = !(AppLogic.AppConfigBool("PasswordIsOptionalDuringCheckout") && !AppLogic.AppConfigBool("AnonCheckoutReqEmail"));

            RequiredEmailValidator.Enabled  = RequireEmail;
            lblRequiredEmailAsterix.Visible = RequireEmail;
        }
Ejemplo n.º 4
0
        private void InitializePageContent()
        {
            JSPopupRoutines.Text = AppLogic.GetJSPopupRoutines();
            ShippingResidenceType.Items.Add(new ListItem(AppLogic.GetString("address.cs.55", SkinID, ThisCustomer.LocaleSetting), ((int)ResidenceTypes.Unknown).ToString()));
            ShippingResidenceType.Items.Add(new ListItem(AppLogic.GetString("address.cs.56", SkinID, ThisCustomer.LocaleSetting), ((int)ResidenceTypes.Residential).ToString()));
            ShippingResidenceType.Items.Add(new ListItem(AppLogic.GetString("address.cs.57", SkinID, ThisCustomer.LocaleSetting), ((int)ResidenceTypes.Commercial).ToString()));
            ShippingResidenceType.SelectedIndex = 1;

            if (CommonLogic.QueryStringNativeInt("ErrorMsg") > 0)
            {
                pnlErrorMsg.Visible = true;

                ErrorMessage e = new ErrorMessage(CommonLogic.QueryStringNativeInt("ErrorMsg"));
                //ctrlShippingMethods.ErrorMessage = e.Message;
                pnlErrorMsg.Controls.Add(new LiteralControl(String.Format("<b style='color:red;'>{0}</b>", e.Message)));
            }

            if (!cart.ShippingIsFree && cart.MoreNeededToReachFreeShipping != 0.0M)
            {
                pnlGetFreeShippingMsg.Visible = true;
                GetFreeShippingMsg.Text       = String.Format(AppLogic.GetString("checkoutshipping.aspx.2", SkinID, ThisCustomer.LocaleSetting), ThisCustomer.CurrencyString(cart.FreeShippingThreshold), CommonLogic.Capitalize(cart.FreeShippingMethod));
            }

            if (cart.ShippingIsFree)
            {
                pnlFreeShippingMsg.Visible = true;
                String Reason = String.Empty;
                if (cart.FreeShippingReason == Shipping.FreeShippingReasonEnum.AllDownloadItems)
                {
                    Reason = AppLogic.GetString("checkoutshipping.aspx.5", SkinID, ThisCustomer.LocaleSetting);
                    btnContinueCheckout.Text = AppLogic.GetString("checkoutshipping.aspx.19", ThisCustomer.SkinID, ThisCustomer.LocaleSetting);
                }
                if (cart.FreeShippingReason == Shipping.FreeShippingReasonEnum.AllFreeShippingItems)
                {
                    Reason = AppLogic.GetString("checkoutshipping.aspx.18", SkinID, ThisCustomer.LocaleSetting);
                    btnContinueCheckout.Text = AppLogic.GetString("checkoutshipping.aspx.19", ThisCustomer.SkinID, ThisCustomer.LocaleSetting);
                }
                if (cart.FreeShippingReason == Shipping.FreeShippingReasonEnum.CouponHasFreeShipping)
                {
                    Reason = AppLogic.GetString("checkoutshipping.aspx.6", SkinID, ThisCustomer.LocaleSetting);
                    btnContinueCheckout.Text = AppLogic.GetString("checkoutshipping.aspx.19", ThisCustomer.SkinID, ThisCustomer.LocaleSetting);
                }
                if (cart.FreeShippingReason == Shipping.FreeShippingReasonEnum.AllOrdersHaveFreeShipping)
                {
                    Reason = String.Format(AppLogic.GetString("checkoutshipping.aspx.7", SkinID, ThisCustomer.LocaleSetting), cart.FreeShippingMethod);
                    btnContinueCheckout.Text = AppLogic.GetString("checkoutshipping.aspx.19", ThisCustomer.SkinID, ThisCustomer.LocaleSetting);
                }
                if (cart.FreeShippingReason == Shipping.FreeShippingReasonEnum.CustomerLevelHasFreeShipping)
                {
                    Reason = String.Format(AppLogic.GetString("checkoutshipping.aspx.8", SkinID, ThisCustomer.LocaleSetting), ThisCustomer.CustomerLevelName);
                    btnContinueCheckout.Text = AppLogic.GetString("checkoutshipping.aspx.19", ThisCustomer.SkinID, ThisCustomer.LocaleSetting);
                }
                if (cart.FreeShippingReason == Shipping.FreeShippingReasonEnum.ExceedsFreeShippingThreshold)
                {
                    Reason = cart.FreeShippingMethod;
                    btnContinueCheckout.Text = AppLogic.GetString("checkoutshipping.aspx.19", ThisCustomer.SkinID, ThisCustomer.LocaleSetting);
                }
                FreeShippingMsg.Text = Reason;
            }

            Addresses addrs = new Addresses();

            addrs.LoadCustomer(ThisCustomer.CustomerID);
            ddlChooseShippingAddr.Items.Clear();
            Hashtable ht = new Hashtable();

            // add their primary shipping address id FIRST:
            foreach (Address a in addrs)
            {
                if (a.AddressID == ThisCustomer.PrimaryShippingAddressID)
                {
                    string addrString = a.Address1 + " " + a.City + " " + a.State + " " + a.Country + " " + a.Zip;
                    while (addrString.IndexOf("  ") != -1)
                    {
                        addrString = addrString.Replace("  ", " ");
                    }
                    ht.Add(addrString, "true");
                    ddlChooseShippingAddr.Items.Add(new ListItem(addrString, a.AddressID.ToString()));
                }
            }
            // now add their remaining addresses, only if they are materially different from the primary shipping address
            foreach (Address a in addrs)
            {
                if (a.AddressID != ThisCustomer.PrimaryShippingAddressID)
                {
                    string addrString = a.Address1 + " " + a.City + " " + a.State + " " + a.Country + " " + a.Zip;
                    while (addrString.IndexOf("  ") != -1)
                    {
                        addrString = addrString.Replace("  ", " ");
                    }
                    if (!ht.Contains(addrString))
                    {
                        ht.Add(addrString, "true");
                        ddlChooseShippingAddr.Items.Add(new ListItem(addrString, a.AddressID.ToString()));
                    }
                }
            }

            //allow the customer to add a new address
            ddlChooseShippingAddr.Items.Add(new ListItem(AppLogic.GetString("checkoutshipping.aspx.22", ThisCustomer.SkinID, ThisCustomer.LocaleSetting), "0"));

            ddlChooseShippingAddr.SelectedValue = ThisCustomer.PrimaryShippingAddressID.ToString();
            ddlChooseShippingAddr.AutoPostBack  = true;

            using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
            {
                con.Open();
                using (IDataReader rs = DB.GetRS("select * from State  with (NOLOCK)  order by DisplayOrder,Name", con))
                {
                    ShippingState.DataSource     = rs;
                    ShippingState.DataTextField  = "Name";
                    ShippingState.DataValueField = "Abbreviation";
                    ShippingState.DataBind();
                }
            }

            using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
            {
                con.Open();
                using (IDataReader rs = DB.GetRS("select * from Country   with (NOLOCK)  order by DisplayOrder,Name", con))
                {
                    ShippingCountry.DataSource     = rs;
                    ShippingCountry.DataTextField  = "Name";
                    ShippingCountry.DataValueField = "Name";
                    ShippingCountry.DataBind();
                }
            }

            ShippingCountry.SelectedValue = "United States";


            pnlCartAllowsShippingMethodSelection.Visible = cart.CartAllowsShippingMethodSelection;
            ctrlShippingMethods.Visible = cart.CartAllowsShippingMethodSelection;

            if ((!cart.CartAllowsShippingMethodSelection || AnyShippingMethodsFound) || (!AnyShippingMethodsFound && !AppLogic.AppConfigBool("FreeShippingAllowsRateSelection") && cart.ShippingIsFree))
            {
                btnContinueCheckout.Visible = true;
            }

            ShippingDisplay(AnyShippingMethodsFound);
        }