コード例 #1
0
ファイル: TopTenRiskController.cs プロジェクト: ryanask/MRK
        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;
        }
コード例 #2
0
ファイル: TopTenRiskController.cs プロジェクト: ryanask/MRK
 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);
 }
コード例 #3
0
ファイル: TopTenRiskController.cs プロジェクト: ryanask/MRK
 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);
 }
コード例 #4
0
ファイル: TopTenRiskController.cs プロジェクト: ryanask/MRK
        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();
        }