public void changeAvailability(string AccessionNumber, bool AvailableStatus)
{
DatabaseConnection connection = new DatabaseConnection();
connection.setQuery("UPDATE tblStoredHerbarium " +
"SET boolLoanAvailable = @availability " +
"WHERE intHerbariumSheetID = (SELECT intHerbariumSheetID " +
"FROM viewHerbariumSheet " +
"WHERE strAccessionNumber = @accessionNumber)");
connection.addParameter("@availability", SqlDbType.Bit, AvailableStatus);
connection.addParameter("@accessionNumber", SqlDbType.VarChar, AccessionNumber);
connection.executeCommand();
string message = AvailableStatus ?
"Herbarium Sheet is Now Available for Loaning" :
"Herbarium Sheet is Now Unavailable for Loaning";
MessageBox.Show(message, "Record Saved", MessageBoxButton.OK, MessageBoxImage.Information);
pnlPlantDeposit.Visibility = Visibility.Hidden;
btnReturn_Click(btnReturn, null);
getFamilyBoxes();
}
