public Perfume getOneDeletedProductPerfumeByID(string productID, string langCode, MySqlConnection conn) { conn.Open(); MySqlCommand cmd = new MySqlCommand("SELECT `p`.`Product_ID`, `p`.`Product_Name_en-US`, `p`.`Product_Name_zh-Hant`, " + "`p`.`Description_en-US`, `p`.`Description_zh-Hant`, `p`.`Photo`, " + "`p`.`Supplier_ID`, `s`.`Supplier_Name`, `p`.`Perfume_Category_Code`, `pc`.`Category_Name_en-US`, " + "`pc`.`Category_Name_zh-Hant`, `p`.`Qty_In_Stock`, `p`.`Price`, `p`.`Release_Date`, `p`.`Date_Deleted` " + "FROM `product_perfume` AS `p` " + "INNER JOIN `supplier` AS `s` ON `p`.`Supplier_ID` = `s`.`Supplier_ID` " + "INNER JOIN `product_perfume_category` AS `pc` ON `p`.`Perfume_Category_Code` = `pc`.`Perfume_Category_Code` " + "WHERE `p`.`Date_Deleted` IS NOT NULL AND `p`.`Product_ID` = @productID", conn); cmd.Parameters.AddWithValue("@productID", productID); cmd.Prepare(); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); Perfume perfume = new Perfume(); foreach (DataRow item in dt.Rows) { perfume.setProductID(item["Product_ID"].ToString()); perfume.setProductName(item["Product_Name_" + langCode].ToString()); perfume.setProductNameEnUs(item["Product_Name_en-US"].ToString()); perfume.setProductNameZhHant(item["Product_Name_zh-Hant"].ToString()); perfume.setDescription(item["Description_" + langCode].ToString()); perfume.setDescriptionEnUs(item["Description_en-US"].ToString()); perfume.setDescriptionZhHant(item["Description_zh-Hant"].ToString()); perfume.setPhoto(ImageConverter.byteArrayToImage((byte[])item["Photo"])); perfume.setSupplierID(item["Supplier_ID"].ToString()); perfume.setSupplierName(item["Supplier_Name"].ToString()); perfume.setQtyInStock((int)item["Qty_In_Stock"]); perfume.setPrice((int)item["Price"]); perfume.setCategoryCode(item["Perfume_Category_Code"].ToString()); perfume.setCategory(item["Category_Name_" + langCode].ToString()); perfume.setReleaseDate(Convert.ToDateTime(item["Release_Date"])); perfume.setDateDeleted(Convert.ToDateTime(item["Date_Deleted"])); } conn.Close(); return(perfume); }
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); } } }