// Methods private void ClearForm() { RejectedDepositData = new PlantDeposit(); cbxPlantType.ItemsSource = new PlantType().GetPlantTypeList(); cbxLocality.ItemsSource = new PlantLocality().GetLocalityList(); }
private bool isDuplicateHerbarium(PlantDeposit deposit, ref string refAccession, ref string taxonName) { bool result; DatabaseConnection connection = new DatabaseConnection(); connection.setQuery("SELECT DISTINCT strReferenceAccession, strScientificName " + "FROM viewHerbariumSheet " + "WHERE strCollector = @collector " + "AND strFullLocality = @locality " + "AND dateCollected = @dateCollected " + "AND strDescription = @description"); connection.addParameter("@collector", SqlDbType.VarChar, deposit.Collector); connection.addParameter("@locality", SqlDbType.VarChar, deposit.Locality); connection.addParameter("@dateCollected", SqlDbType.Date, deposit.DateCollected); connection.addParameter("@description", SqlDbType.VarChar, deposit.Description); SqlDataReader sqlData = connection.executeResult(); while (sqlData.Read()) { refAccession = sqlData[0].ToString(); taxonName = sqlData[1].ToString(); } result = sqlData.HasRows; connection.closeResult(); return(result); }
// Methods private void ClearForm() { cbxTaxonName.ItemsSource = new TaxonSpecies().GetTaxonList(); cbxValidator.ItemsSource = new Validator().GetValidatorList(); cbxReferenceAccession.ItemsSource = null; VerifyingDepositData = new PlantDeposit(); }
private void btnVerify_Click(object sender, RoutedEventArgs e) { // Database - Program Declaration DatabaseConnection connection = new DatabaseConnection(); PlantDeposit plantDeposit = dgrVerifyingDeposit.SelectedValue as PlantDeposit; // Query Command Setting connection.setQuery("SELECT strAccessionNumber, picHerbariumSheet, " + "CONVERT(VARCHAR, dateCollected, 107), CONVERT(VARCHAR, dateDeposited, 107), " + "strFullLocality, strCollector, strDescription " + "FROM viewPlantDeposit " + "WHERE strAccessionNumber = @accessionNo"); connection.addParameter("@accessionNo", SqlDbType.VarChar, plantDeposit.AccessionNumber); // Query Execution SqlDataReader sqlData = connection.executeResult(); // Query Result pnlPlantDeposit.Visibility = Visibility.Visible; while (sqlData.Read()) { try { byte[] tempBlob = (byte[])sqlData[1]; picHerbariumSheet.Source = getHerbariumSheet(tempBlob); } catch (Exception) { } lblAccessionNumber.Text = sqlData[0].ToString(); lblDateCollected.Text = sqlData[2].ToString(); lblDateDeposited.Text = sqlData[3].ToString(); lblLocality.Text = sqlData[4].ToString(); lblCollector.Text = sqlData[5].ToString(); lblDescription.Text = sqlData[6].ToString(); plantDetails.AccessionNumber = sqlData[0].ToString(); plantDetails.DateCollected = sqlData[2].ToString(); plantDetails.DateDeposited = sqlData[3].ToString(); plantDetails.Locality = sqlData[4].ToString(); plantDetails.Collector = sqlData[5].ToString(); plantDetails.Description = sqlData[6].ToString(); } connection.closeResult(); getSpeciesList(); }
// Methods private void ClearForm() { isFileUpload = false; picHerbariumSheet.Source = null; NewDepositData = new PlantDeposit(); btnIsVerifiedDeposit.IsOn = false; msgOrgAccessionNo.Visibility = Visibility.Collapsed; msgNewAccessionNo.Visibility = Visibility.Collapsed; msgPlantType.Visibility = Visibility.Collapsed; msgScientifcName.Visibility = Visibility.Collapsed; msgCollector.Visibility = Visibility.Collapsed; msgValidator.Visibility = Visibility.Collapsed; msgLocality.Visibility = Visibility.Collapsed; msgDescription.Visibility = Visibility.Collapsed; cbxCollector.ItemsSource = new Collector().GetCollectorList(); cbxLocality.ItemsSource = new PlantLocality().GetLocalityList(); cbxPlantType.ItemsSource = new PlantType().GetPlantTypeList(); cbxScientificName.ItemsSource = new TaxonSpecies().GetTaxonList(); cbxValidator.ItemsSource = new Validator().GetValidatorList(); speciesAuthors = new SpeciesAuthor().GetAuthors(); }
// Methods private void ClearForm() => ReceivedDepositData = new PlantDeposit();