// Constructor public findLineSectionsRiskRanking(string connectionstring) { InitializeComponent(); clbSusc.DisplayMember = "ObjectName"; clbSusc.ValueMember = "ObjectValue"; clbCons.DisplayMember = "ObjectName"; clbCons.ValueMember = "ObjectValue"; _connectionstring = connectionstring; _rrsusc = new BPSusRiskRankingValues(_connectionstring); _rrcons = new BPConRiskRankingValues(_connectionstring); if ((_rrsusc != null) && (_rrcons != null)) { LoadFormData(); } }
//----------------------------------------------------------------------------------- // Load the Risk Ranking Values //----------------------------------------------------------------------------------- private void LoadRiskRanking() { // Clear Totals _suscrisktotal = 0; _consrisktotal = 0; //........................................ // Load Susceptibility lvSusc.Columns.Clear(); lvSusc.Columns.Add("Risk Ranking Factor"); lvSusc.Columns[0].Width = 315; lvSusc.Columns.Add("Value", "Value"); lvSusc.Columns[1].Width = 50; lvSusc.Columns[1].TextAlign = HorizontalAlignment.Right; lvSusc.View = View.Details; _suscrisktotal = 0; BPSusRiskRankingValues SusRR = new BPSusRiskRankingValues(_lineid, _beginpoint, _endpoint, _connectionstring); int i; ListViewItem lvi = null; BPRiskRankingItem BBRRitem = new BPRiskRankingItem("", 0, "", ""); if (SusRR != null) { for (i = 0; i <= (SusRR.RrValues.Count - 1); i++) { lvi = new ListViewItem(); if (SusRR.RrValues.GetItem(i, ref BBRRitem)) { lvi.Text = BBRRitem.RiskRankingDesc; lvSusc.Items.Add(lvi); lvi.SubItems.Add(BBRRitem.RiskRankingValue.ToString()); _suscrisktotal = _suscrisktotal + BBRRitem.RiskRankingValue; } } // for } txtSuscTotal.Text = _suscrisktotal.ToString(); //........................................ // Load Consequences lvCons.Columns.Clear(); lvCons.Columns.Add("Risk Ranking Factor"); lvCons.Columns[0].Width = 315; lvCons.Columns.Add("Value", "Value"); lvCons.Columns[1].Width = 50; lvCons.Columns[1].TextAlign = HorizontalAlignment.Right; lvCons.View = View.Details; BPConRiskRankingValues ConRR = new BPConRiskRankingValues(_lineid, _beginpoint, _endpoint, _connectionstring); lvi = null; _consrisktotal = 0; BPRiskRankingItem BPRRitem = new BPRiskRankingItem("", 0, "", ""); if (ConRR != null) { for (i = 0; i <= (ConRR.RrValues.Count - 1); i++) { lvi = new ListViewItem(); if (ConRR.RrValues.GetItem(i, ref BPRRitem)) { lvi.Text = BPRRitem.RiskRankingDesc; lvCons.Items.Add(lvi); lvi.SubItems.Add(BPRRitem.RiskRankingValue.ToString()); _consrisktotal = _consrisktotal + BPRRitem.RiskRankingValue; } } // for } txtConsTotal.Text = _consrisktotal.ToString(); //........................................ // Load Soil Susceptibility lvSoil.Columns.Clear(); lvSoil.Columns.Add("Risk Ranking Factor"); lvSoil.Columns[0].Width = 315; lvSoil.Columns.Add("Value", "Value"); lvSoil.Columns[1].Width = 50; lvSoil.Columns[1].TextAlign = HorizontalAlignment.Right; lvSoil.View = View.Details; double pH = 0; double resistivity = 0; double Cl = 0; double redoxpotential = 0; string soiltype = ""; int RiskPoints = 0; string DataDesc = ""; _soilrisktotal = 0; if (GetSoilData(ref pH, ref resistivity, ref Cl, ref redoxpotential, ref soiltype)) { if (GetSoilRiskPoints(pH.ToString(), "pH", ref DataDesc, ref RiskPoints)) { // pH lvi = new ListViewItem(); lvi.Text = "pH: " + DataDesc; lvSoil.Items.Add(lvi); lvi.SubItems.Add(RiskPoints.ToString()); _soilrisktotal = _soilrisktotal + RiskPoints; } // Cl if (GetSoilRiskPoints(Cl.ToString(), "Chloride Content", ref DataDesc, ref RiskPoints)) { lvi = new ListViewItem(); lvi.Text = "Chloride Content: " + DataDesc; lvSoil.Items.Add(lvi); lvi.SubItems.Add(RiskPoints.ToString()); _soilrisktotal = _soilrisktotal + RiskPoints; } // Resistivity if (GetSoilRiskPoints(resistivity.ToString(), "Soil Resistivity", ref DataDesc, ref RiskPoints)) { lvi = new ListViewItem(); lvi.Text = "Soil Resistivity: " + DataDesc; lvSoil.Items.Add(lvi); lvi.SubItems.Add(RiskPoints.ToString()); _soilrisktotal = _soilrisktotal + RiskPoints; } // Resistivity if (GetSoilRiskPoints(redoxpotential.ToString(), "Redox Potential", ref DataDesc, ref RiskPoints)) { lvi = new ListViewItem(); lvi.Text = "Redox Potential: " + DataDesc; lvSoil.Items.Add(lvi); lvi.SubItems.Add(RiskPoints.ToString()); _soilrisktotal = _soilrisktotal + RiskPoints; } // Soil Type if (GetSoilDescriptionRiskPoints(soiltype, ref RiskPoints)) { lvi = new ListViewItem(); lvi.Text = "Soil Type: " + DataDesc; lvSoil.Items.Add(lvi); lvi.SubItems.Add(RiskPoints.ToString()); _soilrisktotal = _soilrisktotal + RiskPoints; } } txtSoilTotal.Text = _soilrisktotal.ToString(); // Calculate Totals and Display _suscsoilrisktotal = _suscrisktotal + _soilrisktotal; txtSuscSoilTotal.Text = _suscsoilrisktotal.ToString(); // Use BG color to display risk ranking level txtSuscSoilTotal.BackColor = lblSusRanking.BackColor; txtConsTotal.BackColor = lblConRanking.BackColor; }