/// <summary>
/// Adds notification to history database.
/// </summary>
void addNotificationToHistory(string[] input)
{
var db = new SQLiteDatabase();
db.ExecuteNonQuery(@"CREATE TABLE IF NOT EXISTS history (title, subtitle, message, time);");
string tmpinsert = String.Format(@"INSERT INTO history VALUES ('{0}', '{1}', '{2}', '{3}');", input[2], input[3], input[4], input[6]);
db.ExecuteNonQuery(tmpinsert);
}
private void menuItemClick(object sender, RoutedEventArgs e)
{
var db = new SQLiteDatabase();
db.ClearTable("history");
DataTable result = db.GetDataTable("SELECT * FROM history;");
dataGrid1.ItemsSource = result.DefaultView;
}
private void windowLoaded(object sender, RoutedEventArgs e)
{
var db = new SQLiteDatabase();
DataTable result = db.GetDataTable("SELECT * FROM history;");
dataGrid1.ItemsSource = result.DefaultView;
}
