//[AcceptVerbs(HttpVerbs.Get)]
public ActionResult Descargar(int id)
{
try
{
string contentType = "application/pdf";
dsAudiometria dsAudiometria = new dsAudiometria();
string conn = ConfigurationManager.AppSettings["conexion"];
int aud_id = id;
audiometria audiometria = db.audiometria.Find(aud_id);
//medico medico = db.medico.Find(audiometria.aud_medico);
string fileName = String.Empty;
//if (String.IsNullOrEmpty(fileName))
// fileName = "firma.png";
//string path01 = Path.Combine(Server.MapPath("~/Content/firmas"), fileName);
string strAudiometia = "Select * from view_audiometria where aud_id=" + aud_id;
SqlConnection sqlcon = new SqlConnection(conn);
SqlDataAdapter daAudiometria = new SqlDataAdapter(strAudiometia, sqlcon);
daAudiometria.Fill(dsAudiometria, "view_audiometria");
RptAudiometria_ rp = new RptAudiometria_();
rp.Load(Path.Combine(Server.MapPath("~/Reports"), "RptAudiometria_.rpt"));
rp.SetDataSource(dsAudiometria);
//rp.SetParameterValue("picturePath", path01);
rp.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Path.Combine(Server.MapPath("~/Content/audiometria"), aud_id + ".pdf"));
//Stream stream = rp.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
//stream.Seek(0, SeekOrigin.Begin);
//return File(stream, "application/pdf", aud_id + ".pdf");
var document = new Document();
var ms = new MemoryStream();
string archivo1 = Path.Combine(Server.MapPath("~/Content/audiometria"), audiometria.aud_id + ".pdf");
string archivo2 = Path.Combine(Server.MapPath("~/Content/audiometria"), audiometria.aud_archivo);
fileName = "Reporte" + aud_id + ".pdf";
string fileTarget = Path.Combine(Server.MapPath("~/Content/audiometria/") + fileName);
string[] Lista = { archivo1, archivo2 };
Merge(fileTarget, Lista);
ms.Close();
return(File(fileTarget, contentType, fileName));
}
catch (Exception ex)
{
ViewBag.mensaje = ex.Message;
//return View("Message");
return(RedirectToAction("Message", "Home", new { mensaje = ex.Message }));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.reportDocument != null)
{
this.reportDocument.Close();
this.reportDocument.Dispose();
}
dsAudiometria dsPrueba = new dsAudiometria();
string conn = ConfigurationManager.AppSettings["conexion"];
int aud_id = Convert.ToInt32(Session["aud_id"]);
audiometria audiometria = db.audiometria.Find(aud_id);
//string fileName = medico.med_firma;
//if (String.IsNullOrEmpty(fileName))
// fileName = "firma.png";
string strAudiometia = "Select * from audiometria where aud_id=" + aud_id;
string strPaciente = "Select * from paciente where pac_id=" + audiometria.aud_paciente;
SqlConnection sqlcon = new SqlConnection(conn);
SqlDataAdapter daAudiometria = new SqlDataAdapter(strAudiometia, sqlcon);
SqlDataAdapter daPaciente = new SqlDataAdapter(strPaciente, sqlcon);
daAudiometria.Fill(dsPrueba, "audiometria");
daPaciente.Fill(dsPrueba, "paciente");
reportDocument = new ReportDocument();
//Report path
string reportPath = Server.MapPath("~/Reports/RptAudiometria.rpt");
reportDocument.Load(reportPath);
reportDocument.SetDataSource(dsPrueba);
reportDocument.SetParameterValue("hc", "");
reportDocument.SetParameterValue("orden", "");
//string path01 = Path.Combine(Server.MapPath("~/Content/firmas"), fileName);
//reportDocument.SetParameterValue("picturePath", path01);
crViewer.ReportSource = reportDocument;
crViewer.DataBind();
}
