public dynamic SectionsExport(Filter filters, string userName) { using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString)) { #pragma warning disable CS0436 // Type conflicts with imported type SqlCommand sqlComm = DashboardHelpers.GetFiltersParameters(filters, "[GetSectionScores]", userName); #pragma warning restore CS0436 // Type conflicts with imported type sqlComm.Connection = sqlCon; List <CoachingQueue> coachingQueueLst = new List <CoachingQueue>(); List <CoachingQueueCallDetails> cqcd = new List <CoachingQueueCallDetails>(); CoachingQueueResponceData cq = new CoachingQueueResponceData(); var callShortInfo = new CallShortInfov2(); try { sqlCon.Open(); SqlDataReader reader = sqlComm.ExecuteReader(); var sectioInfoRaw = new List <SectionInfoRaw>(); try { sectioInfoRaw = SectionInfoRaw.Create(reader); } catch (Exception ex) { throw ex; } //return scorecardInfo; List <SectionsExportModel> sectionsExportModels = new List <SectionsExportModel>(); var propNames = new List <PropertieName> { new PropertieName { propName = "Scorecard Name", propValue = "scorecardName", propPosition = 1 }, new PropertieName { propName = "Section Name", propValue = "sectionName", propPosition = 2 }, new PropertieName { propName = "Question Name", propValue = "questionName", propPosition = 3 }, new PropertieName { propName = "isLinked", propValue = "isLinked", propPosition = 4 }, new PropertieName { propName = "Total Right", propValue = "totalRight", propPosition = 5 }, new PropertieName { propName = "Right Score, %", propValue = "rightScore", propPosition = 6 }, new PropertieName { propName = "Total Wrong", propValue = "totalWrong", propPosition = 7 }, new PropertieName { propName = "Wrong Score, %", propValue = "wrongScore", propPosition = 8 }, new PropertieName { propName = "Total", propValue = "total", propPosition = 9 } }; foreach (var item in sectioInfoRaw) { sectionsExportModels.Add(new SectionsExportModel { scorecardName = item.scorecardName, sectionName = item.sectionName, questionName = item.questionShortName, isLinked = item.isLinked == true ? "Yes" : "No", totalRight = item.totalRight, totalWrong = item.totalWrong, total = item.totalRight + item.totalWrong, rightScore = (item.totalRight + item.totalWrong) == 0 ? 0 : Math.Round((double)item.totalRight / (item.totalRight + item.totalWrong) * 100, 2), wrongScore = (item.totalRight + item.totalWrong) == 0 ? 0 : Math.Round((double)item.totalWrong / (item.totalRight + item.totalWrong) * 100, 2) }); } ExportHelper.Export(propNames, sectionsExportModels, "Sections" + DateTime.Now.ToString("MM-dd-yyyy") + DateTime.Now.Millisecond.ToString() + ".xlsx", "Sections", userName); return("sucess"); } catch (Exception ex) { throw ex; } } }
public dynamic CalibrationSectionExport(Filter filters, string userName) { using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString)) { SqlCommand sqlComm = DashboardHelpers.GetFiltersParameters(filters, "[GetCalibratorSectionScores]", userName); sqlComm.Connection = sqlCon; try { sqlCon.Open(); SqlDataReader reader = sqlComm.ExecuteReader(); var sectioInfoRaw = new List <SectionInfoRaw>(); while (reader.Read()) { try { sectioInfoRaw.Add(SectionInfoRaw.CreateRecord(reader)); } catch { } } List <SectionsExportModel> sectionsExportModels = new List <SectionsExportModel>(); var propNames = new List <PropertieName> { new PropertieName { propName = "Scorecard Name", propValue = "scorecardName", propPosition = 1 }, new PropertieName { propName = "Section Name", propValue = "sectionName", propPosition = 2 }, new PropertieName { propName = "Question Name", propValue = "questionName", propPosition = 3 }, new PropertieName { propName = "isLinked", propValue = "isLinked", propPosition = 4 }, new PropertieName { propName = "Total Right", propValue = "totalRight", propPosition = 5 }, new PropertieName { propName = "Right Score, %", propValue = "rightScore", propPosition = 6 }, new PropertieName { propName = "Total Wrong", propValue = "totalWrong", propPosition = 7 }, new PropertieName { propName = "Wrong Score, %", propValue = "wrongScore", propPosition = 8 }, new PropertieName { propName = "Total", propValue = "total", propPosition = 9 } }; foreach (var item in sectioInfoRaw) { // var tot = item.totalRight = item.totalWrong; sectionsExportModels.Add(new SectionsExportModel { scorecardName = item.scorecardName, sectionName = item.sectionName, questionName = item.questionShortName, isLinked = item.isLinked == true ? "Yes" : "No", totalRight = item.totalRight, totalWrong = item.totalWrong, total = item.totalRight + item.totalWrong, rightScore = (item.totalRight + item.totalWrong) == 0 ? 0 :Math.Round((double)item.totalRight / (item.totalRight + item.totalWrong) * 100, 2), wrongScore = (item.totalRight + item.totalWrong) == 0 ? 0 : Math.Round((double)item.totalWrong / (item.totalRight + item.totalWrong) * 100, 2) }); } ExportHelper.Export(propNames, sectionsExportModels, "CalibrationSection" + DateTime.Now.ToString("MM-dd-yyyy") + DateTime.Now.Second.ToString() + ".xlsx", "CalibrationSection", userName); return("sucess"); } catch (Exception ex) { throw ex; } } }