private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { //Confirm Delete, then delete selected if (MessageBox.Show("Are you sure?", "Confirm Delete", MessageBoxButtons.YesNo) != DialogResult.Yes) return; using (SABSyncEntities sabSyncEntities = new SABSyncEntities()) { for (int i = 0; i < objectListViewShows2.SelectedItems.Count; i++) { int id = Convert.ToInt32(objectListViewShows2.SelectedItems[i].Text); var show = (from s in sabSyncEntities.shows where s.id == id select s).FirstOrDefault(); var episodes = from ep in sabSyncEntities.episodes where ep.show_id == id select ep; var history = from h in sabSyncEntities.histories where h.show_id == id select h; //Delete each item in history for the selected show foreach (var h in history) sabSyncEntities.DeleteObject(h); //Delete each episode for the selected show foreach (var episode in episodes) sabSyncEntities.DeleteObject(episode); sabSyncEntities.DeleteObject(show); //Delete the show } sabSyncEntities.SaveChanges(); //Save the changes } GetShows(); }
private void btnDeleteHistory_Click(object sender, EventArgs e) { //Popup to Confirm, then delete selected row if (objectListViewHistory.SelectedItems.Count != 1) return; if (MessageBox.Show("Are you sure?", "Confirm Delete", MessageBoxButtons.YesNo) != DialogResult.Yes) return; int id = Convert.ToInt32(objectListViewHistory.SelectedItem.Text); using (SABSyncEntities sabSyncEntities = new SABSyncEntities()) { var item = (from i in sabSyncEntities.histories where i.id == id select i).FirstOrDefault(); sabSyncEntities.DeleteObject(item); sabSyncEntities.SaveChanges(); } GetHistory(); }
private void btnPurgeHistory_Click(object sender, EventArgs e) { //Clear all items in the History if (MessageBox.Show("Are you sure?", "Confirm Purge", MessageBoxButtons.YesNo) != DialogResult.Yes) return; using (SABSyncEntities sabSyncEntities = new SABSyncEntities()) { var items = from i in sabSyncEntities.histories select i; foreach (var item in items) sabSyncEntities.DeleteObject(item); sabSyncEntities.SaveChanges(); } GetHistory(); }
private void btnDeleteFeeds_Click(object sender, EventArgs e) { //Popup to Confirm, then delete selected row if (objectListViewFeeds.SelectedItems.Count != 1) return; if (MessageBox.Show("Are you sure?", "Confirm Delete", MessageBoxButtons.YesNo) != DialogResult.Yes) return; int id = Convert.ToInt32(objectListViewFeeds.SelectedItem.Text); using (SABSyncEntities sabSyncEntities = new SABSyncEntities()) { var feed = (from f in sabSyncEntities.providers where f.id == id select f).FirstOrDefault(); sabSyncEntities.DeleteObject(feed); sabSyncEntities.SaveChanges(); } GetFeeds(); }