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