public void DeleteSeriesCommandAction()
{
if (selectedSeries != null)
{
string message = string.Concat("Are you sure you want to delete ", SelectedSeries, "?");
string title = string.Concat("Deleting ", selectedSeries);
if (MessageBox.Show(message, title, MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
try
{
using (var db = new NR2K3ResultsEntities())
{
Series s = db.Series.Where(d => d.SeriesName.Equals(SelectedSeries)).FirstOrDefault();
db.Series.Remove(s);
db.SaveChanges();
}
UpdateSeries();
}
catch (EntityCommandExecutionException e)
{
MessageBox.Show("Error with database. Check if database file exists or is opened in another program.", "Database Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
catch (SqlException e)
{
MessageBox.Show("Error with database. Check if database file exists or is opened in another program.", "Database Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
SelectedSeries = (Series.Count > 0) ? Series.ElementAt(0) : null;
}
}
}
private void UpdateSeries()
{
using (var db = new NR2K3ResultsEntities())
{
Series.Clear();
foreach (string s in db.Series.Select(d => d.SeriesName))
{
Series.Add(s);
}
}
}
