public IHttpActionResult GetDisciplineStats()
{
var risks = db.RegisterEntries;
var results = risks.GroupBy(x => x.DisciplineId);
List <GrapghItem> grapghItems = new List <GrapghItem>();
foreach (var item in results)
{
var riskStatus = db.DisciplineList.Find(item.Key);
GrapghItem grapgh = new GrapghItem()
{
Title = riskStatus.Code,
Value = item.Count().ToString(),
Percentage = (item.Count() * 100 / risks.Count()).ToString() + "%",
Color = string.Empty,
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL && x.DisciplineId == item.Key).Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM && x.DisciplineId == item.Key).Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH && x.DisciplineId == item.Key).Count()
};
grapghItems.Add(grapgh);
}
return(Ok(grapghItems));
}
public IHttpActionResult GetRiskHeatMap()
{
GrapghItem grapgh1 = new GrapghItem()
{
Title = "Active1",
Value = "20",
Color = "red",
CssClass = ""
};
GrapghItem grapgh2 = new GrapghItem()
{
Title = "Continue1",
Value = "30",
Color = "red",
CssClass = ""
};
GrapghItem grapgh3 = new GrapghItem()
{
Title = "Resolved1",
Value = "20",
Color = "red",
CssClass = ""
};
List <GrapghItem> grapghItems = new List <GrapghItem>();
grapghItems.Add(grapgh1);
grapghItems.Add(grapgh2);
grapghItems.Add(grapgh3);
return(Ok(grapghItems));
}
public IHttpActionResult GetRiskRatingBreakDown()
{
var risks = db.RegisterEntries;
var results = risks.GroupBy(x => x.RiskScoreIdUm);
List <GrapghItem> grapghItems = new List <GrapghItem>();
foreach (var item in results)
{
var riskStatus = db.RiskScores.Find(item.Key);
GrapghItem grapgh = new GrapghItem()
{
Title = riskStatus.Name,
Value = item.Count().ToString(),
Percentage = (item.Count() * 100 / risks.Count()).ToString() + "%",
Color = GetColour(riskStatus.Code),
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL).Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM).Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH).Count()
};
grapghItems.Add(grapgh);
}
return(Ok(grapghItems));
}
public IHttpActionResult GetCards()
{
var risks = db.RegisterEntries;
List <GrapghItem> grapghItems = new List <GrapghItem>();
int hCount = risks.Where(x => x.HAndSRisk == "H").Count();
int eCount = risks.Where(x => x.EnvironmentalRisk == "E").Count();
int pCount = risks.Where(x => x.ProgrammeRisk == "P").Count();
int oCount = risks.Where(x => x.OtherRisk == "O").Count();
GrapghItem grapghT = new GrapghItem()
{
Title = "# of Risks",
Value = risks.Count().ToString(),
Percentage = "%",
Color = "#FE8D89",
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL).Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM).Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH).Count()
};
GrapghItem grapghH = new GrapghItem()
{
Title = "Health & Safety Risks",
Value = hCount.ToString(),
Percentage = (hCount * 100 / risks.Count()).ToString() + "%",
Color = "#3FA8D7",
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL && x.HAndSRisk == "H").Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM && x.HAndSRisk == "H").Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH && x.HAndSRisk == "H").Count()
};
GrapghItem grapghE = new GrapghItem()
{
Title = "Environmental Risks",
Value = eCount.ToString(),
Percentage = (eCount * 100 / risks.Count()).ToString() + "%",
Color = "#7CBA4B",
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL && x.EnvironmentalRisk == "E").Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM && x.EnvironmentalRisk == "E").Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH && x.EnvironmentalRisk == "E").Count()
};
GrapghItem grapghP = new GrapghItem()
{
Title = "Programme Risks",
Value = pCount.ToString(),
Percentage = (pCount * 100 / risks.Count()).ToString() + "%",
Color = "#7C509B",
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL && x.ProgrammeRisk == "P").Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM && x.ProgrammeRisk == "P").Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH && x.ProgrammeRisk == "P").Count()
};
GrapghItem grapghO = new GrapghItem()
{
Title = "Other Risks",
Value = oCount.ToString(),
Percentage = (oCount * 100 / risks.Count()).ToString() + "%",
Color = "#757479",
CssClass = "",
Low = risks.Where(x => x.RiskScoreIdM == riskL && x.OtherRisk == "O").Count(),
Medium = risks.Where(x => x.RiskScoreIdM == riskM && x.OtherRisk == "O").Count(),
High = risks.Where(x => x.RiskScoreIdM == riskH && x.OtherRisk == "O").Count()
};
grapghItems.Add(grapghT);
grapghItems.Add(grapghE);
grapghItems.Add(grapghO);
grapghItems.Add(grapghH);
grapghItems.Add(grapghP);
return(Ok(grapghItems));
}
