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