private void btnView_Click(object sender, RoutedEventArgs e)
{
// Database - Program Declaration
DatabaseConnection connection = new DatabaseConnection();
HerbariumSheet herbariumSheet = dgrHerbariumSheets.SelectedValue as HerbariumSheet;
// Query Command Setting
connection.setQuery("SELECT strAccessionNumber, picHerbariumSheet, strBoxNumber, strFamilyName, strScientificName, " +
"strCommonName, dateCollected, dateDeposited, dateVerified, strFullLocality, " +
"strCollector, strValidator, strDescription, boolLoanAvailable, strStatus " +
"FROM viewHerbariumInventory " +
"WHERE strAccessionNumber = @accessionNo");
connection.addParameter("@accessionNo", SqlDbType.VarChar, herbariumSheet.AccessionNumber);
// Query Execution
SqlDataReader sqlData = connection.executeResult();
// Query Result
while (sqlData.Read())
{
try
{
byte[] tempBlob = (byte[])sqlData[1];
picHerbariumSheet.Source = getHerbariumSheet(tempBlob);
}
catch (Exception) { }
lblAccessionNumber.Text = sqlData[0].ToString();
lblBox.Text = sqlData[2].ToString();
lblFamilyName.Text = " [" + sqlData[3].ToString() + "]";
lblScientificName.Text = sqlData[4].ToString();
lblCommonName.Text = sqlData[5].ToString();
lblDateCollected.Text = sqlData[6].ToString();
lblDateDeposited.Text = sqlData[7].ToString();
lblDateVerified.Text = sqlData[8].ToString();
lblLocality.Text = sqlData[9].ToString();
lblCollector.Text = sqlData[10].ToString();
lblValidator.Text = sqlData[11].ToString();
lblDescription.Text = sqlData[12].ToString();
lblAvail.Text = (bool)sqlData[13] ? "Available" : "Not Available";
lblStatus.Text = sqlData[14].ToString();
btnAvail.Visibility = (sqlData[14].ToString() == "Loaned") ? Visibility.Hidden : Visibility.Visible;
pnlPlantDeposit.Visibility = Visibility.Visible;
}
connection.closeResult();
}
private void ContentDialog_PrimaryButtonClick(ContentDialog sender, ContentDialogButtonClickEventArgs args)
{
bool WithDamage = false;
string message = "";
int UpdateSheetResult = 0;
foreach (var item in dgrLoanedSheets.ItemsSource)
{
HerbariumSheet Record = item as HerbariumSheet;
Record.IsChecked = !Record.IsChecked;
UpdateSheetResult = Record.UpdateReturnedSheets(PlantLoanData.LoanNumber);
if (!Record.IsChecked)
{
WithDamage = true;
}
if (UpdateSheetResult == 1)
{
break;
}
}
if (UpdateSheetResult == 0)
{
TransactionResult = PlantLoanData.ReturnPlantLoan(WithDamage);
switch (TransactionResult)
{
case 0:
message = "Loaned Species are now returned to the center";
break;
case 1:
message = "[2/2] Transaction Failed, The system had run to an Error";
break;
}
MessageDialog dialog = new MessageDialog(message, "Process Done");
var result = dialog.ShowAsync();
}
else
{
MessageDialog dialog = new MessageDialog("[1/2] Transaction Failed, The system had run to an Error", "Process Done");
var result = dialog.ShowAsync();
}
}
// Methods
public void ToggleStatus(HerbariumSheet sheet)
{
switch (sheet.Status)
{
case "For Verification":
lblLocation.Text = "Plant Verification";
Row03.Height = new GridLength(0);
Row04.Height = new GridLength(0);
Row05.Height = new GridLength(0);
Row06.Height = new GridLength(0);
Row07.Height = new GridLength(0);
Row08.Height = new GridLength(0);
Row09.Height = new GridLength(0);
Row12.Height = new GridLength(0);
Row15.Height = new GridLength(0);
Row18.Height = new GridLength(0);
Row20.Height = new GridLength(0);
Row21.Height = new GridLength(0);
break;
case "Further Verification":
lblLocation.Text = "External Verification";
Row03.Height = new GridLength(0);
Row05.Height = new GridLength(0);
Row06.Height = new GridLength(0);
Row07.Height = new GridLength(0);
Row09.Height = new GridLength(0);
Row12.Height = new GridLength(0);
Row15.Height = new GridLength(0);
Row18.Height = new GridLength(0);
Row20.Height = new GridLength(0);
Row21.Height = new GridLength(0);
break;
case "Verified":
lblLocation.Text = "Plant Classification";
Row04.Height = new GridLength(0);
Row05.Height = new GridLength(0);
Row08.Height = new GridLength(0);
Row12.Height = new GridLength(0);
Row20.Height = new GridLength(0);
Row21.Height = new GridLength(0);
break;
case "Stored":
lblLocation.Text = "Herbarium Inventory at " + sheet.BoxLocation;
Row04.Height = new GridLength(0);
Row08.Height = new GridLength(0);
Row12.Height = new GridLength(0);
Row20.Height = new GridLength(0);
break;
case "Loaned":
lblLocation.Text = "Loaned by " + sheet.Borrower;
Row04.Height = new GridLength(0);
Row08.Height = new GridLength(0);
break;
case "Damaged":
lblLocation.Text = "Herbarium Inventory at " + sheet.BoxLocation;
Row04.Height = new GridLength(0);
Row08.Height = new GridLength(0);
Row12.Height = new GridLength(0);
Row20.Height = new GridLength(0);
break;
default:
break;
}
}
private void ClearForm()
{
FamilyBoxes = new HerbariumBox().GetAvailableBoxes();
VerifiedSheetData = new HerbariumSheet();
}
// Methods
private void ClearForm()
{
HerbariumSheetData = new HerbariumSheet();
HerbariumBoxes = new HerbariumBox().GetAvailableBoxes();
}
private void btnClassify_Click(object sender, RoutedEventArgs e)
{
getAvailableBoxes();
// Database - Program Declaration
DatabaseConnection connection = new DatabaseConnection();
HerbariumSheet herbariumSheet = dgrHerbariumSheets.SelectedValue as HerbariumSheet;
// Query Command Setting
connection.setQuery("SELECT strAccessionNumber, strReferenceAccession, picHerbariumSheet, " +
"strFamilyName, strScientificName, strCommonName, CONVERT(VARCHAR, dateCollected, 107), " +
"CONVERT(VARCHAR, dateDeposited, 107), CONVERT(VARCHAR, dateVerified, 107), strFullLocality, " +
"strCollector, strValidator, strDescription " +
"FROM viewHerbariumSheet " +
"WHERE strAccessionNumber = @accessionNo");
connection.addParameter("@accessionNo", SqlDbType.VarChar, herbariumSheet.AccessionNumber);
// Query Execution
SqlDataReader sqlData = connection.executeResult();
// Query Result
while (sqlData.Read())
{
string family = sqlData[3].ToString();
var result = from box in availableBoxes
where box.Family == family
where box.BoxLimit > 0
select box.BoxNumber;
if (result.Count() == 0)
{
MessageBox.Show("No Available Family Box for this Herbarium Sheet");
}
else
{
try
{
byte[] tempBlob = (byte[])sqlData[2];
picHerbariumSheet.Source = getHerbariumSheet(tempBlob);
} catch (Exception) { }
lblAccessionNumber.Text = sqlData[0].ToString();
lblReferenceNumber.Text = sqlData[1].ToString();
lblScientificName.Text = sqlData[4].ToString();
lblCommonName.Text = sqlData[5].ToString();
lblDateCollected.Text = sqlData[6].ToString();
lblDateDeposited.Text = sqlData[7].ToString();
lblDateVerified.Text = sqlData[8].ToString();
lblLocality.Text = sqlData[9].ToString();
lblCollector.Text = sqlData[10].ToString();
lblValidator.Text = sqlData[11].ToString();
lblDescription.Text = sqlData[12].ToString();
lblBox.Text = result.First();
lblFamilyName.Text = " [" + sqlData[3].ToString() + "]";
pnlPlantDeposit.Visibility = Visibility.Visible;
}
}
connection.closeResult();
}
