private void btnUpdate_Click(object sender, EventArgs e) { foreach (ListViewItem item in lstwProducts.SelectedItems) { pro = item.Tag as Entity.Products; } pro.ProductName = txtProductName.Text; pro.UnitPrice = nudUnitPrice.Value; pro.UnitsInStock = int.Parse(nudUnitsInStock.Value.ToString()); pro.id = pro.id; Entity.Categories seciliCat = cbCategori.SelectedItem as Entity.Categories; pro.CategoryID = seciliCat.id; Entity.Suppliers seciliSup = cbSupplier.SelectedItem as Entity.Suppliers; pro.SupplierID = seciliSup.id; int result = proDAL.Update(pro); MessageBox.Show(result.ToString() + " satır etkilendi."); pro.ListViewDoldur(lstwProducts); Entity.Entity en = new Entity.Entity(); en.Temizle(groupBox1); en.Temizle(groupBox2); }
public Products SingleProduct(int selectedID) { SqlCommand cmd = new SqlCommand("pr_SelectedProduct_List", Tools.Connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProductID", selectedID); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); Products singleProduct = new Products(); if (reader.HasRows) { while (reader.Read()) { singleProduct = new Entity.Products { ProductID = Convert.ToInt32(reader["ProductID"]), ProductName = reader["ProductName"].ToString(), Description = reader["Description"].ToString(), CategoryID = Convert.ToInt32(reader["CategoryID"]), LargePhotoPath = reader["LargePhotoPath"].ToString(), UnitPrice = Convert.ToDecimal(reader["UnitPrice"]), UnitsInStock = Convert.ToInt32(reader["UnitsInStock"]), SmallPhotoPath = reader["SmallPhotoPath"].ToString() }; } } cmd.Connection.Close(); return(singleProduct); }
protected void btnProductInsert_Click(object sender, EventArgs e) { try { bool result = false; if (btnProductInsert.Text == "Güncelle") { Entity.Products prod = new Entity.Products { ProductID = Convert.ToInt32(Session["ProductID"]), ProductName = txtProductName.Value, Description = txtProductAciklama.Value, UnitPrice = Convert.ToDecimal(txtProductPrice.Value), UnitsInStock = int.Parse(txtProductUnitsInStock.Value), CategoryID = int.Parse(drpCategory.SelectedItem.Value), SmallPhotoPath = "Content/User/images/small/" + photoUpload.FileName, LargePhotoPath = "Content/User/images/large/" + photoUpload.FileName }; ProductORM prodORM = new ProductORM(); result = prodORM.Update(prod); photoUpload.SaveAs(Server.MapPath("~/Content/User/images/large/" + photoUpload.FileName)); } else { Entity.Products prod = new Entity.Products { ProductName = txtProductName.Value, Description = txtProductAciklama.Value, UnitPrice = Convert.ToDecimal(txtProductPrice.Value), UnitsInStock = int.Parse(txtProductUnitsInStock.Value), CategoryID = int.Parse(drpCategory.SelectedItem.Value), SmallPhotoPath = "Content/User/images/small/" + photoUpload.FileName, LargePhotoPath = "Content/User/images/large/" + photoUpload.FileName }; ProductORM prodORM = new ProductORM(); result = prodORM.Insert(prod); photoUpload.SaveAs(Server.MapPath("~/Content/User/images/large/" + photoUpload.FileName)); } if (result) { eklemeBilgi.Visible = true; eklemeBilgi.InnerText = "İşleminiz Başarıyla Gerçekleştirildi."; } else { eklemeBilgi.Visible = true; eklemeBilgi.InnerText = "İşleminiz Gerçekleştirilemedi."; } } catch { } }
private void silToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult answer = MessageBox.Show("Silmek istediğinize emin misiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Stop); if (answer == DialogResult.Yes) { foreach (ListViewItem li in lstwProducts.SelectedItems) { pro = li.Tag as Entity.Products; pro.id = pro.id; } proDAL.Delete(pro.id); pro.ListViewDoldur(lstwProducts); } }
private void SelectedProductGet() { try { if (string.IsNullOrEmpty(Request.QueryString["pID"])) { Response.Redirect("Products.aspx"); return; } ProductORM prodORM = new ProductORM(); selectedProduct = prodORM.SingleProduct(int.Parse(Request.QueryString["pID"])); } catch { Response.Redirect("Products.aspx"); } }
private void ProductUpdateItem() { if (Session["ProductID"] != null) { ProductORM prodORM = new ProductORM(); Entity.Products prod = prodORM.SingleProduct(Convert.ToInt32(Session["ProductID"])); txtProductName.Value = prod.ProductName; txtProductAciklama.Value = prod.Description; txtProductPrice.Value = prod.UnitPrice.ToString(); txtProductUnitsInStock.Value = prod.UnitsInStock.ToString(); for (int i = 0; i < drpCategory.Items.Count; i++) { if (drpCategory.Items[i].Value == prod.CategoryID.ToString()) { drpCategory.Items[i].Selected = true; } } btnProductInsert.Text = "Güncelle"; } }
private void btnSave_Click(object sender, EventArgs e) { Entity.Products pro = new Entity.Products(); pro.ProductName = txtProductName.Text; pro.UnitPrice = nudUnitPrice.Value; pro.UnitsInStock = int.Parse(nudUnitsInStock.Value.ToString()); Entity.Categories seciliCat = cbCategori.SelectedItem as Entity.Categories; pro.CategoryID = seciliCat.id; Entity.Suppliers seciliSup = cbSupplier.SelectedItem as Entity.Suppliers; pro.SupplierID = seciliSup.id; DAL.ProductsDal proDAL = new DAL.ProductsDal(); int result = proDAL.Save(pro); MessageBox.Show(result.ToString() + " satır etkilendi."); Entity.Entity en = new Entity.Entity(); en.Temizle(groupBox1); en.Temizle(groupBox2); }
private void lstwProducts_SelectedIndexChanged(object sender, EventArgs e) { foreach (ListViewItem li in lstwProducts.SelectedItems) { pro = li.Tag as Entity.Products; txtProductName.Text = pro.ProductName; nudUnitPrice.Value = pro.UnitPrice; nudUnitsInStock.Value = pro.UnitsInStock; foreach (Entity.Categories item in cbCategori.Items) { if (item.id == int.Parse(li.SubItems[2].Text)) { cbCategori.SelectedItem = item; } } foreach (Entity.Suppliers item in cbSupplier.Items) { if (item.id == int.Parse(li.SubItems[1].Text)) { cbSupplier.SelectedItem = item; } } } }
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(); }
private void frmListProducts_Load(object sender, EventArgs e) { Entity.Products pro = new Entity.Products(); pro.ListViewDoldur(lstwProducts); }