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.