public void loadData() { lbUser.Text = this.fullname; BookForUserData dao = new BookForUserData(); dtAvailable = dao.GetAllBook(); dvgAvailableBook.DataSource = null; dvgAvailableBook.DataSource = dtAvailable; listBorrowBook = dao.GetBorrowBook(this.username); dvgBorrowing.DataSource = null; dvgBorrowing.DataSource = listBorrowBook; txtId.DataBindings.Clear(); txtName.DataBindings.Clear(); txtPrice.DataBindings.Clear(); txtId.DataBindings.Add("Text", dtAvailable, "BookID"); txtName.DataBindings.Add("Text", dtAvailable, "name"); txtPrice.DataBindings.Add("Text", dtAvailable, "price"); }
private void btnBorrow_Click(object sender, EventArgs e) { List <tempBook> list = this.getTempBook; BookForUserData dao = new BookForUserData(); foreach (tempBook item in list) { bool result = dao.isBorrowBook(item.bookID, this.username); } listBorrowBook = dao.GetBorrowBook(this.username); dvgBorrowing.DataSource = null; dvgBorrowing.DataSource = listBorrowBook; selectedBook = new List <tempBook>(); dvgSelected.DataSource = null; dvgSelected.DataSource = selectedBook; dvgAvailableBook.DataSource = null; dvgAvailableBook.DataSource = dtAvailable; }
private void btnReturn_Click(object sender, EventArgs e) { string bookId = dvgBorrowing.CurrentRow.Cells[0].Value.ToString(); BookForUserData dao = new BookForUserData(); bool result = dao.returnBook(this.username, bookId); if (result) { MessageBox.Show("Return Succesful!"); dtAvailable = dao.GetAllBook(); dvgAvailableBook.DataSource = null; dvgAvailableBook.DataSource = dtAvailable; listBorrowBook = dao.GetBorrowBook(this.username); dvgBorrowing.DataSource = null; dvgBorrowing.DataSource = listBorrowBook; } else { MessageBox.Show("Fail!"); } }
private void btnReturnAll_Click(object sender, EventArgs e) { bool result = false; BookForUserData dao = new BookForUserData(); foreach (tempBook book in listBorrowBook) { result = dao.returnBook(this.username, book.bookID); } if (result) { MessageBox.Show("Return All Success!"); dvgAvailableBook.DataSource = null; dvgAvailableBook.DataSource = dtAvailable; listBorrowBook = dao.GetBorrowBook(this.username); dvgBorrowing.DataSource = null; dvgBorrowing.DataSource = listBorrowBook; } else { MessageBox.Show("Fail!"); } }