public static ResultSet CRUD(Customers cus, Cate cate, Products pro, Orders ord, Signin sign, EntityState state, string table) { ResultSet r = new ResultSet(); try { switch (table) { case "customer": r = HelperCustomer.CRUD(cus, state); break; case "category": r = HelperCate.CRUD(cate, state); break; case "product": r = HelperProduct.CRUD(pro, state); break; case "order": r = HelperOrder.CRUD(ord, state); break; case "signin": r = HelperSignin.CRUD(sign, state); break; default: break; } if (r.Message != null) { MessageBox.Show(r.Message, "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } return(r); } catch (Exception e) { r.Message = e.Message; } return(r); }
private void button4_Click(object sender, EventArgs e) { //Ürün düzenle butonu if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text)) { Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value)); p.productName = textBox2.Text; p.unitPrice = Convert.ToDouble(textBox3.Text); p.supplierID = Convert.ToInt32(comboBox2.SelectedValue); p.categoryID = Convert.ToInt32(comboBox3.SelectedValue); p.discount = Convert.ToInt32(textBox4.Text); var degistir = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified); if (degistir.Item2) { MessageBox.Show("Güncelleme başarılı."); } else { MessageBox.Show("Güncelleme yapılamadı."); } Yenile(); } else { MessageBox.Show("Lütfen tüm alanları doldurunuz."); } }
private void button1_Click(object sender, EventArgs e) { //Stok eklemek için ürün arama butonu dataGridView1.Rows.Clear(); List <ProductModel> pm = new List <ProductModel>(); if (comboBox1.SelectedIndex == 0) { pm = HelperProduct.GetListByProductname(textBox1.Text); } else if (comboBox1.SelectedIndex == 1) { pm = HelperProduct.GetListByCompanyName(textBox1.Text); } else if (comboBox1.SelectedIndex == 2) { pm = HelperProduct.GetListByCategoryName(textBox1.Text); } foreach (var item in pm) { if (item.IsActive == true) { dataGridView1.Rows.Add(item.productID, item.productName, item.Supplier.companyName, item.category.categoryName, item.unitPrice, item.dateOfAdded, item.stringDiscounted); } } textBox1.Clear(); }
private void button2_Click(object sender, EventArgs e) { //Stok ekle Butonu if (!String.IsNullOrEmpty(textBox2.Text)) { Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value)); p.stock += Convert.ToInt32(textBox2.Text); var degistir = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified); Stock s = new Stock() { productID = p.productID, dateOfAdded = DateTime.Now, count = Convert.ToInt32(textBox2.Text) }; var ekle = HelperStock.CUD(s, System.Data.Entity.EntityState.Added); if (ekle.Item2) { MessageBox.Show("Stok ekleme başarılı."); } else { MessageBox.Show("Stok eklenemedi"); } Yenile(); DataGrid2Yenile(); textBox2.Clear(); } else { MessageBox.Show("Lütfen adet giriniz."); } }
private void B_UrunGetir(object sender, EventArgs e) { flowLayoutPanel2.Controls.Clear(); List <ProductModel> products = HelperProduct.GetListByCategoryName((sender as Button).Text); int urunsayi = 0; List <string> temp3 = new List <string>(); foreach (var item in products) { int stock = HelperStock.GetStockByProductID(item.productID); if (item.IsActive == true) { if (item.discontinued == false) { if (item.stock > 0) { temp3.Add(item.productName); } } } } urunsayi = temp3.Count; for (int i = 0; i < urunsayi; i++) { urun = new Button(); urun.Size = new Size(100, 50); urun.Text = temp3[i]; urun.BackColor = Color.Cyan; urun.MouseEnter += Urun_Click; urun.MouseLeave += Urun_Click2; flowLayoutPanel2.Controls.Add(urun); urun.Click += Urun_SipariseEkle; } }
private void BtRowDelPro_Click(object sender, EventArgs e) { var pro = HelperProduct.GetProduct(proID); if (pro != null) { var result = MessageBox.Show("Bu işlem geri alınamaz. Yine de silinsin mi?", "SİL?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { r = Helper.CRUD(null, null, pro, null, null, EntityState.Deleted, "product"); if (r.isSuccess) { DisplayProducts(); DisplayOrders(); lblWarningPro.Visible = true; lblWarningPro.Text = "Ürün silindi!"; } else { lblWarningPro.Visible = true; lblWarningPro.Text = r.Message; } } } }
private void button3_Click(object sender, EventArgs e) { //Ürün silme butonu if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text)) { var a = MessageBox.Show(" Silmek istediğinize emin misiniz?", "Bilgilendirme", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (a == DialogResult.Yes) { Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value)); p.IsActive = false; var b = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified); if (b.Item2) { MessageBox.Show("Silme işlemi başarılı"); } else { MessageBox.Show("Silme yapılamadı"); } } Yenile(); } else { MessageBox.Show("Lütfen silinecek ürünü seçiniz."); } }
void DisplayProducts() { dgvProducts.Rows.Clear(); foreach (var item in HelperProduct.GetProductModelList()) { dgvProducts.Rows.Add(item.proName, item.Cate.cateName, item.prePrice, item.salePrice, item.quantity, item.Cate.explanation); } }
private void CBoxSubCate_SelectedValueChanged(object sender, EventArgs e) { int subCateID = Convert.ToInt32(cBoxSubCate.SelectedValue); cBoxProduct.ValueMember = "productID"; cBoxProduct.DisplayMember = "proName"; cBoxProduct.DataSource = HelperProduct.GetProductbySubCateModelList(subCateID); }
private void FormDisplayProducts_Load(object sender, EventArgs e) { var list = HelperProduct.GetProductModelList(); foreach (var item in list) { dgvProducts.Rows.Add(item.productID, item.proName, item.SubCate.subCateName, item.Cate.cateName, item.proPrice, item.quantity); } }
private void BtEditPro_Click(object sender, EventArgs e) { var pro = HelperProduct.GetProduct(proID); int previousCateID = Convert.ToInt32(pro.cateID); if (pro != null) { int c = 0; if (!Helper.I(tbProName1.Text)) { pro.proName = tbProName1.Text; c++; } if (!Helper.I(tbPrePrice1.Text)) { pro.prePrice = Convert.ToDouble(tbPrePrice1.Text); c++; } if (!Helper.I(tbSalePrice1.Text)) { pro.salePrice = Convert.ToDouble(tbSalePrice1.Text); c++; } if (!Helper.I(tbStock1.Text)) { pro.quantity = Convert.ToInt32(tbStock1.Text); c++; } pro.cateID = Convert.ToInt32(cbCategory1.SelectedValue); if (previousCateID != pro.cateID) { c++; } r = Helper.CRUD(null, null, pro, null, null, EntityState.Modified, "product"); if (r.isSuccess) { tbProName1.Clear(); cbCategory1.SelectedIndex = 0; tbPrePrice1.Clear(); tbSalePrice1.Clear(); tbStock1.Clear(); DisplayProducts(); DisplayOrders(); if (c != 0) { lblWarningPro.Visible = true; lblWarningPro.Text = "Ürün bilgileri düzenlendi!"; } } else { lblWarningPro.Visible = true; lblWarningPro.Text = r.Message; } } gbEditPro.Enabled = false; }
private void BtRowEditPro_Click(object sender, EventArgs e) { var pro = HelperProduct.GetProductModel(proID); if (pro != null) { gbEditPro.Enabled = true; tbProName1.Clear(); cbCategory.SelectedIndex = 0; tbPrePrice1.Clear(); tbSalePrice1.Clear(); tbStock1.Clear(); } }
public void DataGrid2Yenile() { dataGridView2.Rows.Clear(); List <Product> prlst = HelperProduct.GetList(); foreach (var item in prlst) { if (item.stock > 0) { dataGridView2.Rows.Add(item.productName, item.stock); } } }
public void Yenile() { dataGridView1.Rows.Clear(); List <ProductModel> productmodel = HelperProduct.GetProductModelList(); foreach (var item in productmodel) { if (item.IsActive == true) { dataGridView1.Rows.Add(item.productID, item.productName, item.Supplier.companyName, item.category.categoryName, item.unitPrice, item.dateOfAdded, item.stock, item.stringDiscounted); } } }
void SubDisplayOrders(List <OrderModel> list) { foreach (var item in list) { string ctName = HelperCate.GetCate(Convert.ToInt32(HelperProduct.GetProduct(Convert.ToInt32(item.Products.productID)).cateID)).cateName; dgvOrders.Rows.Add(item.Customers.cFirstName + " " + item.Customers.cLastName, ctName, item.Products.proName, item.piece, item.Products.salePrice, Convert.ToDateTime(item.orderDate).ToShortDateString()); profit += (Convert.ToDouble(item.Products.salePrice) - Convert.ToDouble(item.Products.prePrice)); } lblProfit.Text = profit.ToString(); }
private void BtCompleteOrder_Click(object sender, EventArgs e) { bool result = Helper.I(tbQuantity.Text); if (result) { MessageBox.Show("Adet bilgisini giriniz!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { int custID = HelperCustomer.GetCustomerID(cbCustomers.GetItemText(cbCustomers.SelectedItem)); var pro = HelperProduct.GetProduct(sellProID); if (pro != null) { if (pro.quantity < Convert.ToInt32(tbQuantity.Text)) { if (pro.quantity == 0) { MessageBox.Show("Bu ürün tükenmiştir!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show($"Bu üründen stokta {pro.quantity} adet kaldı!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { Orders ord = new Orders { piece = Convert.ToInt32(tbQuantity.Text), orderDate = DateTime.Now.Date, productID = sellProID, customerID = custID }; r = Helper.CRUD(null, null, null, ord, null, EntityState.Added, "order"); if (r.isSuccess) { pro.quantity -= Convert.ToInt32(tbQuantity.Text); rr = Helper.CRUD(null, null, pro, null, null, EntityState.Modified, "product"); } tbQuantity.Clear(); DisplayProducts(); DisplayOrders(); } } } }
private void BtListCategories_Click(object sender, EventArgs e) { dgvSellPro.Visible = true; lblSelectPro.Visible = true; dgvSellPro.Rows.Clear(); foreach (var item in HelperProduct.GetProductModelList()) { if (item.Cate.cateName == cbCategoryList.GetItemText(cbCategoryList.SelectedItem)) { dgvSellPro.Rows.Add(item.proName, item.salePrice, item.Cate.explanation); } } }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { dataGridView1.ClearSelection(); Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value)); Category c = HelperCategory.GetByID(p.categoryID); Supplier s = HelperSupplier.GetByID(p.supplierID); textBox2.Text = p.productName; textBox3.Text = p.unitPrice.ToString(); textBox4.Text = p.discount.ToString(); comboBox2.Text = s.companyName; comboBox3.Text = c.categoryName; button6.Enabled = true; button7.Enabled = true; }
private void BtUpdProduct_Click(object sender, EventArgs e) { if (!Helper.isNumber(tbPrice.Text) || !Helper.isNumber(tbStock.Text)) { MessageBox.Show("Fiyat ve stok bilgilerini sayı olarak giriniz!"); } else { pro.proPrice = Convert.ToDouble(tbPrice.Text); pro.quantity = Convert.ToInt32(tbStock.Text); var result = HelperProduct.CUD(pro, EntityState.Modified); MessageBox.Show(result == true ? "Ürün başarıyla güncellendi!" : "HATA!"); } }
private void DgvSellPro_CellClick(object sender, DataGridViewCellEventArgs e) { gbSellPro.Visible = true; string sellProName = null, sellProPrice = null, sellProExp = null; if (dgvSellPro.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { dgvSellPro.CurrentRow.Selected = true; sellProName = dgvSellPro.Rows[e.RowIndex].Cells["sellProName"].FormattedValue.ToString(); sellProPrice = dgvSellPro.Rows[e.RowIndex].Cells["sellProPrice"].FormattedValue.ToString(); sellProExp = dgvSellPro.Rows[e.RowIndex].Cells["sellProExp"].FormattedValue.ToString(); } sellProID = HelperProduct.GetProductID(sellProName, Convert.ToDouble(sellProPrice), sellProExp); tbSelectedPro.Text = HelperProduct.GetProduct(sellProID).proName; }
private void DgvProducts_CellClick(object sender, DataGridViewCellEventArgs e) { lblWarningPro.Visible = false; string proName = null, proCate = null, prePrice = null, salePrice = null, stock = null, explanation = null; if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { dgvProducts.CurrentRow.Selected = true; proName = dgvProducts.Rows[e.RowIndex].Cells["proName"].FormattedValue.ToString(); proCate = dgvProducts.Rows[e.RowIndex].Cells["proCate"].FormattedValue.ToString(); prePrice = dgvProducts.Rows[e.RowIndex].Cells["prePrice"].FormattedValue.ToString(); salePrice = dgvProducts.Rows[e.RowIndex].Cells["salePrice"].FormattedValue.ToString(); stock = dgvProducts.Rows[e.RowIndex].Cells["stock"].FormattedValue.ToString(); explanation = dgvProducts.Rows[e.RowIndex].Cells["explanation"].FormattedValue.ToString(); } proID = HelperProduct.GetProductID(proName, proCate, Convert.ToDouble(prePrice), Convert.ToDouble(salePrice), Convert.ToInt32(stock), explanation); }
private void DgvProducts_CellClick(object sender, DataGridViewCellEventArgs e) { if (command == "updProduct") { int proID = 0; if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { dgvProducts.CurrentRow.Selected = true; proID = Convert.ToInt32(dgvProducts.Rows[e.RowIndex].Cells["productID"].FormattedValue.ToString()); } var pro = HelperProduct.GetProduct(proID); if (pro != null) { FormUpdatePro f = new FormUpdatePro(pro); f.Show(); this.Hide(); } } else if (command == "delProduct") { int proID = 0; if (dgvProducts.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { dgvProducts.CurrentRow.Selected = true; proID = Convert.ToInt32(dgvProducts.Rows[e.RowIndex].Cells["productID"].FormattedValue.ToString()); } var pro = HelperProduct.GetProduct(proID); if (pro != null) { if (HelperOrderDet.SoldProductsList().Contains(proID)) { MessageBox.Show("Bu ürün daha önce satıldığı için listeden çıkaramazsınız!"); } else { var result = HelperProduct.CUD(pro, EntityState.Deleted); MessageBox.Show(result == true ? "Ürün başarıyla silindi!" : "HATA!"); } } } }
private void BtAddPro_Click(object sender, EventArgs e) { bool result = Helper.I(tbProName.Text) || Helper.I(tbPrePrice.Text) || Helper.I(tbSalePrice.Text) || Helper.I(tbStock.Text); if (result) { MessageBox.Show("Tüm alanları doldurunuz!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { List <string> list = new List <string>(); foreach (var item in HelperProduct.GetProductModelList()) { list.Add(item.proName); } if (list.Contains(tbProName.Text)) { MessageBox.Show("Bu ürün sistemde kayıtlıdır!", "UYARI", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { Products pro = new Products { proName = tbProName.Text, prePrice = Convert.ToDouble(tbPrePrice.Text), salePrice = Convert.ToDouble(tbSalePrice.Text), quantity = Convert.ToInt32(tbStock.Text), addDate = DateTime.Now.Date, cateID = Convert.ToInt32(cbCategory.SelectedValue) }; r = Helper.CRUD(null, null, pro, null, null, EntityState.Added, "product"); if (r.isSuccess) { tbProName.Clear(); cbCategory.SelectedIndex = 0; tbPrePrice.Clear(); tbSalePrice.Clear(); tbStock.Clear(); DisplayProducts(); } } } }
private void button2_Click(object sender, EventArgs e) { //Ürün ekleme butonu if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text) && !String.IsNullOrEmpty(textBox4.Text)) { if (!HelperProduct.SearchProductName(textBox2.Text)) { MessageBox.Show("Aynı ürün adı mevcut. Lütfen ürün adını değiştiriniz."); } else { Product p = new Product() { productName = textBox2.Text, categoryID = Convert.ToInt32(comboBox3.SelectedValue), supplierID = Convert.ToInt32(comboBox2.SelectedValue), unitPrice = Convert.ToDouble(textBox3.Text), discount = Convert.ToInt32(textBox4.Text), discontinued = false, dateOfAdded = DateTime.Now, stock = 0, IsActive = true }; var ekle = HelperProduct.CUD(p, System.Data.Entity.EntityState.Added); if (ekle.Item2) { MessageBox.Show("Ürün ekleme başarılı."); } else { MessageBox.Show("Ürün eklenemedi"); } Yenile(); } } else { MessageBox.Show("Lütfen tüm alanları doldurunuz."); } textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); }
private void button7_Click(object sender, EventArgs e) { //Satışı devam ettir if (!String.IsNullOrEmpty(textBox2.Text) && !String.IsNullOrEmpty(textBox3.Text)) { Product p = HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value)); p.discontinued = false; var degistir = HelperProduct.CUD(p, System.Data.Entity.EntityState.Modified); if (degistir.Item2) { MessageBox.Show("Güncelleme başarılı."); } else { MessageBox.Show("Güncelleme yapılamadı."); } Yenile(); } else { MessageBox.Show("Lütfen seçim yapınız."); } }
private void BtAddToBasket_Click(object sender, EventArgs e) { int empID = Convert.ToInt32(cBoxEmployee.SelectedValue); int proID = Convert.ToInt32(cBoxProduct.SelectedValue); var pro = HelperProduct.GetProduct(proID); if (pro != null) { if (!Helper.isNumber(tbQuantity.Text) || Convert.ToInt32(tbQuantity.Text) <= 0) { btAddToBasket.Enabled = false; MessageBox.Show("Hatalı giriş yaptınız!"); } else if (pro.quantity < Convert.ToInt32(tbQuantity.Text)) { if (pro.quantity == 0) { MessageBox.Show("Bu ürün tükenmiştir!"); } else { MessageBox.Show($"Bu üründen stokta {pro.quantity} adet kaldı!"); } } else { if (!openOrder) { Orders ord = new Orders { orderDate = DateTime.Now.Date, orderStatus = "Açık", amount = 0, customerID = cusID }; var result1 = HelperOrder.CUD(ord, EntityState.Added); if (result1) { openOrder = true; OrderDetails ordDet = new OrderDetails { productID = proID, priceEach = HelperProduct.GetProduct(proID).proPrice, quantityOrdered = Convert.ToInt32(tbQuantity.Text), orderID = ord.orderID, employeeID = empID }; var result2 = HelperOrderDet.CUD(ordDet, EntityState.Added); if (result2) { btFinishOrder.Enabled = true; MessageBox.Show("Ürün sepete eklendi!"); ord.amount += ordDet.priceEach * ordDet.quantityOrdered; HelperOrder.CUD(ord, EntityState.Modified); } else { MessageBox.Show("HATA!"); } } } else { OrderDetails ordDet = new OrderDetails { productID = proID, priceEach = pro.proPrice, quantityOrdered = Convert.ToInt32(tbQuantity.Text), orderID = HelperOrder.GetOrderList().Count, employeeID = empID }; var ord = HelperOrder.GetOrder(Convert.ToInt32(ordDet.orderID)); var result = HelperOrderDet.CUD(ordDet, EntityState.Added); if (result) { btFinishOrder.Enabled = true; MessageBox.Show("Ürün sepete eklendi!"); ord.amount += ordDet.priceEach * ordDet.quantityOrdered; HelperOrder.CUD(ord, EntityState.Modified); } else { MessageBox.Show("HATA!"); } } pro.quantity -= Convert.ToInt32(tbQuantity.Text); HelperProduct.CUD(pro, EntityState.Modified); } } }
private void button2_Click(object sender, EventArgs e) { //Satışı tamamla butonu //toplam tutar hesapla int totalPrice = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { totalPrice += Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value); } label1.Text = totalPrice.ToString(); Cashier cashier = HelperCashier.GetByName(label3.Text); customer = HelperCustomer.GetByID(customer.CustomerID); Order or = new Order() { customerID = customer.CustomerID, orderDate = DateTime.Now, cashierID = cashier.cashierID, totalPrice = Convert.ToInt32(label1.Text), }; var ekle = HelperOrder.CUD(or, System.Data.Entity.EntityState.Added); for (int i = 0; i < dataGridView1.Rows.Count; i++) { p.Add(HelperProduct.GetByID(Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value))); } int k = 0; foreach (var item in p) { for (; k < dataGridView1.Rows.Count;) { item.stock -= Convert.ToInt32(dataGridView1.Rows[k].Cells[4].Value); var a = HelperProduct.CUD(item, System.Data.Entity.EntityState.Modified); break; } k++; } for (int i = 0; i < dataGridView1.Rows.Count; i++) { //fiş için yapılanlar List <string> temp = new List <string>(); string ad = dataGridView1.Rows[i].Cells[0].Value.ToString(); string id = dataGridView1.Rows[i].Cells[1].Value.ToString(); string birimFiyat = dataGridView1.Rows[i].Cells[2].Value.ToString(); string indirim = dataGridView1.Rows[i].Cells[3].Value.ToString(); string adet = dataGridView1.Rows[i].Cells[4].Value.ToString(); string tutar = dataGridView1.Rows[i].Cells[5].Value.ToString(); temp.Add(ad); temp.Add(id); temp.Add(birimFiyat); temp.Add(indirim); temp.Add(adet); temp.Add(tutar); receipt.Add(temp); } foreach (var item in p) { ord = new OrderDetail(); ord.orderID = or.orderID; ord.productID = item.productID; ord.unitPrice = item.unitPrice; for (; j < dataGridView1.Rows.Count; j++) { ord.count = Convert.ToInt32(dataGridView1.Rows[j].Cells[4].Value); break; } j++; var ekle2 = HelperOrderDetail.CUD(ord, System.Data.Entity.EntityState.Added); } ReceiptForm rpf = new ReceiptForm(receipt, customer, label1.Text); rpf.Show(); this.Hide(); }
private void Urun_SipariseEkle(object sender, EventArgs e) { productModels = HelperProduct.GetListByProductname((sender as Button).Text); }