private void GeneratePDF()
{
ReportDocument rpt = new ReportDocument();
switch (cboView.SelectedItem.Value)
{
case "0":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/ChartOfAccountsDetails.rpt"));
break;
case "1":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/ChartOfAccountsSummary.rpt"));
break;
}
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\RetailPlus\temp\");
string strFileName = "chartofacc_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".pdf";
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
dest.DiskFileName = strPath + strFileName;
exportop = rpt.ExportOptions;
SetDataSource(rpt);
exportop.DestinationOptions = dest;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
exportop.ExportFormatType = ExportFormatType.PortableDocFormat;
rpt.Export(); rpt.Close(); rpt.Dispose();
fraViewer.Attributes.Add("src","/RetailPlus/temp/" + strFileName);
}
public void ExportarRelatorioPdf(string caminho_arquivo)
{
InicializaRpt();
foreach (var p in _relatorio.parametros)
{
relatorio.SetParameterValue(p.parametro, p.valor);
}
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = caminho_arquivo;
CrExportOptions = relatorio.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
relatorio.Export();
//((BasePage)this.Page).ResponsePdf(adExtratoPDF.caminho_arquivo, adExtratoPDF.nome_arquivo);
//ResponsePdf(adExtratoPDF.caminho_arquivo, adExtratoPDF.nome_arquivo);
}
private void GeneraReport(string StringaOdl)
{
report_pmp DtRpt = new report_pmp();
TheSite.SchemiXSD.ReportPmp ds = new TheSite.SchemiXSD.ReportPmp();
ds = DtRpt.GetDataRpt(StringaOdl);
string pathRptSource = Server.MapPath(Request.ApplicationPath + ConfigurationSettings.AppSettings["SourceReports"]);
crReportDocument.Load(pathRptSource + "REPORT_PMP.rpt");
crReportDocument.SetDataSource(ds);
CRView1.ReportSource = crReportDocument;
CRView1.DataBind();
// per pdf
string Fname = Server.MapPath("../Report/" + Session.SessionID.ToString() + ".pdf");//pathRptSource + Session.SessionID.ToString() + ".pdf" ;
ExportOptions optExp;
DiskFileDestinationOptions optDsk = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions optPdfRtf = new PdfRtfWordFormatOptions();
optExp = crReportDocument.ExportOptions;
optExp.ExportFormatType = ExportFormatType.PortableDocFormat;
optExp.FormatOptions = optPdfRtf;
optExp.ExportDestinationType = ExportDestinationType.DiskFile;
optDsk.DiskFileName = Fname;
optExp.DestinationOptions = optDsk;
crReportDocument.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(Fname);
Response.Flush();
Response.Close();
System.IO.File.Delete(Fname);
}
protected void btnBuscar0_Click1(object sender, EventArgs e)
{
try
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(Server.MapPath(@"~/Reportes/ReporteGenerico.rpt"));
//crystalrpt.SetDatabaseLogon("adminSAEDI", "SAEDI.2018*");
crystalrpt.Refresh();
crystalrpt.SetParameterValue("@IdProceso", DropDownList1.SelectedValue);
crystalrpt.SetParameterValue("@IdPersona", DropDownList2.SelectedValue);
ExportOptions exportOption;
DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions();
exportOption = crystalrpt.ExportOptions;
{
exportOption.ExportDestinationType = ExportDestinationType.DiskFile;
exportOption.ExportFormatType = ExportFormatType.Excel;
exportOption.ExportDestinationOptions = diskFileDestinationOptions;
exportOption.ExportFormatOptions = new ExcelFormatOptions();
}
crystalrpt.ExportToHttpResponse(ExportFormatType.Excel, Response, true, "ReporteCuestionario" + DropDownList2.SelectedItem.Text);
crystalrpt.Export();
}
catch { }
}
/// <summary>
/// Print or Export Crystal Report
/// </summary>
private void PerformOutput()
{
if (_printToPrinter)
{
var copy = ReportArguments.PrintCopy;
_reportDoc.PrintToPrinter(copy, true, 0, 0);
_logger.Write(string.Format("Report printed to : {0}", _reportDoc.PrintOptions.PrinterName));
}
else
{
_reportDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions diskOptions = new DiskFileDestinationOptions
{
DiskFileName = _outputFilename
};
_reportDoc.ExportOptions.DestinationOptions = diskOptions;
_reportDoc.Export();
_logger.Write(string.Format("Report exported to : {0}", _outputFilename));
}
if (ReportArguments.ToBurst)
{
PageBreaker pb = new PageBreaker();
var outPath = $"{System.IO.Path.GetDirectoryName(_outputFilename)}\\{BURST_DIR}";
var pageCount = pb.SplitPDFByBookmark(_outputFilename, outPath);
Console.WriteLine($"Number of file genearated = {pageCount}");
}
Console.WriteLine("Completed");
}
//Test
private void GeneraPDF(ReportDocument objInforme, string pathFile)
{
string strMsgResul = string.Empty;
try
{
//string strRutaArchivo = pathPDF + "Reporte_" + proveedor + "_" + tie + "_" + pedido + ".pdf";
//DiskFileDestinationOptions diskDestination = new DiskFileDestinationOptions();
//objInforme.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;//ExportDestinationType.DiskFile;
//objInforme.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;//.CrystalReport; //.NoFormat; //.PortableDocFormat;//.RichText;// //ExportFormatType.PortableDocFormat;//ExportFormatType.CrystalReport;//
//diskDestination.DiskFileName = pathFile;
//objInforme.ExportOptions.DestinationOptions = diskDestination;
//objInforme.Export();
DiskFileDestinationOptions diskDestination = new DiskFileDestinationOptions();
objInforme.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
objInforme.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
diskDestination.DiskFileName = pathFile;
objInforme.ExportOptions.DestinationOptions = diskDestination;
objInforme.Export();
}
catch (Exception ex)
{
throw ex;
}
}
private void ExportarEXCEL(ReportDocument rep)
{
String ruta_exportacion;
ruta_exportacion = Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"]);
//ruta_exportacion = System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"];
ExportOptions exportOpts = new ExportOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = rep.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = ruta_exportacion + Session.SessionID.ToString() + ".xls";
exportOpts.DestinationOptions = diskOpts;
rep.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "attachment;filename=Procedencia_Alumnos.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.WriteFile(diskOpts.DiskFileName.ToString());
Response.Flush();
Response.Close();
System.IO.File.Delete(diskOpts.DiskFileName.ToString());
}
private void ExportarPDF(ReportDocument rep)
{
String ruta_exportacion;
ruta_exportacion = Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"]);
//ruta_exportacion = System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"];
ExportOptions exportOpts = new ExportOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = rep.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = ruta_exportacion + Session.SessionID.ToString() + ".pdf";
exportOpts.DestinationOptions = diskOpts;
rep.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(diskOpts.DiskFileName.ToString());
Response.Flush();
Response.Close();
System.IO.File.Delete(diskOpts.DiskFileName.ToString());
}
public void Exportar(string key)
{
try
{
ReportDocument objRpt = new ReportDocument();
DataSet ds = (DataSet)this.GetDataReport(key);
string reportPath = "C:\\Reportes\\CRTejTicket_rpt.rpt";
objRpt.Load(reportPath);
ExportOptions crExportOptions = new ExportOptions();
objRpt.SetDataSource(ds.Tables[0]);
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.InitialDirectory = Environment.SpecialFolder.MyDocuments.ToString();
saveFileDialog.Filter = "Document (*.pdf)|*.PDF";
saveFileDialog.FilterIndex = 1;
saveFileDialog.FileName = "Etiqueta.pdf";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
objRpt.ExportToDisk(ExportFormatType.PortableDocFormat, saveFileDialog.FileName); ;
}
crExportOptions = objRpt.ExportOptions;
objRpt.Export();
}
catch (Exception ex)
{
ex.ToString();
}
}
private void ExportarEXCEL(ReportDocument rep)
{
String ruta_exportacion;
ruta_exportacion = Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"]);
//ruta_exportacion = System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"];
ExportOptions exportOpts = new ExportOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = rep.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.Excel;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = ruta_exportacion + Session.SessionID.ToString() + ".xls";
exportOpts.DestinationOptions = diskOpts;
rep.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader ("Content-Disposition", "attachment;filename=Morosidad.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.WriteFile(diskOpts.DiskFileName.ToString());
Response.Flush();
Response.Close();
System.IO.File.Delete(diskOpts.DiskFileName.ToString());
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
int idOrientador = (int)Session["id"];
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(Server.MapPath(@"~/Reportes/ReporteAsistenciaDiaria.rpt"));
//crystalrpt.SetDatabaseLogon("adminSAEDI", "SAEDI.2018*");
crystalrpt.Refresh();
crystalrpt.SetParameterValue("@Orientador", idOrientador);
crystalrpt.SetParameterValue("@Anio", ddlAnio.SelectedValue);
crystalrpt.SetParameterValue("@Mes", ddlMes.SelectedValue);
crystalrpt.SetParameterValue("@IdProceso", ddlProceso.SelectedValue);
ExportOptions exportOption;
DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions();
exportOption = crystalrpt.ExportOptions;
{
exportOption.ExportDestinationType = ExportDestinationType.DiskFile;
exportOption.ExportFormatType = ExportFormatType.Excel;
exportOption.ExportDestinationOptions = diskFileDestinationOptions;
exportOption.ExportFormatOptions = new ExcelFormatOptions();
}
crystalrpt.ExportToHttpResponse(ExportFormatType.Excel, Response, true, "ReporteAsistenciaDiaria" + ddlMes.SelectedItem.Text);
crystalrpt.Export();
}
catch { }
}
protected void btnBuscar0_Click(object sender, EventArgs e)
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(Server.MapPath(@"~/Reportes/AsistenciaMensual.rpt"));
//crystalrpt.SetDatabaseLogon("adminSAEDI", "SAEDI.2018*");
crystalrpt.Refresh();
crystalrpt.SetParameterValue("@Anio", DropDownList1.SelectedValue);
crystalrpt.SetParameterValue("@Mes", DropDownList2.SelectedValue);
crystalrpt.SetParameterValue("@IdProceso", ddlProceso.SelectedValue);
//crystalrpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "ReporteAsistenciaDiaria"+ ddlMes.SelectedItem.Text);
//CrystalReportViewer1.ReportSource = crystalrpt;
//CrystalReportViewer1.DataBind();
ExportOptions exportOption;
DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions();
exportOption = crystalrpt.ExportOptions;
{
exportOption.ExportDestinationType = ExportDestinationType.DiskFile;
exportOption.ExportFormatType = ExportFormatType.Excel;
exportOption.ExportDestinationOptions = diskFileDestinationOptions;
exportOption.ExportFormatOptions = new ExcelFormatOptions();
}
crystalrpt.ExportToHttpResponse(ExportFormatType.Excel, Response, true, "ReporteAsistenciaMensual" + DropDownList2.SelectedItem.Text);
crystalrpt.Export();
}
private void PrintSlip(int id, int?no)
{
var obj = _service.GetVisitorByAutoIDForReport(id);
var reportPara = _service.GetReportParameter();
if (obj.ResultObj.Count > 0)
{
List <CustomVisitor> listData = (List <CustomVisitor>)obj.ResultObj;
DataTable dt = ConvertToDataTable(listData);
ReportDocument rpt = new ReportDocument();
string path = System.Reflection.Assembly.GetExecutingAssembly().Location;
//var appPath = Application.StartupPath + "\\" + "ReportSlip.rpt";
//var appPath = Application.StartupPath + "\\" + "ReportSlip_New.rpt";
//var appPath = Application.StartupPath + "\\" + "ReportSlip_Bando.rpt";
//var appPath = Application.StartupPath + "\\" + "ReportSlip_JBF.rpt";
var appPath = Application.StartupPath + "\\" + "ReportSlip_Charoen.rpt";
rpt.Load(appPath);
rpt.SetDataSource(dt);
rpt.PrintToPrinter(1, true, 0, 0);
rpt.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
rpt.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
string dir = DIRECTORY_IN + "\\" + no + "\\";
objDiskOpt.DiskFileName = dir + "SLIP.pdf";
rpt.ExportOptions.DestinationOptions = objDiskOpt;
rpt.Export();
}
}
private string ExportarPDF()
{
try
{
DsPlanillaRedespacho ds = (DsPlanillaRedespacho)Session["DsPlanillaRedespacho"];
ReportDocument oRD = new ReportDocument();
ExportOptions oExO;
DiskFileDestinationOptions oExDo = new DiskFileDestinationOptions();
string nombArchi = "PlanillaRedespacho_" + this.txtPlanillaRedespachoID.Text + "_" + this.AgenciaConectadaID + ".pdf";
string sNombrePDF = Server.MapPath(".") + "/ReportesPDF/" + nombArchi;
if (System.IO.File.Exists(sNombrePDF))
{
System.IO.File.Delete(sNombrePDF);
}
oRD.Load(Server.MapPath("." + "/Reportes/PlanillaRedespacho.rpt"));
oRD.SetDataSource(ds);
oExDo.DiskFileName = sNombrePDF;
oExO = oRD.ExportOptions;
oExO.ExportDestinationType = ExportDestinationType.DiskFile;
oExO.ExportFormatType = ExportFormatType.PortableDocFormat;
oExO.DestinationOptions = oExDo;
oRD.Export();
oRD.Close();
oRD.Dispose();
return(nombArchi);
}
catch (Exception ex)
{
string mensaje = "Error al exportar a PDF: " + ex.Message;
((ErrorWeb)this.phErrores.Controls[0]).setMensaje(mensaje);
return("");
}
}
private void ExportarPDF(ReportDocument rep)
{
String ruta_exportacion;
ruta_exportacion = Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"]);
//ruta_exportacion = System.Configuration.ConfigurationSettings.AppSettings["ruta_exportacion_pdf"];
ExportOptions exportOpts = new ExportOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = rep.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = ruta_exportacion + Session.SessionID.ToString() + ".pdf";
exportOpts.DestinationOptions = diskOpts;
rep.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(diskOpts.DiskFileName.ToString());
Response.Flush();
Response.Close();
System.IO.File.Delete(diskOpts.DiskFileName.ToString());
}
protected void btnBuscar0_Click(object sender, EventArgs e)
{
try
{
int idOrientador = (int)Session["id"];
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(Server.MapPath(@"~/Reportes/ReportePreguntasCerradasOrientador.rpt"));
//crystalrpt.SetDatabaseLogon("adminSAEDI", "SAEDI.2018*");
crystalrpt.Refresh();
crystalrpt.SetParameterValue("@IdProceso", DropDownList1.SelectedValue);
crystalrpt.SetParameterValue("@IdOrientador", idOrientador);
ExportOptions exportOption;
DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions();
exportOption = crystalrpt.ExportOptions;
{
exportOption.ExportDestinationType = ExportDestinationType.DiskFile;
exportOption.ExportFormatType = ExportFormatType.Excel;
exportOption.ExportDestinationOptions = diskFileDestinationOptions;
exportOption.ExportFormatOptions = new ExcelFormatOptions();
}
crystalrpt.ExportToHttpResponse(ExportFormatType.Excel, Response, true, "ReportePreguntasCerradas");
crystalrpt.Export();
}
catch { }
}
private void frmConsolidatedReports_Load(object sender, EventArgs e)
{
using (new LoadingClass.PleaseWait(this.Location, "Generando..."))
{
rp = new Reports.crConsolidatedReports();
foreach (var com in _componentId)
{
ChooseReport(rp, com);
}
crystalReportViewer1.EnableDrillDown = false;
crystalReportViewer1.ReportSource = rp;
ReportDocument repDoc = rp;
repDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
repDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
objDiskOpt.DiskFileName = Application.StartupPath + @"\TempMerge\Crystal1.pdf";
repDoc.ExportOptions.DestinationOptions = objDiskOpt;
repDoc.Export();
//
//crystalReportViewer1.Show();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if ((int.Parse(ddlAnio1.SelectedValue) > int.Parse(ddlAnio2.SelectedValue)) || ((int.Parse(ddlAnio1.SelectedValue) == int.Parse(ddlAnio2.SelectedValue)) && int.Parse(ddlMes1.SelectedValue) > int.Parse(ddlMes2.SelectedValue)))
{
Response.Write(@"<script>alert('RANGO INCORRECTO');setTimeout(function(){window.location = '" + Request.RawUrl + @"';}, 10);</script>");
}
else
{
ReportDocument crystalrpt = new ReportDocument();
crystalrpt.Load(Server.MapPath(@"~/Reportes/AsistenciaRango.rpt"));
//crystalrpt.SetDatabaseLogon("adminSAEDI", "SAEDI.2018*");
crystalrpt.Refresh();
crystalrpt.SetParameterValue("@Anio", ddlAnio1.SelectedValue);
crystalrpt.SetParameterValue("@Mes", ddlMes1.SelectedValue);
crystalrpt.SetParameterValue("@Anio2", ddlAnio2.SelectedValue);
crystalrpt.SetParameterValue("@Mes2", ddlMes2.SelectedValue);
crystalrpt.SetParameterValue("@IdProceso", ddlProceso.SelectedValue);
//crystalrpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "ReporteAsistenciaDiaria"+ ddlMes.SelectedItem.Text);
//CrystalReportViewer1.ReportSource = crystalrpt;
//CrystalReportViewer1.DataBind();
ExportOptions exportOption;
DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions();
exportOption = crystalrpt.ExportOptions;
{
exportOption.ExportDestinationType = ExportDestinationType.DiskFile;
exportOption.ExportFormatType = ExportFormatType.Excel;
exportOption.ExportDestinationOptions = diskFileDestinationOptions;
exportOption.ExportFormatOptions = new ExcelFormatOptions();
}
crystalrpt.ExportToHttpResponse(ExportFormatType.Excel, Response, true, "AsistenciaRango");
crystalrpt.Export();
}
}
private void GeneratePDF()
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/GeneralLedger.rpt"));
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\RetailPlus\temp\");
string strFileName = "generalledger_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".pdf";
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
dest.DiskFileName = strPath + strFileName;
exportop = rpt.ExportOptions;
SetDataSource(rpt);
exportop.DestinationOptions = dest;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
exportop.ExportFormatType = ExportFormatType.PortableDocFormat;
rpt.Export(); rpt.Close(); rpt.Dispose();
fraViewer.Attributes.Add("src","/RetailPlus/temp/" + strFileName);
}
private void ActionWise(string action, string username)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
objDB.Open();
DataTable drs = new DataTable();
SqlDataReader dr = (SqlDataReader)objDB.ExecuteReader(CommandType.Text, "select * from audit_report where user_id in(" + username + ") and instituteid='" + ddlInstitute.SelectedValue + "' and action in(" + action + ") and entry_Date between'" + txtFrom.Text + "' and '" + txtTo.Text + "'");
if (dr.HasRows)
{
drs.Load(dr);
}
if (drs.Rows.Count == 0)
{
objFun.MsgBox1("No record found to print.", UpdatePanel1);
return;
}
ReportDocument rpt1 = new ReportDocument();
string spath = ""; //= Server.MapPath("Report\\CWFD.rpt").Replace("Fee\\Fee\\", "Fee\\");
string spath1 = Server.MapPath("..\\Report\\");
spath = Server.MapPath("..\\Report\\AUWReport.rpt");
// stredds.Tables["DataTable1"].Merge(drs, true, MissingSchemaAction.Ignore);
rpt1.Load(spath);
rpt1.SetDataSource(drs);
CrystalReportViewer1.ReportSource = rpt1;
CrystalReportViewer1.DataBind();
CrystalReportViewer1.RefreshReport();
ExportOptions exportOpts1 = rpt1.ExportOptions;
rpt1.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
rpt1.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
rpt1.ExportOptions.DestinationOptions = new DiskFileDestinationOptions();
((DiskFileDestinationOptions)rpt1.ExportOptions.DestinationOptions).DiskFileName = spath1 + "ActionWise.pdf";
//Session["instName"]
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["GroupHeaderSection4"].ReportObjects["GroupNameSemester1"]).Text = dtInst.Rows[0].ItemArray[0].ToString();
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["Section5"].ReportObjects["Text27"]).Text = Session["instName"].ToString();
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["Section5"].ReportObjects["Text29"]).Text = Session["U_Name"].ToString();
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["Section1"].ReportObjects["Text1"]).Text = Session["instName"].ToString();
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["Section1"].ReportObjects["Text8"]).Text = dtInst.Rows[0].ItemArray[0].ToString();
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["Section1"].ReportObjects["Text8"]).Text = dtInst.Rows[0].ItemArray[0].ToString();
// ((CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.Sections["Section1"].ReportObjects["Text8"]).Text = dtInst.Rows[0].ItemArray[0].ToString();
rpt1.Export();
rpt1.Close();
rpt1.Dispose();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + "ActionWise.pdf");
Response.WriteFile(spath1 + "ActionWise.pdf");
Response.Flush();
Response.End();
File.Delete(Server.MapPath(spath1 + "ActionWise.pdf"));
Response.Close();
}
public void ExportReport(ReportDocument oReport, string cFileName, ExportTypes oExportTypes, int nFirstPage, int nLastPage)
{
ExportOptions oExportOptions = new ExportOptions();
PdfRtfWordFormatOptions oFormatOptions = ExportOptions.CreatePdfRtfWordFormatOptions();
DiskFileDestinationOptions oDestinationOptions = ExportOptions.CreateDiskFileDestinationOptions();
switch (oExportTypes)
{
case ExportTypes.PDF:
case ExportTypes.MSWord:
oExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
PdfRtfWordFormatOptions oPDFFormatOptions = ExportOptions.CreatePdfRtfWordFormatOptions();
if (nFirstPage > 0 && nLastPage > 0)
{
oPDFFormatOptions.FirstPageNumber = nFirstPage;
oPDFFormatOptions.LastPageNumber = nLastPage;
oPDFFormatOptions.UsePageRange = true;
}
oExportOptions.ExportFormatOptions = oPDFFormatOptions;
break;
case ExportTypes.MSExcel:
oExportOptions.ExportFormatType = ExportFormatType.Excel;
ExcelFormatOptions oExcelFormatOptions = ExportOptions.CreateExcelFormatOptions();
if (nFirstPage > 0 && nLastPage > 0)
{
oExcelFormatOptions.FirstPageNumber = nFirstPage;
oExcelFormatOptions.LastPageNumber = nLastPage;
oExcelFormatOptions.UsePageRange = true;
}
oExcelFormatOptions.ExcelUseConstantColumnWidth = false;
oExportOptions.ExportFormatOptions = oExcelFormatOptions;
break;
case ExportTypes.HTML:
oExportOptions.ExportFormatType = ExportFormatType.HTML40;
HTMLFormatOptions oHTMLFormatOptions = ExportOptions.CreateHTMLFormatOptions();
if (nFirstPage > 0 && nLastPage > 0)
{
oHTMLFormatOptions.FirstPageNumber = nFirstPage;
oHTMLFormatOptions.LastPageNumber = nLastPage;
oHTMLFormatOptions.UsePageRange = true;
}
// can set additional HTML export options here
oExportOptions.ExportFormatOptions = oHTMLFormatOptions;
break;
}
oDestinationOptions.DiskFileName = cFileName;
oExportOptions.ExportDestinationOptions = oDestinationOptions;
oExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
oReport.Export(oExportOptions);
}
private string ExportarPDF()
{ //cuando venga 0 en solicitud se han pedidos todas
if (Session["dsClientes"] != null)
{
//el dataset que le voy a pasar al generador de reportes crystal
DsClientes clie = (DsClientes)Session["dsClientes"];
DsReporteClientes reporte = new DsReporteClientes();
for (int i = 0; i <= clie.Datos.Count - 1; i++)
{
DsClientes.DatosRow drClie = (DsClientes.DatosRow)clie.Datos.Rows[i];
DsReporteClientes.DatosRow drReporte = (DsReporteClientes.DatosRow)reporte.Datos.NewDatosRow();
}
string empresa = System.Configuration.ConfigurationSettings.AppSettings["empresa"];
// for (int i=0; i<reporte.Datos.Count-1;i++)
// {
// byte[] d= null;
// DsReporteClientes.DatosRow drDatos= (DsReporteClientes.DatosRow) reporte.Datos.Rows[i];
// d = ConversionImagen(Server.MapPath("." + "/Reportes/images/"+ empresa + ".JPG"));
// drDatos["Imagen"]=d;
// }
// byte[] im= null;
// DsSolicitudRetiroImpresion.SolicitudRow dr= (DsSolicitudRetiroImpresion.SolicitudRow) dsSolicitud.Solicitud.Rows[0];
// im = ConversionImagen(Server.MapPath("." + "/Reportes/images/blanco.JPG"));
// for (int i=0; i<dsSolicitud.Solicitud.Count;i++)
// {
// dr["Imagen"]=im;
// }
ReportDocument oRD = new ReportDocument();
ExportOptions oExO;
DiskFileDestinationOptions oExDo = new DiskFileDestinationOptions();
string nombArchi = "Clientes_" + this.AgenciaConectadaID + ".pdf";
string sNombrePDF = Server.MapPath(".") + "/ReportesPDF/" + nombArchi;
if (System.IO.File.Exists(sNombrePDF))
{
System.IO.File.Delete(sNombrePDF);
}
oRD.Load(Server.MapPath("." + "/Reportes/Clientes.rpt"));
oRD.SetDataSource(clie);
oExDo.DiskFileName = sNombrePDF;
oExO = oRD.ExportOptions;
oExO.ExportDestinationType = ExportDestinationType.DiskFile;
oExO.ExportFormatType = ExportFormatType.PortableDocFormat;
oExO.DestinationOptions = oExDo;
oRD.Export();
oRD.Close();
oRD.Dispose();
return(nombArchi);
}
else
{
((ErrorWeb)this.phErrores.Controls[0]).setMensaje("No se ha podido consultar los datos de la solicitud");
return("");
}
}
private void bindReport(DataSet _dsRpt)
{
try
{
DsAnalisiStatistiche dsP = new DsAnalisiStatistiche();
int i = 0;
for (i = 0; i <= _dsRpt.Tables[0].Rows.Count - 1; i++)
{
dsP.Tables["tblgiudizio"].ImportRow(_dsRpt.Tables[0].Rows[i]);
}
if (i == 0)
{
throw new Exception("* Non ci sono Rdl nell'intervallo temporale che hai selezionato, cambia intervallo e riprova.");
}
// ReportClass _Report;
// _Report = _stdRpt.getReport;
// _Report.SetDataSource(dsP);
//rptEngineOra.DisplayGroupTree=false;
//rptEngineOra.DisplayToolbar=true;
//rptEngineOra.ReportSource=_Report;
string pathRptSource = Server.MapPath(Request.ApplicationPath + ConfigurationSettings.AppSettings["SourceReports"]);
_stdRpt.ImpostaSourceReport(crReportDocument, pathRptSource);
crReportDocument.SetDataSource(dsP);
switch (tipoDocumento)
{
case "PDF":
string Fname = pathRptSource + Session.SessionID.ToString() + ".pdf";
crDiskFileDestinationOptions = new DiskFileDestinationOptions();
crDiskFileDestinationOptions.DiskFileName = Fname;
crExportOptions = crReportDocument.ExportOptions;
crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crReportDocument.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(Fname);
Response.Flush();
Response.Close();
System.IO.File.Delete(Fname);
break;
case "HTML":
rptEngineOra.ReportSource = crReportDocument;
break;
default:
// non fai nulla
break;
}
}
catch (Exception ex)
{
Server.Transfer("Error.aspx?msgErr=" + ex.Message);
}
}
public static void GenerateReport(string FileName, ReportDocument rpt, System.Web.UI.Control ClientScriptBlockControl, ExportFormatType pvtExportFormatType)
{
try
{
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strFileExtensionName = ".pdf";
switch (pvtExportFormatType)
{
case ExportFormatType.PortableDocFormat: strFileExtensionName = ".pdf"; exportop.ExportFormatType = ExportFormatType.PortableDocFormat; break;
case ExportFormatType.WordForWindows: strFileExtensionName = ".doc"; exportop.ExportFormatType = ExportFormatType.WordForWindows; break;
case ExportFormatType.Excel: strFileExtensionName = ".xls"; exportop.ExportFormatType = ExportFormatType.Excel; break;
}
string strPath = System.Web.HttpContext.Current.Server.MapPath(@"\retailplus\temp\");
string strFileName = FileName + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + strFileExtensionName;
if (System.IO.File.Exists(strPath + strFileName))
{
System.IO.File.Delete(strPath + strFileName);
}
dest.DiskFileName = strPath + strFileName;
exportop.DestinationOptions = dest;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
rpt.Export(exportop); //rpt.Close(); rpt.Dispose();
// remove the error
if (pvtExportFormatType == ExportFormatType.WordForWindows || pvtExportFormatType == ExportFormatType.Excel || pvtExportFormatType == ExportFormatType.PortableDocFormat)
{
// the maximum report processing jobs limit configured by your system administrator has been reached.
rpt.Close(); rpt.Dispose();
}
if (pvtExportFormatType == ExportFormatType.PortableDocFormat)
{
string newWindowUrl = Constants.ROOT_DIRECTORY + "/temp/" + strFileName;
string javaScript = "window.open('" + newWindowUrl + "');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(ClientScriptBlockControl, ClientScriptBlockControl.GetType(), "openwindow", javaScript, true);
}
else
{
string newWindowUrl = Constants.ROOT_DIRECTORY + "/temp/" + strFileName;
string javaScript = "window.open('" + newWindowUrl + "','_self');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(ClientScriptBlockControl, ClientScriptBlockControl.GetType(), "openwindow", javaScript, true);
//System.Diagnostics.Process p = new System.Diagnostics.Process();
//p.StartInfo.FileName = System.Web.HttpContext.Current.Server.MapPath(Constants.ROOT_DIRECTORY + "/temp/" + strFileName);
//p.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;
//p.Start();
}
}
catch (Exception ex) { throw ex; }
}
public string Imprimir(int solicitudes, int agencia)
{
string nombArchi = "";
string empresa = System.Configuration.ConfigurationSettings.AppSettings["empresa"];
DsSolicitudRetiroImpresion dsSolicitud = new DsSolicitudRetiroImpresion();
//el dataset que le voy a pasar al generador de reportes crystal
ISolicitudRetiro sol = SolicitudRetiroFactory.GetSolicitudRetiroFactory();
sol.SolicitudRetiroID = solicitudes;
dsSolicitud = (DsSolicitudRetiroImpresion)sol.ConsultarSolicitudAImprimir();
for (int i = 0; i < dsSolicitud.Orden.Count; i++)
{
byte[] d = null;
DsSolicitudRetiroImpresion.OrdenRow drOrden = (DsSolicitudRetiroImpresion.OrdenRow)dsSolicitud.Orden.Rows[i];
d = ConversionImagen(Server.MapPath("." + "/Reportes/images/" + empresa + ".JPG"));
drOrden["Codigo"] = d;
}
byte[] im = null;
DsSolicitudRetiroImpresion.SolicitudRow dr = (DsSolicitudRetiroImpresion.SolicitudRow)dsSolicitud.Solicitud.Rows[0];
im = ConversionImagen(Server.MapPath("." + "/Reportes/images/blanco.JPG"));
for (int i = 0; i < dsSolicitud.Solicitud.Count; i++)
{
dr["Imagen"] = im;
}
if ((dsSolicitud.Solicitud.Count > 0) && (dsSolicitud.Orden.Count > 0))
{
ExportOptions oExO;
DiskFileDestinationOptions oExDo = new DiskFileDestinationOptions();
nombArchi = "SolicitudRetiro_" + solicitudes + "_" + agencia + ".pdf";
string sNombrePDF = Server.MapPath(".") + "/ReportesPDF/" + nombArchi;
if (System.IO.File.Exists(sNombrePDF))
{
System.IO.File.Delete(sNombrePDF);
}
oRD.Load(Server.MapPath("." + "/Reportes/ReporteSolicitudRetiro2.rpt"));
oRD.SetDataSource(dsSolicitud);
oExDo.DiskFileName = sNombrePDF;
oExO = oRD.ExportOptions;
oExO.ExportDestinationType = ExportDestinationType.DiskFile;
oExO.ExportFormatType = ExportFormatType.PortableDocFormat;
oExO.DestinationOptions = oExDo;
oRD.Export();
oRD.Close();
oRD.Dispose();
return(nombArchi);
}
return(nombArchi);
}
protected void GeneratePOAsPDF(DataTable dt, string strPath, string FileName)
{
string repFilePath = Server.MapPath("POReport.rpt");
//using (ReportDocument repDoc = new ReportDocument())
//{
using (ReportDocument repDoc = new ReportDocument())
{
repDoc.Load(repFilePath);
repDoc.SetDataSource(dt);
decimal Total_Price = 0;
decimal Exchane_rate = 1;
decimal Vat = 0;
decimal sercharge = 0;
decimal discount = 0;
foreach (DataRow dr in dt.Rows)
{
Exchane_rate = Convert.ToDecimal(dr["EXCHANGE_RATE"].ToString());
discount = Convert.ToDecimal(dr["DISCOUNT"].ToString());
Vat = Convert.ToDecimal(dr["VAT"].ToString());
sercharge = Convert.ToDecimal(dr["SURCHARGES"].ToString());
Total_Price = Total_Price + (Convert.ToDecimal(dr["REQUESTED_QTY"].ToString()) * Convert.ToDecimal(dr["QUOTED_RATE"].ToString()) - (Convert.ToDecimal(dr["REQUESTED_QTY"].ToString()) * Convert.ToDecimal(dr["QUOTED_RATE"].ToString()) * Convert.ToDecimal(dr["QUOTED_DISCOUNT"].ToString()) / 100));
}
repDoc.DataDefinition.FormulaFields[1].Text = (Total_Price / Exchane_rate).ToString();
repDoc.DataDefinition.FormulaFields[2].Text = (Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[1].Text) * discount / 100).ToString();
repDoc.DataDefinition.FormulaFields[3].Text = ((Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[1].Text) - (Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[1].Text) * discount / 100)) * sercharge / 100).ToString();
repDoc.DataDefinition.FormulaFields[4].Text = ((Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[1].Text) - Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[2].Text) + Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[3].Text)) * Vat / 100).ToString();
repDoc.DataDefinition.FormulaFields[0].Text = ((Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[1].Text) - Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[2].Text) + Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[3].Text) + Convert.ToDecimal(repDoc.DataDefinition.FormulaFields[4].Text)).ToString());
ExportOptions exp = new ExportOptions();
DiskFileDestinationOptions dk = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions pd = new PdfRtfWordFormatOptions();
string sFile = strPath + FileName;
dk.DiskFileName = strPath + FileName;
exp.ExportDestinationType = ExportDestinationType.DiskFile;
exp.ExportFormatType = ExportFormatType.PortableDocFormat;
exp.DestinationOptions = dk;
exp.FormatOptions = pd;
repDoc.Export(exp);
//for email attachment
string destFile = Server.MapPath("../Uploads/Purchase") + "\\" + FileName;;
File.Copy(sFile, destFile, true);
repDoc.Close();
repDoc.Dispose();
}
//}
}
public static void ExportarReporte(string ruta, ReportDocument reporte)
{
reporte.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
reporte.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
reporte.ExportOptions.DestinationOptions = new DiskFileDestinationOptions {
DiskFileName = ruta
};
reporte.ExportOptions.FormatOptions = new PdfRtfWordFormatOptions();
reporte.Export();
}
void Exportar(ReportDocument DocImpresion, string c_archivo)
{
DocImpresion.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
DocImpresion.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
objDiskOpt.DiskFileName = c_archivo;
DocImpresion.ExportOptions.DestinationOptions = objDiskOpt;
DocImpresion.Export();
}
private bool ExportarPDF()
{
DataSet GenDS = new DataSet();
ReportDocument oRD = new ReportDocument();
ExportOptions oExO;
DiskFileDestinationOptions oExDo = new DiskFileDestinationOptions();
admGuiaO.AgenciaOrigenID = AgenciaConectadaID;
DsGuiaFacturaImpresion dataSrc = admGuiaO.GetDataSetImpresionAgenciaAgencia();
Session["DatosGuia"] = dataSrc;
try
{
//ds = (DsRendicionesAgencias) Session["dsRendicionAgencia"];
string sNombrePDF = Server.MapPath(".") + "\\ReportesPDF\\Guia_" + this.admGuiaO.GuiaID + "_" + this.AgenciaConectadaID + ".pdf";
//Load report
oRD.Load(Server.MapPath("." + "/Reportes/GuiaImpresa.rpt"));
//Set Report Datasource
//BindGrilla();
oRD.SetDataSource(dataSrc);
//Export to PDF
oExDo.DiskFileName = sNombrePDF;
oExO = oRD.ExportOptions;
//PrintOptions oExPrint = oRD.PrintOptions;
//oExPrint.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4Small;
//oExPrint.PrinterName = "\\" + "\\CQUIROGA\\HP DeskJet 810C";
//oExPrint.PrinterName = "HP DeskJet 810C";
oExO.ExportDestinationType = ExportDestinationType.DiskFile;
oExO.ExportFormatType = ExportFormatType.PortableDocFormat;
oExO.DestinationOptions = oExDo;
//oRD.PrintToPrinter(1,false,1,1);
oRD.Export();
oRD.Close();
oRD.Dispose();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
void ExportCrystalReport(ReportDocument cryRpt, string formatExport, string pathReportGenerate)
{
if (string.IsNullOrEmpty(pathReportGenerate))
{
throw new Exception("Path report generate not found");
}
if (cryRpt == null)
{
throw new Exception("Resource not found");
}
ExportFormatType exportFormatType = ExportFormatType.NoFormat;
string extensionFile = Path.GetExtension(pathReportGenerate);
object formatOption = new PdfRtfWordFormatOptions();
switch (formatExport)
{
case "WORD":
exportFormatType = ExportFormatType.WordForWindows;
extensionFile = ".doc";
break;
case "PDF":
exportFormatType = ExportFormatType.PortableDocFormat;
break;
case "EXCEL":
exportFormatType = ExportFormatType.Excel;
extensionFile = ".xls";
formatOption = new ExcelFormatOptions();
break;
}
var downloadReportPath = System.Web.Hosting.HostingEnvironment.MapPath("~/DownloadReports/");
//Check exist folder DownloadReports
if (!Directory.Exists(downloadReportPath))
{
Directory.CreateDirectory(downloadReportPath);
}
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
CrDiskFileDestinationOptions.DiskFileName = pathReportGenerate;
ExportOptions CrExportOptions = cryRpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = exportFormatType;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = formatOption;
}
cryRpt.Export();
}
protected void Page_Load(object sender, EventArgs e)
{
ExportOptions objExOpt;
CrystalReportViewer1.ReportSource = (object)getReportDocument();
CrystalReportViewer1.DataBind();
// Get the report document
ReportDocument repDoc = getReportDocument();
repDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
repDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions();
string strLine = "09605954432 5969 59681 2993 00";
List <string> txtLines = new List <string>();
string strnew = strLine.Replace(" ", "");
string path = @"C:\CrystalExport\newline.txt";
for (int i = 0; i < strnew.Count(); i++)
{
txtLines.Add(strnew[i].ToString());
}
foreach (string str in txtLines)
{
File.AppendAllText(path, str + Environment.NewLine);
}
string filePath = @"\\192.168.15.10\IASFileUpload\ReceiptFile\3501600072585\3501600072585_12122e11300319.pdf";
using (FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite))
{
StreamReader sr = new StreamReader(fs, Encoding.GetEncoding("WINDOWS-874"));
// Write data to the file
//newFile.Write(Buffer, 0, Buffer.Length);
HashAlgorithm ha = HashAlgorithm.Create();
//FileStream fs = new FileStream(filePath, FileMode.Open);
byte[] hash = ha.ComputeHash(fs);
fs.Close();
objDiskOpt.DiskFileName = @"C:\CrystalExport\TFA.pdf";
repDoc.ExportOptions.DestinationOptions = objDiskOpt;
repDoc.Export();
//hashValue = BitConverter.ToString(hash);
}
//objDiskOpt.DiskFileName = @"C:\CrystalExport\TFA.pdf";
//repDoc.ExportOptions.DestinationOptions = objDiskOpt;
//repDoc.Export();
}
protected void btnexport_Click(object sender, EventArgs e)
{
ReportDocument rptExcel = new ReportDocument();
string Degree = "0";
if (ddlDegree.SelectedValue == "9")
{
Degree = "9";
}
string Term = "0";
if (ddlTerm.SelectedIndex != 0)
{
Term = ddlTerm.SelectedValue;
}
string connection;
SqlConnection con = null;
connection = ConfigurationManager.ConnectionStrings["SkyLineConnection"].ToString();
con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand("SP_STUDENTMASTERFILE", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TERMID", Term);
cmd.Parameters.Add("@degreetypeid", Degree);
cmd.Parameters.Add("@groupcode", ddlCountry.SelectedValue);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
cmd.CommandTimeout = 300;
Server.ScriptTimeout = 3000000;
DataTable datatable = new DataTable();
da.Fill(datatable);
string strExportFile = Server.MapPath(".") + "/StudentMasterfile.xls";
rptExcel.Load(Server.MapPath("~/Report/STUDENTLIST.rpt"));
rptExcel.SetDataSource(datatable);
rptExcel.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
rptExcel.ExportOptions.ExportFormatType = ExportFormatType.Excel;
ExcelFormatOptions objExcelOptions = new ExcelFormatOptions();
objExcelOptions.ExcelUseConstantColumnWidth = false;
rptExcel.ExportOptions.FormatOptions = objExcelOptions;
DiskFileDestinationOptions objOptions = new DiskFileDestinationOptions();
objOptions.DiskFileName = strExportFile;
rptExcel.ExportOptions.DestinationOptions = objOptions;
rptExcel.SetDatabaseLogon("software", "DelFirMENA$idea");
rptExcel.Export();
objOptions = null;
rptExcel = null;
Response.Redirect("StudentMasterfile.xls");
}
public static void GenerateReport(string FileName, ReportDocument rpt, System.Web.UI.Control ClientScriptBlockControl, ExportFormatType pvtExportFormatType)
{
try
{
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strFileExtensionName = ".pdf";
switch (pvtExportFormatType)
{
case ExportFormatType.PortableDocFormat: strFileExtensionName = ".pdf"; exportop.ExportFormatType = ExportFormatType.PortableDocFormat; break;
case ExportFormatType.WordForWindows: strFileExtensionName = ".doc"; exportop.ExportFormatType = ExportFormatType.WordForWindows; break;
case ExportFormatType.Excel: strFileExtensionName = ".xls"; exportop.ExportFormatType = ExportFormatType.Excel; break;
}
string strPath = System.Web.HttpContext.Current.Server.MapPath(@"\retailplus\temp\");
string strFileName = FileName + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + strFileExtensionName;
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
dest.DiskFileName = strPath + strFileName;
exportop.DestinationOptions = dest;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
rpt.Export(exportop); //rpt.Close(); rpt.Dispose();
// remove the error
if (pvtExportFormatType == ExportFormatType.WordForWindows || pvtExportFormatType == ExportFormatType.Excel || pvtExportFormatType == ExportFormatType.PortableDocFormat)
{
// the maximum report processing jobs limit configured by your system administrator has been reached.
rpt.Close(); rpt.Dispose();
}
if (pvtExportFormatType == ExportFormatType.PortableDocFormat)
{
string newWindowUrl = Constants.ROOT_DIRECTORY + "/temp/" + strFileName;
string javaScript = "window.open('" + newWindowUrl + "');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(ClientScriptBlockControl, ClientScriptBlockControl.GetType(), "openwindow", javaScript, true);
}
else
{
string newWindowUrl = Constants.ROOT_DIRECTORY + "/temp/" + strFileName;
string javaScript = "window.open('" + newWindowUrl + "','_self');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(ClientScriptBlockControl, ClientScriptBlockControl.GetType(), "openwindow", javaScript, true);
//System.Diagnostics.Process p = new System.Diagnostics.Process();
//p.StartInfo.FileName = System.Web.HttpContext.Current.Server.MapPath(Constants.ROOT_DIRECTORY + "/temp/" + strFileName);
//p.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;
//p.Start();
}
}
catch (Exception ex) { throw ex; }
}
private void GenerateHTML()
{
ReportDocument rpt = new ReportDocument();
switch (cboView.SelectedItem.Value)
{
case "0":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/ChartOfAccountsDetails.rpt"));
break;
case "1":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/ChartOfAccountsSummary.rpt"));
break;
}
HTMLFormatOptions htmlOpts = new HTMLFormatOptions();
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\RetailPlus\temp\html\");
// DeleteTempDirectory(strPath);
string strFileName = "chartofacc_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".htm";
if (System.IO.File.Exists(strPath + strFileName))
{
System.IO.File.Delete(strPath + strFileName);
}
htmlOpts.HTMLFileName = strFileName;
htmlOpts.HTMLEnableSeparatedPages = true;;
htmlOpts.HTMLHasPageNavigator = true;
htmlOpts.HTMLBaseFolderName = strPath;
rpt.ExportOptions.FormatOptions = htmlOpts;
exportop = rpt.ExportOptions;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
exportop.ExportFormatType = ExportFormatType.HTML40;
dest.DiskFileName = strFileName.ToString();
exportop.DestinationOptions = dest;
SetDataSource(rpt);
rpt.Export(); rpt.Close(); rpt.Dispose();
strFileName = "//" + Request.ServerVariables["SERVER_NAME"].ToString() + FindHTMLFile(strPath, strFileName);
fraViewer.Attributes.Add("src", strFileName);
}
private void BtnImprimir_Click(object sender, RoutedEventArgs e)
{
try
{
var boton = e.Source as Button;
if (boton != null)
{
var elemento = boton.CommandParameter as ImpresionCalidadMezcladoModel;
var calidad = new CalidadMezcladoFormulasAlimentoPL();
var listaAuxiliar = new List <ImpresionCalidadMezcladoModel> {
elemento
};
calidad.CalculosDetalle(listaAuxiliar);
var documento = new ReportDocument();
var reporte = String.Format("{0}{1}", AppDomain.CurrentDomain.BaseDirectory,
"\\Administracion\\Impresiones\\rptEf.MezRotomix 2.rpt");
documento.Load(reporte);
documento.DataSourceConnections.Clear();
documento.SetDataSource(listaAuxiliar);
documento.Refresh();
ExportOptions rptExportOption;
var rptFileDestOption = new DiskFileDestinationOptions();
var rptFormatOption = new PdfRtfWordFormatOptions();
string reportFileName = string.Format("{0}_{1}_{2}.pdf", @"C:\CheckListCalidadMezclado",
elemento.Tecnica,
Contexto.Fecha.ToString("ddMMyyyy"));
rptFileDestOption.DiskFileName = reportFileName;
rptExportOption = documento.ExportOptions;
{
rptExportOption.ExportDestinationType = ExportDestinationType.DiskFile;
rptExportOption.ExportFormatType = ExportFormatType.PortableDocFormat;
rptExportOption.ExportDestinationOptions = rptFileDestOption;
rptExportOption.ExportFormatOptions = rptFormatOption;
}
documento.Export();
SkMessageBox.Show(Application.Current.Windows[ConstantesVista.WindowPrincipal],
Properties.Resources.Impresion_ReporteGeneradoConExito, MessageBoxButton.OK,
MessageImage.Correct);
Process.Start(reportFileName);
}
}
catch (Exception ex)
{
Logger.Error(ex);
SkMessageBox.Show(Application.Current.Windows[ConstantesVista.WindowPrincipal],
Properties.Resources.ImpresionSupervisionTecnicasDeteccion_ErrorImpresion,
MessageBoxButton.OK,
MessageImage.Error);
}
}
private bool SendWebMail(string strTo, string subj, string cont, string cc, string bcc, string strfrom)
{
// generate reports
DataTable dre = bus.generatereport();
rd.Load(Server.MapPath(Request.ApplicationPath) + "/user/MonthlyReport.rpt");
rd.SetDataSource(dre);
// location of empty pdf file
string filename = Server.MapPath("~/pdf/Monthly_Report.pdf");
// export the report to pdf and write to empty pdf file inside pdf folder
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = filename;
CrExportOptions = rd.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
rd.Export();
// send email with attachment
bool flg = false;
MailMessage msg = new MailMessage();
msg.Body = "<table border='1' cellpadding='0' cellspacing='0' style='width: 750px; border-color: black;'><tr><td colspan='9'><br>   Dear Sir / Madam,<br /><br />     PFA Monthly report for the Month of <b>" + dre.Rows[0][5].ToString() + " " + dre.Rows[0][6].ToString() + "</b>. The details are as follows.<br /><br /></td></tr><tr style='font-weight: 700;'></tr><tr><td colspan='9'><br/><p></p><p>    Opening Date: " + dre.Rows[0][2].ToString() + "</p><p>   Opening Balance: " + dre.Rows[0][7].ToString() + "</p><p>   Closing Balance: " + dre.Rows[0][15].ToString() + "</p><p>   Opened By: " + dre.Rows[0][4].ToString() + " </p><p>   Freezed Date: " + dre.Rows[0][3].ToString() + " </p><p>   click<a href=" + url + "> here </a>to login into the application</p><br/></td></tr><tr></tr><td colspan='9' style='font-weight: bold' align='right'><br /><br />Regards,<br />Team Petty Cash App</td></tr><tr><td align='center'><p style='color:blue;'> This is a system generated response. Please do not respond to this email id.</p></td></tr></table>";
msg.From = strfrom;
msg.To = strTo;
msg.Subject = subj + " " + dre.Rows[0][5].ToString() + " " + dre.Rows[0][6].ToString();
msg.Cc = cc;
msg.Bcc = bcc;
//System.Net.Mail.Attachment attach;
//attach = new System.Net.Mail.Attachment()
msg.Attachments.Add(new MailAttachment(filename));
msg.BodyFormat = MailFormat.Html;
try
{
//SmtpMail.SmtpServer = "175.143.44.165";
SmtpMail.SmtpServer = "192.168.1.4"; // change the ip address to this when hosting in server
SmtpMail.Send(msg);
flg = true;
}
catch (Exception)
{
flg = false;
}
return(flg);
}
public void PrintReport(string key)
{
try
{
ReportDocument objRpt = new ReportDocument();
DataSet ds = (DataSet)this.GetDataReport(key);
string reportPath = "C:\\Reportes\\CRIngreso_etiqueta02.rpt";
objRpt.Load(reportPath);
DiskFileDestinationOptions crDiskFileDestinationOption = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions crFormatTypeOption = new PdfRtfWordFormatOptions();
ExportOptions crExportOptions = new ExportOptions();
objRpt.SetDataSource(ds.Tables[0]);
string strfolder = "C:\\Reporte\\";
crDiskFileDestinationOption.DiskFileName = strfolder + "Etiqueta.pdf";
crExportOptions = objRpt.ExportOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crExportOptions.ExportDestinationOptions = crDiskFileDestinationOption;
crExportOptions.ExportFormatOptions = crFormatTypeOption;
objRpt.Export();
this.printDialog1.Document = this.printDocument1;
DialogResult dr = this.printDialog1.ShowDialog();
if (dr == DialogResult.OK)
{
PageMargins margins;
margins = objRpt.PrintOptions.PageMargins;
margins.bottomMargin = 250;
margins.leftMargin = 250;
margins.rightMargin = 250;
margins.topMargin = 250;
objRpt.PrintOptions.ApplyPageMargins(margins);
string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
objRpt.PrintOptions.PrinterName = PrinterName;
objRpt.PrintToPrinter(1, false, 0, 0);
}
}
catch (Exception ex)
{
ex.ToString();
}
}
public void GeneratePDF(string poId)
{
ReportDocument rptDoc = new ReportDocument();
dsPSMS ds = new dsPSMS();
DataTable dt = new DataTable();
dt.TableName = "PO";
dt = getAllPOs();
ds.Tables["dtPO"].Merge(dt);
//subreport data table
dt = new DataTable();
dt.TableName = "Terms";
dt = getAllTerms();
ds.Tables["dtTerms"].Merge(dt);
rptDoc.Load(Server.MapPath("~/Reports/crPO.rpt"));
rptDoc.SetDataSource(ds);
string fileName = "PO" + poId + "_.pdf";
String targetFolder = Server.MapPath(POAttachmentfolderPath);
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = targetFolder + "\\" + fileName;
CrExportOptions = rptDoc.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
rptDoc.Export();
string strFields = "";
string[] strValues = new string[3];
strFields = "[POID],[FilePath],[Note]";
string filePath = POAttachmentfolderPath + "/" + fileName;
string sqlStr = "select [FilePath] from [dbo].[POAttach] where [FilePath]=@FilePath";
DataTable hasData = am.DataAccess.RecordSet(sqlStr, new string[] { filePath });
if (hasData.Rows.Count == 0)
{
strValues = new string[] { poId.ToString() , filePath , txtAttachmentNote.Text.Trim() };
am.DataAccess.BatchQuery.Insert("[dbo].[POAttach]", strFields, strValues);
am.DataAccess.BatchQuery.Execute();
}
}
private void loadReport()
{
DataTable lData = ((DataTable)Session["WRK_TABLE"]);
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue dctField = new ParameterDiscreteValue();
if (Session["WRK_TABLE"] != null)
{
if (lData.Rows.Count > 0)
{
CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;
myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(Server.MapPath(hidReportName.Value + ".rpt"));
myReportDocument.SetDataSource(lData);
ExportOptions relExportOptions;
DiskFileDestinationOptions relDiskFileDestinationOptions;
string strPDFTemp = Server.MapPath(@"~\Aut\Reports\Files\" + hidReportName.Value + ".pdf");
relDiskFileDestinationOptions = new DiskFileDestinationOptions();
relDiskFileDestinationOptions.DiskFileName = strPDFTemp;
relExportOptions = myReportDocument.ExportOptions;
relExportOptions.ExportDestinationOptions = relDiskFileDestinationOptions;
relExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
relExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
myReportDocument.Export();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "inline; filename=ReportName.pdf");
Response.WriteFile(strPDFTemp);
Response.Flush();
Response.Close();
System.IO.File.Delete(strPDFTemp);
}
}
}
private void Export(ExportFormatType pvtExportFormatType)
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/_StockTransactionReport.rpt"));
SetDataSource(rpt);
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\retailplus\temp\");
string strFileExtensionName = ".pdf";
switch (pvtExportFormatType)
{
case ExportFormatType.PortableDocFormat: strFileExtensionName = ".pdf"; exportop.ExportFormatType = ExportFormatType.PortableDocFormat; break;
case ExportFormatType.WordForWindows: strFileExtensionName = ".doc"; exportop.ExportFormatType = ExportFormatType.WordForWindows; break;
case ExportFormatType.Excel: strFileExtensionName = ".xls"; exportop.ExportFormatType = ExportFormatType.Excel; break;
}
string strFileName = "tranreport_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + strFileExtensionName;
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
dest.DiskFileName = strPath + strFileName;
exportop.DestinationOptions = dest;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
rpt.Export(exportop); //rpt.Close(); rpt.Dispose();
if (pvtExportFormatType == ExportFormatType.PortableDocFormat)
{
rpt.Close(); rpt.Dispose();
Response.Redirect(Constants.ROOT_DIRECTORY + "/temp/" + strFileName, false);
}
else
{
CRViewer.ReportSource = rpt;
Session["ReportDocument"] = rpt;
CRSHelper.OpenExportedReport(strFileName); // OpenExportedReport(strFileName);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt;
String sql = "Select * FROM tableAttendance";
SqlCommand com = new SqlCommand(sql, conn);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(com);
dt = new DataTable("dt");
da.Fill(dt);
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("crystalreportforattendance.rpt"));
rpt.SetDatabaseLogon("sa", "yugioh", @"JOP-PC\SQLEXPRESS", "ISAttandaceManagementSystem");
rpt.SetDataSource(dt);
crvattendance.ReportSource = rpt;
MemoryStream oStream;
oStream = (MemoryStream)
rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
//rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Appointment");
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();
rpt.Export();
conn.Close();
conn.Dispose();
}
}
public void PrintReport(string key)
{
try
{
ReportDocument objRpt = new ReportDocument();
DataSet ds = (DataSet)this.GetDataReport(key);
//string reportPath = Application.StartupPath + "\\Reportes\\OrdenCompraxprov.rpt";
string reportPath = "C:\\Reportes\\OrdenCompraxprov.rpt";
objRpt.Load(reportPath);
DiskFileDestinationOptions crDiskFileDestinationOption = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions crFormatTypeOption = new PdfRtfWordFormatOptions();
ExportOptions crExportOptions = new ExportOptions();
objRpt.SetDataSource(ds.Tables[0]);
string strfolder = "C:\\Reporte\\";
crDiskFileDestinationOption.DiskFileName = strfolder + "Data.pdf";
crExportOptions = objRpt.ExportOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crExportOptions.ExportDestinationOptions = crDiskFileDestinationOption;
crExportOptions.ExportFormatOptions = crFormatTypeOption;
objRpt.Export();
MessageBox.Show("Registros exportados", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
}
}
private void ExportPDF()
{
try
{
lblInfo.Text = "Gerando arquivo pdf para anexo";
DirectoryInfo dinfo = new DirectoryInfo(Server.MapPath("Pedidos"));
if (!dinfo.Exists)
{
dinfo.Create();
}
if (File.Exists(Server.MapPath("Pedidos\\" + sCodigoPedido + ".pdf")))
{
File.Delete(Server.MapPath("Pedidos\\" + sCodigoPedido + ".pdf"));
}
CarregaDataTableParaImpressao();
ReportDocument rpt = new ReportDocument();
dsPedido TabelaImpressao = (dsPedido)Session["PedidoRes"];
rpt.Load(Server.MapPath("rptPedido.rpt"));
rpt.SetDataSource(TabelaImpressao);
CrystalDecisions.Web.CrystalReportViewer cryView = new CrystalDecisions.Web.CrystalReportViewer();
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = Server.MapPath("Pedidos\\" + sCodigoPedido + ".pdf");
CrExportOptions = rpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
rpt.Export();
lblInfo.Text = "Exportando arquivo para o servidor";
}
catch (Exception ex)
{
throw ex;
//lblInfo.Text = ex.Message + (ex.InnerException != null ? ex.InnerException.Message : "");
}
}
private void muestrareporte(String IdOperacion)
{
SqlDataAdapter adapter;
DataSet ds = new DataSet();
String archivo = "";
DataTable dtVoucher = new DataTable();
DataSet dsVoucher = new DataSet();
String emailenviavoucher = "";
dtVoucher.Columns.Add("IdOperacion");
dtVoucher.Columns.Add("FechaEmision");
dtVoucher.Columns.Add("NroVoucher");
dtVoucher.Columns.Add("Pasajero_Nombre");
dtVoucher.Columns.Add("Pasajero_Apellido");
dtVoucher.Columns.Add("Pasajero_Documento");
dtVoucher.Columns.Add("Pasajero_FechaNac");
dtVoucher.Columns.Add("Pasajero_TipoTelefono");
dtVoucher.Columns.Add("Pasajero_Telefono");
dtVoucher.Columns.Add("Pasajero_Celular");
dtVoucher.Columns.Add("Pasajero_Email");
dtVoucher.Columns.Add("ContactoEmergencia_Apellido");
dtVoucher.Columns.Add("ContactoEmergencia_Nombre");
dtVoucher.Columns.Add("ContactoEmergencia_Email");
dtVoucher.Columns.Add("ProductoDescripcion");
dtVoucher.Columns.Add("OrigenDescripcion");
dtVoucher.Columns.Add("DestinoDescripcion");
dtVoucher.Columns.Add("FechaPartida");
dtVoucher.Columns.Add("FechaRegreso");
dtVoucher.Columns.Add("ImporteTarifaPesos");
dtVoucher.Columns.Add("ImporteTarifaDolar");
dtVoucher.Columns.Add("IdCobertura");
dtVoucher.Columns.Add("DescripcionCobertura");
dtVoucher.Columns.Add("ValorCobertura");
dtVoucher.Columns.Add("MonedaDescripcion");
dtVoucher.Columns.Add("SimboloMoneda");
dtVoucher.Columns.Add("IdCobertura2");
dtVoucher.Columns.Add("DescripcionCobertura2");
dtVoucher.Columns.Add("ValorCobertura2");
dtVoucher.Columns.Add("MonedaDescripcion2");
dtVoucher.Columns.Add("SimboloMoneda2");
dtVoucher.Columns.Add("EmailEnviaVoucher");
try
{
System.Data.SqlClient.SqlConnection conn;
conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn.Open();
SqlCommand command = new SqlCommand("spselImprimeVoucher", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("Id_Operacion", Convert.ToInt32(IdOperacion));
command.ExecuteNonQuery();
adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
conn.Close();
ds.Dispose();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow row = dtVoucher.NewRow();
row["IdOperacion"] = ds.Tables[0].Rows[i]["IdOperacion"].ToString();
row["FechaEmision"] = ds.Tables[0].Rows[i]["FechaEmision"].ToString(); ;
row["NroVoucher"] = ds.Tables[0].Rows[i]["NroVoucher"].ToString();
row["Pasajero_Nombre"] = ds.Tables[0].Rows[i]["Pasajero_Nombre"].ToString();
row["Pasajero_Apellido"] = ds.Tables[0].Rows[i]["Pasajero_Apellido"].ToString();
row["Pasajero_Documento"] = ds.Tables[0].Rows[i]["Pasajero_Documento"].ToString();
row["Pasajero_FechaNac"] = ds.Tables[0].Rows[i]["Pasajero_FechaNac"].ToString();
row["Pasajero_TipoTelefono"] = ds.Tables[0].Rows[i]["Pasajero_TipoTelefono"].ToString();
row["Pasajero_Telefono"] = ds.Tables[0].Rows[i]["Pasajero_Telefono"].ToString();
row["Pasajero_Celular"] = ds.Tables[0].Rows[i]["Pasajero_Celular"].ToString();
row["Pasajero_Email"] = ds.Tables[0].Rows[i]["Pasajero_Email"].ToString();
row["ContactoEmergencia_Apellido"] = ds.Tables[0].Rows[i]["ContactoEmergencia_Apellido"].ToString();
row["ContactoEmergencia_Nombre"] = ds.Tables[0].Rows[i]["ContactoEmergencia_Nombre"].ToString();
row["ContactoEmergencia_Email"] = ds.Tables[0].Rows[i]["ContactoEmergencia_Email"].ToString();
row["ProductoDescripcion"] = ds.Tables[0].Rows[i]["ProductoDescripcion"].ToString();
row["OrigenDescripcion"] = ds.Tables[0].Rows[i]["OrigenDescripcion"].ToString();
row["DestinoDescripcion"] = ds.Tables[0].Rows[i]["DestinoDescripcion"].ToString();
row["FechaPartida"] = ds.Tables[0].Rows[i]["FechaPartida"].ToString();
row["FechaRegreso"] = ds.Tables[0].Rows[i]["FechaRegreso"].ToString();
row["ImporteTarifaPesos"] = ds.Tables[0].Rows[i]["ImporteTarifaPesos"].ToString();
row["ImporteTarifaDolar"] = ds.Tables[0].Rows[i]["ImporteTarifaDolar"].ToString();
row["IdCobertura"] = ds.Tables[0].Rows[i]["IdCobertura"].ToString();
row["DescripcionCobertura"] = ds.Tables[0].Rows[i]["DescripcionCobertura"].ToString();
row["ValorCobertura"] = ds.Tables[0].Rows[i]["ValorCobertura"].ToString();
row["MonedaDescripcion"] = ds.Tables[0].Rows[i]["MonedaDescripcion"].ToString();
row["SimboloMoneda"] = ds.Tables[0].Rows[i]["SimboloMoneda"].ToString();
row["IdCobertura2"] = ds.Tables[0].Rows[i]["IdCobertura2"].ToString();
row["DescripcionCobertura2"] = ds.Tables[0].Rows[i]["DescripcionCobertura2"].ToString();
row["ValorCobertura2"] = ds.Tables[0].Rows[i]["ValorCobertura2"].ToString();
row["MonedaDescripcion2"] = ds.Tables[0].Rows[i]["MonedaDescripcion2"].ToString();
row["SimboloMoneda2"] = ds.Tables[0].Rows[i]["SimboloMoneda2"].ToString();
row["EmailEnviaVoucher"] = ds.Tables[0].Rows[i]["EmailEnviaVoucher"].ToString();
emailenviavoucher = ds.Tables[0].Rows[i]["EmailEnviaVoucher"].ToString();
dtVoucher.Rows.Add(row);
}
ds.Dispose();
dsVoucher.Tables.Add(dtVoucher);
ReportDocument reporte = new ReportDocument(); // creating object of crystal report
reporte.Load(Server.MapPath("~/Reportes/pagoconfirmado.rpt")); // path of report
reporte.SetDataSource(dsVoucher.Tables[0]);
dsVoucher.Dispose();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
reporte.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
reporte.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
archivo = "C:/Data/Tusegurodeviaje/Reports/TempReports/pagoconfirmado_" + IdOperacion + ".pdf";
diskOpts.DiskFileName = archivo;
reporte.ExportOptions.DestinationOptions = diskOpts;
reporte.Export();
//CrystalReportViewer1.ReportSource = reporte;
//reporte.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "pagoconfirmado" + IdOperacion);
enviaemail(archivo, emailenviavoucher);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
private static void ExportPDF(ReportDocument rpt, string sCaminhoSave)
{
CrystalDecisions.Windows.Forms.CrystalReportViewer cryView = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = sCaminhoSave;
CrExportOptions = rpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
rpt.Export();
}
private static void saveToFileSytem(ReportDocument informeBasico, string nombreInforme, string ApplicationPath)
{
ExportOptions informeOpcion = new ExportOptions();
informeOpcion.ExportFormatType = ExportFormatType.PortableDocFormat;
informeOpcion.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions destino = new DiskFileDestinationOptions();
destino.DiskFileName = ApplicationPath + "\\informes\\" + nombreInforme;
informeOpcion.ExportDestinationOptions = destino;
informeBasico.Export(informeOpcion);
}
public override void Start()
{
FrmProgress frmProgreso = new FrmProgress();
frmProgreso.Start(2, "Exportando ...");
frmProgreso.Next();
try
{
CReporte reporte = null;
ExportFormatOptions opciones = null;
ExportFormatType formato;
string nombreArchivo = string.Empty;
string extension = string.Empty;
string sql = string.Empty;
if (base.m_ObjectFlow is DocumentoGenerico)
{
DocumentoGenerico documento = (DocumentoGenerico)base.m_ObjectFlow;
reporte = documento.TipoDocumento.Reporte;
nombreArchivo = string.Format("{0} - Nº {1} {2}", reporte.Nombre, documento.Numeracion, DateTime.Now.ToString("yyyy-MM-dd"));
sql = reporte.SQL;
foreach (ParametroReporte Parametro in reporte.ParametrosSQL)
sql = sql.Replace(Parametro.Nombre, documento.ValueByProperty(Parametro.Propiedad).ToString());
}
else if (base.m_ObjectFlow is CReporte)
{
reporte = (CReporte)base.m_ObjectFlow;
nombreArchivo = string.Format("{0} {1}", reporte.Nombre, DateTime.Now.ToString("yyyy-MM-dd"));
sql = reporte.SQL;
foreach (ParametroReporte Parametro in reporte.ParametrosSQL)
sql = sql.Replace(Parametro.Nombre, Parametro.Valor);
}
switch (base.m_Parameter)
{
case TypeEnum.CEnumExportFormat.PDF:
formato = ExportFormatType.PortableDocFormat;
opciones = new PdfRtfWordFormatOptions();
extension = ".pdf";
break;
case TypeEnum.CEnumExportFormat.WORD:
formato = ExportFormatType.WordForWindows;
opciones = new PdfRtfWordFormatOptions();
extension = ".doc";
break;
case TypeEnum.CEnumExportFormat.EXCEL:
formato = ExportFormatType.Excel;
opciones = new ExcelFormatOptions();
extension = ".xls";
break;
default:
throw new Exception("El formato no es válido.");
}
if (reporte != null)
{
ReportDocument CryRpt = new ReportDocument();
CryRpt.Load(String.Format("{0}{1}", FrmMain.CarpetaReportes, reporte.Ubicacion));
frmProgreso.Next();
// Si existe una consulta SQL se ejecuta.
if (sql.Trim().Length > 0) { CryRpt.SetDataSource(HelperNHibernate.GetDataSet(sql)); }
// Se reemplazan los parámetros Crystal.
foreach (ParametroReporte Parametro in reporte.ParametrosCrystal)
CryRpt.SetParameterValue(Parametro.Nombre, Parametro.Valor);
// Se exporta el reporte.
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
CrDiskFileDestinationOptions.DiskFileName = string.Format("{0}{1}{2}", FrmMain.CarpetaExportacion, nombreArchivo, extension);
CrExportOptions = CryRpt.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = formato;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = opciones;
}
// Se exporta el archivo.
CryRpt.Export();
// Se inicia un proceso para abrir el archivo.
Process.Start(CrDiskFileDestinationOptions.DiskFileName);
}
else
throw new Exception("Entidad no válida.");
base.m_ResultProcess = EnumResult.SUCESS;
}
catch (Exception ex)
{
SoftException.Control(ex);
}
finally
{
frmProgreso.Close();
base.Start();
}
}
private void GeneratePDF()
{
ReportDocument rpt = new ReportDocument();
switch (cboReportType.SelectedItem.Text)
{
case "Posted PO":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PostedPO.rpt"));
break;
case "Posted PO Returns":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PostedPOReturns.rpt"));
break;
case "Posted Debit Memo":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PostedDebitMemo.rpt"));
break;
case "By Vendor":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PurchaseAnalysis.rpt"));
break;
default:
return;
}
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\retailplus\temp\");
string strFileName = cboReportType.SelectedItem.Text.Replace(" ", "").ToLower() + "_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".pdf";
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
dest.DiskFileName = strPath + strFileName;
exportop = rpt.ExportOptions;
SetDataSource(rpt);
exportop.DestinationOptions = dest;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
exportop.ExportFormatType = ExportFormatType.PortableDocFormat;
rpt.Export(); rpt.Close(); rpt.Dispose();
fraViewer.Attributes.Add("src",Constants.ROOT_DIRECTORY + "/temp/" + strFileName);
}
private void GenerateHTML()
{
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/GeneralLedger.rpt"));
HTMLFormatOptions htmlOpts = new HTMLFormatOptions();
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\RetailPlus\temp\html\");
// DeleteTempDirectory(strPath);
string strFileName = "generalledger_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".htm";
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
htmlOpts.HTMLFileName = strFileName;
htmlOpts.HTMLEnableSeparatedPages = true;;
htmlOpts.HTMLHasPageNavigator = true;
htmlOpts.HTMLBaseFolderName = strPath;
rpt.ExportOptions.FormatOptions = htmlOpts;
exportop = rpt.ExportOptions;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
exportop.ExportFormatType = ExportFormatType.HTML40;
dest.DiskFileName = strFileName.ToString();
exportop.DestinationOptions = dest;
SetDataSource(rpt);
rpt.Export(); rpt.Close(); rpt.Dispose();
strFileName = "//" + Request.ServerVariables["SERVER_NAME"].ToString() + FindHTMLFile(strPath,strFileName);
fraViewer.Attributes.Add("src",strFileName);
}
/// <summary>
/// Generate a Word, Excel or PDF report from a Crystal Reports template.
/// </summary>
/// <param name="templateFileBytes"></param>
/// <param name="ds"></param>
/// <param name="outputFormat"></param>
/// <returns></returns>
public static byte[] GenerateFromCrystalReportTemplate(byte[] templateFileBytes, DataSet ds, int? outputFormat)
{
// Crystal Reports behave in a strange way. It can only load
// the template from disk and output the final report to disk
// (but not to/from memory stream). So we need to set up
// temporary file paths in the ReportTempFolder.
//
string reportTempFolder = ConfigurationManager.AppSettings["ReportTempFolder"];
string templatePath = reportTempFolder + Guid.NewGuid().ToString();
string outputPath = reportTempFolder + Guid.NewGuid().ToString();
// Write the crystal report template file out to disk.
//
FileStream fs = new FileStream(templatePath, FileMode.Create);
try { fs.Write(templateFileBytes, 0, templateFileBytes.Length); }
finally { fs.Close(); }
// Create the new Crystal Report objects, load the template
// and set the data source.
//
ReportDocument doc = new ReportDocument();
doc.Load(templatePath);
doc.SetDataSource(ds);
// 2011 04 29
// Kien Trung
// Open all the sub reports and set data source to them.
foreach (ReportDocument sub in doc.Subreports)
sub.SetDataSource(ds);
// Then we export the output to a file.
//
ExportOptions exportOpts = doc.ExportOptions;
if (outputFormat == DocumentOutputFormat.AcrobatPDF)
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
else if (outputFormat == DocumentOutputFormat.MicrosoftExcel)
exportOpts.ExportFormatType = ExportFormatType.Excel;
else if (outputFormat == DocumentOutputFormat.MicrosoftWord)
exportOpts.ExportFormatType = ExportFormatType.WordForWindows;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.DestinationOptions = new DiskFileDestinationOptions();
((DiskFileDestinationOptions)doc.ExportOptions.DestinationOptions).DiskFileName = outputPath;
doc.Export();
// And we then read the file and return it to the caller.
//
FileStream fs2 = new FileStream(outputPath, FileMode.Open);
byte[] output = new byte[fs2.Length];
try { fs2.Read(output, 0, (int)fs2.Length); }
finally { fs2.Close(); }
return output;
}
private void imprimepresupuesto()
{
String opciones;
String[] Datos;
SqlConnection connection;
SqlDataAdapter adapter;
try
{
DataSet dspresupuesto= new DataSet();
opciones = Request.QueryString["op"];
Datos = opciones.Split('_');
System.Data.SqlClient.SqlConnection conn;
conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn.Open();
SqlCommand command = new SqlCommand("spselImprimeCotizacion", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("FechaDesde", Datos[0].ToString());
command.Parameters.AddWithValue("FechaHasta", Datos[1].ToString());
command.Parameters.AddWithValue("idOrigen", Datos[2].ToString());
command.Parameters.AddWithValue("IdDestino", Datos[3].ToString() );
command.Parameters.AddWithValue("Email", Datos[4].ToString());
command.Parameters.AddWithValue("edades", Datos[5].ToString());
command.ExecuteNonQuery();
adapter = new SqlDataAdapter(command);
adapter.Fill(dspresupuesto);
conn.Close();
String archivo = "";
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(Server.MapPath("~/Reportes/presupuesto1.rpt"));
rptDoc.SetDataSource(dspresupuesto.Tables[0]);
dspresupuesto.Dispose();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
string targetFileName = "C:/Data/Tusegurodeviaje/Reports/TempReports/presupuesto_" + (new Random()).Next() + ".pdf";
//string targetFileName = Request.PhysicalApplicationPath + "C:\Data\Tusegurodeviaje\Reports\TempReports\\presupuesto" + (new Random()).Next() + ".pdf";
rptDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
rptDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
diskOpts.DiskFileName = targetFileName;
//archivo = Server.MapPath(targetFileName);
rptDoc.ExportOptions.DestinationOptions = diskOpts;
// Export report ... Server-Side.
rptDoc.Export();
CrystalReportViewer1.ReportSource = rptDoc;
rptDoc.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "presupuesto");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
public static byte[] GetInformePreliminar(int ajusteId, string ruta)
{
// Instancia del reporte
String reportPath = ruta + "docs\\crInformePreliminar.rpt";
//MODIFICAR CON LA AGREGACION DE LA EXTENCION DEL PDF
String nombre = "PASA-IP-" + ajusteId + "-" + DateTime.Now.Day + DateTime.Now.Month + DateTime.Now.Year + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Millisecond + ".pdf";
ReportDocument informeBasico = new ReportDocument();
informeBasico.Load(reportPath);
dsReporteTableAdapters.InformeBasicoImagenesTableAdapter dtImagenes = new dsReporteTableAdapters.InformeBasicoImagenesTableAdapter();
DataTable imagenes = (DataTable)dtImagenes.GetData(ajusteId);
informeBasico.OpenSubreport("crIBImagen.rpt").SetDataSource(imagenes);
dsReporteTableAdapters.InformeBasicoDocumentacionSolicitadaTableAdapter dtdocumentacion = new dsReporteTableAdapters.InformeBasicoDocumentacionSolicitadaTableAdapter();
DataTable documentacion = (DataTable)dtdocumentacion.GetData(ajusteId);
informeBasico.OpenSubreport("crIBDocumentacion.rpt").SetDataSource(documentacion);
dsReporteTableAdapters.InformeBasicoReclamoTableAdapter dtreclamo = new dsReporteTableAdapters.InformeBasicoReclamoTableAdapter();
DataTable reclamo = (DataTable)dtreclamo.GetData(ajusteId);
informeBasico.OpenSubreport("crIBReclamo.rpt").SetDataSource(reclamo);
dsReporteTableAdapters.InformeBasicoInspeccionTableAdapter dtinspeccion = new dsReporteTableAdapters.InformeBasicoInspeccionTableAdapter();
DataTable inspeccion = (DataTable)dtinspeccion.GetData(ajusteId);
informeBasico.OpenSubreport("crIBInspeccion.rpt").SetDataSource(inspeccion);
dsReporteTableAdapters.InformeBasicoOcurrenciaDetalleTableAdapter dtdetalleocurrencia = new dsReporteTableAdapters.InformeBasicoOcurrenciaDetalleTableAdapter();
DataTable detalleocurrencia = (DataTable)dtdetalleocurrencia.GetData(ajusteId);
informeBasico.OpenSubreport("crIBDetalleOcurrencia.rpt").SetDataSource(detalleocurrencia);
dsReporteTableAdapters.InformeBasicoOcurrenciaCabeceraTableAdapter dtocurrencia = new dsReporteTableAdapters.InformeBasicoOcurrenciaCabeceraTableAdapter();
DataTable ocurrencia = (DataTable)dtocurrencia.GetData(ajusteId);
informeBasico.OpenSubreport("crIBOcurrencia.rpt").SetDataSource(ocurrencia);
dsReporteTableAdapters.InformeBasicoClausulasTableAdapter dtclausulas = new dsReporteTableAdapters.InformeBasicoClausulasTableAdapter();
DataTable clausulas = (DataTable)dtclausulas.GetData(ajusteId);
informeBasico.OpenSubreport("crIBClausulas.rpt").SetDataSource(clausulas);
dsReporteTableAdapters.InformeBasicoDeduciblesTableAdapter dtdeducibles = new dsReporteTableAdapters.InformeBasicoDeduciblesTableAdapter();
DataTable deducibles = (DataTable)dtdeducibles.GetData(ajusteId);
informeBasico.OpenSubreport("crIBDeducibles.rpt").SetDataSource(deducibles);
dsReporteTableAdapters.InformeBasicoPolizaDetalleTableAdapter dtdetallepoliza = new dsReporteTableAdapters.InformeBasicoPolizaDetalleTableAdapter();
DataTable detallePoliza = (DataTable)dtdetallepoliza.GetData(ajusteId);
informeBasico.OpenSubreport("crIBDetallePoliza.rpt").SetDataSource(detallePoliza);
dsReporteTableAdapters.InformeBasicoPolizaTableAdapter dtPoliza = new dsReporteTableAdapters.InformeBasicoPolizaTableAdapter();
DataTable poliza = (DataTable)dtPoliza.GetData(ajusteId);
informeBasico.OpenSubreport("crIBPoliza.rpt").SetDataSource(poliza);
dsReporteTableAdapters.InformeBasicoFechaAvisoCoordinacionTableAdapter dtfechacoordinacion = new dsReporteTableAdapters.InformeBasicoFechaAvisoCoordinacionTableAdapter();
DataTable fechaCoordinacion = (DataTable)dtfechacoordinacion.GetData(ajusteId);
informeBasico.OpenSubreport("crIBFechaAviso.rpt").SetDataSource(fechaCoordinacion);
dsReporteTableAdapters.InformeBasicoGeneralesTableAdapter dtgenerales = new dsReporteTableAdapters.InformeBasicoGeneralesTableAdapter();
DataTable datosgenerales = (DataTable)dtgenerales.GetData(ajusteId);
informeBasico.OpenSubreport("crIBGenerales.rpt").SetDataSource(datosgenerales);
dsReporteTableAdapters.InformeBasicoCabeceraTableAdapter cabeceraAdapter = new dsReporteTableAdapters.InformeBasicoCabeceraTableAdapter();
informeBasico.SetDataSource((DataTable)cabeceraAdapter.GetData(ajusteId));
//informeBasico.FileName = "InformeBasico" + ajusteId + ".pdf";
ExportOptions informeOpcion = new ExportOptions();
informeOpcion.ExportFormatType = ExportFormatType.PortableDocFormat;
informeOpcion.ExportDestinationType = ExportDestinationType.DiskFile;
DiskFileDestinationOptions destino = new DiskFileDestinationOptions();
nombre = "InformeBasicoAYP.pdf";
destino.DiskFileName = ruta + "informes\\" + nombre;
informeOpcion.ExportDestinationOptions = destino;
informeBasico.Export(informeOpcion);
//dsReporteTableAdapters.InformeBasicoSelectTableAdapter tainforme = new dsReporteTableAdapters.InformeBasicoSelectTableAdapter();
//tainforme.Insert(ajusteId, nombre, ruta + "informes\\");
MemoryStream oStream;
oStream = (MemoryStream)informeBasico.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return oStream.ToArray();
}
private void enviaemail(String IdOperacion)
{
SqlDataAdapter adapter;
DataSet ds = new DataSet();
String archivo = "";
try
{
ReportDocument reporte = new ReportDocument(); // creating object of crystal report
reporte.Load(Server.MapPath("~/Reportes/voucher.rpt")); // path of report
//ParameterField myParam = new ParameterField();
//ParameterDiscreteValue myDiscreteValue = new ParameterDiscreteValue();
//myParam.ParameterFieldName = "Id_Operacion";
//myDiscreteValue.Value = Convert.ToInt32(IdOperacion);
//myParam.CurrentValues.Add(myDiscreteValue);
//reporte.ParameterFields.Add(myParam);
reporte.SetParameterValue("@Id_Operacion", Convert.ToInt32(IdOperacion));
//ParameterDiscreteValue crtParamDiscreteValue;
//ParameterField crtParamField;
//ParameterFields crtParamFields;
//crtParamDiscreteValue = new ParameterDiscreteValue();
//crtParamField = new ParameterField();
//crtParamFields = new ParameterFields();
//crtParamDiscreteValue.Value = Convert.ToInt32(IdOperacion);
//crtParamField.ParameterFieldName = "Id_Operacion";
//crtParamField.CurrentValues.Add(crtParamDiscreteValue);
//crtParamFields.Add(crtParamField);
//CrystalReportViewer1.ParameterFieldInfo = crtParamFields;
////this.CrystalReportViewer1.RefreshReport();
//CrystalReportViewer1.ReportSource = reporte;
//reporte.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "voucher");
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
reporte.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
reporte.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
archivo = Server.MapPath("~/Reportes/TempReports/v" + IdOperacion + ".pdf");
diskOpts.DiskFileName = archivo;
reporte.ExportOptions.DestinationOptions = diskOpts;
reporte.Export();
MailMessage mail = new MailMessage();
//set the addresses
string emailAddressList = System.Configuration.ConfigurationManager.AppSettings["emailsToSend"];
string displayName = System.Configuration.ConfigurationManager.AppSettings["displayNameEmailAddressToSendAuthorizationDocs"];
mail.From = new MailAddress(System.Configuration.ConfigurationManager.AppSettings["fromEmailAddressToSendAuthorizationDocs"], displayName);
mail.To.Add(emailAddressList);
mail.IsBodyHtml = true;
//set the content
mail.Subject = "Voucher";
//set the body
mail.Body += "Muchas gracias.<br />";
//MailAttachment objArchivo = new MailAttachment("E:\\Email\\pedido.pdf");
mail.Attachments.Add(new Attachment(archivo));
//mail.Attachments.Add(archivo);
string SMTPServer = System.Configuration.ConfigurationManager.AppSettings["SMTPServer"];
SmtpClient smtp = new SmtpClient(SMTPServer); //specify the mail server address
smtp.Send(mail);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
private void imprimecomparativa()
{
String opciones = "";
String[] Datos;
DataSet ds = new DataSet();
DataSet dsCompara = new DataSet();
SqlDataAdapter adapter;
String valorcobertura = "-";
String tabla = "";
Boolean band = false;
int planes = 0;
String archivo = "";
DataTable dtComparativa = new DataTable();
DataSet dsComparativa = new DataSet();
dtComparativa.Columns.Add("Producto");
dtComparativa.Columns.Add("Cobertura");
dtComparativa.Columns.Add("Importe");
opciones = Request.QueryString["op"];
Datos = opciones.Split('*');
planes = (Datos.Count() - 1);
try
{
System.Data.SqlClient.SqlConnection conn;
conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn.Open();
SqlCommand command = new SqlCommand("spselCoberturas", conn);
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
conn.Close();
if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
{
for (int x = 0; x < ds.Tables[0].Rows.Count; x++)
{
for (int j = 0; j < Datos.Count() - 1; j++)
{
System.Data.SqlClient.SqlConnection conn1;
conn1 = new System.Data.SqlClient.SqlConnection();
conn1.ConnectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
conn1.Open();
SqlCommand command1 = new SqlCommand("spselComparativa", conn1);
command1.CommandType = CommandType.StoredProcedure;
command1.Parameters.AddWithValue("IDProducto", Convert.ToInt32(Datos[j].ToString()));
command1.ExecuteNonQuery();
adapter = new SqlDataAdapter(command1);
adapter.Fill(dsCompara);
conn1.Close();
valorcobertura = "-";
band = false;
for (int z = 0; z < dsCompara.Tables[0].Rows.Count; z++)
{
if (ds.Tables[0].Rows[x]["IdCobertura"].ToString() == dsCompara.Tables[0].Rows[z]["IdCobertura"].ToString())
{
DataRow row = dtComparativa.NewRow();
row["Producto"] = dsCompara.Tables[0].Rows[x]["Nombre"].ToString();
row["Cobertura"] = dsCompara.Tables[0].Rows[x]["Descripcion"].ToString();
row["Importe"] = dsCompara.Tables[0].Rows[x]["ValorCobertura"].ToString();
dtComparativa.Rows.Add(row);
band = true;
break;
}
}
dsCompara.Dispose();
}
}
}
ds.Dispose();
dsComparativa.Tables.Add(dtComparativa);
ReportDocument reporte = new ReportDocument();
reporte.Load(Server.MapPath("~/Reportes/comparativa.rpt"));
reporte.SetDataSource(dsComparativa.Tables[0]);
dsComparativa.Dispose();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
reporte.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
reporte.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
archivo = "C:/Data/Tusegurodeviaje/Reports/TempReports/plan_" + (new Random()).Next() + ".pdf";
diskOpts.DiskFileName = archivo;
reporte.ExportOptions.DestinationOptions = diskOpts;
reporte.Export();
enviamensaje(archivo);
}
catch (Exception ex)
{
lblError.Text = "Error enviando correo electrónico: " + ex.Message;
}
finally
{
}
}
private void GenerateHTML()
{
ReportDocument rpt = new ReportDocument();
switch (cboReportType.SelectedItem.Text)
{
case "Posted PO":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PostedPO.rpt"));
break;
case "Posted PO Returns":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PostedPOReturns.rpt"));
break;
case "Posted Debit Memo":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PostedDebitMemo.rpt"));
break;
case "By Vendor":
rpt.Load(Server.MapPath(Constants.ROOT_DIRECTORY + "/Reports/PurchaseAnalysis.rpt"));
break;
default:
return;
}
HTMLFormatOptions htmlOpts = new HTMLFormatOptions();
ExportOptions exportop = new ExportOptions();
DiskFileDestinationOptions dest = new DiskFileDestinationOptions();
string strPath = Server.MapPath(@"\retailplus\temp\html\");
string strFileName = cboReportType.SelectedItem.Text.Replace(" ", "").ToLower() + "_" + Session["UserName"].ToString() + "_" + DateTime.Now.ToString("yyyyMMddhhmmssff") + ".htm";
if (System.IO.File.Exists(strPath + strFileName))
System.IO.File.Delete(strPath + strFileName);
htmlOpts.HTMLFileName = strFileName;
htmlOpts.HTMLEnableSeparatedPages = true;;
htmlOpts.HTMLHasPageNavigator = true;
htmlOpts.HTMLBaseFolderName = strPath;
rpt.ExportOptions.FormatOptions = htmlOpts;
exportop = rpt.ExportOptions;
exportop.ExportDestinationType = ExportDestinationType.DiskFile;
exportop.ExportFormatType = ExportFormatType.HTML40;
dest.DiskFileName = strFileName.ToString();
exportop.DestinationOptions = dest;
SetDataSource(rpt);
Session["ReportDocument"] = rpt;
rpt.Export(); rpt.Close(); rpt.Dispose();
strFileName = "//" + Request.ServerVariables["SERVER_NAME"].ToString() + FindHTMLFile(strPath,strFileName);
fraViewer.Attributes.Add("src",strFileName);
}
protected void btnPresupuesto_Click(object sender, EventArgs e)
{
/*
DataSet dss = BRBitacora.buscarPorFiltro("","","","","");
DataTable dt = dss.Tables[0];
//dt.Columns.Add("id");
//TransArteReport report = new TransArteReport();
//DataTable _tabla = report.DataTable1;
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("../Reportes/ReportBitacora.rpt"));
rpt.SetDataSource(dt);
*/
ReportDocument rpt = new ReportDocument();
String szFileName = "";
String strServerPath = "";
rpt.PrintOptions.PaperOrientation = PaperOrientation.DefaultPaperOrientation;
rpt.PrintOptions.PaperSize = PaperSize.DefaultPaperSize;
rpt.PrintOptions.PaperSource = PaperSource.Upper;
rpt.PrintOptions.PrinterDuplex = PrinterDuplex.Default;
DataSet dss = BRBitacora.buscarPorFiltro("", "", "", "", "");
DataTable dt = dss.Tables[0];
dt.Columns.Add("Logo", System.Type.GetType("System.Byte[]"));//Agrego la columna con el tipo de dato "System.Byte[]",donde guardare mi imagen.
dt.Rows[0]["Logo"] = CargarImagen("C:\\TransArte\\Website\\images\\logoMini.PNG");//Cargo La imagen
dt.Columns.Add("UsuarioFiltro", System.Type.GetType("System.String"));//Agrego la columna con el tipo de dato "System.Byte[]",donde guardare mi imagen.
dt.Rows[0]["UsuarioFiltro"] = "MAXIMILIANO";//Cargo La imagen
rpt.Load(Server.MapPath("../Reportes/ReportBitacora.rpt"));
rpt.SetDataSource(dt);
szFileName = "bitacora.pdf";
strServerPath = Server.MapPath("~") + "\\Reportes\\";
DiskFileDestinationOptions dfdoFile = new DiskFileDestinationOptions();
dfdoFile.DiskFileName = strServerPath + szFileName;
rpt.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
rpt.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
rpt.ExportOptions.DestinationOptions = dfdoFile;
rpt.Export();
Response.Redirect("../Reportes/" + szFileName, false);
/*
*
http://localhost:49173/website/Servicio/Reportes.aspx
*
* */
}
public void VistaPrevia(string key)
{
try
{
ReportDocument objRpt = new ReportDocument();
DataSet ds = (DataSet)this.GetDataReport(key);
//string reportPath = Application.StartupPath + "\\Reporte\\co_ordenCompra_rpt.rpt";
string reportPath = "C:\\Reportes\\co_ordenCompra_rpt.rpt";
objRpt.Load(reportPath);
DiskFileDestinationOptions crDiskFileDestinationOption = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions crFormatTypeOption = new PdfRtfWordFormatOptions();
ExportOptions crExportOptions = new ExportOptions();
objRpt.SetDataSource(ds.Tables[0]);
string strfolder = "C:\\Reporte\\";
crDiskFileDestinationOption.DiskFileName = strfolder + txtnu_oc.Text + ".pdf";
crExportOptions = objRpt.ExportOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crExportOptions.ExportDestinationOptions = crDiskFileDestinationOption;
crExportOptions.ExportFormatOptions = crFormatTypeOption;
objRpt.Export();
}
catch (Exception ex)
{
}
}
public void PrintReport(string key)
{
try
{
//----------------------------------------
ReportDocument objRpt = new ReportDocument();
DataSet ds = (DataSet)this.GetDataReport(key);
string reportPath = "C:\\Reportes\\CRIngreso_etiqueta02.rpt";
objRpt.Load(reportPath);
DiskFileDestinationOptions crDiskFileDestinationOption = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions crFormatTypeOption = new PdfRtfWordFormatOptions();
ExportOptions crExportOptions = new ExportOptions();
objRpt.SetDataSource(ds.Tables[0]);
string strfolder = "C:\\Reporte\\";
crDiskFileDestinationOption.DiskFileName = strfolder + "Etiqueta.pdf";
crExportOptions = objRpt.ExportOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
crExportOptions.ExportDestinationOptions = crDiskFileDestinationOption;
crExportOptions.ExportFormatOptions = crFormatTypeOption;
objRpt.Export();
//---------------------------------------
////string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
//string NombreImpresora = "";
////for (int i = 0; i < PrinterSettings.InstalledPrinters.Count; i++)
////{
//// PrinterSettings a = new PrinterSettings();
//// a.PrinterName = PrinterSettings.InstalledPrinters[i].ToString();
//// if (a.IsDefaultPrinter)
//// {
//// PrinterName = PrinterSettings.InstalledPrinters[i].ToString();
//// }
////}
//this.printDialog1.Document = this.printDocument1;
//DialogResult dr = this.printDialog1.ShowDialog();
//if (dr == DialogResult.OK)
// {
PageMargins margins;
margins = objRpt.PrintOptions.PageMargins;
margins.bottomMargin = 250;
margins.leftMargin = 250;
margins.rightMargin = 250;
margins.topMargin = 250;
objRpt.PrintOptions.ApplyPageMargins(margins);
//string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
// ////objRpt.PrintOptions.PrinterName = PrinterName;
objRpt.PrintOptions.PrinterName = GetImpresoraDefecto();
//objRpt.PrintOptions.PrinterName = PrinterName;
objRpt.PrintToPrinter(1, false, 0, 0);
//}
}
catch (Exception ex)
{
ex.ToString();
}
}
private void ExportarComprobanteButton_Click(object sender, EventArgs e)
{
try
{
Cursor = System.Windows.Forms.Cursors.WaitCursor;
if (DetalleLoteDataGridView.SelectedRows.Count != 0)
{
for (int i = 0; i < DetalleLoteDataGridView.SelectedRows.Count; i++)
{
int renglon = DetalleLoteDataGridView.SelectedRows[i].Index;
ReportDocument ReporteDocumento = new ReportDocument();
ProcesarComprobante(out ReporteDocumento, lote, renglon);
//Nombre del comprobante ( pdf )
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(lote.CuitVendedor);
sb.Append("-");
sb.Append(Convert.ToInt32(lote.PuntoVenta).ToString("0000"));
sb.Append("-");
sb.Append(Convert.ToInt32(lote.Comprobantes[renglon].IdTipoComprobante).ToString("00"));
sb.Append("-");
sb.Append(Convert.ToInt32(lote.Comprobantes[renglon].NumeroComprobante).ToString("00000000"));
sb.Append(".pdf");
//ExportOptions
DiskFileDestinationOptions crDiskFileDestinationOptions = new DiskFileDestinationOptions();
crDiskFileDestinationOptions.DiskFileName = Aplicacion.Aplic.ArchPathPDF + sb.ToString();
ReporteDocumento.ExportOptions.ExportDestinationOptions = crDiskFileDestinationOptions;
ReporteDocumento.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
ReporteDocumento.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
ReporteDocumento.ExportOptions.ExportFormatOptions = CrFormatTypeOptions;
ReporteDocumento.Export();
ReporteDocumento.Close();
}
if (DetalleLoteDataGridView.SelectedRows.Count == 1)
{
MessageBox.Show("El comprobante seleccionado se ha exportado satisfactoriamente.", "Exportar Comprobantes", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
else
{
MessageBox.Show("Los comprobantes seleccionados se han exportado satisfactoriamente.", "Exportar Comprobantes", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Problemas al procesar el comprobante", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
finally
{
Cursor = System.Windows.Forms.Cursors.Default;
}
}
protected void lnkbtnDownload_Click(object sender, EventArgs e)
{
try
{
ReportDocument doc = new ReportDocument();
string fileName = Server.MapPath("~/Reports/Invoice.rpt");
doc.Load(fileName);
doc.SetParameterValue("@invoiceNo", lblInvoiceNo.Text);
doc.SetParameterValue("@notes", lblNotes.Text);
doc.SetParameterValue("@subTotal", lbldiscount.Text);
doc.SetParameterValue("@discount", lbldiscount.Text);
doc.SetParameterValue("@Tax", lblTaxAmount.Text);
doc.SetParameterValue("@total", lblTotalAmount.Text);
doc.SetParameterValue("@invoiceDate", lblInvoiceDate.Text);
doc.SetParameterValue("@clientName", clientName);
doc.SetParameterValue("@clientAdd", clientAdd);
doc.SetParameterValue("@clientState", clientState);
doc.SetParameterValue("@clientCountry", clientCountry);
doc.SetParameterValue("@clientEmail", clientEmail);
doc.SetParameterValue("@description", lbldesc.Text);
doc.SetParameterValue("@NoOfEmailsSent", lblnoofemailsent.Text);
doc.SetParameterValue("@priceRate", lblprice.Text);
doc.SetParameterValue("@amount", lblamount.Text);
doc.SetParameterValue("@status", lblStatus.Text);
doc.SetParameterValue("@clientMobileNo", clientMobileNo);
//set the export options to PDF
ExportOptions exportOpts = doc.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.DestinationOptions = new DiskFileDestinationOptions();
// Set the disk file options.
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
((DiskFileDestinationOptions)doc.ExportOptions.DestinationOptions).DiskFileName = Server.MapPath("~/pages/ReportSummary/Invoice.pdf");
doc.Export();
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=Invoice.pdf");
Response.ContentType = "Application/pdf";
//Get the physical path to the file.
string FilePath = Server.MapPath("~/pages/ReportSummary/Invoice.pdf");
//Write the file directly to the HTTP content output stream.
Response.WriteFile(FilePath);
Response.End();
}
catch (Exception ex)
{
//ExceptionPolicy.HandleException(ex, "Web.UIPolicy");
}
}
