//add books to user's borrowed book list protected void GridView_Book_RowCommand(object sender, GridViewCommandEventArgs e) { conn = new OleDbConnection(connectionString); string bookID = null; try { if (e.CommandName == "BorrowBook") { string bookTitle = e.CommandArgument.ToString(); conn.Open(); cmd = new OleDbCommand("Select ID FROM Book where BookName='" + bookTitle + "'", conn); int x = (int)cmd.ExecuteScalar(); if (x != 0) { bookID = cmd.ExecuteScalar().ToString(); } OleDbCommand insertIntoBorrowedBooks = new OleDbCommand("insert into BorrowedBook([BorrowedBookID],[BorrowedUserID],[State],[BorrowDate]) values (?,?,?,?)", conn); insertIntoBorrowedBooks.Parameters.Add(new OleDbParameter("BorrowedBookID", int.Parse(bookID))); insertIntoBorrowedBooks.Parameters.Add(new OleDbParameter("BorrowedUserID", int.Parse(Session["userID"].ToString()))); insertIntoBorrowedBooks.Parameters.Add(new OleDbParameter("State", OleDbType.Boolean)).Value = true; insertIntoBorrowedBooks.Parameters.Add(new OleDbParameter("BorrowDate", OleDbType.Date)).Value = System.DateTime.Now; insertIntoBorrowedBooks.ExecuteNonQuery(); conn.Close(); GridView_Book.DataBind(); } } catch (Exception exp1) { Label2.Text = exp1.Message; } }
protected void btn_addBook_Click(object sender, EventArgs e) { OleDbConnection connection = new OleDbConnection(connectionString); try { connection.Open(); OleDbCommand insert = new OleDbCommand(); insert.Connection = connection; insert.CommandType = CommandType.Text; insert.CommandText = "insert into Book ([BookName],[BookAuthor],[BookPublishedIn],[ISBN],[BookEdition],[BookCategory]) values (?,?,?,?,?,?)"; insert.Parameters.Add(new OleDbParameter("BookName", txt_bookTitle.Text)); insert.Parameters.Add(new OleDbParameter("BookAuthor", txt_bookAuthor.Text)); insert.Parameters.Add(new OleDbParameter("BookPublishedIn", int.Parse(txt_year.Text))); insert.Parameters.Add(new OleDbParameter("ISBN", int.Parse(txt_isbn.Text))); insert.Parameters.Add(new OleDbParameter("BookEdition", txt_volume.Text)); insert.Parameters.Add(new OleDbParameter("BookCategory", int.Parse(droplist_bookCategory.SelectedValue))); insert.ExecuteNonQuery(); lbl_errorAddBook.Text = "Successfully added a new book!"; connection.Close(); GridView_Book.DataBind(); } catch { } }
protected void BookViewTypes_SelectedIndexChanged(object sender, EventArgs e) { if (BookViewTypes.SelectedValue == "AllBook") { GridView_Book.DataSourceID = "DataSource_AllBook"; GridView_Book.DataBind(); //disable the borrowed books foreach (GridViewRow row in GridView_Book.Rows) { if (row.RowType == DataControlRowType.DataRow) { string bookTitle = row.Cells[1].Text; if (bookTitle != null && bookIsBorrowed(bookTitle) == true) { LinkButton theButton = (LinkButton)row.FindControl("btn_borrowBook"); if (theButton != null) { theButton.Enabled = false; theButton.Text = "Borrowed"; } } } } } if (BookViewTypes.SelectedValue == "AvailableBook") { GridView_Book.DataSourceID = "DataSource_AvailableBook"; GridView_Book.DataBind(); //for all available book make enable borrow book button foreach (GridViewRow row in GridView_Book.Rows) { if (row.RowType == DataControlRowType.DataRow) { LinkButton theLinkButton = (LinkButton)row.FindControl("btn_borrowBook"); if (theLinkButton != null) { theLinkButton.Enabled = true; } } } } if (BookViewTypes.SelectedValue == "BorrowedBook") { GridView_Book.DataSourceID = "DataSource_BorrowedBook"; GridView_Book.DataBind(); //for all borrowed book show that its borrowed and disable the borrow book button foreach (GridViewRow row in GridView_Book.Rows) { if (row.RowType == DataControlRowType.DataRow) { LinkButton theButton = (LinkButton)row.FindControl("btn_borrowBook"); if (theButton != null) { theButton.Enabled = false; theButton.Text = "Borrowed"; } } } } }