private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { // check if there is a selection if (listView1.SelectedItems.Count > 0) { try { SQLiteDatabase db = new SQLiteDatabase(); for (int i = 0; i < listView1.SelectedItems.Count; i++) { ListViewItem item = listView1.SelectedItems[i]; db.Delete("history", String.Format("id = {0}", item.SubItems[3].Text)); } // reload loadItems(); } catch (Exception fail) { String error = "The following error has occurred:\n\n"; error += fail.Message.ToString() + "\n\n"; fallyToast.Toaster alertdb = new fallyToast.Toaster(); alertdb.Show("fallyGrab", error, -1, "Fade", "Up", "", "", "error"); commonFunctions.writeLog(fail.Message, fail.StackTrace); } } }
private void toolStripButton4_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("Are you sure you want to clear your history?", "fallyGrab", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { SQLiteDatabase db = new SQLiteDatabase(); db.Delete("history", "1=1"); // reload loadItems(); } } catch (Exception fail) { String error = "The following error has occurred:\n\n"; error += fail.Message.ToString() + "\n\n"; fallyToast.Toaster alertdb = new fallyToast.Toaster(); alertdb.Show("fallyGrab", error, -1, "Fade", "Up", "", "", "error"); commonFunctions.writeLog(fail.Message, fail.StackTrace); } }