private void DeleteBookBtn_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(bookComboBox.Text))
            {
                MessageBox.Show("Please select a book");
                return;
            }

            //Get the selected book
            Book selectedBook = (Book)bookComboBox.SelectedItem;

            string message = $"Are you sure you want to delete {selectedBook.Title} {selectedBook.ISBN}?";

            DialogResult result = MessageBox.Show(text: message,
                                                  caption: "Delete?",
                                                  buttons: MessageBoxButtons.YesNo,
                                                  icon: MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                try
                {
                    //Remove in database
                    BookDB.Delete(selectedBook.ISBN);

                    //Remove from the list
                    customerComboBox.Items.Remove(selectedBook);

                    MessageBox.Show("Book deleted");

                    PopulateBookList();

                    bookComboBox.Text = "";
                }
                catch (SqlException)
                {
                    MessageBox.Show("Delete unsuccessful. The book you are trying to delete is currently registered to a customer.");
                }
                catch (Exception)
                {
                    MessageBox.Show("No books deleted");
                }
            }
        }