private void makeTypeGraph(string[] roadTypes, string column, string title, Color[] c = null)
{
string thisSql = moduleRoads.GetSelectAllSQL();
try
{
DataTable roadTable = Database.GetDataByQuery(Project.conn, thisSql);
if (roadTable.Rows.Count == 0)
{
MessageBox.Show("No graph could be generated because no roads have a road type set.", "No Roads", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Dictionary <string, double> roadArea = new Dictionary <string, double>();
for (int i = 0; i < roadTypes.Length; i++)
{
roadArea.Add(roadTypes[i], 0.0);
}
double totalArea = 0.0;
foreach (DataRow row in roadTable.Rows)
{
for (int i = 0; i < roadTypes.Length; i++)
{
if (row[column].ToString().Contains(roadTypes[i]))
{
totalArea += Util.ToDouble(row["length"].ToString()) * Util.ToDouble(row["width"].ToString());
roadArea[roadTypes[i]] += Util.ToDouble(row["length"].ToString()) * Util.ToDouble(row["width"].ToString());
}
}
}
DataTable results = new DataTable();
results.Columns.Add("Distribution");
for (int i = 0; i < roadTypes.Length; i++)
{
results.Columns.Add(Util.UppercaseFirst(roadTypes[i]));
}
DataRow totalsRow = results.NewRow();
DataRow percentageRow = results.NewRow();
totalsRow["Distribution"] = "Area (sqr. ft.)";
percentageRow["Distribution"] = "Percentage";
string[] domain = new string[roadTypes.Length];
double[] range = new double[roadTypes.Length];
for (int i = 0; i < roadTypes.Length; i++)
{
totalsRow[Util.UppercaseFirst(roadTypes[i])] = roadArea[roadTypes[i]];
percentageRow[Util.UppercaseFirst(roadTypes[i])] = Math.Round(roadArea[roadTypes[i]] / totalArea, 3) * 100;
domain[i] = roadTypes[i];
range[i] = Math.Round(roadArea[roadTypes[i]] / totalArea, 3) * 100;
}
results.Rows.Add(totalsRow);
results.Rows.Add(percentageRow);
FormGraphDisplay graph = new FormGraphDisplay(results, domain, range, title, c);
graph.Show();
}
catch (Exception err)
{
Log.Error("Problem getting data from database " + err.ToString());
}
}
public void graphGoverningDistress(object sender, EventArgs e)
{
ChooseRoadForm roadChooser = new ChooseRoadForm("What Road Type?", "Select a Road Surface Type");
string thisSql = moduleRoads.GetSelectAllSQL();
if (roadChooser.ShowDialog() == DialogResult.OK)
{
try
{
string roadType = roadChooser.chooseRoad();
DataTable roadTable = Database.GetDataByQuery(Project.conn, thisSql);
var roads = roadTable.Select("surface = '" + roadType + "'");
if (roads.Length == 0)
{
MessageBox.Show("No graph could be generated because there are no roads of type " + roadType + ".", "No Roads", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Dictionary <string, string[]> distressGroup = new Dictionary <string, string[]>()
{
{ "Asphalt", distressAsphalt },
{ "Gravel", distressGravel },
{ "Concrete", distressConcrete }
};
Dictionary <string, double> distressedArea = new Dictionary <string, double>();
double totalArea = 0.0;
double noDistress = 0.0;
for (int i = 0; i < distressGroup[roadType].Length; i++)
{
distressedArea.Add(distressGroup[roadType][i], 0.0);
}
foreach (DataRow row in roads)
{
double area = Util.ToDouble(row["length"].ToString()) * Util.ToDouble(row["width"].ToString());
totalArea += area;
int[] dvs = new int[9];
for (int i = 0; i < 9; i++)
{
dvs[i] = Util.ToInt(row["distress" + (i + 1).ToString()].ToString());
}
string governingDistress = moduleRoads.GetGoverningDistress(dvs, row["surface"].ToString());
if (string.IsNullOrEmpty(governingDistress))
{
noDistress += area;
}
else
{
distressedArea[governingDistress] += area;
}
}
DataTable results = new DataTable();
results.Columns.Add("Distribution");
for (int i = 0; i < distressGroup[roadType].Length; i++)
{
results.Columns.Add(distressGroup[roadType][i]);
}
results.Columns.Add("No Distress");
DataRow totalsRow = results.NewRow();
DataRow percentageRow = results.NewRow();
totalsRow["Distribution"] = "Area (sqr. ft.)";
percentageRow["Distribution"] = "Percentage";
string[] domain = new string[distressGroup[roadType].Length + 1];
double[] range = new double[distressGroup[roadType].Length + 1];
for (int i = 0; i < distressGroup[roadType].Length; i++)
{
totalsRow[distressGroup[roadType][i]] = distressedArea[distressGroup[roadType][i]];
percentageRow[distressGroup[roadType][i]] = Math.Round(distressedArea[distressGroup[roadType][i]] / totalArea, 3) * 100;
domain[i] = distressGroup[roadType][i];
range[i] = Math.Round(distressedArea[distressGroup[roadType][i]] / totalArea, 3) * 100;
}
totalsRow["No Distress"] = noDistress;
percentageRow["No Distress"] = Math.Round(noDistress / totalArea, 3) * 100;
results.Rows.Add(totalsRow);
results.Rows.Add(percentageRow);
domain[distressGroup[roadType].Length] = "No Distress";
range[distressGroup[roadType].Length] = Math.Round(noDistress / totalArea, 3) * 100;
FormGraphDisplay graph = new FormGraphDisplay(results, domain, range, Util.UppercaseFirst(roadType) + " Road Governing Distress Distribution");
graph.Show();
}
catch (Exception err)
{
Log.Error("Problem getting data from database " + err.ToString());
}
}
}
public void graphRSL(object sender, EventArgs e)
{
ChooseRoadForm roadChooser = new ChooseRoadForm("What Road Type?", "Select a road surface type.");
string thisSql = moduleRoads.GetSelectAllSQL();
if (roadChooser.ShowDialog() == DialogResult.OK)
{
try
{
string roadType = roadChooser.chooseRoad();
string[] categories = { "0", "1-3", "4-6", "7-9", "10-12", "13-15", "16-18", "19-20" };
int[] caps = { 0, 3, 6, 9, 12, 15, 18, 20 };
DataTable roadTable = Database.GetDataByQuery(Project.conn, thisSql);
var roads = roadTable.Select("surface = '" + roadType + "'");
if (roadType == "All")
{
roads = roadTable.Select();
}
if (roads.Length == 0)
{
MessageBox.Show("No graph could be generated because there are no roads of type " + roadType + ".", "No Roads", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Dictionary <string, double> rslArea = new Dictionary <string, double>();
double totalArea = 0.0;
for (int i = 0; i < categories.Length; i++)
{
rslArea.Add(categories[i], 0.0);
}
foreach (DataRow row in roads)
{
int rsl = Util.ToInt(row["rsl"].ToString());
if (rsl == -1)
{
continue;
}
for (int i = 0; i < categories.Length; i++)
{
if (rsl <= caps[i])
{
totalArea += Util.ToDouble(row["length"].ToString()) * Util.ToDouble(row["width"].ToString());
rslArea[categories[i]] += Util.ToDouble(row["length"].ToString()) * Util.ToDouble(row["width"].ToString());
break;
}
}
}
DataTable results = new DataTable();
results.Columns.Add("Distribution");
for (int i = 0; i < categories.Length; i++)
{
results.Columns.Add(categories[i]);
}
DataRow totalsRow = results.NewRow();
DataRow percentageRow = results.NewRow();
totalsRow["Distribution"] = "Area (sqr. ft.)";
percentageRow["Distribution"] = "Percentage";
string[] domain = new string[categories.Length];
double[] range = new double[categories.Length];
for (int i = 0; i < categories.Length; i++)
{
totalsRow[categories[i]] = rslArea[categories[i]];
percentageRow[categories[i]] = Math.Round(rslArea[categories[i]] / totalArea, 3) * 100;
domain[i] = categories[i];
range[i] = Math.Round(rslArea[categories[i]] / totalArea, 3) * 100;
}
results.Rows.Add(totalsRow);
results.Rows.Add(percentageRow);
Color[] color = { Color.DarkRed, Color.Red, Color.Orange, Color.Yellow, Color.LimeGreen, Color.Green, Color.DeepSkyBlue, Color.Blue };
FormGraphDisplay graph = new FormGraphDisplay(results, domain, range, "Road RSL Distribution", color);
graph.Show();
}
catch (Exception err)
{
Log.Error("Problem getting data from database " + err.ToString());
}
}
}