public override List <Abstract> GetRecords(ref string err, bool includeSublevel)
{
try
{
string xml = toXmlQuery(true);
if (xml == null)
{
err = "Hubo un error al generar el XML" + Environment.NewLine;
return(null);
}
XmlDocument res = new XmlDocument();
if (Config.IsProduction == true)
{
var qbook = Config.quickbooks;
if (qbook.isOpen())
{
string response = qbook.sendRequest(xml);
res.LoadXml(response);
if (Config.SaveLogXML == true)
{
string NameCustomerByDay = Config.CompaniaDB + DateTime.Now.ToString("MM-dd-yyyy");
string pathFile = Directory.GetCurrentDirectory() + "\\samples\\V_" + NameCustomerByDay + ".xml";
File.WriteAllText(pathFile, response);
}
}
else
{
err = "QuickBook no conecto";
}
}
else
{
if (Config.SaveLogXML == true)
{
string pathFile = Directory.GetCurrentDirectory() + "\\samples\\V_" + DateTime.Now.Ticks + ".xml";
File.WriteAllText(pathFile, xml);
}
//Datos de prueba
// string pathFile = Directory.GetCurrentDirectory() + "\\samples\\NewVendor_Test.xml";
// string response = File.ReadAllText(pathFile);
//res.LoadXml(response);
}
string code = "";
string statusMessage = "";
code = res["QBXML"]["QBXMLMsgsRs"]["VendorQueryRs"].Attributes["statusCode"].Value;
statusMessage = res["QBXML"]["QBXMLMsgsRs"]["VendorQueryRs"].Attributes["statusMessage"].Value;
if (code == "0")
{
List <Abstract> quickbookListVendors = new List <Abstract>();
XmlNodeList fieldsList = (((System.Xml.XmlNode)(res))).LastChild.FirstChild.FirstChild.ChildNodes;
XmlNodeList rets = res.SelectNodes("/QBXML/QBXMLMsgsRs/VendorQueryRs/VendorRet");
quickbookListVendors = GetVendors(rets);
if (quickbookListVendors.Count > 0)
{
return(quickbookListVendors);
}
else
{
err = "No se obtuvo ningun registro" + Environment.NewLine;
}
string message = string.Empty;
foreach (XmlNode node in rets)
{
Vendor v = new Vendor();
v.ListID = node["ListID"].InnerText;
v.Name = node["Name"].InnerText;
if (node.SelectNodes("CompanyName").Count > 0)
{
v.CompanyName = node["CompanyName"].InnerText;
}
if (node.SelectNodes("AdditionalContactRef").Count > 0)
{
v.Phone = "";
v.Email = "";
}
XmlNodeList extras = node.SelectNodes("DataExtRet");
foreach (XmlNode ex in extras)
{
var name = ex["DataExtName"].InnerText;
var value = ex["DataExtValue"].InnerText;
v.AddDataEx(name, value);
}
quickbookListVendors.Add(v);
}
if (quickbookListVendors.Count > 0)
{
return(quickbookListVendors);
}
else
{
err = "No se obtuvo ningun registro" + Environment.NewLine;
}
}
else
{
err = statusMessage;
}
}
catch (Exception ex)
{
throw new Exception("Error al conectar al Obtener Proveedores registros de Quickbooks: " + ex.Message);
}
return(new List <Abstract>());
}
private List <Abstract> GetVendors(XmlNodeList rets)
{
List <Abstract> quickbookListVendor = new List <Abstract>();
string message = string.Empty;
foreach (XmlNode node in rets)
{
Vendor toUpdate = new Vendor();
if (node["ListID"] != null)
{
toUpdate.ListID = node["ListID"].InnerText;
}
if (node["Name"] != null)
{
toUpdate.Name = node["Name"].InnerText;
}
if (node["IsActive"] != null)
{
toUpdate.active = node["IsActive"].InnerText == "true" ? true : false;
}
if (node.SelectNodes("ClassRef").Count > 0)
{
toUpdate.classRef = new Class();
toUpdate.classRef.ListID = node["ClassRef"].FirstChild.InnerText;
toUpdate.classRef.FullName = node["ClassRef"].LastChild.InnerText;
}
if (node["IsTaxAgency"] != null)
{
toUpdate.IsTaxAgency = node["IsTaxAgency"].InnerText == "true" ? true : false;
}
if (node["CompanyName"] != null)
{
toUpdate.companyName = node["CompanyName"].InnerText;
}
if (node["Salutation"] != null)
{
toUpdate.Salutation = node["Salutation"].InnerText;
}
if (node["FirstName"] != null)
{
toUpdate.firstName = node["FirstName"].InnerText;
}
if (node["MiddleName"] != null)
{
toUpdate.MiddleName = node["MiddleName"].InnerText;
}
if (node["LastName"] != null)
{
toUpdate.LastName = node["LastName"].InnerText;
}
if (node["JobTitle"] != null)
{
toUpdate.JobTitle = node["JobTitle"].InnerText;
}
if (node.SelectNodes("VendorAddress").Count > 0)
{
toUpdate.VendorAdress = new VendorAddress();
if (node["VendorAddress"]["Addr1"] != null)
{
toUpdate.VendorAdress.Addr1 = node["VendorAddress"]["Addr1"].InnerText;
}
if (node["VendorAddress"]["Addr2"] != null)
{
toUpdate.VendorAdress.Addr2 = node["VendorAddress"]["Addr2"].InnerText;
}
if (node["VendorAddress"]["Addr3"] != null)
{
toUpdate.VendorAdress.Addr3 = node["VendorAddress"]["Addr3"].InnerText;
}
if (node["VendorAddress"]["Addr4"] != null)
{
toUpdate.VendorAdress.Addr4 = node["VendorAddress"]["Addr4"].InnerText;
}
if (node["VendorAddress"]["Addr5"] != null)
{
toUpdate.VendorAdress.Addr5 = node["VendorAddress"]["Addr5"].InnerText;
}
if (node["VendorAddress"]["City"] != null)
{
toUpdate.VendorAdress.City = node["VendorAddress"]["City"].InnerText;
}
if (node["VendorAddress"]["Country"] != null)
{
toUpdate.VendorAdress.Country = node["VendorAddress"]["Country"].InnerText;
}
if (node["VendorAddress"]["Note"] != null)
{
toUpdate.VendorAdress.Note = node["VendorAddress"]["Note"].InnerText;
}
if (node["VendorAddress"]["PostalCode"] != null)
{
toUpdate.VendorAdress.PostalCode = node["VendorAddress"]["PostalCode"].InnerText;
}
if (node["VendorAddress"]["State"] != null)
{
toUpdate.VendorAdress.State = node["VendorAddress"]["State"].InnerText;
}
}
if (node.SelectNodes("ShipAddress").Count > 0)
{
toUpdate.ShipAddress = new ShipAdress();
if (node["ShipAddress"]["Addr1"] != null)
{
toUpdate.ShipAddress.Addr1 = node["ShipAddress"]["Addr1"].InnerText;
}
if (node["ShipAddress"]["Addr2"] != null)
{
toUpdate.ShipAddress.Addr2 = node["ShipAddress"]["Addr2"].InnerText;
}
if (node["ShipAddress"]["Addr3"] != null)
{
toUpdate.ShipAddress.Addr3 = node["ShipAddress"]["Addr3"].InnerText;
}
if (node["ShipAddress"]["Addr4"] != null)
{
toUpdate.ShipAddress.Addr4 = node["ShipAddress"]["Addr4"].InnerText;
}
if (node["ShipAddress"]["Addr5"] != null)
{
toUpdate.ShipAddress.Addr5 = node["ShipAddress"]["Addr5"].InnerText;
}
if (node["ShipAddress"]["City"] != null)
{
toUpdate.ShipAddress.City = node["ShipAddress"]["City"].InnerText;
}
if (node["ShipAddress"]["Country"] != null)
{
toUpdate.ShipAddress.Country = node["ShipAddress"]["Country"].InnerText;
}
if (node["ShipAddress"]["Note"] != null)
{
toUpdate.ShipAddress.Note = node["ShipAddress"]["Note"].InnerText;
}
if (node["ShipAddress"]["PostalCode"] != null)
{
toUpdate.ShipAddress.PostalCode = node["ShipAddress"]["PostalCode"].InnerText;
}
if (node["ShipAddress"]["State"] != null)
{
toUpdate.ShipAddress.State = node["ShipAddress"]["State"].InnerText;
}
}
if (node["Phone"] != null)
{
toUpdate.Phone = node["Phone"].InnerText;
}
if (node["Fax"] != null)
{
toUpdate.Fax = node["Fax"].InnerText;
}
if (node["Email"] != null)
{
toUpdate.Email = node["Email"].InnerText;
}
if (node["Cc"] != null)
{
toUpdate.Cc = node["Cc"].InnerText;
}
if (node["Contact"] != null)
{
toUpdate.Contact = node["Contact"].InnerText;
}
if (node["AltContact"] != null)
{
toUpdate.AltContact = node["AltContact"].InnerText;
}
if (node.SelectNodes("AdditionalContactRef").Count > 0)
{
toUpdate.AdditionalContactRef = new List <AdditionalContact>();
XmlNodeList nodes = node.SelectNodes("AdditionalContactRef");
for (int i = 0; i < nodes.Count; i++)
{
AdditionalContact contact = new AdditionalContact();
contact.ContactName = nodes[i].FirstChild.InnerText;
contact.ContactValue = nodes[i].LastChild.InnerText;
toUpdate.AdditionalContactRef.Add(contact);
}
}
if (node.SelectNodes("ContactsRet").Count > 0)
{
toUpdate.Contacts = new List <Contact>();
XmlNodeList nodes = node.SelectNodes("ContactsRet");
for (int i = 0; i < nodes.Count; i++)
{
Contact contact = new Contact();
if (nodes[i]["ListID"] != null)
{
contact.ListID = nodes[i]["ListID"].InnerText;
}
if (nodes[i]["FirstName"] != null)
{
contact.FirstName = nodes[i]["FirstName"].InnerText;
}
if (nodes[i]["LastName"] != null)
{
contact.LastName = nodes[i]["LastName"].InnerText;
}
if (nodes[i]["MiddleName"] != null)
{
contact.MiddleName = nodes[i]["MiddleName"].InnerText;
}
if (nodes[i]["Salutation"] != null)
{
contact.Salutation = nodes[i]["Salutation"].InnerText;
}
if (nodes[i]["JobTitle"] != null)
{
contact.JobTitle = nodes[i]["JobTitle"].InnerText;
}
if (nodes[i].SelectNodes("AdditionalContactRef").Count > 0)
{
contact.AdicionalContacRef = new List <AdditionalContact>();
XmlNodeList nodes2 = nodes[i].SelectNodes("AdditionalContactRef");
for (int j = 0; j < nodes2.Count; j++)
{
AdditionalContact contactRef = new AdditionalContact();
contactRef.ContactName = nodes2[j].FirstChild.InnerText;
contactRef.ContactValue = nodes2[j].LastChild.InnerText;
contact.AdicionalContacRef.Add(contactRef);
}
}
toUpdate.Contacts.Add(contact);
}
}
if (node["NameOnCheck"] != null)
{
toUpdate.NameOnCheck = node["NameOnCheck"].InnerText;
}
if (node["AccountNumber"] != null)
{
toUpdate.AccountNumber = node["AccountNumber"].InnerText;
}
if (node["Notes"] != null)
{
toUpdate.Notes = node["Notes"].InnerText;
}
//<AdditionalNotesRet> <!-- optional, may repeat -->
// <NoteID >INTTYPE</NoteID> <!-- required -->
// <Date >DATETYPE</Date> <!-- required -->
// <Note >STRTYPE</Note> <!-- required -->
// </AdditionalNotesRet>
if (node.SelectNodes("VendorTypeRef").Count > 0)
{
toUpdate.VendorType = new VendorTypeRef();
if (node["VendorTypeRef"]["ListID"] != null)
{
toUpdate.VendorType.ListID = node["VendorTypeRef"]["ListID"].InnerText;
}
if (node["VendorTypeRef"]["FullName"] != null)
{
toUpdate.VendorType.FullName = node["VendorTypeRef"]["FullName"].InnerText;
}
}
if (node.SelectNodes("TermsRef").Count > 0)
{
toUpdate.TermsRef = new TermsRef();
if (node["TermsRef"]["ListID"] != null)
{
toUpdate.TermsRef.ListID = node["TermsRef"]["ListID"].InnerText;
}
if (node["TermsRef"]["FullName"] != null)
{
toUpdate.TermsRef.FullName = node["TermsRef"]["FullName"].InnerText;
}
}
if (node["CreditLimit"] != null)
{
toUpdate.CreditLimit = Convert.ToDouble(node["CreditLimit"].InnerText);
}
if (node["VendorTaxIdent"] != null)
{
toUpdate.VendorTaxIdent = node["VendorTaxIdent"].InnerText;
}
if (node["IsVendorEligibleFor1099"] != null)
{
toUpdate.IsVendorEligibleFor1099 = node["IsVendorEligibleFor1099"].InnerText == "true" ? true : false;
}
if (node["Balance"] != null)
{
toUpdate.OpenBalance = Convert.ToDouble(node["Balance"].InnerText);
}
if (node["OpenBalanceDate"] != null)
{
toUpdate.OpenBalanceDate = Convert.ToDateTime(node["OpenBalanceDate"].InnerText);
}
if (node["BillingRateRef"] != null)
{
toUpdate.BillingRateRef = new BillingRateRef();
if (node["BillingRateRef"]["ListID"] != null)
{
toUpdate.BillingRateRef.ListID = node["BillingRateRef"]["ListID"].InnerText;
}
if (node["BillingRateRef"]["FullName"] != null)
{
toUpdate.BillingRateRef.FullName = node["BillingRateRef"]["FullName"].InnerText;
}
}
if (node["ExternalGUID"] != null)
{
toUpdate.ExternalGUID = node["ExternalGUID"].InnerText;
}
if (node["SalesTaxCodeRef"] != null)
{
toUpdate.SalesTaxCodeRef = new SalesTaxCode();
if (node["SalesTaxCodeRef"]["ListID"] != null)
{
toUpdate.SalesTaxCodeRef.ListID = node["SalesTaxCodeRef"]["ListID"].InnerText;
}
if (node["SalesTaxCodeRef"]["FullName"] != null)
{
toUpdate.SalesTaxCodeRef.FullName = node["SalesTaxCodeRef"]["FullName"].InnerText;
}
}
if (node["SalesTaxCountry"] != null)
{
toUpdate.SalesTaxCountry = node["SalesTaxCountry"].InnerText;
}
if (node["IsSalesTaxAgency"] != null)
{
toUpdate.IsSalesTaxAgency = node["IsSalesTaxAgency"].InnerText == "true" ? true : false;
}
if (node["TaxRegistrationNumber"] != null)
{
toUpdate.TaxRegistrationNumber = node["TaxRegistrationNumber"].InnerText;
}
if (node["ReportingPeriod"] != null)
{
toUpdate.ReportingPeriod = node["ReportingPeriod"].InnerText;
}
if (node["IsTaxTrackedOnPurchases"] != null)
{
toUpdate.IsTaxTrackedOnPurchases = node["IsTaxTrackedOnPurchases"].InnerText == "true" ? true : false;
}
if (node["TaxOnPurchasesAccountRef"] != null)
{
toUpdate.TaxOnPurchasesAccountRef = new TaxOnPurchasesAccountRef();
if (node["TaxOnPurchasesAccountRef"]["ListID"] != null)
{
toUpdate.TaxOnPurchasesAccountRef.ListID = node["TaxOnPurchasesAccountRef"]["ListID"].InnerText;
}
if (node["TaxOnPurchasesAccountRef"]["FullName"] != null)
{
toUpdate.TaxOnPurchasesAccountRef.FullName = node["TaxOnPurchasesAccountRef"]["FullName"].InnerText;
}
}
if (node["IsTaxTrackedOnSales"] != null)
{
toUpdate.IsTaxTrackedOnSales = node["IsTaxTrackedOnSales"].InnerText == "true" ? true : false;
}
if (node["TaxOnSalesAccountRef"] != null)
{
toUpdate.TaxOnSalesAccountRef = new TaxOnSalesAccountRef();
if (node["TaxOnSalesAccountRef"]["ListID"] != null)
{
toUpdate.TaxOnSalesAccountRef.ListID = node["TaxOnSalesAccountRef"]["ListID"].InnerText;
}
if (node["TaxOnSalesAccountRef"]["FullName"] != null)
{
toUpdate.TaxOnSalesAccountRef.FullName = node["TaxOnSalesAccountRef"]["FullName"].InnerText;
}
}
if (node["IsTaxTrackedOnSales"] != null)
{
toUpdate.IsTaxTrackedOnSales = node["IsTaxTrackedOnSales"].InnerText == "true" ? true : false;
}
if (node["IsTaxOnTax"] != null)
{
toUpdate.IsTaxOnTax = node["IsTaxOnTax"].InnerText == "true" ? true : false;
}
if (node["PrefillAccountRef"] != null)
{
toUpdate.PrefillAccountRef = new PrefillAccountRef();
if (node["PrefillAccountRef"]["ListID"] != null)
{
toUpdate.PrefillAccountRef.ListID = node["PrefillAccountRef"]["ListID"].InnerText;
}
if (node["PrefillAccountRef"]["FullName"] != null)
{
toUpdate.PrefillAccountRef.FullName = node["PrefillAccountRef"]["FullName"].InnerText;
}
}
if (node["CurrencyRef"] != null)
{
toUpdate.CurrencyRef = new Currency();
if (node["CurrencyRef"]["ListID"] != null)
{
toUpdate.CurrencyRef.ListID = node["CurrencyRef"]["ListID"].InnerText;
}
if (node["CurrencyRef"]["FullName"] != null)
{
toUpdate.CurrencyRef.FullName = node["CurrencyRef"]["FullName"].InnerText;
}
}
XmlNodeList extras = node.SelectNodes("DataExtRet");
foreach (XmlNode ex in extras)
{
var name = ex["DataExtName"].InnerText;
var value = ex["DataExtValue"].InnerText;
toUpdate.AddDataEx(name, value);
}
quickbookListVendor.Add(toUpdate);
}
return(quickbookListVendor);
}
public static List <Vendor> getVendors()
{
List <Vendor> list = new List <Vendor>();
//Hashtable list = new Hashtable();
string xml = "";
xml += "<?xml version=\"1.0\"?>";
xml += "<?qbxml version=\"4.0\"?>";
xml += "<QBXML>";
xml += "<QBXMLMsgsRq onError=\"stopOnError\">";
xml += "<VendorQueryRq requestID=\"12\">";
xml += "<IncludeRetElement>ListID</IncludeRetElement>";
xml += "<IncludeRetElement>Name</IncludeRetElement>";
xml += "<IncludeRetElement>FirstName</IncludeRetElement>";
xml += "<IncludeRetElement>CompanyName</IncludeRetElement>";
xml += "<IncludeRetElement>IsActive</IncludeRetElement>";
xml += "<IncludeRetElement>IsVendorEligibleFor1099</IncludeRetElement>";
xml += "<IncludeRetElement>DataExtRet</IncludeRetElement>";
xml += "<OwnerID>0</OwnerID>";
xml += "</VendorQueryRq>";
xml += "</QBXMLMsgsRq>";
xml += "</QBXML>";
if (Vars.qb != null && Vars.qb.isOpen())
{
//vendors.xml
var response = "";
if (Vars.isLocalhost() == true)
{
response = File.ReadAllText(System.AppDomain.CurrentDomain.BaseDirectory + "/xml-debug/vendors.xml");
}
else
{
response = Vars.qb.sendRequest(xml);
}
XmlDocument doc = new XmlDocument();
doc.LoadXml(response);
XmlNodeList rets = doc.SelectNodes("/QBXML/QBXMLMsgsRs/VendorQueryRs/VendorRet");
string message = string.Empty;
foreach (XmlNode node in rets)
{
Vendor v = new Vendor();
v.ListID = node["ListID"].InnerText;
v.Name = node["Name"].InnerText;
v.active = (bool)(node["IsActive"].InnerText == "true");
if (node.SelectNodes("FirstName").Count > 0)
{
v.FirstName = node["FirstName"].InnerText;
}
if (node.SelectNodes("CompanyName").Count > 0)
{
v.CompanyName = node["CompanyName"].InnerText;
}
v.IsVendorEligibleFor1099 = (bool)(node["IsVendorEligibleFor1099"].InnerText == "true");
//v.Balance = float.Parse(node["Balance"].InnerText);
XmlNodeList extras = node.SelectNodes("DataExtRet");
foreach (XmlNode ex in extras)
{
var name = ex["DataExtName"].InnerText;
var value = ex["DataExtValue"].InnerText;
v.AddDataEx(name, value);
}
list.Add(v);
}
}
return(list);
}
