public ActionResult Index(ParamIDandDateModel param) { var agerangeModel = _clPatientStatisticsDB.GetAgeRange(); int dateoption = string.IsNullOrEmpty(param.DateFrom) ? 1 : 2; var agerange = agerangeModel.FirstOrDefault(w => w.id == param.Id); var patientbyageModel = _clPatientStatisticsDB.PatientbyAge(agerange.startage, agerange.endage, dateoption, param.DateFrom, param.DateTo); //_clReportDAL.GetReportProcedureDoneListDAL(DateFrom, DateTo); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\PatientbyAge.rdl"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsPatientbyAge", patientbyageModel)); reportViewer.LocalReport.SetParameters(new ReportParameter("stAge", agerange.startage)); reportViewer.LocalReport.SetParameters(new ReportParameter("enAge", agerange.endage)); reportViewer.LocalReport.SetParameters(new ReportParameter("xOption", dateoption.ToString())); reportViewer.LocalReport.SetParameters(new ReportParameter("regSTDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("regENDate", param.DateTo)); reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer); ViewBag.ReportViewer = reportViewer; ViewBag.Option = dateoption == 2 ? "checked" : null; ViewBag.Disabled = dateoption == 2 ? null : "disabled"; return(View()); }
public ActionResult Index(ParamIDandDateModel param) { var opdpatientcountModel = _clPolyClinicDB.OPDPatientCount(param.DateFrom, param.DateTo, param.Id); //_clReportDAL.GetReportProcedureDoneListDAL(DateFrom, DateTo); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; if (param.Id == 0) { reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PolyClinic\OpdPatientCount.rdl"; reportViewer.LocalReport.SetParameters(new ReportParameter("FromDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("ToDate", param.DateTo)); } else { reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PolyClinic\OpdRevisitPatientCount.rdl"; reportViewer.LocalReport.SetParameters(new ReportParameter("FromDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("ToDate", param.DateTo)); reportViewer.LocalReport.SetParameters(new ReportParameter("Label", param.Id == 1 ? "Patient Revisit Against Total Number/Department Report" : "Number of New Patients Visited the Hospital Report")); } reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsOPDPatientCount", opdpatientcountModel)); reportViewer = this.DynamicReportHeader(reportViewer, "DataSet2"); reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer); ViewBag.ReportViewer = reportViewer; return(View()); }
public ActionResult ListOrDone(ParamIDandDateModel param) { var patientnationalitystatisticsModel = _clPatientStatisticsDB.GetListOfORDone(param.DateFrom, param.DateTo); //_clReportDAL.GetReportProcedureDoneListDAL(DateFrom, DateTo); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\ListOfORDone.rdl"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("ListOfORDone", patientnationalitystatisticsModel)); reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.DateTo)); reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer); ViewBag.ReportViewer = reportViewer; return(View()); }
public ActionResult Index(ParamIDandDateModel param) { var patientnationalitystatisticsModel = _clPolyClinicDB.ReceptionistTransactionSummary(param.DateFrom, param.DateTo); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PolyClinic\ReceptionistTransactionSummary.rdl"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsReceptionistCharges", patientnationalitystatisticsModel)); reportViewer = this.DynamicReportHeader(reportViewer, "DataSet2"); reportViewer.LocalReport.SetParameters(new ReportParameter("stDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("enDate", param.DateTo)); reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer); ViewBag.ReportViewer = reportViewer; return(View()); }
public ActionResult Index(ParamIDandDateModel param) { var patientnationalitystatisticsModel = _clPolyClinicDB.PINRegistrationbyDateRange(param.Id, param.DateFrom, param.DateTo); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PolyClinic\PINRegisteredDateRange.rdl"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsGetPINRegistered", patientnationalitystatisticsModel)); reportViewer = this.DynamicReportHeader(reportViewer, "DataSet2"); reportViewer.LocalReport.SetParameters(new ReportParameter("stDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("enDate", param.DateTo)); reportViewer.LocalReport.SetParameters(new ReportParameter("xdep", param.Id.ToString())); reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer); ViewBag.ReportViewer = reportViewer; return(View()); }
public ActionResult Index(ParamIDandDateModel param) { var oppha_cancelledreceiptModel = _clPatientStatisticsDB.OPPHA_CancelledReceipt(param.Id, param.DateFrom, param.DateTo); //_clReportDAL.GetReportProcedureDoneListDAL(DateFrom, DateTo); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\OPPHA_CancelledReceipt.rdl"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsOPPHA_CancelledReceipt", oppha_cancelledreceiptModel)); reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsServiceType", _clPatientStatisticsDB.GetServiceTypeWhereID(param.Id.ToString()))); reportViewer.LocalReport.SetParameters(new ReportParameter("stDate", param.DateFrom)); reportViewer.LocalReport.SetParameters(new ReportParameter("enDate", param.DateTo)); reportViewer.LocalReport.SetParameters(new ReportParameter("serviceid", param.Id.ToString())); reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer); ViewBag.ReportViewer = reportViewer; return(View()); }