public ActionResult printProcedure(int ID)
{
DataTable dt = new DataTable();
dt.Columns.Add("procedureName", typeof(string));
dt.Columns.Add("fullName", typeof(string));
dt.Columns.Add("age", typeof(int));
dt.Columns.Add("creationDate", typeof(DateTime));
dt.Columns.Add("nextAppointment", typeof(DateTime));
using (SIGECEntities db1 = new SIGECEntities())
{
var result = db1.PrintProcedureIndication(ID).ToList();
foreach (var a in result)
{
dt.Rows.Add(a.procedureName, a.fullName, a.age, a.creationDate, a.nextAppointnment);
}
ReportDocument rep = new ReportDocument();
rep.Load(Path.Combine(Server.MapPath("~/Reports"), "PrintableProcedureIndication.rpt"));
rep.SetDataSource(dt);
try
{
var response = System.Web.HttpContext.Current.Response;
rep.ExportToHttpResponse(ExportFormatType.PortableDocFormat, response, false, "IndicacionProcedimiento");
}
catch (Exception ex)
{
throw ex;
}
}
return(new EmptyResult());
}
public ActionResult printAnalysis(int ID)
{
DataTable dt = new DataTable();
dt.Columns.Add("analysis", typeof(string));
dt.Columns.Add("fullName", typeof(string));
dt.Columns.Add("age", typeof(int));
dt.Columns.Add("creationDate", typeof(DateTime));
dt.Columns.Add("nextAppointment", typeof(DateTime));
using (SIGECEntities db1 = new SIGECEntities())
{
var result = db1.PrintAnalysisIndication(ID).ToList();
foreach (var a in result)
{
dt.Rows.Add(a.analysis, a.fullName, a.age, a.creationDate, a.nextAppointnment);
}
}
using (var reportDocument = new ReportDocument())
{
reportDocument.Load(Path.Combine(Server.MapPath("~/Reports"), "PrintableAnalysisIndication.rpt"));
reportDocument.SetDataSource(dt);
var response = System.Web.HttpContext.Current.Response;
response.Buffer = false;
response.ClearContent();
response.ClearHeaders();
reportDocument.ExportToHttpResponse(ExportFormatType.PortableDocFormat, response, false, "IndicacionAnalisis");
}
return(new EmptyResult());
}
public ActionResult printIncomes(DateTime date)
{
DataTable dt = new DataTable();
dt.Columns.Add("No", typeof(int));
dt.Columns.Add("fullName", typeof(string));
dt.Columns.Add("price", typeof(double));
dt.Columns.Add("discount", typeof(double));
dt.Columns.Add("insurer", typeof(double));
dt.Columns.Add("total", typeof(double));
dt.Columns.Add("reportDate", typeof(DateTime));
using (SIGECEntities db1 = new SIGECEntities())
{
var result = db1.PrintIncomes(date).ToList();
foreach (var a in result)
{
dt.Rows.Add(a.No, a.fullName, a.price, a.discount, a.insurer, a.total, a.reportDate);
}
ReportDocument rep = new ReportDocument();
rep.Load(Path.Combine(Server.MapPath("~/Reports"), "Incomes.rpt"));
rep.SetDataSource(dt);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
var response = System.Web.HttpContext.Current.Response;
rep.ExportToHttpResponse(ExportFormatType.PortableDocFormat, response, false, "Receta");
}
catch (Exception ex)
{
throw ex;
}
}
return(new EmptyResult());
}
