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;
}
