private void SaveChangesPAPersonnel() { foreach (var person in PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Local.ToList()) { if (person.EMPID == null) { PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Remove(person); } } PA_PERSONNEL_CONTEXT.SaveChanges(); DataChangedEventHandler handler = DataChanged; if (handler != null) { handler(this, new EventArgs()); } PA_PERSONNEL_CONTEXT.Dispose(); PA_PERSONNEL_CONTEXT = new Data_Model.Portable_Traps_Entities(); System.Windows.Data.CollectionViewSource pA_PERSONNELViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pA_PERSONNELViewSource"))); PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Local.Add(new Data_Model.PA_PERSONNEL() { ID = ROWID }); pA_PERSONNELViewSource.Source = PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Local; }
private void SaveChangesPASpecies() { foreach (var species in SPECIES_CONTEXT.PA_SPECIES.Local.ToList()) { if (species.ID == 0) { SPECIES_CONTEXT.PA_SPECIES.Remove(species); } } try { SPECIES_CONTEXT.SaveChanges(); } catch (DbUpdateException ex) { var sb = new StringBuilder(); sb.AppendLine("DbUpdateException error details - {ex?.InnerException?.InnerException?.Message}"); foreach (var eve in ex.Entries) { sb.AppendLine("Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated"); } var error = sb.ToString(); MessageBox.Show(error); //throw; } catch (Exception ex1) { var error1 = ex1.ToString(); MessageBox.Show(error1); } DataChangedEventHandler handler = DataChanged; if (handler != null) { handler(this, new EventArgs()); } if (OfficeUseID == 0) { SPECIES_CONTEXT.Dispose(); SPECIES_CONTEXT = new Data_Model.Portable_Traps_Entities(); System.Windows.Data.CollectionViewSource pA_SPECIESViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pA_SPECIESViewSource"))); SPECIES_CONTEXT.PA_SPECIES.Local.Add(new Data_Model.PA_SPECIES() { ID = ROWID }); pA_SPECIESViewSource.Source = SPECIES_CONTEXT.PA_SPECIES.Local; textBoxspecies.Text = ""; textBoxAlive.Text = ""; textBoxDead.Text = ""; } }
private void Button_Click_3(object sender, RoutedEventArgs e) { Button cmd = (Button)sender; if (cmd.DataContext is Data_Model.PA_INDIVIDUALS) { Data_Model.PA_INDIVIDUALS deleteme = (Data_Model.PA_INDIVIDUALS)cmd.DataContext; String SelectedSpecies = deleteme.SPECIES.ToString(); MessageBoxResult result = MessageBox.Show("Are you sure you want to delete Species " + SelectedSpecies + "?", "Portable Traps", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { PA_INDIVIDUALS_CONTEXT.PA_INDIVIDUALS.Remove(deleteme); PA_INDIVIDUALS_CONTEXT.SaveChanges(); pA_INDIVIDUALSListView.Items.Refresh(); } } }
private void btnFindelete_Click(object sender, RoutedEventArgs e) { Button cmd = (Button)sender; if (cmd.DataContext is Data_Model.PA_FIN_CLIPS_OF_RECAPTURES) { Data_Model.PA_FIN_CLIPS_OF_RECAPTURES deleteme = (Data_Model.PA_FIN_CLIPS_OF_RECAPTURES)cmd.DataContext; String SelectedFinClip = deleteme.FIN_CLIP.ToString(); MessageBoxResult result = MessageBox.Show("Are you sure you want to delete Fin Clip " + SelectedFinClip + "?", "Portable Traps", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { PA_FIN_CLIPS_CONTEXT.PA_FIN_CLIPS_OF_RECAPTURES.Remove(deleteme); PA_FIN_CLIPS_CONTEXT.SaveChanges(); pA_FIN_CLIPS_OF_RECAPTURESListView.Items.Refresh(); } } }
private void Button_Click(object sender, RoutedEventArgs e) { Button cmd = (Button)sender; if (cmd.DataContext is Data_Model.PA_PERSONNEL) { Data_Model.PA_PERSONNEL deleteme = (Data_Model.PA_PERSONNEL)cmd.DataContext; String SelectedEMPID = deleteme.EMPID.ToString(); MessageBoxResult result = MessageBox.Show("Are you sure you want to delete EMPID " + SelectedEMPID + "?", "Portable Traps", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { PA_PERSONNEL_CONTEXT.PA_PERSONNEL.Remove(deleteme); PA_PERSONNEL_CONTEXT.SaveChanges(); pA_PERSONNELListView.Items.Refresh(); } } }
private void SaveChangesPA_PAT_Assessments() { foreach (var assessment in PA_PAT_ASSESSMENTS_CONTEXT.PA_PAT_ASSESSMENTS.Local.ToList()) { if (assessment.ID == 0) { PA_PAT_ASSESSMENTS_CONTEXT.PA_PAT_ASSESSMENTS.Remove(assessment); } } try { PA_PAT_ASSESSMENTS_CONTEXT.SaveChanges(); } catch (System.Data.Entity.Infrastructure.DbUpdateException ex) { var sb = new StringBuilder(); sb.AppendLine("DbUpdateException error details - {ex?.InnerException?.InnerException?.Message}"); foreach (var eve in ex.Entries) { sb.AppendLine("Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated"); } var error = sb.ToString(); MessageBox.Show(error); //throw; } catch (Exception ex1) { var error1 = ex1.ToString(); MessageBox.Show(error1); } DataChangedEventHandler handler = DataChanged; if (handler != null) { handler(this, new EventArgs()); } }
private void SaveChangesPA_PAT_Assessments() { foreach (var Personnel in PA_PAT_ASSESSMENTS_CONTEXT.PA_PERSONNEL.Local.ToList()) { if (Personnel.ID == 0) { PA_PAT_ASSESSMENTS_CONTEXT.PA_PERSONNEL.Remove(Personnel); } } foreach (var Species in PA_PAT_ASSESSMENTS_CONTEXT.PA_SPECIES.Local.ToList()) { if (Species.ID == 0) { PA_PAT_ASSESSMENTS_CONTEXT.PA_SPECIES.Remove(Species); } } foreach (var FinClip in PA_PAT_ASSESSMENTS_CONTEXT.PA_FIN_CLIPS_OF_RECAPTURES.Local.ToList()) { if (FinClip.ID == 0) { PA_PAT_ASSESSMENTS_CONTEXT.PA_FIN_CLIPS_OF_RECAPTURES.Remove(FinClip); } } foreach (var Individual in PA_PAT_ASSESSMENTS_CONTEXT.PA_INDIVIDUALS.Local.ToList()) { if (Individual.ID == 0) { PA_PAT_ASSESSMENTS_CONTEXT.PA_INDIVIDUALS.Remove(Individual); } } foreach (var Assessments in PA_PAT_ASSESSMENTS_CONTEXT.PA_PAT_ASSESSMENTS.Local.ToList()) { if (Assessments.ID == 0) { PA_PAT_ASSESSMENTS_CONTEXT.PA_PAT_ASSESSMENTS.Remove(Assessments); } } try { PA_PAT_ASSESSMENTS_CONTEXT.SaveChanges(); } catch (DbUpdateException ex) { var sb = new StringBuilder(); sb.AppendLine("DbUpdateException error details - {ex?.InnerException?.InnerException?.Message}"); foreach (var eve in ex.Entries) { sb.AppendLine("Entity of type {eve.Entity.GetType().Name} in state {eve.State} could not be updated"); } var error = sb.ToString(); MessageBox.Show(error); //throw; } catch (Exception ex1) { var error1 = ex1.ToString(); MessageBox.Show(error1); } }