private void Mywork_OnDoWork(object sender, DoWorkEventArgs e)
{
using (ReportClass rptH = new ReportClass())
{
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
CrystalDecisions.Shared.ExcelDataOnlyFormatOptions excelOptsDataOnly = CrystalDecisions.Shared.ExportOptions.CreateDataOnlyExcelFormatOptions();
CrystalDecisions.Shared.ExcelFormatOptions excelOpts = CrystalDecisions.Shared.ExportOptions.CreateExcelFormatOptions();
CrystalDecisions.Shared.MicrosoftMailDestinationOptions mailOpts = CrystalDecisions.Shared.ExportOptions.CreateMicrosoftMailDestinationOptions();
CrystalDecisions.Shared.DiskFileDestinationOptions diskOpts = CrystalDecisions.Shared.ExportOptions.CreateDiskFileDestinationOptions();
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
ReportDocument rpt = new ReportDocument();
rpt.Load(file);
pdfOpts.UsePageRange = false;
exportOpts.ExportFormatOptions = pdfOpts;
excelOptsDataOnly.UseWorksheetFunctionsForSummaries = true;
excelOptsDataOnly.MaintainColumnAlignment = true;
string MyRptName = rpt.FileName.ToString();
//MyRptName = @"D:\ITProject\Tin\Tin2.xls";
MyRptName = filepath + "\\" + filenameNoExtension + ".xls";
//diskOpts.DiskFileName = "World Sales Report.pdf";
diskOpts.DiskFileName = MyRptName;
exportOpts.ExportDestinationOptions = diskOpts;
//exportOpts.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.MicrosoftMail;
exportOpts.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
//exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.ExcelRecord;
rpt.Export(exportOpts);
for (int i = 0; i <= 100; i = i + 20)
{
// Report progress to 'UI' thread
mywork.ReportProgress(i);
// Simulate long task
System.Threading.Thread.Sleep(100);
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
try
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/Iva_Compras.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "Iva_Compras.xsd", true);
oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
bool HayME = false;
string reportPath = "";
if (Session["monedasExtranjeras"] != null)
{
HayME = (bool)Session["monedasExtranjeras"];
}
if (!HayME)
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaComprasCR.rpt");
}
else
{
reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/IvaComprasMECR.rpt");
}
oRpt.Load(reportPath);
Entidades.IvaCompras ivaCompras = new Entidades.IvaCompras();
if (Session["ivaCompras"] != null)
{
ivaCompras = (Entidades.IvaCompras)Session["ivaCompras"];
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(ivaCompras.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, ivaCompras);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
oRpt.SetDataSource(ds);
}
else
{
Response.Redirect("~/Facturacion/Electronica/Reportes/IvaComprasFiltros.aspx", true);
}
string formatoRptExportar = "";
if (Session["formatoRptExportar"] != null)
{
formatoRptExportar = (string)Session["formatoRptExportar"];
}
if (Session["mostrarFechaYHora"] != null)
{
if ((bool)Session["mostrarFechaYHora"] == false)
{
oRpt.DataDefinition.FormulaFields["MostrarFechaYHora"].Text = "'N'";
}
}
oRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
oRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
oRpt.DataDefinition.FormulaFields["RazSoc"].Text = "'" + ((Entidades.Sesion)Session["Sesion"]).Cuit.RazonSocial + "'";
if (formatoRptExportar == "")
{
CrystalReportViewer1.GroupTreeStyle.ShowLines = false;
CrystalReportViewer1.HasToggleGroupTreeButton = false;
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CrystalReportViewer1.ReportSource = oRpt;
CrystalReportViewer1.HasPrintButton = true;
}
else
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(ivaCompras.Cuit);
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaCompras.PeriodoDsd).ToString("yyyyMMdd"));
sb.Append("-");
sb.Append(Convert.ToDateTime(ivaCompras.PeriodoHst).ToString("yyyyMMdd"));
if (formatoRptExportar == "PDF")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
if (formatoRptExportar == "Excel")
{
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.ExcelFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreateExcelFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
oRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, Server.MapPath("~/TempExcel/") + sb.ToString() + ".xls");
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment; filename=" + sb.ToString() + ".xls" + ";");
response.TransmitFile(Server.MapPath("~/TempExcel/" + sb.ToString() + ".xls"));
response.Flush();
response.End();
}
}
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
WebForms.Excepciones.Redireccionar(ex, "~/NotificacionDeExcepcion.aspx");
}
}
public JsonResult SendMail(string Lab, string testid)
{
var tosend = "*****@*****.**";
string path = "";
PatientLabReportPrint rptPatientLabReports = new PatientLabReportPrint();
DataSet ds = BL_obj.SendMail(Lab, testid);
List <PatientLabReportPrint> searchlist = new List <PatientLabReportPrint>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchlist.Add(new PatientLabReportPrint
{
EmailID = dr["EmailID"].ToString(),
EmailPassword = dr["EmailPassword"].ToString()
});
}
ReportDocument crystalReport = new ReportDocument(); // creating object of crystal report
crystalReport.Load(Path.Combine(Server.MapPath("~/Report"), "RptPatientLabReports.rpt")); // path of report
crystalReport.SetDataSource(ds); // binding datatable
//SetDataSource(ds);
int email1 = 0;
string hospitalname = ds.Tables[0].Rows[0]["HospitalName"].ToString();
string patname = ds.Tables[1].Rows[0]["PatientName"].ToString();
path = "c:\\LabReports" + "ss" + ".pdf";
email1++;
//CrystalDecisions.Shared.ExportOptions CrExportOptions;
CrystalDecisions.Shared.DiskFileDestinationOptions CrDiskFileDestinationOptions = new CrystalDecisions.Shared.DiskFileDestinationOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions CrFormatTypeOptions = new CrystalDecisions.Shared.PdfRtfWordFormatOptions();
var filename = Path.GetFileName(crystalReport.FileName);
var extention = Path.GetExtension(crystalReport.FileName);
var filenamethoutextenction = Path.GetFileNameWithoutExtension(crystalReport.FileName);
CrDiskFileDestinationOptions.DiskFileName = crystalReport.FileName;
//CrExportOptions = rptPatientLabReports.ExportOptions;
//{
// CrExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
// CrExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
// CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
// CrExportOptions.FormatOptions = CrFormatTypeOptions;
//}
//rptPatientLabReports.Export();
email1++;
string email = ds.Tables[0].Rows[0]["EmailID"].ToString();
string pass = ds.Tables[0].Rows[0]["EmailPassword"].ToString();
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress(email);
mail.To.Add("*****@*****.**");
// mail.Subject = txtSubject.Text;
mail.Attachments.Add(new Attachment(@"C:\Users\Saurabh\Downloads\Nilesh (1).pdf"));
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "saurabh@123");
SmtpServer.EnableSsl = true;
SmtpServer.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Send(mail);
bool result = false;
return(Json(result, JsonRequestBehavior.AllowGet));
}
protected void Page_Load(object sender, EventArgs e)
{
var culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB");
culture.NumberFormat.CurrencySymbol = string.Empty;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
base.InitializeCulture();
if (Session["lote"] == null)
{
Response.Redirect("~/Inicio.aspx");
}
else
{
try
{
string lcomp = Server.MapPath("~/Facturacion/Electronica/Reportes/lote_comprobantesT.xsd");
System.IO.File.Copy(lcomp, @System.IO.Path.GetTempPath() + "lote_comprobantesT.xsd", true);
string imagen = Server.MapPath("~/Facturacion/Electronica/Reportes/Imagen.xsd");
System.IO.File.Copy(imagen, @System.IO.Path.GetTempPath() + "Imagen.xsd", true);
facturaRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string reportPath = Server.MapPath("~/Facturacion/Electronica/Reportes/FacturaT.rpt");
facturaRpt.Load(reportPath);
FeaEntidades.Turismo.lote_comprobantes lc = (FeaEntidades.Turismo.lote_comprobantes)Session["lote"];
AsignarCamposOpcionales(lc);
ReemplarResumenImportesMonedaExtranjera(lc);
DataSet ds = new DataSet();
XmlSerializer objXS = new XmlSerializer(lc.GetType());
StringWriter objSW = new StringWriter();
objXS.Serialize(objSW, lc);
StringReader objSR = new StringReader(objSW.ToString());
ds.ReadXml(objSR);
bool original = true;
try
{
original = (bool)Session["EsComprobanteOriginal"];
if (original == false)
{
facturaRpt.DataDefinition.FormulaFields["Borrador"].Text = "'BORRADOR'";
}
}
catch
{
}
facturaRpt.SetDataSource(ds);
facturaRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
facturaRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
IncrustarLogo(lc.comprobante[0].cabecera.informacion_vendedor.cuit.ToString(), lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString());
string cae = lc.comprobante[0].cabecera.informacion_comprobante.cae;
if (cae.Replace(" ", string.Empty).Equals(string.Empty))
{
cae = "99999999999999";
}
GenerarCodigoBarras(lc.comprobante[0].cabecera.informacion_vendedor.cuit + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00") + lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000") + cae + System.DateTime.Now.ToString("yyyyMMdd"));
AsignarParametros(lc.comprobante[0].resumen.importe_total_factura);
facturaRpt.Subreports["impuestos"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
facturaRpt.Subreports["resumen"].DataDefinition.FormulaFields["TipoDeComprobante"].Text = "'" + lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString() + "'";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(lc.comprobante[0].cabecera.informacion_vendedor.cuit);
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00"));
sb.Append("-");
sb.Append(lc.comprobante[0].cabecera.informacion_comprobante.numero_comprobante.ToString("00000000"));
if (original == false)
{
sb.Append("-BORRADOR");
}
CrystalDecisions.Shared.ExportOptions exportOpts = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.PdfRtfWordFormatOptions pdfOpts = CrystalDecisions.Shared.ExportOptions.CreatePdfRtfWordFormatOptions();
exportOpts.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
exportOpts.ExportFormatOptions = pdfOpts;
facturaRpt.ExportToHttpResponse(exportOpts, Response, true, sb.ToString());
}
catch (System.Threading.ThreadAbortException)
{
Trace.Warn("Thread abortado");
}
catch (Exception ex)
{
RN.Sesion.GrabarLogTexto(Server.MapPath("~/Consultar.txt"), "Reporte: " + ex.Message + " " + ex.StackTrace);
throw new Exception(ex.Message);
//WebForms.Excepciones.Redireccionar(ex, "~/Excepciones/Excepciones.aspx");
}
}
}