private void CalcTopTenRisk(TopTenViewModel vm)
{
var risks = db.Risks.Where(p => p.ProbLevelId != null && p.ImpactLevelId != null);
if (vm.Param.PosId == 1)
risks = risks.Where(p => p.DeptId != null);
else if (vm.Param.PosId == 2)
{
risks = risks.Where(p => p.BranchId != null);
if (vm.Param.BranchId != null)
risks = risks.Where(p => p.BranchId == vm.Param.BranchId);
}
if (vm.Param.IsApproved)
{
risks = risks.Where(p => p.CloseDate == null || p.CloseDate > vm.Param.ReportDate);
risks = risks.Where(p => p.ApprovalDate != null && p.ApprovalDate <= vm.Param.ReportDate);
}
else
{
risks = risks.Where(p => p.ApprovalDate == null && p.RiskDate <= vm.Param.ReportDate);
}
foreach (var r in risks)
{
//if (vm.Param.IsApproved)
//{
// var rm = db.RiskMitigations.Where(p => p.RiskId == r.RiskId && p.ApprovalDate != null && p.ApprovalDate <= vm.Param.ReportDate);
// if (rm.Count() > 0)
// {
// var m = rm.OrderByDescending(p => p.ApprovalDate).First();
// AddRiskToList(r, (int)m.ProbLevelId, (int)m.ImpactLevelId, vm.RiskList);
// }
// else
// vm.RiskList.Add(r);
//}
//else
// vm.RiskList.Add(r);
vm.RiskList.Add(r);
}
vm.RiskList = vm.RiskList.OrderByDescending(p => p.RiskLevel).ThenByDescending(p => p.ImpactLevelId).ThenByDescending(p => p.ProbLevelId).Take(10).ToList();
foreach (var r in vm.RiskList)
{
TopTenData data = new TopTenData();
data.Risk = r;
data.ApprovedMitigations = db.RiskMitigations.Where(p => p.RiskId == r.RiskId && p.ApprovalDate != null).ToList();
data.PlannedMitigations = db.RiskMitigations.Where(p => p.RiskId == r.RiskId && p.ApprovalDate == null).ToList();
vm.TopTenList.Add(data);
}
// map processing here...
for (var i = 1; i <= 5; i++)
for (var j = 1; j <= 5; j++)
vm.MapList.Add(new TopTenMap() { ProbLevelId = i, ImpactLevelId = j, Count = 0, RiskLevel = i * j });
foreach (var r in vm.RiskList)
foreach(var m in vm.MapList)
if (r.ProbLevelId == m.ProbLevelId && r.ImpactLevelId == m.ImpactLevelId)
{
m.Count++;
break;
}
vm.MaxCount = 0;
var maxCount = int.MinValue;
foreach (var m in vm.MapList)
if (maxCount < m.Count)
maxCount = m.Count;
vm.MaxCount = maxCount;
}
public ActionResult Index(bool? showMap)
{
TopTenViewModel vm = new TopTenViewModel();
vm.RiskList = new List<Risk>();
vm.TopTenList = new List<TopTenData>();
vm.MapList = new List<TopTenMap>();
vm.Param = new TopTenParam();
vm.Param.PosId = 1;
vm.Param.ReportDate = DateTime.Now;
UpdateTopTenParam(vm.Param);
CalcTopTenRisk(vm);
return View(vm);
}
public ActionResult Index(TopTenViewModel vm, bool? showMap)
{
vm.RiskList = new List<Risk>();
vm.TopTenList = new List<TopTenData>();
vm.MapList = new List<TopTenMap>();
UpdateTopTenParam(vm.Param);
CalcTopTenRisk(vm);
return View(vm);
}
public void ExportToExcel(int? posId, int? branchId, DateTime reportDate,
bool isApproved, bool showOrg, bool showRiskCode, bool showRiskDate,
bool showRiskCat, bool showRiskCause, bool showRiskEffect,
bool showRiskOwner, bool showProbLevel, bool showImpactLevel,
bool showApprovedMitigations, bool showPlannedMitigations)
{
TopTenViewModel vm = new TopTenViewModel();
vm.RiskList = new List<Risk>();
vm.TopTenList = new List<TopTenData>();
vm.MapList = new List<TopTenMap>();
vm.Param = new TopTenParam();
vm.Param.PosId = posId;
vm.Param.BranchId = branchId;
vm.Param.ReportDate = reportDate;
vm.Param.IsApproved = isApproved;
vm.Param.ShowOrg = showOrg;
vm.Param.ShowRiskCode = showRiskCode;
vm.Param.ShowRiskDate = showRiskDate;
vm.Param.ShowRiskCat = showRiskCat;
vm.Param.ShowRiskCause = showRiskCause;
vm.Param.ShowRiskEffect = showRiskEffect;
vm.Param.ShowRiskOwner = showRiskOwner;
vm.Param.ShowProbLevel = showProbLevel;
vm.Param.ShowImpactLevel = showImpactLevel;
vm.Param.ShowApprovedMitigations = showApprovedMitigations;
vm.Param.ShowPlannedMitigations = showPlannedMitigations;
CalcTopTenRisk(vm);
StringWriter sw = new StringWriter();
sw.WriteLine("<table rules='all' border='1' style='border-collapse:collapse;'>");
sw.WriteLine("<tr>");
if (vm.Param.ShowRiskCode)
{
sw.WriteLine("<th style='background-color: #eee'>Kode Risiko</th>");
}
sw.WriteLine("<th style='background-color: #eee'>Peristiwa Risiko</th>");
if (vm.Param.ShowRiskDate)
{
sw.WriteLine("<th style='background-color: #eee'>Tanggal</th>");
}
if (vm.Param.ShowOrg)
{
sw.WriteLine("<th style='background-color: #eee'>Unit Kerja</th>");
}
if (vm.Param.ShowRiskCat)
{
sw.WriteLine("<th style='background-color: #eee'>Klasifikasi Risiko</th>");
}
if (vm.Param.ShowRiskCause)
{
sw.WriteLine("<th style='background-color: #eee'>Sebab Risiko</th>");
}
if (vm.Param.ShowRiskEffect)
{
sw.WriteLine("<th style='background-color: #eee'>Akibat Risiko</th>");
}
if (vm.Param.ShowRiskOwner)
{
sw.WriteLine("<th style='background-color: #eee'>RCP</th>");
}
if (vm.Param.ShowProbLevel)
{
sw.WriteLine("<th style='background-color: #eee'>Tk. Prob</th>");
}
if (vm.Param.ShowImpactLevel)
{
sw.WriteLine("<th style='background-color: #eee'>Tk. Dampak</th>");
}
sw.WriteLine("<th style='background-color: #eee'>Tk. Risiko</th>");
if (vm.Param.ShowApprovedMitigations)
{
sw.WriteLine("<th style='background-color: #eee'>Mitigasi yg telah Di-approve</th>");
}
if (vm.Param.ShowPlannedMitigations)
{
sw.WriteLine("<th style='background-color: #eee'>Rencana Mitigasi</th>");
}
if (vm.Param.ShowRiskOwner)
{
sw.WriteLine("<th style='background-color: #eee'>tes</th>");
}
sw.WriteLine("</tr>");
foreach (var item in vm.TopTenList)
{
sw.WriteLine("<tr>");
if (vm.Param.ShowRiskCode)
{
sw.WriteLine(string.Format("<td>{0}</td>", item.Risk.RiskCode));
}
sw.WriteLine(string.Format("<td>{0}</td>", item.Risk.RiskName));
if (vm.Param.ShowRiskDate)
{
sw.WriteLine(string.Format("<td>{0:dd-MM-yyyy}</td>", item.Risk.RiskDate));
}
if (vm.Param.ShowOrg)
{
sw.WriteLine(string.Format("<td>{0}</td>", Utils.GetRiskOrgName(item.Risk)));
}
if (vm.Param.ShowRiskCat)
{
sw.WriteLine("<td>");
if (item.Risk.RiskCat != null)
{
sw.WriteLine(item.Risk.RiskCat.RiskCatName);
}
sw.WriteLine("</td>");
}
if (vm.Param.ShowRiskCause)
{
sw.WriteLine("<td>");
if (item.Risk.Cause != null)
{
sw.WriteLine(item.Risk.Cause.CauseName);
}
sw.WriteLine("</td>");
}
if (vm.Param.ShowRiskEffect)
{
sw.WriteLine("<td>");
if (item.Risk.Effect != null)
{
sw.WriteLine(item.Risk.Effect.EffectName);
}
sw.WriteLine("</td>");
}
if (vm.Param.ShowRiskOwner)
{
sw.WriteLine("<td>{0}</td>", item.Risk.UserInfo.FullName);
}
if (vm.Param.ShowProbLevel)
{
sw.WriteLine("<td align='center'>{0}</td>", item.Risk.ProbLevelId);
}
if (vm.Param.ShowImpactLevel)
{
sw.WriteLine("<td align='center'>{0}</td>", item.Risk.ImpactLevelId);
}
sw.WriteLine("<td align='center'>{0}</td>", item.Risk.RiskLevel);
if (vm.Param.ShowApprovedMitigations)
{
sw.WriteLine("<td valign='top' style='padding: 0'>");
if (item.ApprovedMitigations.Count() > 0)
{
sw.WriteLine("<table rules='all' border='1' style='border-collapse:collapse;'>");
sw.WriteLine("<tr>");
if (vm.Param.ShowRiskCode)
{
sw.WriteLine("<th style='background-color: #eee'>Kode Mitigasi</th>");
}
sw.WriteLine("<th style='background-color: #eee'>Uraian</th>");
if (vm.Param.ShowRiskDate)
{
sw.WriteLine("<th style='background-color: #eee'>Tanggal</th>");
}
if (vm.Param.ShowProbLevel)
{
sw.WriteLine("<th style='background-color: #eee'>Tk. Prob</th>");
}
if (vm.Param.ShowImpactLevel)
{
sw.WriteLine("<th style='background-color: #eee'>Tk. Dampak</th>");
}
sw.WriteLine("<th style='background-color: #eee'>Tk. Risiko</th>");
sw.WriteLine("</tr>");
foreach (var m in item.ApprovedMitigations)
{
sw.WriteLine("<tr>");
if (vm.Param.ShowRiskCode)
{
sw.WriteLine(string.Format("<td>{0}</td>", m.MitigationCode));
}
sw.WriteLine(string.Format("<td>{0}</td>", m.MitigationName));
if (vm.Param.ShowRiskDate)
{
sw.WriteLine(string.Format("<td>{0:dd-MM-yyyy}</td>", m.MitigationDate));
}
if (vm.Param.ShowProbLevel)
{
sw.WriteLine(string.Format("<td align='center'>{0}</td>", m.ProbLevelId));
}
if (vm.Param.ShowImpactLevel)
{
sw.WriteLine(string.Format("<td align='center'>{0}</td>", m.ImpactLevelId));
}
sw.WriteLine(string.Format("<td align='center'>{0}</td>", m.RiskLevel));
sw.WriteLine("</tr>");
}
sw.WriteLine("</table>");
}
sw.WriteLine("</td>");
}
if (vm.Param.ShowPlannedMitigations)
{
sw.WriteLine("<td valign='top' style='padding: 0'>");
if (item.PlannedMitigations.Count() > 0)
{
sw.WriteLine("<table rules='all' border='1' style='border-collapse:collapse;'>");
sw.WriteLine("<tr>");
if (vm.Param.ShowRiskCode)
{
sw.WriteLine("<th style='background-color: #eee'>Kode Mitigasi</th>");
}
sw.WriteLine("<th style='background-color: #eee'>Uraian</th>");
if (vm.Param.ShowRiskDate)
{
sw.WriteLine("<th style='background-color: #eee'>Tanggal</th>");
}
if (vm.Param.ShowProbLevel)
{
sw.WriteLine("<th style='background-color: #eee'>Tk. Prob</th>");
}
if (vm.Param.ShowImpactLevel)
{
sw.WriteLine("<th style='background-color: #eee'>Tk. Dampak</th>");
}
sw.WriteLine("<th style='background-color: #eee'>Tk. Risiko</th>");
sw.WriteLine("</tr>");
foreach (var m in item.PlannedMitigations)
{
sw.WriteLine("<tr>");
if (vm.Param.ShowRiskCode)
{
sw.WriteLine(string.Format("<td>{0}</td>", m.MitigationCode));
}
sw.WriteLine(string.Format("<td>{0}</td>", m.MitigationName));
if (vm.Param.ShowRiskDate)
{
sw.WriteLine(string.Format("<td>{0:dd-MM-yyyy}</td>", m.MitigationDate));
}
if (vm.Param.ShowProbLevel)
{
sw.WriteLine(string.Format("<td align='center'>{0}</td>", m.ProbLevelId));
}
if (vm.Param.ShowImpactLevel)
{
sw.WriteLine(string.Format("<td align='center'>{0}</td>", m.ImpactLevelId));
}
sw.WriteLine(string.Format("<td align='center'>{0}</td>", m.RiskLevel));
sw.WriteLine("</tr>");
}
sw.WriteLine("</table>");
}
sw.WriteLine("</td>");
}
if (vm.Param.ShowRiskOwner)
{
sw.WriteLine("<td>{0}</td>", item.Risk.UserInfo.FullName);
}
sw.WriteLine("</tr>");
}
sw.WriteLine("</table>");
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=top_ten_risks.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Write(sw.ToString());
Response.End();
}