public void Void(Int64 TransactionID, decimal ItemSold, decimal QuantitySold, decimal GrossSales, decimal SubTotal, decimal NetSales, decimal ItemsDiscount, decimal SNRItemsDiscount, decimal PWDItemsDiscount, decimal OtherItemsDiscount, decimal Discount, decimal SNRDiscount, decimal PWDDiscount, decimal OtherDiscount, decimal TransDiscount, DiscountTypes TransDiscountType, decimal VAT, decimal VATableAmount, decimal ZeroRatedSales, decimal NonVATableAmount, decimal VATExempt, decimal EVAT, decimal EVATableAmount, decimal NonEVATableAmount, decimal LocalTax, decimal Charge, Int64 CashierID, string CashierName)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblTransactions SET " +
"TransactionStatus = @TransactionStatus, " +
"ItemSold = @ItemSold, " +
"QuantitySold = @QuantitySold, " +
"GrossSales = @GrossSales, " +
"SubTotal = @SubTotal, " +
"NetSales = @NetSales, " +
"ItemsDiscount = @ItemsDiscount, " +
"SNRItemsDiscount = @SNRItemsDiscount, " +
"PWDItemsDiscount = @PWDItemsDiscount, " +
"OtherItemsDiscount = @OtherItemsDiscount, " +
"Discount = @Discount, " +
"SNRDiscount = @SNRDiscount, " +
"PWDDiscount = @PWDDiscount, " +
"OtherDiscount = @OtherDiscount, " +
"VAT = @VAT, " +
"VATableAmount = @VATableAmount, " +
"ZeroRatedSales = @ZeroRatedSales, " +
"NonVATableAmount = @NonVATableAmount, " +
"VATExempt = @VATExempt, " +
"EVAT = @EVAT, " +
"EVATableAmount = @EVATableAmount, " +
"NonEVATableAmount = @NonEVATableAmount, " +
"LocalTax = @LocalTax, " +
"DateClosed = NOW(), " +
"Charge = @Charge, " +
"CashierID = @CashierID, " +
"CashierName = @CashierName, " +
"LastModified = NOW() " +
"WHERE TransactionID = @TransactionID;";
cmd.Parameters.AddWithValue("TransactionStatus", TransactionStatus.Void.ToString("d"));
cmd.Parameters.AddWithValue("ItemSold", ItemSold);
cmd.Parameters.AddWithValue("QuantitySold", QuantitySold);
cmd.Parameters.AddWithValue("GrossSales", GrossSales);
cmd.Parameters.AddWithValue("SubTotal", SubTotal);
cmd.Parameters.AddWithValue("NetSales", NetSales);
cmd.Parameters.AddWithValue("ItemsDiscount", ItemsDiscount);
cmd.Parameters.AddWithValue("SNRItemsDiscount", SNRItemsDiscount);
cmd.Parameters.AddWithValue("PWDItemsDiscount", PWDItemsDiscount);
cmd.Parameters.AddWithValue("OtherItemsDiscount", OtherItemsDiscount);
cmd.Parameters.AddWithValue("Discount", Discount);
cmd.Parameters.AddWithValue("SNRDiscount", SNRDiscount);
cmd.Parameters.AddWithValue("PWDDiscount", PWDDiscount);
cmd.Parameters.AddWithValue("OtherDiscount", OtherDiscount);
cmd.Parameters.AddWithValue("VAT", VAT);
cmd.Parameters.AddWithValue("VATableAmount", VATableAmount);
cmd.Parameters.AddWithValue("ZeroRatedSales", ZeroRatedSales);
cmd.Parameters.AddWithValue("NonVATableAmount", NonVATableAmount);
cmd.Parameters.AddWithValue("VATExempt", VATExempt);
cmd.Parameters.AddWithValue("EVAT", EVAT);
cmd.Parameters.AddWithValue("EVATableAmount", EVATableAmount);
cmd.Parameters.AddWithValue("NonEVATableAmount", NonEVATableAmount);
cmd.Parameters.AddWithValue("LocalTax", LocalTax);
cmd.Parameters.AddWithValue("Charge", Charge);
cmd.Parameters.AddWithValue("CashierID", CashierID);
cmd.Parameters.AddWithValue("CashierName", CashierName);
cmd.Parameters.AddWithValue("TransactionID", TransactionID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
SalesTransactionItems clsSalesTransactionItems = new SalesTransactionItems(base.Connection, base.Transaction);
clsSalesTransactionItems.VoidByTransaction(TransactionID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
