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