public void InsertBook(Book book) { using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(INSERT_BOOK, conn); /* Add parameters into the command */ command.Parameters.AddWithValue("@book_name", book.book_name); command.Parameters.AddWithValue("@book_isbn", book.book_isbn); command.Parameters.AddWithValue("@book_annotation", book.book_annotation); command.Parameters.AddWithValue("@author_id", book.author_id); /* Executes the command */ command.ExecuteNonQuery(); } }
public List<Book> SelectAll() { List<Book> bookList = new List<Book>(); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(SELECT_ALL, conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Book book = new Book(); book.book_id = reader.GetInt32(0); book.book_name = reader.GetString(1); book.book_isbn = reader.GetString(2); book.book_annotation = reader.GetString(3); book.author_id = reader.GetInt32(4); bookList.Add(book); } } return bookList; }
public Book SelectOne(int bookId) { Book book = new Book(); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(SELECT_ONE, conn); command.Parameters.AddWithValue("@book_id", bookId); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { book.book_id = reader.GetInt32(0); book.book_name = reader.GetString(1); book.book_isbn = reader.GetString(2); book.book_annotation = reader.GetString(3); book.author_id = reader.GetInt32(4); } reader.Close(); } return book; }
protected void Button8_Click(object sender, EventArgs e) { //prida do Book DatabaseLibrary.Book book = new DatabaseLibrary.Book(); book.book_name = TextBox_book_name.Text; book.book_isbn = TextBox_book_isbn.Text; book.book_annotation = TextBox_book_annotation.Text; book.author_id = Convert.ToInt32(DropDownList_book_author_id.SelectedValue); new DatabaseLibrary.BookTable().InsertBook(book); Response.Redirect(Request.RawUrl); }