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]);
}
}
}
public void showOrderDetail(string orderID)
{
receiptButton.Enabled = false;
invoiceButton.Enabled = false;
refundButton.Visible = false;
string paymentStatus = null;
string paymentDate = null;
string refundedAmount = null;
string refundedDate = null;
bool disableApprovalButton = false;
orderDetail = null;
orderDetail = oda.getOneOrderByID(orderID, conn);
try
{
if (!string.IsNullOrEmpty(orderDetail.getPayPalPaymentID()))
{
Payment payment = Payment.Get(apiContext, orderDetail.getPayPalPaymentID());
if (payment.state.Equals("approved"))
{
List <RelatedResources> relatedResources = payment.transactions.ElementAt(0).related_resources;
Sale sale = relatedResources.ElementAt(0).sale;
if (sale.state.Equals("completed"))
{
paymentStatus = rs.GetString("paidText");
paymentDate = sale.create_time;
}
else if (sale.state.Equals("refunded") || sale.state.Equals("partially_refunded"))
{
Refund refund = relatedResources.ElementAt(1).refund;
paymentStatus = rs.GetString("refundedText");
paymentDate = sale.create_time;
refundedAmount = rs.GetString("hkdText") + refund.amount.total;
refundedDate = refund.create_time;
}
}
else
{
paymentStatus = rs.GetString("unpaidText");
disableApprovalButton = true;
}
}
else
{
paymentStatus = rs.GetString("unpaidText");
disableApprovalButton = true;
}
}
catch (PayPal.HttpException ex)
{
if (!ex.StatusCode.ToString().Equals("NotFound"))
{
paymentStatus = rs.GetString("failGetPaymentStatusMsg");
}
else
{
paymentStatus = rs.GetString("unpaidText");
}
disableApprovalButton = true;
}
catch (PayPal.ConnectionException)
{
paymentStatus = rs.GetString("failGetPaymentStatusMsg");
disableApprovalButton = true;
}
showOrderIdLabel.Text = orderDetail.getOrderID();
showOrderDateLabel.Text = orderDetail.getOrderDate().Date.ToLongDateString();
showNameLabel.Text = orderDetail.getCustName();
showAddressLabel.Text = orderDetail.getCustAddress();
showEmailLabel.Text = orderDetail.getCustEmail();
showMobileNoLabel.Text = orderDetail.getCustMobilePhoneNo();
showApproveDateLabel.Text = (orderDetail.getApprovedDate() == null) ? rs.GetString("naText") : orderDetail.getApprovedDate().Value.Date.ToLongDateString();
barCodeShowLabel.Text = orderDetail.getBarCode();
if (orderDetail.getApprovedDate() != null)
{
showApproveStatusLabel.Text = "(" + ((orderDetail.getRejected()) ? rs.GetString("rejectedText") : rs.GetString("apporvedBy1Text") + orderDetail.getApprovedBy() + rs.GetString("apporvedBy2Text")) + ")";
}
else
{
showApproveStatusLabel.Text = " ";
}
if (!orderDetail.getRejected() && orderDetail.getApprovedDate() != null)
{
receiptButton.Enabled = true;
invoiceButton.Enabled = true;
}
showPayDateLabel.Text = (paymentDate == null) ? rs.GetString("naText") : Convert.ToDateTime(paymentDate).Date.ToLongDateString();
showPaymentStatusLabel.Text = "(" + paymentStatus + ")";
if (refundedDate != null)
{
showRefundDateLabel.Text = Convert.ToDateTime(refundedDate).Date.ToLongDateString();
showRefundedAmountLabel.Text = refundedAmount;
refundDateLabel.Visible = true;
innerPanel4.Visible = true;
}
else
{
if (orderDetail.getRejected() && refundedDate == null && paymentDate != null)
{
refundButton.Visible = true;
}
refundDateLabel.Visible = false;
innerPanel4.Visible = false;
}
packageOl = null;
packageOl = olda.getPackageOrderLine(showOrderIdLabel.Text, Language.getLanguageCode(), conn);
double packageSubTotal = 0;
if (!string.IsNullOrEmpty(packageOl.getProductID()))
{
showPackageIdLabel.Text = packageOl.getProductID();
showPackageNameLabel.Text = packageOl.getProductName();
showPackageUnitPriceLabel.Text = rs.GetString("hkdText") + packageOl.getUnitPrice().ToString();
showPackageDiscountLabel.Text = (packageOl.getDiscount() != null) ? packageOl.getDiscount().ToString() + "% OFF" : "";
packageSubTotal = ((packageOl.getDiscount() != null) ? packageOl.getUnitPrice() * (0.01 * (100 - packageOl.getDiscount())) : packageOl.getUnitPrice()).Value;
showPackageSubTotalLabel.Text = rs.GetString("hkdText") + packageSubTotal.ToString();
}
else
{
showPackageIdLabel.Text = " ";
showPackageNameLabel.Text = " ";
showPackageUnitPriceLabel.Text = " ";
showPackageDiscountLabel.Text = " ";
showPackageSubTotalLabel.Text = " ";
}
bottleOl = null;
bottleOl = olda.getBottleOrderLine(showOrderIdLabel.Text, Language.getLanguageCode(), conn);
double bottleSubTotal = 0;
if (!string.IsNullOrEmpty(bottleOl.getProductID()))
{
showBottleIdLabel.Text = bottleOl.getProductID();
showBottleNameLabel.Text = bottleOl.getProductName();
showBottleCapacityLabel.Text = bottleOl.getBottleCapacity().ToString() + " " + rs.GetString("mlText");
showBottleUnitPriceLabel.Text = rs.GetString("hkdText") + bottleOl.getUnitPrice().ToString();
showBottleDiscountLabel.Text = (bottleOl.getDiscount() != null) ? bottleOl.getDiscount().ToString() + "% OFF" : "";
bottleSubTotal = ((bottleOl.getDiscount() != null) ? bottleOl.getUnitPrice() * (0.01 * (100 - bottleOl.getDiscount())) : bottleOl.getUnitPrice()).Value;
showBottleSubTotalLabel.Text = rs.GetString("hkdText") + bottleSubTotal.ToString();
}
else
{
showBottleIdLabel.Text = " ";
showBottleNameLabel.Text = " ";
showBottleCapacityLabel.Text = " ";
showBottleUnitPriceLabel.Text = " ";
showBottleDiscountLabel.Text = " ";
showBottleSubTotalLabel.Text = " ";
}
perfumeOlList = null;
perfumeOlList = olda.getPerfumeOrderLine(showOrderIdLabel.Text, Language.getLanguageCode(), conn);
double perfumeSubTotal0 = 0;
if (perfumeOlList.Count > 0)
{
showPerfumeId0Label.Text = perfumeOlList.ElementAt(0).getProductID();
showPerfumeName0Label.Text = perfumeOlList.ElementAt(0).getProductName();
showPerfumeUnitPrice0Label.Text = rs.GetString("hkdText") + perfumeOlList.ElementAt(0).getUnitPrice().ToString();
showPerfumeDiscount0Label.Text = (perfumeOlList.ElementAt(0).getDiscount() != null) ? perfumeOlList.ElementAt(0).getDiscount().ToString() + "% OFF" : "";
showPerfumeNote0Label.Text = rs.GetString(perfumeOlList.ElementAt(0).getNote() + "Text");
showPerfumeQty0Label.Text = perfumeOlList.ElementAt(0).getQty().ToString();
perfumeSubTotal0 = ((perfumeOlList.ElementAt(0).getDiscount() != null) ? (perfumeOlList.ElementAt(0).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(0).getDiscount()))) * perfumeOlList.ElementAt(0).getQty() : perfumeOlList.ElementAt(0).getUnitPrice() * perfumeOlList.ElementAt(0).getQty()).Value;
showPerfumeSubTotal0Label.Text = rs.GetString("hkdText") + perfumeSubTotal0.ToString();
}
else
{
showPerfumeId0Label.Text = " ";
showPerfumeName0Label.Text = " ";
showPerfumeUnitPrice0Label.Text = " ";
showPerfumeDiscount0Label.Text = " ";
showPerfumeNote0Label.Text = " ";
showPerfumeQty0Label.Text = " ";
showPerfumeSubTotal0Label.Text = " ";
}
double perfumeSubTotal1 = 0;
if (perfumeOlList.Count > 1)
{
showPerfumeId1Label.Text = perfumeOlList.ElementAt(1).getProductID();
showPerfumeName1Label.Text = perfumeOlList.ElementAt(1).getProductName();
showPerfumeUnitPrice1Label.Text = rs.GetString("hkdText") + perfumeOlList.ElementAt(1).getUnitPrice().ToString();
showPerfumeDiscount1Label.Text = (perfumeOlList.ElementAt(1).getDiscount() != null) ? perfumeOlList.ElementAt(1).getDiscount().ToString() + "% OFF" : "";
showPerfumeNote1Label.Text = rs.GetString(perfumeOlList.ElementAt(1).getNote() + "Text");
showPerfumeQty1Label.Text = perfumeOlList.ElementAt(1).getQty().ToString();
perfumeSubTotal1 = ((perfumeOlList.ElementAt(1).getDiscount() != null) ? (perfumeOlList.ElementAt(1).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(1).getDiscount()))) * perfumeOlList.ElementAt(1).getQty() : perfumeOlList.ElementAt(1).getUnitPrice() * perfumeOlList.ElementAt(1).getQty()).Value;
showPerfumeSubTotal1Label.Text = rs.GetString("hkdText") + perfumeSubTotal1.ToString();
}
else
{
showPerfumeId1Label.Text = " ";
showPerfumeName1Label.Text = " ";
showPerfumeUnitPrice1Label.Text = " ";
showPerfumeDiscount1Label.Text = " ";
showPerfumeNote1Label.Text = " ";
showPerfumeQty1Label.Text = " ";
showPerfumeSubTotal1Label.Text = " ";
}
double perfumeSubTotal2 = 0;
if (perfumeOlList.Count > 2)
{
showPerfumeId2Label.Text = perfumeOlList.ElementAt(2).getProductID();
showPerfumeName2Label.Text = perfumeOlList.ElementAt(2).getProductName();
showPerfumeUnitPrice2Label.Text = rs.GetString("hkdText") + perfumeOlList.ElementAt(2).getUnitPrice().ToString();
showPerfumeDiscount2Label.Text = (perfumeOlList.ElementAt(2).getDiscount() != null) ? perfumeOlList.ElementAt(2).getDiscount().ToString() + "% OFF" : "";
showPerfumeNote2Label.Text = rs.GetString(perfumeOlList.ElementAt(2).getNote() + "Text");
showPerfumeQty2Label.Text = perfumeOlList.ElementAt(2).getQty().ToString();
perfumeSubTotal2 = ((perfumeOlList.ElementAt(2).getDiscount() != null) ? (perfumeOlList.ElementAt(2).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(2).getDiscount()))) * perfumeOlList.ElementAt(2).getQty() : perfumeOlList.ElementAt(2).getUnitPrice() * perfumeOlList.ElementAt(2).getQty()).Value;
showPerfumeSubTotal2Label.Text = rs.GetString("hkdText") + ((perfumeOlList.ElementAt(2).getDiscount() != null) ? ((perfumeOlList.ElementAt(2).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(2).getDiscount()))) * perfumeOlList.ElementAt(2).getQty()).ToString() : (perfumeOlList.ElementAt(2).getUnitPrice() * perfumeOlList.ElementAt(2).getQty()).ToString());
}
else
{
showPerfumeId2Label.Text = " ";
showPerfumeName2Label.Text = " ";
showPerfumeUnitPrice2Label.Text = " ";
showPerfumeDiscount2Label.Text = " ";
showPerfumeNote2Label.Text = " ";
showPerfumeQty2Label.Text = " ";
showPerfumeSubTotal2Label.Text = " ";
}
double perfumeSubTotal3 = 0;
if (perfumeOlList.Count > 3)
{
showPerfumeId3Label.Text = perfumeOlList.ElementAt(3).getProductID();
showPerfumeName3Label.Text = perfumeOlList.ElementAt(3).getProductName();
showPerfumeUnitPrice3Label.Text = rs.GetString("hkdText") + perfumeOlList.ElementAt(3).getUnitPrice().ToString();
showPerfumeDiscount3Label.Text = (perfumeOlList.ElementAt(3).getDiscount() != null) ? perfumeOlList.ElementAt(3).getDiscount().ToString() + "% OFF" : "";
showPerfumeNote3Label.Text = rs.GetString(perfumeOlList.ElementAt(3).getNote() + "Text");
showPerfumeQty3Label.Text = perfumeOlList.ElementAt(3).getQty().ToString();
perfumeSubTotal3 = ((perfumeOlList.ElementAt(3).getDiscount() != null) ? (perfumeOlList.ElementAt(3).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(3).getDiscount()))) * perfumeOlList.ElementAt(3).getQty() : perfumeOlList.ElementAt(3).getUnitPrice() * perfumeOlList.ElementAt(3).getQty()).Value;
showPerfumeSubTotal3Label.Text = rs.GetString("hkdText") + perfumeSubTotal3.ToString();
}
else
{
showPerfumeId3Label.Text = " ";
showPerfumeName3Label.Text = " ";
showPerfumeUnitPrice3Label.Text = " ";
showPerfumeDiscount3Label.Text = " ";
showPerfumeNote3Label.Text = " ";
showPerfumeQty3Label.Text = " ";
showPerfumeSubTotal3Label.Text = " ";
}
double perfumeSubTotal4 = 0;
if (perfumeOlList.Count > 4)
{
showPerfumeId4Label.Text = perfumeOlList.ElementAt(4).getProductID();
showPerfumeName4Label.Text = perfumeOlList.ElementAt(4).getProductName();
showPerfumeUnitPrice4Label.Text = rs.GetString("hkdText") + perfumeOlList.ElementAt(4).getUnitPrice().ToString();
showPerfumeDiscount4Label.Text = (perfumeOlList.ElementAt(4).getDiscount() != null) ? perfumeOlList.ElementAt(4).getDiscount().ToString() + "% OFF" : "";
showPerfumeNote4Label.Text = rs.GetString(perfumeOlList.ElementAt(4).getNote() + "Text");
showPerfumeQty4Label.Text = perfumeOlList.ElementAt(4).getQty().ToString();
perfumeSubTotal4 = ((perfumeOlList.ElementAt(4).getDiscount() != null) ? (perfumeOlList.ElementAt(4).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(4).getDiscount()))) * perfumeOlList.ElementAt(4).getQty() : perfumeOlList.ElementAt(4).getUnitPrice() * perfumeOlList.ElementAt(4).getQty()).Value;
showPerfumeSubTotal4Label.Text = rs.GetString("hkdText") + perfumeSubTotal4.ToString();
}
else
{
showPerfumeId4Label.Text = " ";
showPerfumeName4Label.Text = " ";
showPerfumeUnitPrice4Label.Text = " ";
showPerfumeDiscount4Label.Text = " ";
showPerfumeNote4Label.Text = " ";
showPerfumeQty4Label.Text = " ";
showPerfumeSubTotal4Label.Text = " ";
}
double perfumeSubTotal5 = 0;
if (perfumeOlList.Count > 5)
{
showPerfumeId5Label.Text = perfumeOlList.ElementAt(5).getProductID();
showPerfumeName5Label.Text = perfumeOlList.ElementAt(5).getProductName();
showPerfumeUnitPrice5Label.Text = rs.GetString("hkdText") + perfumeOlList.ElementAt(5).getUnitPrice().ToString();
showPerfumeDiscount5Label.Text = (perfumeOlList.ElementAt(5).getDiscount() != null) ? perfumeOlList.ElementAt(5).getDiscount().ToString() + "% OFF" : "";
showPerfumeNote5Label.Text = rs.GetString(perfumeOlList.ElementAt(5).getNote() + "Text");
showPerfumeQty5Label.Text = perfumeOlList.ElementAt(5).getQty().ToString();
perfumeSubTotal5 = ((perfumeOlList.ElementAt(5).getDiscount() != null) ? (perfumeOlList.ElementAt(5).getUnitPrice() * (0.01 * (100 - perfumeOlList.ElementAt(5).getDiscount()))) * perfumeOlList.ElementAt(5).getQty() : perfumeOlList.ElementAt(5).getUnitPrice() * perfumeOlList.ElementAt(5).getQty()).Value;
showPerfumeSubTotal5Label.Text = rs.GetString("hkdText") + perfumeSubTotal5.ToString();
}
else
{
showPerfumeId5Label.Text = " ";
showPerfumeName5Label.Text = " ";
showPerfumeUnitPrice5Label.Text = " ";
showPerfumeDiscount5Label.Text = " ";
showPerfumeNote5Label.Text = " ";
showPerfumeQty5Label.Text = " ";
showPerfumeSubTotal5Label.Text = " ";
}
orderTotal = null;
orderTotal = packageSubTotal + bottleSubTotal + perfumeSubTotal0 + perfumeSubTotal1 + perfumeSubTotal2 + perfumeSubTotal3 + perfumeSubTotal4 + perfumeSubTotal5;
showOrderTotalLabel.Text = rs.GetString("hkdText") + orderTotal.Value.ToString();
if (orderDetail.getApprovedDate() == null)
{
if (disableApprovalButton)
{
approvalButton.Enabled = false;
}
else
{
approvalButton.Enabled = true;
}
rejectButton.Enabled = true;
}
else
{
approvalButton.Enabled = false;
rejectButton.Enabled = false;
}
}