private void updateButton_Click(object sender, EventArgs e) { bool isInputCorrect = this.isInputCorrect(); if (isInputCorrect) { Package p = ppda.getOneProductPackageByID(packageIdTextBox.Text, Language.getLanguageCode(), conn); p.setProductNameEnUs(englishNameTextBox.Text); p.setProductNameZhHant(tChineseNameTextBox.Text); p.setDescriptionEnUs(engDescTextBox.Text); p.setDescriptionZhHant(tChiDescTextBox.Text); p.setPhoto(productPhotoBox.Image); p.setSupplierID(supplierID); p.setQtyInStock(int.Parse(quantityTextBox.Text)); p.setPrice(int.Parse(priceTextBox.Text)); int i = ppda.update(p, conn); if (i > 0) { foreach (DataGridViewRow row in packageListDataGridView.Rows) { if (packageIdTextBox.Text.Equals(row.Cells["packageIdColumn"].Value.ToString())) { row.Cells["engNameColumn"].Value = englishNameTextBox.Text; row.Cells["tChiNameColumn"].Value = tChineseNameTextBox.Text; row.Cells["engDescriptionColumn"].Value = engDescTextBox.Text; row.Cells["tChiDescriptionColumn"].Value = tChiDescTextBox.Text; row.Cells["quantityColumn"].Value = quantityTextBox.Text; row.Cells["priceColumn"].Value = rs.GetString("hkdText") + priceTextBox.Text; } } showedStockAlertPackage.Remove(p.getProductID()); setting.Save(); productList.Clear(); productList = null; productList = ppda.findProductPackagesBySupplierID(supplierID, Language.getLanguageCode(), conn); MessageBox.Show(rs.GetString("updateProductSuccessMsg")); } else { MessageBox.Show(rs.GetString("updateProductFailMsg"), rs.GetString("errorText"), MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void approvalButton_Click(object sender, EventArgs e) { bool qtyBelow50 = false; if (!qtyBelow50) { Package package = ppgda.getOneProductPackageByID(packageOl.getProductID(), Language.getLanguageCode(), conn); if (package.getQtyInStock() < 1) { qtyBelow50 = true; } } if (!qtyBelow50) { Bottle bottle = pbda.getOneProductBottleByID(bottleOl.getProductID(), Language.getLanguageCode(), conn); if (bottle.getQtyInStock() < 1) { qtyBelow50 = true; } } if (!qtyBelow50) { foreach (OrderLine perfumeOl in perfumeOlList) { Perfume perfume = ppda.getOneProductPerfumeByID(perfumeOl.getProductID(), Language.getLanguageCode(), conn); if (perfume.getQtyInStock() < 50) { qtyBelow50 = true; break; } } } if (qtyBelow50) { rejectButton_Click(null, null); } else { Package package = ppgda.getOneProductPackageByID(packageOl.getProductID(), Language.getLanguageCode(), conn); package.setQtyInStock(package.getQtyInStock() - 1); ppgda.update(package, conn); Bottle bottle = pbda.getOneProductBottleByID(bottleOl.getProductID(), Language.getLanguageCode(), conn); bottle.setQtyInStock(bottle.getQtyInStock() - 1); pbda.update(bottle, conn); foreach (OrderLine perfumeOl in perfumeOlList) { Perfume perfume = ppda.getOneProductPerfumeByID(perfumeOl.getProductID(), Language.getLanguageCode(), conn); perfume.setQtyInStock(perfume.getQtyInStock() - perfumeOl.getQty()); ppda.update(perfume, conn); } productCategoriesComboBox_SelectedIndexChanged(null, null); orderDetail.setApprovedDate(DateTime.Now.Date); orderDetail.setRejected(false); orderDetail.setApprovedByEmpID(staffID); if (oda.update(orderDetail, conn) > 0) { MessageBox.Show(rs.GetString("orderApprovalMsg")); } else { MessageBox.Show(rs.GetString("failToUpdateMsg"), rs.GetString("errorText"), MessageBoxButtons.OK, MessageBoxIcon.Error); } } approvalButton.Enabled = false; rejectButton.Enabled = false; showOrderDetail(orderDetail.getOrderID()); for (int i = orderDataGridView.Rows.Count - 1; i >= 0; i--) { if (orderDataGridView.Rows[i].Cells["orderIdColumn"].Value.Equals(orderDetail.getOrderID())) { orderDataGridView.Rows.Remove(orderDataGridView.Rows[i]); } } }