private TaxesXMLDTO AddLocalTax(decimal lDblAmount, double lDblBase)
{
TaxesXMLDTO lObjLocalTax = new TaxesXMLDTO();
lObjLocalTax.Tax = "ISH";
lObjLocalTax.Rate = "0.02";
lObjLocalTax.Amount = lDblAmount.ToString();
lObjLocalTax.TypeFactor = string.Empty;
return(lObjLocalTax);
}
private TaxesXMLDTO AddIeps(decimal lDblAmount, double lDblBase)
{
TaxesXMLDTO lObjTaxIeps = new TaxesXMLDTO();
lObjTaxIeps.Tax = "003";
lObjTaxIeps.Rate = "1";
lObjTaxIeps.Amount = (Convert.ToDecimal(lDblAmount) - Convert.ToDecimal(lDblBase)).ToString();
lObjTaxIeps.Base = "0.1"; //??
lObjTaxIeps.TypeFactor = "Cuota"; // ??
return(lObjTaxIeps);
}
/// <summary>
/// Lee los campos del xml
/// <summary>
public PurchaseXMLDTO ReadXML(string pStrFileName)
{
XmlTextReader reader = new XmlTextReader(pStrFileName);
XDocument lObjDoc = XDocument.Load(pStrFileName);
XNamespace cfdiNamespace = lObjDoc.Root.Name.Namespace;
XElement lElementAdenda = lObjDoc.Root.Element(cfdiNamespace + "Addenda");
if (lElementAdenda != null)
{
lObjDoc.Root.Element(cfdiNamespace + "Addenda").Remove();
}
List <string> lLstStrSchemas = GetXmlSchemas(lObjDoc);
LogService.WriteInfo("Obtencion de esquemas correctamente");
//DownloadSchema(lLstStrSchemas);
List <string> lStrLstXML = new List <string>();//lStrValidateSchema(lObjDoc, lLstStrSchemas); //
PurchaseXMLDTO lObjXML = new PurchaseXMLDTO();
string lStrField = string.Empty;
if (lStrLstXML.Count == 0)
{
try {
XNamespace cfdi;
cfdi = lObjDoc.Root.Name.Namespace;
XNamespace tfd = @"http://www.sat.gob.mx/TimbreFiscalDigital";
lStrField = "Complemento " + " " + "TimbreFiscalDigital" + " UUID ";
lObjXML.FolioFiscal = lObjDoc.Root.Element(cfdi + "Complemento").Element(tfd + "TimbreFiscalDigital").Attribute("UUID").Value;
lStrField = "Receptor " + " " + "Rfc";
lObjXML.RFCReceptor = lObjDoc.Root.Element(cfdi + "Receptor").Attribute("Rfc").Value;
string lStrRFC = mObjPurchasesServiceFactory.GetPurchaseXmlService().GetRFC();
if (lStrRFC != lObjXML.RFCReceptor)
{
SAPbouiCOM.Framework.Application.SBO_Application.MessageBox("RFC de receptor incorrecto");
lObjXML = null;
}
else
{
if (string.IsNullOrEmpty(lObjXML.FolioFiscal))
{
lStrLstXML.Add("El folio fiscal no existe en el xml");
}
else
{
if (ValidateUUID(lObjXML.FolioFiscal))
{
lStrLstXML.Add(" El folio fiscal ya existe en la base de datos");
}
else
{
UIApplication.ShowSuccess(string.Format("XML válido"));
lStrField = "Comprobante" + " " + "Folio";
XAttribute lObjAttribute = lObjDoc.Element(cfdi + "Comprobante").Attribute("Folio");
if (lObjAttribute != null)
{
lObjXML.ReferenceFolio = lObjDoc.Element(cfdi + "Comprobante").Attribute("Folio").Value;
}
lStrField = "Emisor " + " " + "Rfc";
lObjXML.RFCProvider = lObjDoc.Root.Element(cfdi + "Emisor").Attribute("Rfc").Value;
lStrField = "Emisor" + " " + "Nombre";
lObjXML.BPName = lObjDoc.Root.Element(cfdi + "Emisor").Attribute("Nombre").Value;
lStrField = "Comprobante" + " " + "Fecha";
lObjXML.Date = lObjDoc.Element(cfdi + "Comprobante").Attribute("Fecha").Value;
lStrField = "Comprobante" + " " + "SubTotal";
lObjXML.SubTotal = lObjDoc.Element(cfdi + "Comprobante").Attribute("SubTotal").Value;
lStrField = "Comprobante" + " " + "Total";
lObjXML.Total = lObjDoc.Element(cfdi + "Comprobante").Attribute("Total").Value;
lStrField = "Conceptos";
IEnumerable <XElement> lLstConcepts = lObjDoc.Root.Element(cfdi + "Conceptos").Elements();
List <ConceptsXMLDTO> lLstConceptsXMLDTO = new List <ConceptsXMLDTO>();
foreach (XElement lObjElements in lLstConcepts)
{
ConceptsXMLDTO lObjConcepts = new ConceptsXMLDTO();
lStrField = "Conceptos" + "//" + "ClaveProdServ";
lObjConcepts.ClassificationCode = lObjElements.Attribute("ClaveProdServ").Value;
lStrField = "Conceptos" + "//" + "Cantidad";
lObjConcepts.Quantity = lObjElements.Attribute("Cantidad").Value;
// lStrField = "Conceptos" + "//" + "ClaveProdServ";
//lObjConcepts.CodeItmProd = lObjElements.Attribute("ClaveProdServ").Value;
lStrField = "Conceptos" + "//" + "ClaveUnidad";
lObjConcepts.UnitType = lObjElements.Attribute("ClaveUnidad").Value;
lStrField = "Conceptos" + "//" + "Descripcion";
lObjConcepts.Description = lObjElements.Attribute("Descripcion").Value;
lStrField = "Conceptos" + "//" + "Importe";
lObjConcepts.Amount = lObjElements.Attribute("Importe").Value;
//lObjConcepts.NoIdentification = lObjElements.Attribute("NoIdentificacion").Value != null ? lObjElements.Attribute("NoIdentificacion").Value : "";
lStrField = "Conceptos" + "//" + "Unidad";
lObjConcepts.Unit = (string)lObjElements.Attribute("Unidad");
lStrField = "Conceptos" + "//" + "ValorUnitario";
lObjConcepts.UnitPrice = lObjElements.Attribute("ValorUnitario").Value;
XAttribute lObjDiscount = lObjElements.Attribute("Descuento");
if (lObjDiscount != null)
{
lStrField = "Conceptos" + "//" + "Descuento";
lObjConcepts.Discount = lObjDiscount.Value;
//lObjConcepts.Amount = (Convert.ToDecimal(lObjConcepts.Amount) - Convert.ToDecimal(lObjConcepts.Discount)).ToString();
}
if (lObjElements.HasElements)
{
XElement lObjHasTax = lObjElements.Element(cfdi + "Impuestos");
if (lObjHasTax != null)
{
XElement lObjHasTraslate = lObjElements.Element(cfdi + "Impuestos").Element(cfdi + "Traslados");
if (lObjHasTraslate != null)
{
lStrField = "Conceptos//Impuestos" + "//" + "Traslados";
IEnumerable <XElement> lLstTaxesXml = lObjElements.Element(cfdi + "Impuestos").Elements(cfdi + "Traslados").Elements();
List <TaxesXMLDTO> lLstTaxes = new List <TaxesXMLDTO>();
foreach (XElement lObjTax in lLstTaxesXml)
{
TaxesXMLDTO lObjTaxes = new TaxesXMLDTO();
lStrField = "Conceptos//Impuestos//Traslados" + "//" + "Importe";
lObjTaxes.Amount = (string)lObjTax.Attribute("Importe");
if (string.IsNullOrEmpty(lObjTaxes.Amount))
{
lObjTaxes.Amount = "0";
}
if (Convert.ToDouble(lObjTaxes.Amount) > 0)
{
lStrField = "Conceptos//Impuestos//Traslados" + "//" + "TasaOCuota";
lObjTaxes.Rate = (string)lObjTax.Attribute("TasaOCuota");
if (string.IsNullOrEmpty(lObjTaxes.Rate))
{
lObjTaxes.Rate = "";
}
//lObjTaxes.Rate = lObjTax.Attribute("TasaOCuota").Value;
lStrField = "Conceptos//Impuestos//Traslados" + "//" + "Importe";
lObjTaxes.Amount = (string)lObjTax.Attribute("Importe");
if (string.IsNullOrEmpty(lObjTaxes.Amount))
{
lObjTaxes.Amount = "";
}
lStrField = "Conceptos//Impuestos//Traslados" + "//" + "Base";
lObjTaxes.Base = lObjTax.Attribute("Base").Value;
lStrField = "Conceptos//Impuestos//Traslados" + "//" + "Impuesto";
lObjTaxes.Tax = lObjTax.Attribute("Impuesto").Value;
lStrField = "Conceptos//Impuestos//Traslados" + "//" + "TipoFactor";
lObjTaxes.TypeFactor = lObjTax.Attribute("TipoFactor").Value;
lLstTaxes.Add(lObjTaxes);
decimal lDecAmount = Convert.ToDecimal(lObjConcepts.Amount) - Convert.ToDecimal(lObjConcepts.Discount);
decimal lDecAmount1 = lDecAmount + Convert.ToDecimal(0.01);
decimal lDecAmount01 = lDecAmount - Convert.ToDecimal(0.01);
decimal lDecBase = Convert.ToDecimal(lObjTaxes.Base);
//if(lObjTaxes.Tax == "002" && (lDecAmount != lDecBase && lDecAmount1 != lDecBase && lDecAmount01 != lDecBase)) {
if (lObjTaxes.Tax == "002" && !((lDecAmount1 >= lDecBase && lDecAmount <= lDecBase) || (lDecAmount01 <= lDecBase && lDecAmount01 >= lDecBase)))
{
if (Convert.ToDouble(lObjTaxes.Amount) > 0)
{
lObjConcepts.Amount = (Convert.ToDecimal(lObjTaxes.Base) + Convert.ToDecimal(lObjConcepts.Discount)).ToString();
//lObjConcepts.Amount = lObjTaxes.Base;
lObjConcepts.UnitPrice = Convert.ToDecimal((((Convert.ToDouble(lObjTaxes.Base) + Convert.ToDouble(lObjConcepts.Discount)) / Convert.ToDouble(lObjConcepts.Quantity)))).ToString();
lLstTaxes.Add(AddIeps(lDecAmount, Convert.ToDouble(lObjTaxes.Base)));
}
}
}
}
lObjConcepts.LstTaxes = lLstTaxes;
}
XElement lObjHasWht = lObjElements.Element(cfdi + "Impuestos").Element(cfdi + "Retenciones");
if (lObjHasWht != null)
{
//Retenciones
lStrField = "Conceptos//Impuestos//Retenciones";
IEnumerable <XElement> lXmlWithholdingTax = lObjElements.Element(cfdi + "Impuestos").Elements(cfdi + "Retenciones").Elements();
List <TaxesXMLDTO> lLstWithholdingTax = new List <TaxesXMLDTO>();
foreach (XElement lObjTax in lXmlWithholdingTax)
{
TaxesXMLDTO lObjTaxes = new TaxesXMLDTO();
lStrField = "Conceptos//Impuestos//Retenciones" + "//" + "TasaOCuota";
lObjTaxes.Rate = lObjTax.Attribute("TasaOCuota").Value;
lStrField = "Conceptos//Impuestos//Retenciones" + "//" + "Importe";
lObjTaxes.Amount = lObjTax.Attribute("Importe").Value;
lStrField = "Conceptos//Impuestos//Retenciones" + "//" + "Impuesto";
lObjTaxes.Tax = lObjTax.Attribute("Impuesto").Value;
lStrField = "Conceptos//Impuestos//Retenciones" + "//" + "TipoFactor";
lObjTaxes.TypeFactor = lObjTax.Attribute("TipoFactor").Value;
// lObjTaxes.Base = lObjTax.Attribute("Base").Value != null ? lObjTax.Attribute("Base").Value : "";
lLstWithholdingTax.Add(lObjTaxes);
}
lObjConcepts.LstWithholdingTax = lLstWithholdingTax;
}
}
}
lLstConceptsXMLDTO.Add(lObjConcepts);
}
lObjXML.ConceptLines = lLstConceptsXMLDTO;
List <SchemaDTO> lLstSchemaName = GetSchemasName(lObjDoc);
if (lLstSchemaName.Where(x => x.Key == "implocal").Count() > 0)
{
XNamespace XNSimplocal = lLstSchemaName.Where(x => x.Key == "implocal").FirstOrDefault().Value;
lStrField = "Conceptos//ImpuestosLocales//TotaldeTraslados";
XElement lXElement = lObjDoc.Root.Element(cfdi + "Complemento");
IEnumerable <XElement> XImpLoc = lXElement.Descendants();//.Element(XNSimplocal + "ImpuestosLocales");
IEnumerable <XAttribute> xLstAtr = XImpLoc.Attributes();
XAttribute xAtr = xLstAtr.Where(x => x.Name == "TotaldeTraslados").FirstOrDefault();
if (xAtr != null)
{
TaxesXMLDTO lObjTaxesXMLDTO = AddLocalTax(Convert.ToDecimal(xAtr.Value), 0.02);
lObjXML.LstLocalTax = new List <TaxesXMLDTO>();
lObjXML.LstLocalTax.Add(lObjTaxesXMLDTO);
}
}
}
XElement lObjImpuestos = lObjDoc.Root.Element(cfdi + "Impuestos");
if (lObjImpuestos != null)
{
lStrField = "Impuestos" + " " + "TotalImpuestosTrasladados";
XAttribute lObjTotalTraslados = lObjImpuestos.Attribute("TotalImpuestosTrasladados");
if (lObjTotalTraslados != null)
{
lObjXML.TaxesTransfers = lObjDoc.Root.Element(cfdi + "Impuestos").Attribute("TotalImpuestosTrasladados").Value;
}
lStrField = "Impuestos//Retenciones";
IEnumerable <XElement> lLstXMLWithholdingTaxDoc = lObjDoc.Root.Element(cfdi + "Impuestos").Elements(cfdi + "Retenciones").Elements();
List <TaxesXMLDTO> lLstWithholdingTaxDoc = new List <TaxesXMLDTO>();
foreach (XElement lObjTax in lLstXMLWithholdingTaxDoc)
{
TaxesXMLDTO lObjTaxes = new TaxesXMLDTO();
lStrField = "Impuestos//Retenciones" + "//" + "Importe";
lObjTaxes.Amount = lObjTax.Attribute("Importe").Value;
lStrField = "Impuestos//Retenciones" + "//" + "Importe";
lObjTaxes.Tax = lObjTax.Attribute("Impuesto").Value;
// lObjTaxes.Base = lObjTax.Attribute("Base").Value != null ? lObjTax.Attribute("Base").Value : "";
lLstWithholdingTaxDoc.Add(lObjTaxes);
lStrField = string.Empty;
}
lObjXML.WithholdingTax = lLstWithholdingTaxDoc;
}
}
//}
}
}
catch (Exception ex) {
lObjXML = null;
lStrLstXML.Add(lStrField);
LogService.WriteError("ReadXMLService (ReadXML) " + ex.Message + ": " + lStrField);
LogService.WriteError(ex);
}
}
if (lStrLstXML.Count > 0)
{
lObjXML = null;
string lStrMessage = string.Format("Error en {0}:\n{1}",
(lStrLstXML.Count == 1 ? "el siguiente campo" : "los siguientes campos " + lStrField),
string.Join("\n", lStrLstXML.Select(x => string.Format("-{0}", x)).ToArray()));
SAPbouiCOM.Framework.Application.SBO_Application.MessageBox(lStrMessage);
LogService.WriteError("ReadXMLService (ReadXML) " + lStrMessage);
}
return(lObjXML);
}