public FileResult ExportPdf() { Stream stream = null; var nombreArchivo = ""; int IdMovimiento = 1313; try { object objetos = new object(); EntitiesProveduria db = new EntitiesProveduria(); SqlConnectionStringBuilder builderOrden = new SqlConnectionStringBuilder(db.Database.Connection.ConnectionString); SP_INGRESO_BODEGATableAdapter tableAdapter = new SP_INGRESO_BODEGATableAdapter(); DataTable dataTable = tableAdapter.GetData(IdMovimiento, out objetos); String pathReport = Path.Combine(HttpRuntime.AppDomainAppPath, "Reports\\Cr_Ingreso_Bodega1.rpt"); ReportDocument reportDocument = new ReportDocument(); reportDocument.Load(pathReport); reportDocument.SetDataSource(dataTable); reportDocument.SetDatabaseLogon(builderOrden.UserID, builderOrden.Password); stream = reportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); nombreArchivo = "INGRESO_BODEGA.pdf"; } catch (Exception ex) { logger.Error(ex, ex.Message); } return(File(stream, "application/pdf", nombreArchivo)); }
public FileResult ExportPdfKardex(string pinicio, string pfin, int pidItem) { Stream stream = null; var nombreArchivo = ""; ReportDocument reportDocument = new ReportDocument(); byte[] pdfByte = null; try { object objetos = new object(); EntitiesProveduria db = new EntitiesProveduria(); SqlConnectionStringBuilder builderOrden = new SqlConnectionStringBuilder(db.Database.Connection.ConnectionString); SP_KARDEXTableAdapter tableAdapter = new SP_KARDEXTableAdapter(); DataTable dataTable; DateTime fi = DateTime.Parse(pinicio); DateTime ff = DateTime.Parse(pfin); dataTable = tableAdapter.GetData(pidItem, fi, ff, out objetos); String pathReport = Path.Combine(HttpRuntime.AppDomainAppPath, "Reports\\Cr_Kardex.rpt"); reportDocument.Load(pathReport); reportDocument.SetDataSource(dataTable); reportDocument.SetDatabaseLogon(builderOrden.UserID, builderOrden.Password); reportDocument.SetParameterValue("fecha_inicio", fi); reportDocument.SetParameterValue("fecha_fin", ff); stream = reportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); pdfByte = ReadFully(stream); nombreArchivo = "Kardex"; Response.AddHeader("content-disposition", "inline; title='';" + "filename=" + nombreArchivo + ".pdf"); } catch (Exception ex) { logger.Error(ex, ex.Message); } finally { if (reportDocument != null) { if (reportDocument.IsLoaded) { reportDocument.Close(); reportDocument.Dispose(); } } } return(File(pdfByte, MediaTypeNames.Application.Pdf)); }
public FileResult ViewPDF(int?id) { Stream stream = null; var nombreArchivo = ""; ReportDocument reportDocument = new ReportDocument(); byte[] pdfByte = null; try { EPRTA_MOVIMIENTO solicitud = unitOfWork.MovimientoRepository.GetById(id); EntitiesProveduria db = new EntitiesProveduria(); SqlConnectionStringBuilder builderVenta = new SqlConnectionStringBuilder(db.Database.Connection.ConnectionString); SP_REQUISICION_BODEGATableAdapter tableAdapter = new SP_REQUISICION_BODEGATableAdapter(); object objetos = new object(); DataTable dataTable = tableAdapter.GetData(id, out objetos); String pathReport = Path.Combine(HttpRuntime.AppDomainAppPath, "Reports\\Cr_Requisicion_Bodega.rpt"); reportDocument.Load(pathReport); reportDocument.SetDataSource(dataTable); reportDocument.SetDatabaseLogon(builderVenta.UserID, builderVenta.Password); stream = reportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); pdfByte = ReadFully(stream); nombreArchivo = "REQUISICION DE BODEGA "; Response.AddHeader("content-disposition", "inline; title='';" + "filename=" + nombreArchivo + ".pdf"); } catch (Exception ex) { logger.Error(ex, ex.Message); } finally { if (reportDocument != null) { if (reportDocument.IsLoaded) { reportDocument.Close(); reportDocument.Dispose(); } } } return(File(pdfByte, MediaTypeNames.Application.Pdf)); }
public GenericRepository(EntitiesProveduria db) { this.db = db; table = db.Set <TEntity>(); }
public GenericRepository() { this.db = new EntitiesProveduria(); table = db.Set <TEntity>(); }