// 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();
