Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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;
        }
Esempio n. 3
0
        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;
        }
Esempio n. 4
0
        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);
        }