http://forums.ablecommerce.com/
Since most of the code came from WA state, I don't think it would be proper to sell.compunerdy wrote:Are you willing to share the code or sell it?
Code: Select all
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CommerceBuilder.Orders;
using CommerceBuilder.Taxes;
using System.Net;
using System.IO;
using System.Xml;
/// <summary>
/// Summary description for TaxLookUp
/// </summary>
public class TaxLookUp
{
public TaxLookUp()
{
}
public Basket getTaxCodes(Basket basket)
{
BasketShipment shipment = basket.Shipments[0];
XmlDocument doc = new XmlDocument();
string xml = "";
if (shipment.Address.ProvinceId == 93)
{
WebClient wc = new WebClient();
string protocol = "http";
string server = "dor.wa.gov";
string port = "";
string street = shipment.Address.Address1;
string city = shipment.Address.City;
string zip = shipment.Address.PostalCode;
string urlPrefix = protocol +
"://" + server +
"/AddressRates.aspx?output=xml";
string uri = urlPrefix +
"&addr=" +
street +
"&city=" +
city +
"&zip=" +
zip;
StreamReader reader = new StreamReader(wc.OpenRead(uri));
xml = reader.ReadToEnd();
reader.Close();
// Now parse the XML
// ...
//doc = new XmlDocument();
doc.LoadXml(xml);
//doc.Save(Server);
XmlNode node = doc.SelectSingleNode("response");
XmlNode addressNode = doc.SelectSingleNode("addressline");
string locCode = node.Attributes["loccode"].Value;
string rate = node.Attributes["rate"].Value;
shipment.Address.Fax = locCode;
shipment.Address.Save();
//Get the right tax code
//Set the tax code variable equally to the id of the tax code in your database
int taxCode = 0;
switch (rate)
{
case "0.075":
taxCode = 5;
break;
case "0.076":
taxCode = 6;
break;
case "0.077":
taxCode = 7;
break;
case "0.078":
taxCode = 8;
break;
case "0.079":
taxCode = 9;
break;
case "0.080":
taxCode = 10;
break;
case "0.081":
taxCode = 11;
break;
case "0.082":
taxCode = 12;
break;
case "0.083":
taxCode = 13;
break;
case "0.084":
taxCode = 14;
break;
case "0.085":
taxCode = 15;
break;
case "0.086":
taxCode = 16;
break;
case "0.087":
taxCode = 17;
break;
case "0.088":
taxCode = 18;
break;
case "0.089":
taxCode = 19;
break;
case "0.090":
taxCode = 20;
break;
default:
break;
}
foreach (BasketItem item in basket.Items)
{
item.TaxCodeId = taxCode;
}
basket.Shipments[0].ShipMethod.TaxCodeId = taxCode;
basket.Save();
}
//return basket;
return basket;
}
}
Code: Select all
private void RecalculateBasket(bool rebindPaymentForms)
{
Basket basket = Token.Instance.User.Basket;
if (trShowRates.Visible)
{
int shipmentIndex = 0;
foreach (RepeaterItem item in ShipmentList.Items)
{
BasketShipment shipment = basket.Shipments[shipmentIndex];
DropDownList ShipMethodList = (DropDownList)item.FindControl("ShipMethodList");
if (ShipMethodList != null)
{
shipment.ShipMethodId = AlwaysConvert.ToInt(ShipMethodList.SelectedValue);
}
else
{
shipment.ShipMethodId = 0;
}
shipment.Save();
shipmentIndex++;
}
}
basket.Recalculate();
if (rebindPaymentForms) BindPaymentMethodForms();
//Adding washington state taxes to each item in the basket
TaxLookUp taxes = new TaxLookUp();
basket = taxes.getTaxCodes(basket);
//RECALCULATE SHIPPING, TAXES, DISCOUNTS, ETC.
basket.Recalculate();
_CurrentBasketHash = basket.GetContentHash(OrderItemType.Product);
if (rebindPaymentForms) BindPaymentMethodForms();
}
No tax codes are assigned to individual items. I believe you'll need to remove taxation from the items, otherwise you may end up with duplicate taxes against the order.compunerdy wrote:Ok..still a tad confused
1. Do I need to worry about assigning items to the tax codes?
2. Does it matter that all the items are already assigned to a different tax code?
Or does the code ignore all of this anyways so just do what you said to do and quit thinking so hard?
There is a form to fill out on the DOR website. (I cannot find it right now) The form has you list the location code along with the total sales and sales tax collected. My understanding is you use the location code for filing and not the county since sales tax can change within the county due to various taxing districts.compunerdy wrote:This did collect the correct sales tax amount as far as I can tell. My system was screwed up a bit because of my initial setup. I think I have it setup correctly now though.
When you go to file the state tax's how are you figuring out which countys you sold to? I know how much of each percentage rate I collected but no clue what amount to which county like the tax setup is asking for.
Uh... you didn't capture that information when you looked up the tax rates ???compunerdy wrote:Ok..yes when I went to fill out the form online it asks for the name or location code.. The problem is how do I know which location codes we sold to? As far as I know all I can easily see is what percentage rate we charged yet there will be like 10 location codes with the same percentage rate.
We use the sales tax integration routine to capture the location code (we stuff it in the fax number since we do not track shipping fax numbers)