} //End Update
//Method to prompt user more books to be returned for same Member?
public void returnMoreBooks()
{
//Check if RowCount is not equal to 1.
//1 indicate that there is only one book left on grdLoanItemList
if (grdLoanItemList.RowCount != 1)
{
DialogResult result = MessageBox.Show("More books to be return for Member '" + txtMemName.Text + "'?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//Display Loan Items on DataGridView for the selected Member
//Initiate DataSet Object
DataSet ds = new DataSet();
//Reload data onto DataGridView
//LoanItemList
grdLoanItemList.DataSource = LoanItems.getLoanItems(ds, intMemID).Tables["loan"];
//Display UI
grpLoanItemList.Visible = true;
//Hide grpLoanDetails and grpFineDetails
grpLoanDetails.Visible = false;
btnReturn.Visible = true;
grpFineDetails.Visible = false;
}
else
{
//Reset UI because Member may return only one book
clearUI();
}
}
else
{
//Display Information Message
MessageBox.Show("All books has been returned", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
//Reset UI
clearUI();
}
} //End Method
} //End Search Member Button Event
//MemList cell click event
private void grdMemList_CellClick(object sender, DataGridViewCellEventArgs e)
{
//Extract MemID from column 0 of selected row
intMemID = Convert.ToInt32(grdMemList.Rows[grdMemList.CurrentCell.RowIndex].Cells[0].Value);
//Instantiate Members object
Members aMember = new Members();
aMember.getMember(intMemID);
String strName = aMember.getForename() + " " + aMember.getSurname();
//Display Loan Items on DataGridView for the selected Member
//Initiate DataSet Object
DataSet ds = new DataSet();
//Load data onto DataGridView
//LoanItemList
grdLoanItemList.DataSource = LoanItems.getLoanItems(ds, intMemID).Tables["loan"];
if (grdLoanItemList.DataSource == null || grdLoanItemList.RowCount == 0)
{
//Display error message if no data returned
MessageBox.Show("No Rental Items found for Member '" + strName + "'", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
grpLoanItemList.Visible = false;
grpLoanDetails.Visible = false;
txtSurname.Focus();
}
else
{
//Display UI
grpLoanItemList.Visible = true;
//Disable Sorting when clicking Column Header
foreach (DataGridViewColumn column in grdLoanItemList.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
} //End Cell Click Event
