public RiskMatrixDTO GetAnalysisRiskMatrix() { RiskMatrixDTO result = new RiskMatrixDTO(); try { result = _riskAnalysisService.GetAnalysisRiskMatrix(); _logger.LogDebug("Result returned"); } catch (Exception exception) { _logger.LogError(exception, ""); } return(result); }
public RiskMatrixDTO GetAnalysisRiskMatrix() { RiskMatrixDTO riskMatrix = new RiskMatrixDTO(); List <RiskLineChartDTO> list = (from p in _unitOfWork.RiskAnalysis.FindAll() group p by new { p.COF, p.AnalysisPOF } into g select new RiskLineChartDTO { Failure = g.Key.COF + g.Key.AnalysisPOF.Value.ToString(), Count = g.Count() }) .ToList(); foreach (RiskLineChartDTO item in list) { switch (item.Failure) { case "A1": riskMatrix.A1 = item.Count; break; case "A2": riskMatrix.A2 = item.Count; break; case "A3": riskMatrix.A3 = item.Count; break; case "A4": riskMatrix.A4 = item.Count; break; case "A5": riskMatrix.A5 = item.Count; break; case "B1": riskMatrix.B1 = item.Count; break; case "B2": riskMatrix.B2 = item.Count; break; case "B3": riskMatrix.B3 = item.Count; break; case "B4": riskMatrix.B4 = item.Count; break; case "B5": riskMatrix.B5 = item.Count; break; case "C1": riskMatrix.C1 = item.Count; break; case "C2": riskMatrix.C2 = item.Count; break; case "C3": riskMatrix.C3 = item.Count; break; case "C4": riskMatrix.C4 = item.Count; break; case "C5": riskMatrix.C5 = item.Count; break; case "D1": riskMatrix.D1 = item.Count; break; case "D2": riskMatrix.D2 = item.Count; break; case "D3": riskMatrix.D3 = item.Count; break; case "D4": riskMatrix.D4 = item.Count; break; case "D5": riskMatrix.D5 = item.Count; break; case "E1": riskMatrix.E1 = item.Count; break; case "E2": riskMatrix.E2 = item.Count; break; case "E3": riskMatrix.E3 = item.Count; break; case "E4": riskMatrix.E4 = item.Count; break; case "E5": riskMatrix.E5 = item.Count; break; } } return(riskMatrix); }
public RiskMatrixDTO GetCurrentRiskMatrix(RiskAnalysisFilterDTO filter) { string PlantCode = ""; string ParentPlantCode = ""; string FluidCode = ""; string Priority = ""; RiskMatrixDTO riskMatrix = new RiskMatrixDTO(); //IQueryable<RiskAnalysis> query = (from r in _unitOfWork.RiskAnalysis.GenerateEntityAsIQueryable() // join p in _context.PipeMaster on r.EquipmentNo equals l.Code // join l in _context.Plant on p.PlantCode equals l.Code // select r); //List<RiskLineChartDTO> list = (from p in _unitOfWork.RiskAnalysis.FindAll() // group p by new // { // p.COF, // p.CurrentPOF // } into g // select new RiskLineChartDTO // { // Failure = g.Key.COF + g.Key.CurrentPOF.Value.ToString(), // Count = g.Count() // }) // .ToList(); //if (filter != null) //{ // if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.LoopNo)) // query = (from re in query // where re.LoopNo == corrosionStudyFilterDTO.LoopNo // select re); // if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.PlantCode)) // query = (from re in query // where re.PlantCode == corrosionStudyFilterDTO.PlantCode // select re); // if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.FluidCode)) // query = (from re in query // where re.FluidCode == corrosionStudyFilterDTO.FluidCode // select re); // if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.ParentPlantCode)) // query = (from re in query // where re.ParentPlantCode == corrosionStudyFilterDTO.ParentPlantCode // select re); // list = query.OrderBy(p => p.LoopNo).ToList(); //} //foreach (RiskLineChartDTO item in list) //{ // switch (item.Failure) // { // case "A1": // riskMatrix.A1 = item.Count; // break; // case "A2": // riskMatrix.A2 = item.Count; // break; // case "A3": // riskMatrix.A3 = item.Count; // break; // case "A4": // riskMatrix.A4 = item.Count; // break; // case "A5": // riskMatrix.A5 = item.Count; // break; // case "B1": // riskMatrix.B1 = item.Count; // break; // case "B2": // riskMatrix.B2 = item.Count; // break; // case "B3": // riskMatrix.B3 = item.Count; // break; // case "B4": // riskMatrix.B4 = item.Count; // break; // case "B5": // riskMatrix.B5 = item.Count; // break; // case "C1": // riskMatrix.C1 = item.Count; // break; // case "C2": // riskMatrix.C2 = item.Count; // break; // case "C3": // riskMatrix.C3 = item.Count; // break; // case "C4": // riskMatrix.C4 = item.Count; // break; // case "C5": // riskMatrix.C5 = item.Count; // break; // case "D1": // riskMatrix.D1 = item.Count; // break; // case "D2": // riskMatrix.D2 = item.Count; // break; // case "D3": // riskMatrix.D3 = item.Count; // break; // case "D4": // riskMatrix.D4 = item.Count; // break; // case "D5": // riskMatrix.D5 = item.Count; // break; // case "E1": // riskMatrix.E1 = item.Count; // break; // case "E2": // riskMatrix.E2 = item.Count; // break; // case "E3": // riskMatrix.E3 = item.Count; // break; // case "E4": // riskMatrix.E4 = item.Count; // break; // case "E5": // riskMatrix.E5 = item.Count; // break; // } //} return(riskMatrix); }