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