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