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);
}
