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