private void SearchProducts()
{
ProductORM prodORM = new ProductORM();
dtListProducts.DataSource = prodORM.ProductSearch(Request.Form["Search"]);
dtListProducts.DataBind();
}
void ListViewProductFill(int categoryID, string searchText)
{
try
{
lstwProducts.Items.Clear();
ProductORM prodORM = new ProductORM();
DataTable dt = prodORM.ProductSearch(categoryID, searchText);
foreach (DataRow item in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Tag = item["ProductID"].ToString();
li.Text = item["ProductName"].ToString();
li.SubItems.Add(item["UnitPrice"].ToString());
li.SubItems.Add(item["QuantityPerUnit"].ToString());
if (Convert.ToInt32(item["UnitsInStock"]) < 15)
{
li.SubItems.Add(item["UnitsInStock"].ToString());
li.BackColor = Color.Red;
}
else
{
li.SubItems.Add(item["UnitsInStock"].ToString());
}
li.SubItems.Add(item["CategoryName"].ToString());
lstwProducts.Items.Add(li);
}
lstwProducts.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("Ürünleri Listeleme İşleminde Bir Hata İle Karşılaşıldı");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
