Exemplo n.º 1
0
        public ActionResult Index(DeficiencyFilesPINWiseModel param)
        {
            ReportViewer reportViewer = new ReportViewer();

            reportViewer.ProcessingMode = ProcessingMode.Local;
            var deficiencypinwiseModel = new System.Data.DataTable();

            List <DeficiencyFilesPINWiseModel.YearDate> yeardate = new List <DeficiencyFilesPINWiseModel.YearDate>();
            DateTime yearToday = DateTime.Now;

            for (int i = 2006; i <= yearToday.Year; i++)
            {
                yeardate.Add(new DeficiencyFilesPINWiseModel.YearDate {
                    Id = i, Value = i.ToString()
                });
            }
            param.YearOptions = yeardate;

            if (!param.IncludeParameter)
            {
                if (param.PIN == "0")
                {
                    if (param.ExcludeAdmission)
                    {
                        deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWiseAll(param.StartDate, param.EndDate, param.ExcludeAdmission);

                        reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWise.rdl";
                        reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                        reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                    }
                    else
                    {
                        deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWiseAll(param.StartDate, param.EndDate, param.ExcludeAdmission);

                        reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWise.rdl";
                        reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                        reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                    }
                }
                else
                {
                    if (param.ExcludeAdmission)
                    {
                        deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWise(param.StartDate, param.EndDate, param.PIN, param.ExcludeAdmission);

                        reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWise.rdl";
                        reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                        reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                    }
                    else
                    {
                        deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWise(param.StartDate, param.EndDate, param.PIN, param.ExcludeAdmission);

                        reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWise.rdl";
                        reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                        reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                    }
                }
            }
            else
            {
                if ((param.Speciality != "0") && (param.Doctor == "0"))
                {
                    deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWiseComparisonAll(param.ExcludeAdmission, param.MonthFromDate, param.YearFromDate, param.MonthToDate, param.YearToDate, param.Standard, param.Speciality, param.Doctor);

                    reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWiseComparison.rdl";
                    reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                    reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                }
                else if ((param.Speciality != "0") && (param.Doctor != "0"))
                {
                    deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWiseComparison(param.ExcludeAdmission, param.MonthFromDate, param.YearFromDate, param.MonthToDate, param.YearToDate, param.Doctor, param.Standard);

                    reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWiseComparison.rdl";
                    reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                    reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                }
                else
                {
                    deficiencypinwiseModel = _clPatientStatisticsDB.DeficiencyPINWiseComparisonSpeciality(param.ExcludeAdmission, param.MonthFromDate, param.YearFromDate, param.MonthToDate, param.YearToDate, param.Standard);

                    reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\PatientStatistics\DeficiencyPINWiseComparison.rdl";
                    reportViewer.LocalReport.SetParameters(new ReportParameter("StartDate", param.StartDate));
                    reportViewer.LocalReport.SetParameters(new ReportParameter("EndDate", param.EndDate));
                }
            }

            reportViewer.LocalReport.DataSources.Add(new ReportDataSource("dsDeficiencyPINWise", deficiencypinwiseModel));
            reportViewer.LocalReport.DisplayName = base.SaveFilestreamtoPDF(reportViewer);
            ViewBag.ReportViewer = reportViewer;

            return(View(param));
        }