public static AnalysisDetail GetAnalysisDetail(int riskId)
{
AnalysisDetail analysisDetail = new AnalysisDetail();
try
{
analysisDetail = AnalysisDetailDAO.getInstance().GetAnalysisDetail(riskId);
}
catch (Exception ex)
{
analysisDetail = new AnalysisDetail();
}
return(analysisDetail);
}
public AnalysisDetail GetAnalysisDetail(int riskId)
{
AnalysisDetail analysisDetail = null;
SqlConnection con = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
try
{
con = Conexion.getInstance().ConexionBD();
cmd = new SqlCommand("dbo.USP_DETAIL_GET", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_RISK_ID", riskId);
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
analysisDetail = new AnalysisDetail();
analysisDetail.ANALYSIS_DETAIL_ID = Convert.ToInt16(dr["ANALYSIS_DETAIL_ID"].ToString());
analysisDetail.IMPACT = Convert.ToInt16(dr["IMPACT"].ToString());
analysisDetail.IMPACT_DESCRIPTION = analysisDetail.IMPACT == 1 ? "Menor" : analysisDetail.IMPACT == 2 ? "Moderado" : analysisDetail.IMPACT == 3?"Mayor":"Catastrófico";
analysisDetail.PROBABILITY = Convert.ToInt16(dr["PROBABILITY"].ToString());
analysisDetail.PROBABILITY_DESCRIPTION = analysisDetail.PROBABILITY == 1 ? "Excepcional" : analysisDetail.PROBABILITY == 2 ? "Poco frecuente" :analysisDetail.PROBABILITY == 3 ? "Frecuente" : "Muy frecuente";
analysisDetail.SEVERIDAD = dr["RISK_TYPE"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
return(analysisDetail);
}
public static string ToPdf(int projectId) //Este se acerca más
{
#region html
Project project = ProjectDAO.getInstance().GetProjectByCode(projectId);
List <Risk> listRisk = RiskDAO.getInstance().ListRisks(projectId);
string htmlString = "<table style=\"width: 100%; border: groove;\">" +
"<tr style=\"height: 100px;\">" +
" <th>" +
"<img src=\"imgPronet/logo.png\" style=\"width:200px;\"/>" +
"</th>" +
"<th>SISTEMA DE GESTIÓN DE RIESGOS DE PROYECTO</th>" +
"<th>Código: PRT - SGRP - 2017 </th>" +
"</tr> " +
"</table>";
htmlString +=
"<h2 align=\"center\">Proyecto " + project.PROCESS_NAME + "</h2>" +
"<h3>Riesgos:</h3>" +
"<form style=\"padding: 10px; \">"
;
foreach (Risk risk in listRisk)
{
htmlString += "<ul>" +
" <li>";
htmlString += "<label>" + risk.RISK_NAME + "</label></br>";
htmlString += "<label>" + "Tipo: " + risk.RISK_TYPE_NAME + "</label></br>";
htmlString += "<label>" + "Estado: " + risk.STATUS_DESCRIPTION + "</label></br>";
htmlString += "<div style=\"border-style:groove; padding: 10px\">";
List <Cause> listCauses = CauseDAO.getInstance().ListCauses(risk.RISK_ID);
if (listCauses.Count > 0)
{
htmlString +=
"<label>Identificar: </label>" +
"<div style=\"border-style:groove; padding: 10px;\">" +
"<label>Causas: </label>" +
"<ul>";
foreach (Cause cause in listCauses)
{
htmlString +=
" <li>" +
" <label>" + cause.CAUSE_DESCRIPTION + "</label>" +
" <br />" +
" <label>" + "Tipo: " + cause.CAUSE_TYPE_NAME + "</label>" +
" <br />" +
" <label>" + "Porcentaje: " + cause.CAUSE_PERCENT + "%</label>";
List <Effect> listEffect = EffectDAO.getInstance().ListEffects(cause.CAUSE_ID);
if (listEffect.Count > 0)
{
htmlString += " <br />" +
" <strong><label>Consecuencias: </label></strong>" +
" <ul>";
foreach (Effect effect in listEffect)
{
htmlString += " <li> " +
" <label>" + effect.DESCRIPTION + "</label>" +
" </li>";
}
htmlString += "</ul>";
}
htmlString += "</li>";
}
htmlString += " </ul>";
htmlString += "</div>";
}
//htmlString+= "</div>";
AnalysisDetail analysisDetail = AnalysisDetailDAO.getInstance().GetAnalysisDetail(risk.RISK_ID);
if (analysisDetail != null)
{
htmlString +=
"<label>Detalle de Análisis: </label>" +
"<div style=\"border-style:groove; padding: 10px;\">";
htmlString += "<label>Impacto: " + analysisDetail.IMPACT_DESCRIPTION + " </label></br>";
htmlString += "<label>Probabilidad: " + analysisDetail.PROBABILITY_DESCRIPTION + " </label></br>";
htmlString += "<label>Severidad: " + analysisDetail.SEVERIDAD + " </label>";
htmlString += "</div>";
}
Treatment treatment = TreatmentDAO.getInstance().GetTreatment(risk.RISK_ID);
if (treatment != null)
{
htmlString +=
"<label>Tratamiento: </label>" +
"<div style=\"border-style:groove; padding: 10px;\">";
htmlString += "<label>Control: " + treatment.CONTROL_NAME + " </label></br>";
htmlString += "<label>Persona encargada: " + treatment.PERSON_IN_CHARGE + " </label></br>";
htmlString += "<label>Descripción: " + treatment.TREATMENT_DESCRIPTION + " </label></br>";
htmlString += "<label>Respuesta al riesgo: " + treatment.RISK_RESPONSE_DESCRIPTION + " </label>";
htmlString += "</div>";
if (treatment.DATE_IMPLEMENTATION != null)
{
htmlString +=
"<label>Implementación: </label>" +
"<div style=\"border-style:groove; padding: 10px;\">";
htmlString += "<label>Fecha: " + treatment.DATE_IMPLEMENTATION.ToString("dd/MM/yyyy") + " </label></br>";
htmlString += "</div>";
}
//htmlString += "</div>";
}
htmlString += "</div>";
htmlString += "</li>";
//fin del riesgo
htmlString += "</ul>";
}
htmlString += "</form>";
#endregion
return(htmlString);
}
public override async Task Execute(params object[] args)
{
using (one = new OneNote())
{
(backupPath, defaultPath, _) = one.GetFolders();
if (!Directory.Exists(backupPath))
{
UIHelper.ShowError(owner, Resx.AnalyzeCommand_NoBackups);
return;
}
using (var dialog = new AnalyzeDialog())
{
if (dialog.ShowDialog(owner) != DialogResult.OK)
{
return;
}
showNotebookSummary = dialog.IncludeNotebookSummary;
showSectionSummary = dialog.IncludeSectionSummary;
pageDetail = dialog.Detail;
thumbnailSize = dialog.ThumbnailSize;
}
one.CreatePage(one.CurrentSectionId, out var pageId);
var page = one.GetPage(pageId);
page.Title = Resx.AnalyzeCommand_Title;
page.SetMeta(MetaNames.AnalysisReport, "true");
ns = page.Namespace;
PageNamespace.Set(ns);
heading1Index = page.GetQuickStyle(Styles.StandardStyles.Heading1).Index;
heading2Index = page.GetQuickStyle(Styles.StandardStyles.Heading2).Index;
using (progress = new UI.ProgressDialog())
{
progress.SetMaximum(5);
progress.Show(owner);
var container = page.EnsureContentContainer();
var notebooks = await one.GetNotebooks();
var prev = false;
if (showNotebookSummary)
{
ReportNotebooks(container, notebooks);
ReportOrphans(container, notebooks);
ReportCache(container);
prev = true;
}
if (showSectionSummary)
{
if (prev)
{
WriteHorizontalLine(page, container);
}
await ReportSections(container, notebooks);
prev = true;
}
if (pageDetail == AnalysisDetail.Current)
{
if (prev)
{
WriteHorizontalLine(page, container);
}
ReportPages(container, one.GetSection(), null, pageId);
}
else if (pageDetail == AnalysisDetail.All)
{
if (prev)
{
WriteHorizontalLine(page, container);
}
ReportAllPages(container, await one.GetNotebook(), null, pageId);
}
progress.SetMessage("Updating report...");
await one.Update(page);
}
await one.NavigateTo(pageId);
}
}
