public void Add(SalesTaxCode taxcode)
{
QbDb.SalesTaxCodes.InsertOnSubmit(taxcode);
}
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();
}
}
private void detach_SalesTaxCodes(SalesTaxCode entity)
{
this.SendPropertyChanging();
entity.Client = null;
}
partial void DeleteSalesTaxCode(SalesTaxCode instance);
partial void UpdateSalesTaxCode(SalesTaxCode instance);
partial void InsertSalesTaxCode(SalesTaxCode instance);