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