Thread: freeshippingthreshold

I have some states that have one value for free shipping and other states that have another value. I tried to go in and create another appconfig for the other value and put an if statement that queried the address table to get the customer's state. When I try to do this, it always uses the default shipping threshold. Is this hard coded somewhere? I modified prices.cs and shoppingcart.cs to look at the new app config but it continues to use the value in freeshippingthreshold.

Make a global search with "FreeShippingThreshold" in the solution and see all the methods calls that appconfig, specifically AnalyzeCartForFreeShippingConditions() in ShoppingCart.cs class.

I have a mod in that function that I compiled and reloaded. Below is the code that I am using. Any suggestions?

Code:

            m_FreeShippingThreshold = AppLogic.AppConfigUSDecimal("FreeShippingThreshold");
            using (SqlConnection conn = DB.dbConn())
            {
                conn.Open();
                using (IDataReader rs = DB.GetRS("SELECT '1' AS lowthreshold FROM Address A with (NOLOCK) inner join Customer C ON A.CustomerID=C.CustomerID WHERE c.CustomerID = " + ThisCustomer.CustomerID + " AND C.ShippingAddressID = A.AddressID AND A.State NOT IN('AZ','CA','ID','MT','NM','NV','OR','UT','WA','WY')", conn))
                {
                    while (rs.Read())
                    {
                        if (DB.RSField(rs, "lowthreshold") != "1")
                        {
                            m_FreeShippingThreshold = AppLogic.AppConfigUSDecimal("FreeShippingThresholdWest");
                        }
                    }
                }
            }

Even when I manually set m_FreeShippingThreshold = AppLogic.AppConfigUSDecimal("FreeShippingThreshold West");, it still looks at FreeShippingThreshold.

I ended up using this, and it works now. I'm not sure why my other one didn't work.

Code:

                using (SqlConnection conn = DB.dbConn())
                {
                    conn.Open();
                    using (IDataReader rs = DB.GetRS("SELECT state FROM Address A with (NOLOCK) inner join Customer C ON A.CustomerID=C.CustomerID WHERE c.CustomerID = " + ThisCustomer.CustomerID + " AND C.ShippingAddressID = A.AddressID", conn))
                    {
                        while (rs.Read()) 
                        {
                            string state = DB.RSField(rs, "state");
                            if (state == "AZ" || state == "CA" || state == "ID" || state == "MT" || state == "NM" || state == "NV" || state == "OR" || state == "UT" || state == "WA" || state == "WY")
                            {
                                FreeShippingThreshold = AppLogic.AppConfigUSDecimal("FreeShippingThresholdWest");
                            }
                        }
                    }
                }