private void FORMAdjustments_Modify_Load(object sender, System.EventArgs e)
{
//Set Edit OleDbCommand
cmdAdjustBook = new OleDbCommand("UPDATE tblBooks SET Qty =@getQty, Barrowed =@getBarrowed WHERE BookNo LIKE '" + sBookID + "' ", clsConnections.CN);
FillFields();
cmdAdjustBook.Parameters.Add("@getQty", OleDbType.Double);
cmdAdjustBook.Parameters.Add("@getBarrowed", OleDbType.Double);
publicBooksList = this;
}
private void bttnAdjust_Click(object sender, System.EventArgs e)
{
if (lvBooks.Items.Count > 0)
{
try
{
FORMAdjustments_Modify.sBookID = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[0].Text;
FORMAdjustments_Modify.sISBN = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[1].Text;
FORMAdjustments_Modify.sBookTitle = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[2].Text;
FORMAdjustments_Modify.sQuantity = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[3].Text;
FORMAdjustments_Modify.sBarrowed = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[4].Text;
FORMAdjustments_Modify.sAvailable = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[5].Text;
FORMAdjustments_Modify sForm = new FORMAdjustments_Modify();
sForm.ShowDialog();
}
catch (ArgumentOutOfRangeException aooreE) { MessageBox.Show("" + aooreE.Message); }
catch (NullReferenceException nreE) {}
}
else
{
MessageBox.Show("No record to edit.", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
