private void ProductGetList()
{
try
{
ProductORM prodORM = new ProductORM();
if (string.IsNullOrEmpty(Request.QueryString["cID"]))
{
dtListProducts.DataSource = prodORM.List();
dtListProducts.DataBind();
dtListSinglePopup.DataSource = prodORM.List();
dtListSinglePopup.DataBind();
}
else
{
dtListProducts.DataSource = prodORM.ProductInCategory(Convert.ToInt32(Request.QueryString["cID"]));
dtListProducts.DataBind();
dtListSinglePopup.DataSource = prodORM.ProductInCategory(Convert.ToInt32(Request.QueryString["cID"]));
dtListSinglePopup.DataBind();
}
}
catch
{
Response.Redirect("Products.aspx");
}
}
private void RelatedProducts(int categoryID)
{
ProductORM prodORM = new ProductORM();
DataTable dt = prodORM.ProductInCategory(categoryID);
foreach (DataRow item in dt.Rows)
{
Entity.Products prod = new Entity.Products
{
ProductID = Convert.ToInt32(item["ProductID"]),
ProductName = item["ProductName"].ToString(),
Description = item["Description"].ToString(),
CategoryID = Convert.ToInt32(item["CategoryID"]),
LargePhotoPath = item["LargePhotoPath"].ToString(),
UnitPrice = Convert.ToDecimal(item["UnitPrice"]),
UnitsInStock = Convert.ToInt32(item["UnitPrice"]),
SmallPhotoPath = item["SmallPhotoPath"].ToString()
};
RelatedProductsList.Add(prod);
}
dtListSinglePopup.DataSource = prodORM.ProductInCategory(categoryID);
dtListSinglePopup.DataBind();
}
void ListViewProductFill(int categoryID)
{
try
{
lstwProducts.Items.Clear();
ProductORM prodORM = new ProductORM();
DataTable dt = prodORM.ProductInCategory(categoryID);
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);
}
}
