Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Shipping State Bug

  1. #1
    DotNetDevelopments is offline Senior Member
    Join Date
    Jul 2008
    Location
    Harlow / Essex / UK
    Posts
    619

    Exclamation Shipping State Bug

    In ver 8.0.1.1. you can have a state with no country. We use Other (Non US) for all countries bar the USA.

    However in ver 8.0.1.2. this breaks the shipping options! You have to assign a state to a country.

    I don't really want to assign a new Other (Non US) for every country in the world. Is there a fix to this?
    =====
    Version (Code/DB): AspDotNetStorefront MSx 9.1.0.1/9.1.0.0
    Execution Mode: 64 Bit
    Dot Net Developments - E-commerce By Experience

  2. #2
    DotNetDevelopments is offline Senior Member
    Join Date
    Jul 2008
    Location
    Harlow / Essex / UK
    Posts
    619

    Default

    Has no one ran into this?

    The only way I can get around this is by editing out lines 3665 to 3672 in ShoppingCart.aspx
    Should be fine as we only check shipping on country. What changed in the code that meant every country needs to be assigned a state or was it always like that?

    C#/VB.NET Code:
    StringBuilder shipsql = new StringBuilder(4096);
                            
    shipsql.Append("select * from ShippingMethod  with (NOLOCK)  where IsRTShipping=0 ");
                            
    //if (!ShippingMethodToStateMapIsEmpty && !ShippingMethodToCountryMapIsEmpty)
                            //{
                            //    shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToStateMap  with (NOLOCK)  where StateID=" + AppLogic.GetStateID(FirstItemShippingAddress.State, AppLogic.GetCountryID(FirstItemShippingAddress.Country)).ToString() + ")");
                            //}
                            //else if (!ShippingMethodToStateMapIsEmpty)
                            //{
                            //    shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToStateMap  with (NOLOCK)  where StateID=" + AppLogic.GetStateID(FirstItemShippingAddress.State).ToString() + ")");
                            //}

                            
    if (!ShippingMethodToCountryMapIsEmpty)
                            {
                                
    shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToCountryMap  with (NOLOCK)  where CountryID=" AppLogic.GetCountryID(FirstItemShippingAddress.Country).ToString() + ")");
                            }
                            
    shipsql.Append(" order by Displayorder");
                            
    int i 1;
                            
    int zeroShipCostCountThatShouldBeFiltered 0
    Last edited by DotNetDevelopments; 01-28-2011 at 03:40 AM.
    =====
    Version (Code/DB): AspDotNetStorefront MSx 9.1.0.1/9.1.0.0
    Execution Mode: 64 Bit
    Dot Net Developments - E-commerce By Experience