public PartialViewResult _GetEPScoringReportFinalMockSurveyRDLCData(SearchEPScoringReportFinalMockSurveyParams search, Email emailInput, string ReportType = "Summary") { ReportViewer reportViewer = new ReportViewer(); try { if (String.IsNullOrEmpty(search.ScoreValueList)) { search.ScoreValueList = ""; } var findingsService = new EPScoringReportFinalMockSurvey(); if (emailInput.To != null) { ViewBag.FromEmail = true; ViewBag.FromEmailSuccess = WebConstants.Email_Success; } reportViewer = findingsService.EPScoringReportFinalMockSurveyRDLC(search, emailInput, ReportType); if (Session["EmailSuccess"] != null) { if (Session["EmailSuccess"].ToString() == "false") { ViewBag.FromEmailSuccess = WebConstants.Email_Failed; } } } catch (Exception ex) { if (ex.Message.ToString() != "Email") { if (ex.Message.ToString() == "No Data") { ModelState.AddModelError("Error", WebConstants.NO_DATA_FOUND_RDLC_VIEW_TSR); } } else { ViewBag.FromEmail = true; ModelState.AddModelError("Error", WebConstants.Email_Failed); } } finally { if (Session["EmailSuccess"] != null) { Session.Remove("EmailSuccess"); } } Session["MyReportViewer"] = reportViewer; return(PartialView("_ReportViewer")); }
public ActionResult _GetEPScoringReportFinalMockSurveyExcelData(SearchEPScoringReportFinalMockSurveyParams search) { JsonResult jr = new JsonResult(); List <EPScoringReportFinalMockSurveyExcel> EpExcelData = new List <EPScoringReportFinalMockSurveyExcel>(); try { if (String.IsNullOrEmpty(search.ScoreValueList)) { search.ScoreValueList = ""; } var findingsService = new EPScoringReportFinalMockSurvey(); EpExcelData = findingsService.GetEPScoringReportFinalMockSurveyExcel(search); jr = Json(EpExcelData, JsonRequestBehavior.AllowGet); jr.MaxJsonLength = Int32.MaxValue; jr.RecursionLimit = 100; return(jr); } catch (Exception ex) { if (ex.Message.ToString() == "No Data") { jr = Json(EpExcelData, JsonRequestBehavior.AllowGet); return(jr); } else { ExceptionLog exceptionLog = new ExceptionLog { ExceptionText = "Reports: " + ex.Message, PageName = "EPScoringReportFinalMockSurvey", MethodName = "_GetEPScoringReportFinalMockSurveyExcelData", UserID = Convert.ToInt32(AppSession.UserID), SiteId = Convert.ToInt32(AppSession.SelectedSiteId), TransSQL = "", HttpReferrer = null }; exceptionService.LogException(exceptionLog); return(RedirectToAction("Error", "Transfer")); } } }
private DataSet GetReportDataView(SearchEPScoringReportFinalMockSurveyParams searchParams, string reportType = "Summary") { DataSet ds = new DataSet(); try { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { cn.Open(); string spname = string.Empty; if (reportType == "Summary") { spname = "amp.usmReportEPScoringReportFinalMockSurveySummary"; } else if (reportType == "Detail") { spname = "amp.usmReportEPScoringReportFinalMockSurveyDetail"; } else { spname = "amp.usmReportEPScoringReportFinalMockSurveyExcel"; } SqlCommand cmd = new SqlCommand(spname, cn); cmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["SPCmdTimeout"].ToString()); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("SiteID", searchParams.SiteID); cmd.Parameters.AddWithValue("ProgramID", searchParams.ProgramID); if (searchParams.ChapterList == "-1") { cmd.Parameters.AddWithValue("ChapterList", null); } else { cmd.Parameters.AddWithValue("ChapterList", searchParams.ChapterList); } if (searchParams.StandardList == "-1") { cmd.Parameters.AddWithValue("StandardList", null); } else { cmd.Parameters.AddWithValue("StandardList", searchParams.StandardList); } cmd.Parameters.AddWithValue("ScoreTypeList", searchParams.ScoreTypeList); cmd.Parameters.AddWithValue("ScoreValueList", searchParams.ScoreValueList); if (searchParams.ScoredByList == "-1") { cmd.Parameters.AddWithValue("ScoredByList", null); } else { cmd.Parameters.AddWithValue("ScoredByList", searchParams.ScoredByList); } if (searchParams.MockSurveyIDList == "-1") { cmd.Parameters.AddWithValue("MockSurveyIDList", null); } else { cmd.Parameters.AddWithValue("MockSurveyIDList", searchParams.MockSurveyIDList); } //Mock Survey Status Variable. Corporate Reports displays data after Mock Survey Recommendations are approved. var MockSurveyStatusID = (int)MockSurveyStatus.Publish_CCA_Recommendation; cmd.Parameters.AddWithValue("MockSurveyStatusID", MockSurveyStatusID); cmd.Parameters.AddWithValue("IncludeFSA", searchParams.FSA); cmd.Parameters.AddWithValue("DocRequired", searchParams.DocRequiredValue); cmd.Parameters.AddWithValue("NewChangedEPs", searchParams.NewChangedEPs); cmd.Parameters.AddWithValue("PlanOfAction", searchParams.PlanOfAction); cmd.Parameters.AddWithValue("OrgFindings", searchParams.OrgFindings); cmd.Parameters.AddWithValue("OrgNotes", searchParams.OrgNotes); cmd.Parameters.AddWithValue("LinkedDocs", searchParams.LinkedDocs); cmd.Parameters.AddWithValue("MockSurveyFindings", searchParams.MockSurveyFindings); cmd.Parameters.AddWithValue("MockSurveyRecommendations", searchParams.MockSurveyRecommendations); cmd.Parameters.AddWithValue("@DateStart", searchParams.DateStart); cmd.Parameters.AddWithValue("@DateEnd", searchParams.DateEnd); cmd.Parameters.AddWithValue("@StandardEffBeginDate", null); cmd.Parameters.AddWithValue("@CertificationItemID", null); if (reportType == "Detail" || reportType == "Excel") { cmd.Parameters.AddWithValue("IncludeCMS", searchParams.chkIncludeCMS); } #if DEBUG CreateSQLExecuted(spname, cmd); System.Diagnostics.Debug.WriteLine(_SQLExecuted); #endif SqlDataAdapter da = new SqlDataAdapter(cmd); using (cn) using (cmd) using (da) { da.Fill(ds); } } } catch (Exception ex) { ex.Data.Add(TSQL, _SQLExecuted); throw ex; } int rowsCount = ds.Tables[0].Rows.Count; if (rowsCount == 0) { throw (new Exception("No Data")); } return(ds); }
public List <EPScoringReportFinalMockSurveyExcel> GetEPScoringReportFinalMockSurveyExcel(SearchEPScoringReportFinalMockSurveyParams search) { var GetEPScoringReportFinalMockSurveyData = new List <EPScoringReportFinalMockSurveyExcel>(); GetEPScoringReportFinalMockSurveyData = GetReportDataView(search, "Excel").Tables[0].ToList <EPScoringReportFinalMockSurveyExcel>(); GetEPScoringReportFinalMockSurveyData.ForEach(a => a.CoPHTML = string.IsNullOrEmpty(a.CoPHTML) == false ? a.CoPHTML.Replace("<", "<").Replace(">", ">") : null); GetEPScoringReportFinalMockSurveyData.ForEach(a => a.CoPExcel = string.IsNullOrEmpty(a.CoPExcel) == false ? a.CoPExcel.Trim().TrimEnd(';') : null); return(GetEPScoringReportFinalMockSurveyData); }
public ReportViewer EPScoringReportFinalMockSurveyRDLC(SearchEPScoringReportFinalMockSurveyParams searchParams, Email emailInput, string reportType = "Summary") { DateTime?startDate = null; DateTime?endDate = null; string reportDate = "All Dates"; SearchFormat searchoutput = new SearchFormat(); if (searchParams.DateStart != null) { startDate = searchParams.DateStart; if (searchParams.DateEnd != null) { reportDate = searchParams.DateStart.Value.ToShortDateString() + " - " + searchParams.DateEnd.Value.ToShortDateString(); } else { reportDate = "since " + searchParams.DateStart.Value.ToShortDateString(); } } if (searchParams.DateEnd != null) { endDate = searchParams.DateEnd.Value.Date.AddHours(23).AddMinutes(59).AddSeconds(59); if (searchParams.DateStart == null) { reportDate = "through " + searchParams.DateEnd.Value.ToShortDateString(); } } ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.SizeToReportContent = true; try { if (AppSession.ReportScheduleID > 0 && searchParams.ReportTitle != null) { searchParams.ReportTitle = String.Concat(searchParams.ReportTitle, " - Report ID: ", AppSession.ReportScheduleID); } else { string reportTitle = WebConstants.AMP_EP_SCORING_REPORT_FINAL; if (searchParams.IsCorporateAccess == true) { reportTitle = WebConstants.AMP_EP_SCORING_REPORT_FINAL_AND_MOCK_SURVEY; } if (reportType == "Summary") { searchParams.ReportTitle = reportTitle + " - Summary"; } else { searchParams.ReportTitle = reportTitle + " - Detail"; } } string rdlcfilename = string.Empty; string dsName = string.Empty; if (reportType == "Summary") { rdlcfilename = "rptEP_Scoring_Report_Final_Mock_Survey_Summary.rdlc"; dsName = "dsEPScoringReportFinalMockSurveySummaryView"; } else { rdlcfilename = "rptEP_Scoring_Report_Final_Mock_Survey_Detail.rdlc"; dsName = "dsEPScoringReportFinalMockSurveyDetail"; } DataView dvReportResultForEPScoring = new DataView(GetReportDataView(searchParams, reportType).Tables[0]); reportViewer.LocalReport.DisplayName = searchParams.ReportTitle; reportViewer.LocalReport.ReportPath = HttpContext.Current.Request.MapPath(HttpContext.Current.Request.ApplicationPath) + @"Areas\Corporate\Reports\" + rdlcfilename; if (searchParams.ScoreTypeList.Contains("4"))//for Mock Survey score Type { reportViewer.LocalReport.DataSources.Add(new ReportDataSource(dsName, dvReportResultForEPScoring)); reportViewer.LocalReport.DataSources.Add(new ReportDataSource(dsName + "_Final", new DataView())); } else { reportViewer.LocalReport.DataSources.Add(new ReportDataSource(dsName, new DataView())); reportViewer.LocalReport.DataSources.Add(new ReportDataSource(dsName + "_Final", dvReportResultForEPScoring)); } string filterBy = string.Empty; if (searchParams.FSA == 1) { filterBy = "\nInclude FSA Eps"; } if (searchParams.DocRequiredValue == 1) { filterBy += "\nDocumentation Required"; } if (searchParams.NewChangedEPs == 1) { filterBy += "\nNew Eps"; } searchParams.ScoreTypeNameList = string.Empty; if (searchParams.ScoreTypeList.Contains("3")) { searchParams.ScoreTypeNameList = "Final, "; } if (searchParams.ScoreTypeList.Contains("4")) { searchParams.ScoreTypeNameList += "Mock Survey"; } searchParams.ScoreValueNameList = string.Empty; if (searchParams.ScoreValueList.Contains("2")) { searchParams.ScoreValueNameList = "Satisfactory, "; } if (searchParams.ScoreValueList.Contains("0")) { searchParams.ScoreValueNameList += "Insufficient, "; } if (searchParams.ScoreValueList.Contains("6")) { searchParams.ScoreValueNameList += "Not Applicable, "; } if (searchParams.ScoreValueList.Contains("99")) { searchParams.ScoreValueNameList += "Not Scored"; } ReportParameter p1 = new ReportParameter("ReportTitle", searchParams.ReportTitle); ReportParameter p2 = new ReportParameter("Copyright", "© " + DateTime.Now.Year.ToString() + WebConstants.Copyright.ToString()); ReportParameter p3 = new ReportParameter("ProgramName", searchParams.ProgramName); ReportParameter p4 = new ReportParameter("SiteName", searchParams.SiteName); ReportParameter p5 = new ReportParameter("ReportDateTitle", DateTime.Now.ToString()); ReportParameter p6 = new ReportParameter("ChapterNameList", searchParams.ChapterNameList); ReportParameter p7 = new ReportParameter("StandardNameList", searchParams.StandardNameList); ReportParameter p9 = new ReportParameter("ScoreDateRange", reportDate); ReportParameter p11 = new ReportParameter("ScoreTypeNameList", Regex.Replace(searchParams.ScoreTypeNameList, ", $", "")); ReportParameter p12 = new ReportParameter("FilterByList", filterBy == "" ? "None" : filterBy); string DocumentationList = string.Empty; if (searchParams.IsCorporateAccess && searchParams.ScoreTypeList.Contains("4")) { if (searchParams.MockSurveyFindings == 1) { DocumentationList = DocumentationList + "All Mock Survey Findings\n"; } else if (searchParams.MockSurveyFindings == 2) { DocumentationList = DocumentationList + "Presence of Mock Survey Findings\n"; } else if (searchParams.MockSurveyFindings == 3) { DocumentationList = DocumentationList + "Absence of Mock Survey Findings"; } if (searchParams.MockSurveyRecommendations == 1) { DocumentationList = DocumentationList + "All Mock Survey Recommendations\n"; } else if (searchParams.MockSurveyRecommendations == 2) { DocumentationList = DocumentationList + "Presence of Mock Survey Recommendations\n"; } else if (searchParams.MockSurveyRecommendations == 3) { DocumentationList = DocumentationList + "Absence of Mock Survey Recommendations"; } } if (searchParams.OrgFindings == 1) { DocumentationList += "All Organizational Findings\n"; } else if (searchParams.OrgFindings == 2) { DocumentationList += "Presence of Organizational Findings\n"; } else if (searchParams.OrgFindings == 3) { DocumentationList += "Absence of Organizational Findings\n"; } if (searchParams.PlanOfAction == 1) { DocumentationList = DocumentationList + "All Plan of Action\n"; } else if (searchParams.PlanOfAction == 2) { DocumentationList = DocumentationList + "Presence of Plan of Action\n"; } else if (searchParams.PlanOfAction == 3) { DocumentationList = DocumentationList + "Absence of Plan of Action\n"; } if (searchParams.OrgNotes == 1) { DocumentationList = DocumentationList + "All Internal Notes\n"; } else if (searchParams.OrgNotes == 2) { DocumentationList = DocumentationList + "Presence of Internal Notes\n"; } else if (searchParams.OrgNotes == 3) { DocumentationList = DocumentationList + "Absence of Internal Notes\n"; } if (searchParams.LinkedDocs == 1) { DocumentationList = DocumentationList + "All Linked Documents\n"; } else if (searchParams.LinkedDocs == 2) { DocumentationList = DocumentationList + "Presence of Linked Documents\n"; } else if (searchParams.LinkedDocs == 3) { DocumentationList = DocumentationList + "Absence of Linked Documents"; } ReportParameter p13 = new ReportParameter("DocumentationList", DocumentationList); ReportParameter p15 = new ReportParameter("ProgramID", searchParams.ProgramID.ToString()); ReportParameter p16 = new ReportParameter("IncludeCMS", searchParams.chkIncludeCMS.ToString()); ReportParameterCollection reportParameterCollection = new ReportParameterCollection { p1, p2, p3, p4, p5, p6, p7, p9, p11, p12, p13, p15, p16 }; reportParameterCollection.Add(new ReportParameter("ScoreValueNameList", searchParams.ScoreValueNameList)); reportParameterCollection.Add(new ReportParameter("ScoreType", searchParams.ScoreTypeList.Contains('4') == true ? "4" : "3")); reportParameterCollection.Add(new ReportParameter("MockSurveyNameList", searchParams.MockSurveyNameList)); reportParameterCollection.Add(new ReportParameter("ScoredByNameList", searchParams.ScoredByNameList)); reportViewer.LocalReport.SetParameters(reportParameterCollection); if (emailInput.To != null) { CommonService emailService = new CommonService(); int actionTypeId = (int)ActionTypeEnum.EPAssignmentReport; if (emailService.SendReportEmail(emailInput, actionTypeId, emailService.SetRdlcEmail(reportViewer))) { HttpContext.Current.Session["EmailSuccess"] = "true"; } else { HttpContext.Current.Session["EmailSuccess"] = "false"; } } } catch (Exception ex) { if (ex.Message.ToString() != "No Data") { ExceptionLog exceptionLog = new ExceptionLog { ExceptionText = "Reports: " + ex.Message + ";" + ex.InnerException.Message, PageName = "EPScoringReportFinalMockSurveySummary", MethodName = "EPScoringReportFinalMockSurveySummaryRDLC", UserID = Convert.ToInt32(AppSession.UserID), SiteId = Convert.ToInt32(AppSession.SelectedSiteId), TransSQL = "", HttpReferrer = null }; _exceptionService.LogException(exceptionLog); } throw ex; } return(reportViewer); }