private void textBox2_TextChanged(object sender, EventArgs e)
{
string keywords = txtBoxHistoryOrderSearch.Text;
dgvHistoryOrder.DataSource = null;
dgvHistoryOrder.Rows.Clear();
//check if the keywords has value
if (keywords != null)
{
//Show user based on keywords
DataTable dataTableHistoryOrder = transactionDAL.SearchHistoryTransactions(keywords);
foreach (DataRow row in dataTableHistoryOrder.Rows)
{
if (row["type"].ToString() == "Dùng t?i quán")
{
dgvHistoryOrder.Rows.Add(row["id"].ToString(), row["customer_name"].ToString(), row["customer_contact"].ToString(), "Dùng tại quán", row["grandTotal"].ToString(), row["transaction_date"].ToString(), row["added_by"].ToString());
}
else if (row["type"].ToString() == "Mang di")
{
dgvHistoryOrder.Rows.Add(row["id"].ToString(), row["customer_name"].ToString(), row["customer_contact"].ToString(), "Mang đi", row["grandTotal"].ToString(), row["transaction_date"].ToString(), row["added_by"].ToString());
}
else
{
dgvHistoryOrder.Rows.Add(row["id"].ToString(), row["customer_name"].ToString(), row["customer_contact"].ToString(), "Giao hàng", row["grandTotal"].ToString(), row["transaction_date"].ToString(), row["added_by"].ToString());
}
}
}
else
{
//show all users from the database
DataTable dataTableHistoryOrder = transactionDAL.DisplayHistoryTransaction();
foreach (DataRow row in dataTableHistoryOrder.Rows)
{
if (row["type"].ToString() == "Dùng t?i quán")
{
dgvHistoryOrder.Rows.Add(row["id"].ToString(), row["customer_name"].ToString(), row["customer_contact"].ToString(), "Dùng tại quán", row["grandTotal"].ToString(), row["transaction_date"].ToString(), row["added_by"].ToString());
}
else if (row["type"].ToString() == "Mang di")
{
dgvHistoryOrder.Rows.Add(row["id"].ToString(), row["customer_name"].ToString(), row["customer_contact"].ToString(), "Mang đi", row["grandTotal"].ToString(), row["transaction_date"].ToString(), row["added_by"].ToString());
}
else
{
dgvHistoryOrder.Rows.Add(row["id"].ToString(), row["customer_name"].ToString(), row["customer_contact"].ToString(), "Giao hàng", row["grandTotal"].ToString(), row["transaction_date"].ToString(), row["added_by"].ToString());
}
}
}
}
