public static void loadEvents()
{
events.Clear();
if (!opened)
{
return;
}
string sql = "SELECT rowid, d,m,y, since,length,data FROM events";
var cmd = new SQLiteCommand(sql, db);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var item = new EventRecord();
item.id = Convert.ToInt32(reader["rowid"]);
item.since = Convert.ToSingle(reader["since"]);
item.length = Convert.ToSingle(reader["length"]);
item.data = reader["data"].ToString();
item.d = Convert.ToInt32(reader["d"]);
item.m = Convert.ToInt32(reader["m"]);
item.y = Convert.ToInt32(reader["y"]);
allEvents[item.id] = item;
}
}
