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();
}