taxengine:integration:code_samples:select_tax_schedule
Table of Contents
Sample Code to Select a Tax Schedule
Select Tax Schedule is an ASP.net web page on the eStore Example
Fields
- txtZIPcode - A text box which allows the user to enter a U.S. ZIP Code.
- txtCustomer - A text box which allows the user to enter a GP customer.
- txtItem - A text box which allows the user to enter a GP Inventory Item.
- btnScheduleSelect - A button the user can push to run Tax Schedule Selection for the given ZIP Code, customer and inventory item.
- txtMessage - A read only text box which displays all the cities, counties and state(s) that exist in the given ZIP Code.
- txtSchedule - A read only text box which displays the selected Tax Schedule ID.
Code
using System; using System.Data; using System.Configuration; using System.Collections; 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 KampData.TaxEngine; using System.Runtime.InteropServices; namespace eStoreExample { public partial class WebForm11 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnScheduleSelect_Click(object sender, EventArgs e) { ////Please enter your SQL login for "sa" string server = "SQLServerComputerName\\SQLinstance"; string userId = "sa"; string password = "P@ssw0rd"; string companyDatabase = "TWO"; bool abort = false; ArrayList cities = new ArrayList(); ArrayList counties = new ArrayList(); ArrayList states = new ArrayList(); string loginMessage = ""; txtMessage.Text = ""; txtSchedule.Text = ""; TaxEngine txEngn = new TaxEngine(); try { loginMessage = txEngn.Login(server, userId, password, companyDatabase); } catch (Exception ea) { loginMessage = ea.Message; } if (loginMessage != "") { txtMessage.Text = loginMessage; abort = true; } if (!abort) { string docNumber = "001"; Int16 docType = -1; string module = "SOP"; txEngn.Document(docNumber, docType, module); txEngn.DocTransactionType = TransactionType.Sales; if (txtCustomer.Text != "") { txEngn.DocCustomerID = txtCustomer.Text; } int lineNumber = 1; txEngn.LineAdd(lineNumber); txEngn.LineItemNumber = txtItem.Text; try { txEngn.LineZip = txtZIPcode.Text; states = txEngn.LineStatesInZip(); txtMessage.Text = "States in ZIP: "; foreach (string state in states) { txtMessage.Text = txtMessage.Text + Convert.ToString(state) + ", "; } cities = txEngn.LineCitiesInStateAndZip(); txtMessage.Text = txtMessage.Text + "Cities: "; foreach (string city in cities) { txtMessage.Text = txtMessage.Text + Convert.ToString(city) + ", "; } counties = txEngn.LineCountiesInCityStateAndZip(); txtMessage.Text = txtMessage.Text + "Counties: "; foreach (string county in counties) { txtMessage.Text = txtMessage.Text + Convert.ToString(county) + ", "; } txEngn.LineInCityLimits = true; txtSchedule.Text = txEngn.LineTaxScheduleID; } catch (Exception ea) { txtMessage.Text = ea.Message; } } } } }
taxengine/integration/code_samples/select_tax_schedule.txt · Last modified: 2015/06/12 20:07 by conni