private LacStats GetStats() // Date range as arguments?
{
DataSet ds = db.ExecuteNonScalarQuery(@"select * from stats where time >= '2018-05-08 12:00:00' order by control_id asc");
DataTable dt = ds.Tables["TABLE"];
LacStats stats = new LacStats();
foreach (DataRow row in dt.Rows)
{
LacStat stat = new LacStat(Convert.ToInt32(row["control_id"]), Convert.ToInt32(row["statcount"]));
stats.Add(stat);
}
return(stats);
}
private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
LacStats stats = GetStats();
var statCountPerControlID = from s in stats
group s by s.ControlId into g
select new
{
id = g.Key,
sum = g.Sum(x => x.StatCount)
};
foreach (var s in statCountPerControlID)
{
// add to new collection
txtblk_main.Text += $"{s.id}|{s.sum} \r\n";
}
}
