public IDictionary <double, int> GetDistributionByEnergyValue() { var resultDistribution = new Dictionary <double, int>(); int fieldCountInSelectedItem = 2; var selectedItems = ADOUtils.ExecuteReaderRows(_connectionString, "Select_Distribution_By_EnergyValue", null, fieldCountInSelectedItem); if (selectedItems == null) { throw new SqlStorageException("Can not select distribution by estimated value."); } foreach (var item in selectedItems) { resultDistribution.Add((double)item["EstimatedValue"], (int)item["Count"]); } return(resultDistribution); }
public IDictionary <DateTime, int> GetDistributionByObservationTime() { var resultDistribution = new Dictionary <DateTime, int>(); int fieldCountInSelectedItem = 2; var selectedItems = ADOUtils.ExecuteReaderRows(_connectionString, "Select_Distribution_By_ObservationTime", null, fieldCountInSelectedItem); if (selectedItems == null) { throw new SqlStorageException("Can not select distribution by observation time."); } foreach (var item in selectedItems) { resultDistribution.Add((DateTime)item["ObservationTime"], (int)item["Count"]); } return(resultDistribution); }
public IDictionary <Coordinates, int> GetDistributionByCoordinates() { var resultDistribution = new Dictionary <Coordinates, int>(); int fieldCountInSelectedItem = 4; var selectedItems = ADOUtils.ExecuteReaderRows(_connectionString, "Select_Distribution_By_Coordinates", null, fieldCountInSelectedItem); if (selectedItems == null) { throw new SqlStorageException("Can not select distribution by coordinates"); } foreach (var item in selectedItems) { var coordinate = new Coordinates((int)item["Id"], (double)item["X"], (double)item["Y"]); resultDistribution.Add(coordinate, (int)item["Count"]); } return(resultDistribution); }