private void btnGenerarPDF_Click(object sender, EventArgs e)
{
DataSet dsXML = new DataSet();
string AppPathXSD = AppDomain.CurrentDomain.BaseDirectory;
AppPathXSD = AppPathXSD + @"\Reports\cfdv32_EGSA.xsd";
dsXML.ReadXmlSchema(AppPathXSD);
dsXML.ReadXml(new StringReader(sXMLSAT.ToString()));
CreatePDF crearPDF = new CreatePDF();
crearPDF.fCreatePDF(dsXML, sXMLSAT, txtboxShipperId.Text);
}
void void_GeneraXML(object sender, EventArgs e)
{
String sShipperId = _view.ShipperIdStr;
DataSet datasetCFDI_XML = new DataSet();
long transactionID = _random.Next();
var token = String.Empty;
string Error;
ConvertToXML convertToXML = new ConvertToXML();
MemoryStream memoryStreamXML = new MemoryStream();
string sXMLPath = Util.XMLPath;
string sQRCodePath = Util.QRCodePath;
try
{
dataRetrieve.SelectDataRetrieve("update xCFDIXML set Start_DateTime = GETDATE() where shipperid = '" + _view.ShipperIdStr + "'", Util.ConnectionString);
XmlTextWriter writerXML = new XmlTextWriter(memoryStreamXML, new UTF8Encoding(false));
writerXML.WriteStartDocument();
writerXML.WriteStartElement("cfdi", ConvertToXML.sNivel0, "http://www.sat.gob.mx/cfd/3");
writerXML.WriteAttributeString("xmlns", "xsi", null, "http://www.w3.org/2001/XMLSchema-instance");
writerXML.WriteAttributeString("xsi", "schemaLocation", null, "http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv32.xsd");
datasetCFDI_XML = dataRetrieve.SelectDataRetrieve("select * from xvr_CFDI_XML Where [null/ShipperId] = '" + sShipperId + "'", Util.ConnectionString);
writerXML = convertToXML.fAddLevesXML(datasetCFDI_XML, writerXML, "", "");
writerXML.Flush();
writerXML.Close();
string XMLString = Encoding.UTF8.GetString(memoryStreamXML.ToArray());
XDocument xmlParser = new XDocument();
xmlParser = XDocument.Parse(XMLString);
dataRetrieve.SelectDataRetrieve("update xCFDIXML set status = 'P', XMLParser = '" + xmlParser.ToString() + "' where shipperid = '" + _view.ShipperIdStr + "'", Util.ConnectionString);
#region READ XML AND SEND TO SELLADO Y TIMBRADO
Error = Util.CreateToken(Util.RFC, transactionID, ref token);
if (!string.IsNullOrEmpty(Error))
{
_view.ShowUnknownError(Error);
return;
}
transactionID = _random.Next();
var invoiceXML = new SrvInvoices.ComprobanteXML();
invoiceXML.DatosXML = XMLString;
using (var invoiceSrv = new SrvInvoices.ComprobantesClient())
{
var advertencias = invoiceSrv.SellaTimbraXML(ref invoiceXML, Util.RFC, token, ref transactionID);
}
transactionID = _random.Next();
XDocument XMLTimbradoSelladoFirmado = new XDocument();
XMLTimbradoSelladoFirmado = XDocument.Parse(invoiceXML.DatosXML);
XElement signatureSAT = new XElement("{http://www.sat.gob.mx/TimbreFiscalDigital}TimbreFiscalDigital");
string uuid = XMLTimbradoSelladoFirmado.Root.Descendants(signatureSAT.Name).ToArray()[0].Attribute("UUID").Value;
string FechaTimbrado = XMLTimbradoSelladoFirmado.Root.Descendants(signatureSAT.Name).ToArray()[0].Attribute("FechaTimbrado").Value;
string selloCFD = XMLTimbradoSelladoFirmado.Root.Descendants(signatureSAT.Name).ToArray()[0].Attribute("selloCFD").Value;
string noCertificadoSAT = XMLTimbradoSelladoFirmado.Root.Descendants(signatureSAT.Name).ToArray()[0].Attribute("noCertificadoSAT").Value;
string selloSAT = XMLTimbradoSelladoFirmado.Root.Descendants(signatureSAT.Name).ToArray()[0].Attribute("selloSAT").Value;
dataRetrieve.SelectDataRetrieve("update xCFDIXML set status = 'U', UUID='" + uuid + "', XMLSAT = '" + XMLTimbradoSelladoFirmado.ToString() + "', InvcDate = '" + FechaTimbrado + "' where shipperid = '" + _view.ShipperIdStr + "'", Util.ConnectionString);
dataRetrieve.SelectDataRetrieve("update SoShipHeader set InvcDate = '" + FechaTimbrado + "' where shipperid = '" + _view.ShipperIdStr + "'", Util.ConnectionString);
#endregion
#region READ DATASET FROM XML
DataSet dsXML = new DataSet();
string AppPathXSD = AppDomain.CurrentDomain.BaseDirectory;
AppPathXSD = AppPathXSD + @"\Reports\cfdv32_EGSA.xsd";
dsXML.ReadXmlSchema(AppPathXSD);
dsXML.ReadXml(new StringReader(XMLTimbradoSelladoFirmado.ToString()));
string sSerie;
string sFolio;
string sFactura;
string sRFCCliente;
sSerie = dsXML.Tables["Comprobante"].Rows[0]["serie"].ToString();
sFolio = dsXML.Tables["Comprobante"].Rows[0]["folio"].ToString();
sRFCCliente = dsXML.Tables["Receptor"].Rows[0]["rfc"].ToString();
sFactura = sSerie + sFolio;
#endregion
#region CREATE QRCODE
using (var repositorySrv = new SrvRepository.RepositorioClient())
{
var infoQR = repositorySrv.ObtenerQR(Util.RFC, token, ref transactionID, uuid);
var memoryStream = new System.IO.MemoryStream(infoQR.Imagen);
_view.BarcodeQR = new System.Drawing.Bitmap(memoryStream);
System.Drawing.Bitmap imageQR = new System.Drawing.Bitmap(memoryStream);
imageQR.Save(sQRCodePath + sFactura + ".bmp");
_view.ResultStr = XMLTimbradoSelladoFirmado.ToString();
dataRetrieve.SelectDataRetrieve("update xCFDIXML set status = 'Q' where shipperid = '" + _view.ShipperIdStr + "'", Util.ConnectionString);
}
#endregion
#region SAVE XML TO DISK
StringBuilder lsOutputFile = new StringBuilder(string.Format(@"{0}\{1}{2}{3}", sXMLPath, sRFCCliente, sFactura, ".XML"));
StringBuilder loXML = new StringBuilder();
loXML.Append(XMLTimbradoSelladoFirmado.ToString());
using (StreamWriter loSW = new StreamWriter(lsOutputFile.ToString(), false, Encoding.UTF8))
{
loSW.Write(loXML.ToString());
}
dataRetrieve.SelectDataRetrieve("update xCFDIXML set status = 'X' where shipperid = '" + _view.ShipperIdStr + "'", Util.ConnectionString);
#endregion
CreatePDF crearPDF = new CreatePDF();
crearPDF.fCreatePDF(dsXML, invoiceXML.DatosXML, _view.ShipperIdStr);
}
#region Invoice service exceptions
catch (FaultException <SrvInvoices.FallaServicio> serviceFault)
{
using (var errorForm = new Forms.Error(TranslateFault.ToServiceError(serviceFault.Detail)))
{
errorForm.ShowDialog();
}
}
catch (FaultException <SrvInvoices.FallaSesion> sessionFauld)
{
using (var errorForm = new Forms.Error(TranslateFault.ToSessionError(sessionFauld.Detail)))
{
errorForm.ShowDialog();
}
}
catch (FaultException <SrvInvoices.FallaValidacion> validationFault)
{
using (var errorForm = new Forms.Error(TranslateFault.ToValidationError(validationFault.Detail)))
{
errorForm.ShowDialog();
}
}
#endregion
//catch (Exception ex)
//{
// _view.ShowUnknownError(ex.Message);
//}
}