// 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;
}
