public void classicBtnSearch(object sender, EventArgs e)
{
searchPanel.Controls.Clear();
DataTable dt = getBooksByGenre("Fiction/Classic");
if (dt != null)
{
//display search page
welcomePanel.Visible = false;
searchPanel.Visible = true;
myOrdersPanel.Visible = false;
SearchBookItem sb;
foreach (DataRow row in dt.Rows)
{
sb = new SearchBookItem(UserID);
sb.BookTitle = row[0].ToString();
sb.BookAuthor = row[1].ToString();
sb.BookPublisher = row[4].ToString();
sb.BookPages = row[2].ToString();
sb.BookGenre = row[3].ToString();
sb.BookPrice = row[5].ToString();
sb.BookID = row[6].ToString();
sb.Dock = DockStyle.Top;
searchPanel.Controls.Add(sb);
}
}
}
public void searchBooks(object sender, EventArgs e)
{
myCartButton.BackColor = Color.FromArgb(9, 132, 227);
aMyOrders.BackColor = Color.FromArgb(9, 132, 227);
searchPanel.Controls.Clear();
//clear other pages
myOrdersPanel.Visible = false;
welcomePanel.Visible = false;
searchPanel.Visible = true;
//get data
DataTable dt = SQL.SQLcommand(@"Select * from books");
if (dt != null)
{
SearchBookItem sb;
foreach (DataRow row in dt.Rows)
{
if (resultMatch(aSearchBar.Text, row))
{
sb = new SearchBookItem(UserID);
sb.BookTitle = row[0].ToString();
sb.BookAuthor = row[1].ToString();
sb.BookPublisher = row[4].ToString();
sb.BookPages = row[2].ToString();
sb.BookGenre = row[3].ToString();
sb.BookPrice = row[5].ToString();
sb.BookID = row[6].ToString();
sb.Dock = DockStyle.Top;
searchPanel.Controls.Add(sb);
}
}
}
}
