Exemple #1
0
        public ActionResult Index()
        {
            DeficiencyFilesPINWiseModel m = new DeficiencyFilesPINWiseModel();
            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()
                });
            }
            m.YearOptions      = yeardate;
            m.StartDate        = DateTime.Now.ToString("MM/dd/yyyy");
            m.EndDate          = DateTime.Now.ToString("MM/dd/yyyy");
            m.IncludeStandards = true;
            m.Speciality       = "0";
            m.Doctor           = "0";
            m.PIN = "0";

            return(View(m));
        }
Exemple #2
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));
        }