private void ProcessStats(IList<FeatureStatistics> stats)
{
try
{
Logger.Debug("Adding Stats to database");
using (var database = new PetaPoco.Database(_connectionStringName))
{
using (ITransaction transaction = database.GetTransaction())
{
foreach (var stat in stats)
{
foreach (var reading in stat.Readings)
{
var data = new FeatureData()
{
Reading = reading.Name,
Timestamp = DateTime.Now,
Name = stat.Name,
Group = stat.Group
};
data.ValueType = reading.GetType().Name;
SetValue(data, reading);
database.Insert("FeatureData", "Id", true, data);
}
}
transaction.Complete();
}
}
}
catch (Exception ex)
{
Logger.Error("Error saving stats to the database", ex);
}
}