private static string BuildHighestRiskText(int issueId, IssuueRiskTypeId riskTypeId) { var highestRisk = GetHighestIssueRisk(issueId, riskTypeId); if (highestRisk != null) { return String.Format("{0} - {1}", highestRisk.IssueRiskMatrix.RiskRatingNumber, highestRisk.IssueRiskMatrix.IssueRiskRating.Name); } return "-"; }
private static IssueRisk GetHighestIssueRisk(int issueId, IssuueRiskTypeId riskTypeId) { //1=initial //2==final IssueRisk highestRisk = null; int highestRating = 0; using (CmsEntities cee = new CmsEntities()) { List<IssueRisk> issueRisks = Enumerable.ToList((from x in cee.IssueRisks .Include("IssueRiskMatrix") .Include("IssueRiskMatrix.IssueRiskRating") where x.IssueId == issueId && x.IssueRiskType.Id == (int)riskTypeId select x)); foreach (IssueRisk issueRisk in issueRisks) { if (issueRisk.IssueRiskMatrix.RiskRatingNumber > highestRating) { highestRating = issueRisk.IssueRiskMatrix.RiskRatingNumber; highestRisk = issueRisk; } } } return highestRisk; }
private static string BuildHighestRiskColourText(int issueId, IssuueRiskTypeId riskTypeId) { var highestRisk = GetHighestIssueRisk(issueId, riskTypeId); if (highestRisk != null) { //style="background-color:rgb(255,255,0)" return String.Format("background-color:rgb({0},{1},{2})", highestRisk.IssueRiskMatrix.IssueRiskRating.ColourRed, highestRisk.IssueRiskMatrix.IssueRiskRating.ColourGreen, highestRisk.IssueRiskMatrix.IssueRiskRating.ColourBlue); } return "-"; }
private static string BuildHighestRiskText(int issueId, IssuueRiskTypeId riskTypeId) { //1=initial //2==final IssueRisk highestRisk = null; int highestRating = 0; using (CmsEquipmentEntities cee = new CmsEquipmentEntities()) { List<IssueRisk> issueRisks = (from x in cee.IssueRisks .Include("IssueRiskMatrix") .Include("IssueRiskMatrix.IssueRiskRating") where x.IssueId == issueId && x.IssueRiskType.Id == (int)riskTypeId select x).ToList(); foreach (IssueRisk issueRisk in issueRisks) { if (issueRisk.IssueRiskMatrix.RiskRatingNumber > highestRating) { highestRating = issueRisk.IssueRiskMatrix.RiskRatingNumber; highestRisk = issueRisk; } } } if (highestRisk != null) { return String.Format("{0} - {1}", highestRating, highestRisk.IssueRiskMatrix.IssueRiskRating.Name); } return "-"; }