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