private void Button5_Click(object sender, EventArgs e)
{
string searchQuery = txtSearchBox.Text;
//search by book title
if (cmbSearchFilter.SelectedIndex == 0)
{
bookSearchGridView.DataSource = SelectQueries.SearchBookByTitle(searchQuery);
}
//search by author
if (cmbSearchFilter.SelectedIndex == 1)
{
bookSearchGridView.DataSource = SelectQueries.SearchBookByAuthor(searchQuery);
}
//search by publisher
if (cmbSearchFilter.SelectedIndex == 2)
{
bookSearchGridView.DataSource = SelectQueries.SearchBookByPublisher(searchQuery);
}
//search by category
if (cmbSearchFilter.SelectedIndex == 3)
{
bookSearchGridView.DataSource = SelectQueries.SearchBookByCategory(searchQuery);
}
if (bookSearchGridView.Rows.Count == 1)
{
MessageBox.Show("Book not found.\n Please try searching again", "NOT FOUND"
, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("Book Found", "FOUND", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Button2_Click(object sender, EventArgs e)
{
string searchQuery = txtBoxSearch.Text;
DataTable dt = new DataTable();
//search by book title
if (cmbFilter.SelectedIndex == 0)
{
dt = SelectQueries.SearchBookByTitle(searchQuery);
bookSearchGridView.DataSource = dt;
}
//search by author
if (cmbFilter.SelectedIndex == 1)
{
dt = SelectQueries.SearchBookByAuthor(searchQuery);
bookSearchGridView.DataSource = dt;
}
//search by publisher
if (cmbFilter.SelectedIndex == 2)
{
dt = SelectQueries.SearchBookByPublisher(searchQuery);
bookSearchGridView.DataSource = dt;
}
//search by category
if (cmbFilter.SelectedIndex == 3)
{
dt = SelectQueries.SearchBookByCategory(searchQuery);
bookSearchGridView.DataSource = dt;
}
if (bookSearchGridView.Rows.Count == 1)
{
lblMsg.Text = "Book not found!";
MessageBox.Show("Book not found.\n Please try searching again", "NOT FOUND"
, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
lblMsg.Text = "Book Found";
MessageBox.Show("Book Found", "FOUND", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbBookID.ValueMember = "book_id";
cmbBookID.DisplayMember = "book_id";
cmbBookID.DataSource = dt;
}
}