private void LoadTasks()
{
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
IEnumerable <DAO.CalculType> ECalculTypes = connection.Query <DAO.CalculType>("select * from CalculType");
foreach (DAO.CalculType calculTypes in ECalculTypes)
{
if (!Cache.ContainsKey(calculTypes.SensorType))
{
Business.CacheDataDeviceSensor temp = new Business.CacheDataDeviceSensor(calculTypes, this);
Cache.Add(
calculTypes.SensorType,
temp
);
}
else
{
Cache[calculTypes.SensorType].AddCalculType(calculTypes);
}
}
connection.Close();
}
}
catch
{
Status = "🔴 - EndPoint Down - Fail to connect to the DataBase";
}
}
public static List <DAO.CalculatedMetric> BusinessToListDAO(Business.CacheDataDeviceSensor business, string period)
{
List <DAO.CalculatedMetric> temp = new List <DAO.CalculatedMetric>();
foreach (KeyValuePair <string, Dictionary <string, double> > kv in business.ResultCalculType)
{
foreach (KeyValuePair <string, double> kv2 in kv.Value)
{
if (kv2.Key == period)
{
DateTime d = DateTime.Now;
int c = business.Type[kv2.Key].Id;
temp.Add(new DAO.CalculatedMetric(d, kv2.Value, c, kv.Key));
}
}
}
return(temp);
}