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