} //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