public DateTime GetMinEnergyTime() { object result = ADOUtils.ExecuteScalar(_connectionString, "Select_Min_Energy_Time", null); if (result == null) { throw new SqlStorageException("Can not select time of min energy."); } return((DateTime)result); }
public double GetMinEnergy() { object result = ADOUtils.ExecuteScalar(_connectionString, "Select_Min_Energy", null); if (result == null) { throw new SqlStorageException("Can not select min Energy."); } return((double)result); }
public Coordinates GetMinEnergyPosition() { int fieldsCountInCoordinateInstanse = 3; var result = ADOUtils.ExecuteReaderSingleRow(_connectionString, "Select_Min_Energy_Position", null, fieldsCountInCoordinateInstanse); if (result == null) { throw new ArgumentNullException("Can not select position of min energy."); } return(new Coordinates((int)result["Id"], (double)result["X"], (double)result["Y"])); }
public double GetMinEnergy(DateTime dateTime) { var parameters = new Dictionary <string, object>(); parameters.Add("@Date", dateTime); object result = ADOUtils.ExecuteScalar(_connectionString, "Select_Min_Energy_By_Date", null); if (result == null) { throw new SqlStorageException("Can not select min Energy."); } return((double)result); }
public void OnNext(T value) { if (EqualityComparer <T> .Default.Equals(value, default)) { throw new ArgumentException($"The {nameof(value)} must be initialized."); } var parameters = new Dictionary <string, object>(); parameters.Add("@X", value.ObservationPoint.X); parameters.Add("@Y", value.ObservationPoint.Y); parameters.Add("@EstimatedValue", value.EstimatedValue); parameters.Add("@ObservationTime", value.ObservationTime); ADOUtils.ExecuteNonQuery(_connectionString, "Insert_EnergyObservation", parameters); }
public double GetAverageEnergy(DateTime startFrom, DateTime endBy) { var parameters = new Dictionary <string, object>(); parameters.Add("@StartFrom", startFrom); parameters.Add("@EndBy", endBy); object result = ADOUtils.ExecuteScalar(_connectionString, "Select_Average_Energy_Between_Dates", parameters); if (result == null) { throw new SqlStorageException("Can not select average Energy."); } return((double)result); }
public double GetMaxEnergy(Coordinates coordinates) { var parameters = new Dictionary <string, object>(); parameters.Add("@X", coordinates); parameters.Add("@Y", coordinates); object result = ADOUtils.ExecuteScalar(_connectionString, "Select_Max_Energy_By_Coordinate", null); if (result == null) { throw new SqlStorageException("Can not select max Energy."); } return((double)result); }
public double GetAverageEnergy(Coordinates rectTopLeft, Coordinates rectBottomRight) { var parameters = new Dictionary <string, object>(); parameters.Add("@TopLeftX", rectTopLeft.X); parameters.Add("@TopLeftY", rectTopLeft.Y); parameters.Add("@BottomRightX", rectBottomRight.X); parameters.Add("@BottomRightY", rectBottomRight.Y); object result = ADOUtils.ExecuteScalar(_connectionString, "Select_Average_Energy_Between_Coordinates", parameters); if (result == null) { throw new SqlStorageException("Can not select average Energy."); } return((double)result); }
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); }