Thread: sprocs for taxrate

I have modified the stored procedures for getting the state tax rate (aspdnsf_getStateTaxRate, aspdnsf_getStateTaxRatebyID). I have attached my modification script to this post. My problem is that it is still pulling the tax rate straight from what the value is set to in the taxrate table. This makes me think that nothing is looking at these sprocs and it's calculated elsewhere. Any ideas?

What exactly you're trying to achieve?

I am trying to have the system look at my other table and pull the tax rate for an ohio county if the state ID is 44. I tried just changing the stored proc to start with but it always pulls the percent from the state tax table even though I put the if @stateid=44 in the sproc.

I took the aspdnsf_GetStateTaxRate & GetStateTaxRateByID sprocs completely out and the tax still calculates. I thought the script looked at those sprocs to calculate the tax?

So deleting the sprocs for getting the state tax rate doesn't effect the application. It still continues to calculate state taxes. I cannot find how it is doing this though. I have searched StateTaxRate.cs and Prices.cs w/ no success

I think I may have tracked down the code but I'm not 100% sure. I am modified line 260 in StateTaxRate.cs to be the following but this throws the error "Object reference not set to an instance of an object":

Code:

public StateTaxRates()
        {
            m_StateTaxRates = new SortedList();
            object customersession = HttpContext.Current.Session["CustomerID"];
            int customer;
            customer = (int)customersession;

            using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
            {
                con.Open();
                using (IDataReader rs = DB.GetRS("aspdnsf_getStateTaxRate " + customer.ToString(), con))
                {
                    while (rs.Read())
                    {
                        m_StateTaxRates.Add(DB.RSFieldInt(rs, "StateTaxID"), new StateTaxRate(DB.RSFieldInt(rs, "StateTaxID"), DB.RSFieldInt(rs, "StateID"), DB.RSFieldInt(rs, "TaxClassID"), DB.RSField(rs, "StateName"), DB.RSField(rs, "TaxClass"), DB.RSFieldDecimal(rs, "TaxRate"), DB.RSFieldDateTime(rs, "CreatedOn")));
                    }
                }
            }

Any ideas why I'm getting this error or if this is even the right spot to modify?

I have my sproc fixed and running just how I want. The only issue is that when I choose a county and submit that change, it changes in the db but not in the application. It seems that if I don't change the state, the tax rate doesn't get re-pulled from the database. Is there something that runs when the state is changed and submitted that it goes out and re-calculates the tax?