private void btnMember_Click(object sender, EventArgs e)
        {
            int borrowerNumber;

            try {
                borrowerNumber = int.Parse(txtBorrowerNumber.Text);
            } catch {
                MessageBox.Show("Borrower number must be a integer!");
                txtBorrowerNumber.Focus();
                return;
            }
            Borrower b = BorowerDAO.GetBorrower(borrowerNumber);

            if (b == null)
            {
                MessageBox.Show(String.Format("Borrower number {0} does't exist!", borrowerNumber));
                txtBorrowerNumber.Focus();
                return;
            }
            txtName.Text = b.Name;


            View();

            displayButtons(2);
        }
        private void btnEdit_Click(object sender, EventArgs e)
        {
            if (dataMember.SelectedRows.Count == 0)
            {
                MessageBox.Show("Please select a rows!");
                return;
            }

            if (btnEdit.Text.Equals("Edit"))
            {
                btnEdit.Text = "Save";
                setEnabled(true);
                txtMemberCode.Enabled = false;
            }
            else
            {
                int      borrowerNumber = int.Parse(txtMemberCode.Text);
                string   name           = txtName.Text;
                char     sex            = char.Parse(txtSex.Text);
                string   address        = txtAddress.Text;
                string   telephone      = txtTelephone.Text;
                string   email          = txtEmail.Text;
                Borrower b = new Borrower(borrowerNumber, name, sex, address, telephone, email);
                if (borowerDAO.Update(b))
                {
                    MessageBox.Show("Edit member done!");
                }
                txtMemberCode.Enabled = true;
                setEnabled(false);
                btnEdit.Text = "Edit";
                displayMember(BorowerDAO.GetDataTable());
            }
        }
 private void btnAdd_Click(object sender, EventArgs e)
 {
     if (btnAdd.Text.Equals("Add"))
     {
         btnAdd.Text = "Save";
         setEnabled(true);
     }
     else
     {
         int      borrowerNumber = int.Parse(txtMemberCode.Text);
         string   name           = txtName.Text;
         char     sex            = char.Parse(txtSex.Text);
         string   address        = txtAddress.Text;
         string   telephone      = txtTelephone.Text;
         string   email          = txtEmail.Text;
         Borrower b = new Borrower(borrowerNumber, name, sex, address, telephone, email);
         if (borowerDAO.Insert(b))
         {
             MessageBox.Show("Insert member done!");
         }
         setEnabled(false);
         btnAdd.Text = "Add";
         displayMember(BorowerDAO.GetDataTable());
     }
 }
        private void displayMember(DataTable memberDAO)
        {
            DataTable dt = BorowerDAO.GetDataTable();
            DataView  dv = new DataView(dt);

            dataMember.DataSource = dt;
        }
        public MemberGUI()
        {
            InitializeComponent();
            borowerDAO = new BorowerDAO();

            displayMember(BorowerDAO.GetDataTable());
        }
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (dataMember.SelectedRows.Count == 0)
            {
                MessageBox.Show("Please select a rows!");
                return;
            }

            string borrowerNumber = txtMemberCode.Text;

            DialogResult dialog = MessageBox.Show("Are you sure you want to delete member with borrowerNumber is " + borrowerNumber, "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);

            if (dialog == DialogResult.OK)
            {
                if (borowerDAO.Delete(int.Parse(borrowerNumber)))
                {
                    MessageBox.Show("Edit member done!");
                    displayMember(BorowerDAO.GetDataTable());
                }
            }
        }
        private void btnMember_Click(object sender, EventArgs e)
        {
            int borrowerNumber;

            try {
                borrowerNumber = int.Parse(txtBorrowerNumber.Text);
            } catch {
                MessageBox.Show("Borrower number must be a integer!");
                txtBorrowerNumber.Focus();
                return;
            }
            Borrower b = BorowerDAO.GetBorrower(borrowerNumber);

            if (b == null)
            {
                MessageBox.Show(String.Format("Borrower number {0} does't exist!", borrowerNumber));
                txtBorrowerNumber.Focus();
                return;
            }
            txtName.Text = b.Name;

            View();

            int n = dataGridView1.Rows.Count - 1;

            MessageBox.Show("Number = " + n);

            if (n >= 5)
            {
                MessageBox.Show("You borrowed 5 books, so you can't borrow any more!");
                txtBorrowerNumber.Focus();
                return;
            }

            displayButtons(2);

            r = null;
            c = null;
        }