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); }