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