private void SearchProducts() { ProductORM prodORM = new ProductORM(); dtListProducts.DataSource = prodORM.ProductSearch(Request.Form["Search"]); dtListProducts.DataBind(); }
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 ProductGetList() { ProductORM prodORM = new ProductORM(); rptProduct.DataSource = prodORM.List(); rptProduct.DataBind(); }
protected void rptProduct_ItemCommand(object source, RepeaterCommandEventArgs e) { try { bool result = false; if (e.CommandName == "btnDelete") { Button btnDelete = e.Item.FindControl("btnDelete") as Button; ProductORM prodORM = new ProductORM(); result = prodORM.Delete(Convert.ToInt32(btnDelete.CommandArgument)); if (result) { rptProduct.DataSource = prodORM.List(); rptProduct.DataBind(); } } else if (e.CommandName == "btnUpdate") { Session["ProductID"] = e.CommandArgument; Server.Transfer("NewProduct.aspx"); } } catch (Exception) { throw; } }
private void sellProductToolStripMenuItem_Click(object sender, EventArgs e) { try { string productName = lstwProducts.SelectedItems[0].Text; int productID = Convert.ToInt32(lstwProducts.SelectedItems[0].Tag); DialogResult dialogResult = MessageBox.Show("Seçili Ürünün Stok Miktarını " + toolStripTextBoxQuantity.Text + " Adet Eksiltmek İstediğinize Emin Misiniz ?", productName, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { ProductORM prodORM = new ProductORM(); bool result = prodORM.StockDecrease(productID, int.Parse(toolStripTextBoxQuantity.Text)); if (result) { MessageBox.Show("Stok Azaltma İşleminiz Başarıyla Gerçekleştirildi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ListViewProductFill(Convert.ToInt32(cbCategories.SelectedValue)); } else { MessageBox.Show("İşlem Sırasında Bir Hata Meydana Geldi !", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (SqlException ex) { MessageBox.Show(ex.Message); } }
private void GetNewProducts() { ProductORM prodORM = new ProductORM(); dtListNewProducts.DataSource = prodORM.GetNewProducts(); dtListNewProducts.DataBind(); dtListSingleProduct.DataSource = prodORM.GetNewProducts(); dtListSingleProduct.DataBind(); }
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 SaleForm_Load(object sender, EventArgs e) { CustomerORM csOrm = new CustomerORM(); cmbCustomer.DataSource = csOrm.Select(); cmbCustomer.DisplayMember = "Name"; cmbCustomer.ValueMember = "id"; RoomsORM rOrm = new RoomsORM(); cmbRoom.DataSource = rOrm.Select(); cmbRoom.DisplayMember = "Name"; cmbRoom.ValueMember = "id"; ProductORM pOrm = new ProductORM(); dataGridView1.DataSource = pOrm.Select(); }
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 btnAddProduct_Click(object sender, EventArgs e) { try { Products prod = new Products { ProductName = txtProductName.Text, CategoryID = (int)cbAddCategories.SelectedValue, QuantityPerUnit = txtProductUnit.Text, UnitPrice = Convert.ToDecimal(txtProductPrice.Text), UnitsInStock = (int)nUdUnitsInStock.Value }; ProductORM prodORM = new ProductORM(); bool result = prodORM.Insert(prod); if (result) { MessageBox.Show("Ürün Ekleme İşleminiz Başarıyla Gerçekleştirildi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ListViewProductFill(Convert.ToInt32(cbAddCategories.SelectedValue)); cbCategories.SelectedIndex = cbAddCategories.SelectedIndex; tabControlProducts.SelectedIndex = 0; ProductControlsClear(true); } else { MessageBox.Show("İşlem Sırasında Bir Hata Meydana Geldi !", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } catch { MessageBox.Show("Fiyat Girişi Yapılırken Bir Sorunla Karşılaşıldı"); txtProductPrice.Clear(); txtProductPrice.Focus(); } }
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); } }
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(); }