private void FormDisplaySold_Load(object sender, EventArgs e) { var list = HelperOrderDet.GetOrderDetbyEmpModelList(empID); foreach (var item in list) { dgvSoldProducts.Rows.Add(item.Products.productID, item.Products.proName, item.priceEach, item.quantityOrdered, HelperOrder.GetCusFullNameByOrderId(item.Orders.orderID)); } }
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 DgvOrder_CellClick(object sender, DataGridViewCellEventArgs e) { dgvOrderDet.Rows.Clear(); //int orderID = Convert.ToInt32(dgvOrder.CurrentCell.Value.ToString()); int orderID = 0; if (dgvOrder.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { dgvOrder.CurrentRow.Selected = true; orderID = Convert.ToInt32(dgvOrder.Rows[e.RowIndex].Cells["orderID"].FormattedValue.ToString()); } var list = HelperOrderDet.GetOrderDetModelList(orderID); foreach (var item in list) { dgvOrderDet.Rows.Add(item.Products.productID, item.Products.proName, item.priceEach, item.quantityOrdered, item.Employees.eFirstName + " " + item.Employees.eLastName); } }
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); } } }