public string this[string columnName]
{
get
{
string result = null;
if (columnName == "EMPID")
{
bool _ISDuplicateEMPID;
bool _IsValidEMPID;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISDuplicateEMPID = context.PA_PERSONNEL.Any(x => x.EMPID == EMPID && x.ID == ID);
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_IsValidEMPID = context.EMPLOYEES.Any(x => x.EMPID == EMPID);
if (EMPID == null)
{
result = "Please enter an Employee ID!";
}
else if (_ISDuplicateEMPID)
{
result = "Duplicate Employee ID!";
}
else if (_IsValidEMPID == false)
{
result = "Invalid Employee ID!";
}
}
return(result);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
if (LakeTextBox.SelectedValue != null)
{
STREAMS_CONTEXT.Dispose();
STREAMS_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource StreamListViewSource = ((CollectionViewSource)(this.FindResource("StreamListViewSource")));
decimal lake = System.Convert.ToDecimal(LakeTextBox.SelectedValue.ToString());
var Streams = STREAMS_CONTEXT.QRY_PORTABLE_TRAP_SITES_STREAM_LIST
.Where(QRY_PORTABLE_TRAP_SITES_STREAM_LIST => QRY_PORTABLE_TRAP_SITES_STREAM_LIST.LAKE == lake)
.ToList();
StreamListViewSource.Source = STREAMS_CONTEXT.QRY_PORTABLE_TRAP_SITES_STREAM_LIST.Local;
}
if (LakeTextBox.SelectedValue != null && streamcomboBox.SelectedValue != null)
{
decimal lake = System.Convert.ToDecimal(LakeTextBox.SelectedValue.ToString());
decimal stream = System.Convert.ToDecimal(streamcomboBox.SelectedValue.ToString());
SITE_CONTEXT.Dispose();
SITE_CONTEXT = new Data_Model.Portable_Traps_Entities();
var Sites = SITE_CONTEXT.PORTABLE_TRAP_SITES
.Where(PORTABLE_TRAP_SITES => PORTABLE_TRAP_SITES.LAKE == lake)
.Where(PORTABLE_TRAP_SITES => PORTABLE_TRAP_SITES.STREAM == stream)
.OrderBy(PORTABLE_TRAP_SITES => PORTABLE_TRAP_SITES.TRAP_SITE)
.ToList();
CollectionViewSource SiteListViewSource = ((CollectionViewSource)(this.FindResource("SiteListViewSource")));
SiteListViewSource.Source = SITE_CONTEXT.PORTABLE_TRAP_SITES.Local;
}
}
private void textBoxCaptureCode_TextChanged(object sender, TextChangedEventArgs e)
{
bool _ISValidCaptureCode;
using (Data_Model.Portable_Traps_Entities context = new Data_Model.Portable_Traps_Entities())
_ISValidCaptureCode = context.CAPTURE_DESCRIPTIONS.Any(x => x.CAPTURE_CODE == textBoxCaptureCode.Text);
if (_ISValidCaptureCode == true)
{
try
{
using (SqlConnection conn = new SqlConnection(ConStr))
{
//Code to set query for Capture Code label
string LookupCaptureCode = "SELECT CAPTURE_DESCRIPTION FROM [dbo].[CAPTURE_DESCRIPTIONS] WHERE CAPTURE_CODE = @CaptureCode";
SqlCommand ShowCaptureCode = new SqlCommand(LookupCaptureCode, conn);
ShowCaptureCode.Parameters.AddWithValue("CaptureCode", textBoxCaptureCode.Text);
//Open Database Connection and Get Values
conn.Open();
dsp_capturecode.Content = ShowCaptureCode.ExecuteScalar().ToString();
//Close Database Connection
conn.Close();
}
}
catch (Exception)
{
e.Handled = true;
}
}
else
{
dsp_capturecode.Content = "";
}
}
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 StreamTextBox_SelectionChanged(object sender, RoutedEventArgs e)
{
SITE_CONTEXT.Dispose();
SITE_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource SiteListViewSource = ((CollectionViewSource)(this.FindResource("SiteListViewSource")));
SiteListViewSource.Source = SITE_CONTEXT.PORTABLE_TRAP_SITES.Local;
}
private void textBoxSex_DropDownOpened(object sender, EventArgs e)
{
GENDER_List_Context.Dispose();
GENDER_List_Context = new Data_Model.Portable_Traps_Entities();
CollectionViewSource GenderListViewSource = ((CollectionViewSource)(this.FindResource("GenderListViewSource")));
var Gender = GENDER_List_Context.GENDERS
.ToList();
GenderListViewSource.Source = GENDER_List_Context.GENDERS.Local;
}
private void textBoxCaptureCode_DropDownOpened(object sender, EventArgs e)
{
CAPTURE_CODE_Context.Dispose();
CAPTURE_CODE_Context = new Data_Model.Portable_Traps_Entities();
System.Windows.Data.CollectionViewSource CaptureListViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("CaptureListViewSource")));
var CaptureCode = SPECIES_CONTEXT.CAPTURE_DESCRIPTIONS
.ToList();
CaptureListViewSource.Source = SPECIES_CONTEXT.CAPTURE_DESCRIPTIONS.Local;
}
private void textBoxspecies_DropDownOpened(object sender, EventArgs e)
{
SPECIES_LIST_CONTEXT.Dispose();
SPECIES_LIST_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource SpeciesListViewSource = ((CollectionViewSource)(this.FindResource("SpeciesListViewSource")));
var Species = SPECIES_LIST_CONTEXT.QRY_PA_SPECIES_USAGE_FREQUENCY
.OrderByDescending(QRY_PA_SPECIES_USAGE_FREQUENCY => QRY_PA_SPECIES_USAGE_FREQUENCY.Count)
.ToList();
SpeciesListViewSource.Source = SPECIES_LIST_CONTEXT.QRY_PA_SPECIES_USAGE_FREQUENCY.Local;
}
private void FinClipsWindow_DataChanged(object sender, EventArgs e)
{
PA_FIN_CLIPS_CONTEXT.Dispose();
PA_FIN_CLIPS_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource pA_FIN_CLIPS_OF_RECAPTURESViewSource = ((CollectionViewSource)(this.FindResource("pA_FIN_CLIPS_OF_RECAPTURESViewSource")));
var SelectedFINCLIPS = PA_FIN_CLIPS_CONTEXT.PA_FIN_CLIPS_OF_RECAPTURES
.Where(PA_FIN_CLIPS_OF_RECAPTURES => PA_FIN_CLIPS_OF_RECAPTURES.ID == SelectedID)
.ToList();
pA_FIN_CLIPS_OF_RECAPTURESViewSource.Source = PA_FIN_CLIPS_CONTEXT.PA_FIN_CLIPS_OF_RECAPTURES.Local;
}
private void IndividualsWindow_DataChanged(object sender, EventArgs e)
{
PA_INDIVIDUALS_CONTEXT.Dispose();
PA_INDIVIDUALS_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource pA_INDIVIDUALSViewSource = ((CollectionViewSource)(this.FindResource("pA_INDIVIDUALSViewSource")));
var SelectedIndividuals = PA_INDIVIDUALS_CONTEXT.PA_INDIVIDUALS
.Where(PA_INDIVIDUALS => PA_INDIVIDUALS.ID == SelectedID)
.ToList();
pA_INDIVIDUALSViewSource.Source = PA_INDIVIDUALS_CONTEXT.PA_INDIVIDUALS.Local;
}
private void SpeciesWindow_DataChanged(object sender, EventArgs e)
{
//System.Windows.MessageBox.Show("Something has happened", "Parent");
PA_SPECIES_CONTEXT.Dispose();
PA_SPECIES_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource pA_SPECIESViewSource = ((CollectionViewSource)(this.FindResource("pA_SPECIESViewSource")));
var SelectedSpecies = PA_SPECIES_CONTEXT.PA_SPECIES
.Where(PA_SPECIES => PA_SPECIES.ID == SelectedID)
.ToList();
pA_SPECIESViewSource.Source = PA_SPECIES_CONTEXT.PA_SPECIES.Local;
pA_SPECIESListView.Items.Refresh();
}
private void LakeTextBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
STREAMS_CONTEXT.Dispose();
STREAMS_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource StreamListViewSource = ((CollectionViewSource)(this.FindResource("StreamListViewSource")));
StreamListViewSource.Source = STREAMS_CONTEXT.QRY_PORTABLE_TRAP_SITES_STREAM_LIST.Local;
StreamTextBox.Text = "";
SITE_CONTEXT.Dispose();
SITE_CONTEXT = new Data_Model.Portable_Traps_Entities();
CollectionViewSource SiteListViewSource = ((CollectionViewSource)(this.FindResource("SiteListViewSource")));
SiteListViewSource.Source = SITE_CONTEXT.PORTABLE_TRAP_SITES.Local;
}
private void fIRSTNAMEComboBox_DropDownOpened(object sender, EventArgs e)
{
string officeval = oFFICE_NAMEComboBox.SelectedValue.ToString();
string lastnameval = lASTNAMEComboBox.Text.ToString();
EMPLOYEE_CONTEXT.Dispose();
EMPLOYEE_CONTEXT = new Data_Model.Portable_Traps_Entities();
var Employees = EMPLOYEE_CONTEXT.EMPLOYEES
.Where(EMPLOYEES => EMPLOYEES.OFFICE == officeval)
.Where(EMPLOYEES => EMPLOYEES.LASTNAME == lastnameval)
.ToList();
System.Windows.Data.CollectionViewSource eMPLOYEEViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("eMPLOYEEViewSource")));
eMPLOYEEViewSource.Source = EMPLOYEE_CONTEXT.EMPLOYEES.Local;
}
private void streamcomboBox_DropDownOpened(object sender, EventArgs e)
{
if (LakeTextBox.SelectedValue != null)
{
decimal lake = System.Convert.ToDecimal(LakeTextBox.SelectedValue.ToString());
STREAMS_CONTEXT.Dispose();
STREAMS_CONTEXT = new Data_Model.Portable_Traps_Entities();
var Streams = STREAMS_CONTEXT.QRY_PORTABLE_TRAP_SITES_STREAM_LIST
.Where(QRY_PORTABLE_TRAP_SITES_STREAM_LIST => QRY_PORTABLE_TRAP_SITES_STREAM_LIST.LAKE == lake)
.OrderBy(QRY_PORTABLE_TRAP_SITES_STREAM_LIST => QRY_PORTABLE_TRAP_SITES_STREAM_LIST.STREAM_NAME)
.ToList();
CollectionViewSource StreamListViewSource = ((CollectionViewSource)(this.FindResource("StreamListViewSource")));
StreamListViewSource.Source = STREAMS_CONTEXT.QRY_PORTABLE_TRAP_SITES_STREAM_LIST.Local;
}
}
private void lASTNAMEComboBox_DropDownOpened(object sender, EventArgs e)
{
string officeval = oFFICE_NAMEComboBox.SelectedValue.ToString();
OfficeCode = officeval;
//LAST_NAME_CONTEXT.QRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICE.RemoveRange(LAST_NAME_CONTEXT.QRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICE.ToList());
LAST_NAME_CONTEXT.Dispose();
LAST_NAME_CONTEXT = new Data_Model.Portable_Traps_Entities();
var LastNames = LAST_NAME_CONTEXT.QRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICE
.Where(QRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICE => QRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICE.OFFICE == OfficeCode)
.ToList();
System.Windows.Data.CollectionViewSource qRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICEViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("qRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICEViewSource")));
// Load data by setting the CollectionViewSource.Source property:
qRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICEViewSource.Source = LAST_NAME_CONTEXT.QRY_EMPLOYEES_LAST_NAME_LIST_WITH_OFFICE.Local;
}
public string this[string columnName]
{
get
{
string result = null;
if (columnName == "CAPTURE_CODE")
{
bool _ISValidCaptureCode;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidCaptureCode = context.CAPTURE_DESCRIPTIONS.Any(x => x.CAPTURE_CODE == CAPTURE_CODE);
if (CAPTURE_CODE == null)
{
result = "Please enter a Capture Code!";
}
else if (_ISValidCaptureCode == false)
{
result = "Invalid Capture Code!";
}
}
if (columnName == "SPECIES")
{
bool _ISValidSpecies;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidSpecies = context.SPECIES_NAMES.Any(x => x.SPECIES == SPECIES);
if (_ISValidSpecies == false)
{
result = "Invalid Species!";
}
}
return(result);
}
}
public string this[string columnName]
{
get
{
string result = null;
if (columnName == "FIN_CLIP")
{
bool _ISValidFIN_CLIP;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidFIN_CLIP = context.PA_FIN_CLIPS_OF_RECAPTURES.Any(x => x.FIN_CLIP == FIN_CLIP && x.ID == ID);
if (FIN_CLIP == null)
{
result = "Please enter a Fin Clip!";
}
else if (_ISValidFIN_CLIP == true)
{
result = "Duplicate Fin Clip!";
}
}
return(result);
}
}
public string this[string columnName]
{
get
{
string result = null;
if (columnName == "OFFICE")
{
bool _ISValidOffice;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidOffice = context.OFFICES.Any(x => x.OFFICE1 == OFFICE);
if (_ISValidOffice == false)
{
result = "Invalid Office Code!";
}
}
if (columnName == "LAKE")
{
bool _ISValidLake;
string lakedec = System.Convert.ToString(LAKE);
string streamstring = System.Convert.ToString(STREAM);
string sitedec = System.Convert.ToString(TRAP_SITE);
decimal?streamdec = System.Convert.ToDecimal(STREAM);
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidLake = context.PORTABLE_TRAP_SITES.Any(x => x.LAKE == LAKE);
if (_ISValidLake == false)
{
result = "Invalid Lake Code!";
}
}
if (columnName == "STREAM")
{
bool _ISValidStream;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidStream = context.PORTABLE_TRAP_SITES.Any(x => x.LAKE == LAKE && x.STREAM == STREAM);
if (_ISValidStream == false)
{
result = "Invalid Stream Code!";
}
}
if (columnName == "TRAP_SITE")
{
bool _ISValidTrapSite;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidTrapSite = context.PORTABLE_TRAP_SITES.Any(x => x.LAKE == LAKE && x.STREAM == STREAM && x.TRAP_SITE == TRAP_SITE);
if (_ISValidTrapSite == false)
{
result = "Invalid Trap Site!";
}
}
if (columnName == "TIME_FINISHED")
{
Decimal Time = System.Convert.ToDecimal(TIME_FINISHED);
if (Time > 2359)
{
result = "Time must be less than 2400!";
}
}
if (columnName == "TURBIDITY_CODE")
{
bool _ISValidTurbidityCode;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidTurbidityCode = context.TURBIDITIES.Any(x => x.TURBIDITY1 == TURBIDITY_CODE);
if (_ISValidTurbidityCode == false)
{
result = "Turbidity Code is Required!";
}
}
if (columnName == "FLOW_CODE")
{
bool _ISValidFlowCode;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidFlowCode = context.TRAP_FLOW_CODES.Any(x => x.FLOW_CODE == FLOW_CODE);
if (_ISValidFlowCode == false)
{
result = "Flow Code is Required!";
}
}
if (columnName == "PROBLEMS_CODE")
{
bool _ISValidProblemsCode;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidProblemsCode = context.TRAP_PROBLEMS.Any(x => x.PROBLEMS_CODE == PROBLEMS_CODE);
if (_ISValidProblemsCode == false)
{
result = "Problems Code is Required!";
}
}
return(result);
}
}
public string this[string columnName]
{
get
{
string result = null;
if (columnName == "CAPTURE_CODE")
{
bool _ISValidCaptureCode;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidCaptureCode = context.CAPTURE_DESCRIPTIONS.Any(x => x.CAPTURE_CODE == CAPTURE_CODE);
if (CAPTURE_CODE == null)
{
result = "Please enter a Capture Code!";
}
else if (_ISValidCaptureCode == false)
{
result = "Invalid Capture Code!";
}
}
if (columnName == "SPECIES")
{
bool _ISValidSpecies;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidSpecies = context.SPECIES_NAMES.Any(x => x.SPECIES == SPECIES);
if (_ISValidSpecies == false)
{
result = "Invalid Species!";
}
}
if (columnName == "SEX")
{
bool _ISValidGender;
using (Portable_Traps_Entities context = new Portable_Traps_Entities())
_ISValidGender = context.GENDERS.Any(x => x.GENDER1 == SEX);
if (SEX == null)
{
result = "Please enter a Gender!";
}
else if (_ISValidGender == false)
{
result = "Invalid Gender!";
}
}
if (columnName == "LENGTH")
{
if (LENGTH == null)
{
result = "Please enter a Length!";
}
}
if (columnName == "WEIGHT")
{
if (WEIGHT == null)
{
result = "Please enter a Weight!";
}
}
return(result);
}
}
