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