private void perfumeListDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { categoryComboBox.Enabled = false; addButton.Enabled = false; updateButton.Enabled = true; pefumeIdHintLabel.Visible = false; Perfume p = ppda.getOneProductPerfumeByID(perfumeListDataGridView.Rows[e.RowIndex].Cells["perfumeIdColumn"].Value.ToString(), Language.getLanguageCode(), conn); categoryComboBox.Text = p.getCategory(); perfumeIdTextBox.Text = p.getProductID(); englishNameTextBox.Text = p.getProductNameEnUs(); tChineseNameTextBox.Text = p.getProductNameZhHant(); quantityTextBox.Text = p.getQtyInStock().ToString(); priceTextBox.Text = p.getPrice().ToString(); engDescTextBox.Text = p.getDescriptionEnUs(); tChiDescTextBox.Text = p.getDescriptionZhHant(); productPhotoBox.Image = p.getPhoto(); } }
public int update(Perfume perfume, MySqlConnection conn) { conn.Open(); MySqlCommand cmd = new MySqlCommand("UPDATE `product_perfume` SET `Product_Name_en-US`=@productNameEnUs,`Product_Name_zh-Hant`=@productNameZhHant,`Description_en-US`=@descriptionEnUs,`Description_zh-Hant`=@descriptionZhHant,`Photo`=@photo,`Supplier_ID`=@supplierID,`Perfume_Category_Code`=@categoryCode,`Qty_In_Stock`=@qtyInStock,`Price`=@price,`Release_Date`=@releaseDate WHERE `Product_ID`=@productID", conn); cmd.Parameters.AddWithValue("@productID", perfume.getProductID()); cmd.Parameters.AddWithValue("@productNameEnUs", perfume.getProductNameEnUs()); cmd.Parameters.AddWithValue("@productNameZhHant", perfume.getProductNameZhHant()); cmd.Parameters.AddWithValue("@descriptionEnUs", perfume.getDescriptionEnUs()); cmd.Parameters.AddWithValue("@descriptionZhHant", perfume.getDescriptionZhHant()); cmd.Parameters.AddWithValue("@photo", ImageConverter.imageToByteArray(perfume.getPhoto())); cmd.Parameters.AddWithValue("@supplierID", perfume.getSupplierID()); cmd.Parameters.AddWithValue("@qtyInStock", perfume.getQtyInStock()); cmd.Parameters.AddWithValue("@price", perfume.getPrice()); cmd.Parameters.AddWithValue("@categoryCode", perfume.getCategoryCode()); cmd.Parameters.AddWithValue("@releaseDate", perfume.getReleaseDate().ToString("yyyy-MM-dd HH:mm:ss")); cmd.Prepare(); int i = cmd.ExecuteNonQuery(); conn.Close(); return(i); }
private void addButton_Click(object sender, EventArgs e) { bool isInputCorrect = this.isInputCorrect(); if (isInputCorrect) { Perfume p = new Perfume(); p.setProductID(perfumeIdTextBox.Text.Trim()); p.setProductNameEnUs(englishNameTextBox.Text.Trim()); p.setProductNameZhHant(tChineseNameTextBox.Text.Trim()); p.setDescriptionEnUs(engDescTextBox.Text.Trim()); p.setDescriptionZhHant(tChiDescTextBox.Text.Trim()); p.setPhoto(productPhotoBox.Image); p.setSupplierID(supplierID); p.setQtyInStock(int.Parse(quantityTextBox.Text.Trim())); p.setPrice(int.Parse(priceTextBox.Text.Trim())); p.setCategoryCode(categoryComboBox.SelectedValue.ToString()); p.setReleaseDate(DateTime.Now.Date); int i = ppda.insert(p, conn); if (i > 0) { perfumeListDataGridView.Rows.Add( false, p.getProductID(), p.getProductNameEnUs(), p.getProductNameZhHant(), p.getDescriptionEnUs(), p.getDescriptionZhHant(), categoryComboBox.Text, p.getQtyInStock().ToString() + " " + rs.GetString("mlText"), rs.GetString("hkdText") + p.getPrice().ToString(), p.getReleaseDate().ToLongDateString()); perfumeListDataGridView.ClearSelection(); foreach (DataGridViewRow row in perfumeListDataGridView.Rows) { if (perfumeIdTextBox.Text.Equals(row.Cells["perfumeIdColumn"].Value.ToString())) { row.Selected = true; perfumeListDataGridView.FirstDisplayedScrollingRowIndex = row.Index; } } perfumeDataResetButton.Enabled = true; deleteButton.Enabled = true; deselectAllButton.Enabled = true; selectAllButton.Enabled = true; categoryComboBox.Enabled = false; addButton.Enabled = false; updateButton.Enabled = true; pefumeIdHintLabel.Visible = false; productList.Clear(); productList = null; productList = ppda.findProductPerfumeBySupplierID(supplierID, Language.getLanguageCode(), conn); MessageBox.Show(rs.GetString("addNewProductSuccessMsg")); } else { MessageBox.Show(rs.GetString("addNewProductFailMsg"), 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]); } } }