private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (validateLoanSpecies())
{
MessageBoxResult response = MessageBox.Show("Do you want to Process this Loan Transaction?",
"Confirm Transaction",
MessageBoxButton.YesNo,
MessageBoxImage.Question);
if (response == MessageBoxResult.Yes)
{
int status;
string loanStatus = (StaticData.role == "STUDENT ASSISTANT") ? "Requesting" : "Approved";
string loanNumber = "";
DatabaseConnection connection = new DatabaseConnection();
connection.setStoredProc("dbo.procProcessLoan");
connection.addSprocParameter("@collectorName", SqlDbType.VarChar, lblCollector.Text);
connection.addSprocParameter("@startDate", SqlDbType.Date, loanDate);
connection.addSprocParameter("@endDate", SqlDbType.Date, returnDate);
connection.addSprocParameter("@purpose", SqlDbType.VarChar, lblPurpose.Text);
connection.addSprocParameter("@status", SqlDbType.VarChar, loanStatus);
status = connection.executeProcedure();
if (status == 0)
{
connection.setQuery("SELECT strLoanNumber " +
"FROM viewPlantLoans " +
"WHERE strCollector = @collector AND dateLoan = @startdate AND dateReturning = @enddate");
connection.addParameter("@collector", SqlDbType.VarChar, lblCollector.Text);
connection.addParameter("@startdate", SqlDbType.Date, loanDate);
connection.addParameter("@enddate", SqlDbType.Date, returnDate);
SqlDataReader sqlData = connection.executeResult();
while (sqlData.Read())
{
loanNumber = sqlData[0].ToString();
}
connection.closeResult();
foreach (ListSpecies list in dgrTaxonSpecies.Items)
{
if (list.IsChecked)
{
connection.setStoredProc("dbo.procLoanPlants");
connection.addSprocParameter("@loanNumber", SqlDbType.VarChar, loanNumber);
connection.addSprocParameter("@taxonName", SqlDbType.VarChar, list.TaxonName);
connection.addSprocParameter("@copies", SqlDbType.Int, list.Copies);
status = connection.executeProcedure();
if (status == 1)
{
break;
}
}
}
switch (status)
{
case 0:
MessageBox.Show("Plant Deposit Transaction Processed Successfully");
break;
case 1:
MessageBox.Show("Plant Deposit Transaction Processed with Some Error Records");
break;
}
}
else
{
MessageBox.Show("The System had run to an Error");
}
}
pnlPlantLoaningForm.Visibility = Visibility.Hidden;
getLoanTable();
}
}
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();
}