public static void ItemSalesTaxGroupQueryRs(string response) { var rep = new Repository(); var client = rep.GetClient(rep.GetUser(WebSecurity.CurrentUserId).ClientID ?? 0); var db = Database.Open("Quickbooks"); var taxCodes = XDocument.Parse(response).Document.Root.Descendants("QBXMLMsgsRs").Descendants("ItemSalesTaxGroupQueryRs").FirstOrDefault().Descendants("ItemSalesTaxGroupRet"); var clientID = rep.GetUser(WebSecurity.CurrentUserId).ClientID; foreach (var item in taxCodes) { var taxCode = rep.GetSalesTaxCode(rep.GetUser(WebSecurity.CurrentUserId).ClientID ?? 0, item.Descendants("Name").FirstOrDefault().Value); var taxCodeExists = taxCode != null; var name = item.Descendants("Name").FirstOrDefault().Value; var listID = item.Descendants("ListID").FirstOrDefault().Value; decimal rate = 0; foreach (var rat in item.Descendants("ItemSalesTaxRef")) { rate += rep.GetSalesTaxCode(clientID ?? 0, rat.Descendants("FullName").FirstOrDefault().Value).Rate; } var taxRate = rate; if (!taxCodeExists) { var taxcode = new SalesTaxCode() { ClientID = clientID ?? 0, QuickbooksFullName = name, Rate = taxRate }; rep.Add(taxcode); } rep.Save(); } }
public SalesTaxCode GetSingleTaxCode(string taxCode) { StringBuilder oSQL = new StringBuilder(); oSQL.Append(string.Format("SELECT code, name, rate FROM OSTC T0 where code = '{0}'", taxCode)); DbCommand dbCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); SalesTaxCode tax = new SalesTaxCode(); using (this.reader = this.dataBase.ExecuteReader(dbCommand)) { while (this.reader.Read()) { tax.code = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); tax.name = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); tax.rate = this.reader.IsDBNull(2) ? 0 : double.Parse(this.reader.GetValue(2).ToString()); } } return(tax); }
public List <SalesTaxCode> GetSalesTaxCodeList() { StringBuilder oSQL = new StringBuilder(); oSQL.Append("SELECT code, name FROM OSTC T0 where lock = 'N'"); DbCommand dbCommand = this.dataBase.GetSqlStringCommand(oSQL.ToString()); List <SalesTaxCode> taxCodes = new List <SalesTaxCode>(); using (this.reader = this.dataBase.ExecuteReader(dbCommand)) { while (this.reader.Read()) { SalesTaxCode item = new SalesTaxCode(); item.code = this.reader.IsDBNull(0) ? "" : this.reader.GetValue(0).ToString(); item.name = this.reader.IsDBNull(1) ? "" : this.reader.GetValue(1).ToString(); taxCodes.Add(item); } } return(taxCodes); }
public SalesTaxCodeForm(SalesTaxCode code) { InitializeComponent(); this.SalesTaxCode = code; }
public void Add(SalesTaxCode taxcode) { QbDb.SalesTaxCodes.InsertOnSubmit(taxcode); }
public EditSalesTaxCode(SalesTaxCode code) { this.code = code; }