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>();
}
