public void CreateConditionCitywidePercentReport()
{
List <BinAttribute> binAttributes = new List <BinAttribute>();
Dictionary <string, double> binnedPCIData = new Dictionary <string, double>();
binAttributes.Add(new BinAttribute(10, 0, "FAILED"));
binAttributes.Add(new BinAttribute(25, 10, "SERIOUS"));
binAttributes.Add(new BinAttribute(40, 25, "VERY POOR"));
binAttributes.Add(new BinAttribute(55, 40, "POOR"));
binAttributes.Add(new BinAttribute(70, 55, "FAIR"));
binAttributes.Add(new BinAttribute(85, 70, "GOOD"));
binAttributes.Add(new BinAttribute(100, 85, "EXCELLENT"));
BinAttributeData PCIBins = new BinAttributeData("1", "PCI", "", "", "", "");
binnedPCIData = PCIBins.CreateAttributeBins(binAttributes, Method.AREA);
GenerateReport(binnedPCIData);
}
public void CreateConditionByFunctionalClassReport()
{
List <BinAttribute> binAttributes = new List <BinAttribute>();
Dictionary <string, double> binnedPCIData;
List <BinnedData> pciBins = new List <BinnedData>();
binAttributes.Add(new BinAttribute(10, 0, "FAILED"));
binAttributes.Add(new BinAttribute(25, 10, "SERIOUS"));
binAttributes.Add(new BinAttribute(40, 25, "VERY POOR"));
binAttributes.Add(new BinAttribute(55, 40, "POOR"));
binAttributes.Add(new BinAttribute(70, 55, "FAIR"));
binAttributes.Add(new BinAttribute(85, 70, "GOOD"));
binAttributes.Add(new BinAttribute(100, 85, "EXCELLENT"));
BinAttributeData PCIBinsPerFunctionalClass;
string functionalClass = "";
string query = "SELECT DISTINCT CLASS FROM SEGMENT_" + m_networkID + "_NS0";
DataSet distinctClasses = DBMgr.ExecuteQuery(query);
foreach (DataRow distinctClass in distinctClasses.Tables[0].Rows)
{
BinnedData bin = new BinnedData();
if (distinctClass[0] != null)
{
functionalClass = distinctClass[0].ToString();
PCIBinsPerFunctionalClass = new BinAttributeData(m_networkID.ToString(), "PCI", m_userName, "", "CLASS = '" + functionalClass + "'", "");
binnedPCIData = PCIBinsPerFunctionalClass.CreateAttributeBins(binAttributes, Method.PERCENTAGE);
bin.m_binnedPCIData = binnedPCIData;
bin.m_functionalClass = functionalClass;
}
pciBins.Add(bin);
}
GenerateReport(pciBins);
}