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); } }