private void InsertItemTaxIntoSalesCart(InvoiceItemTax invoiceItemTaxes, object[] objPageDetails)
{
string strQueryName = "InsertItemTaxIntoSalesCart";
string sqlCmd = "INSERT INTO tbl_currentSalesItemsTaxes VALUES(@intInvoiceItemID, @intTaxID, @fltTaxAmount, @bitIsTaxCharged)";
object[][] parms =
{
new object[] { "@intInvoiceItemID", invoiceItemTaxes.intInvoiceItemID },
new object[] { "@intTaxID", invoiceItemTaxes.intTaxTypeID },
new object[] { "@fltTaxAmount", invoiceItemTaxes.fltTaxAmount },
new object[] { "@bitIsTaxCharged", invoiceItemTaxes.bitIsTaxCharged }
};
DBC.MakeDataBaseCallToNonReturnDataQuery(sqlCmd, parms, objPageDetails, strQueryName);
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
//Collects current method for error tracking
string method = "OnRowUpdating";
object[] objPageDetails = { Session["currPage"].ToString(), method };
try
{
Invoice invoice = IM.CallReturnCurrentInvoice(Convert.ToInt32(Request.QueryString["invoice"].ToString()), objPageDetails)[0];
lblInvalidQty.Visible = false;
//Stores all the data for each element in the row
#pragma warning disable IDE0017 // Simplify object initialization
InvoiceItems newItemInfo = new InvoiceItems();
#pragma warning restore IDE0017 // Simplify object initialization
newItemInfo.intInvoiceID = invoice.intInvoiceID;
newItemInfo.intInvoiceItemID = Convert.ToInt32(((Label)GrdCartItems.Rows[e.RowIndex].Cells[0].FindControl("lblInvoiceItemID")).Text);
newItemInfo.intInventoryID = IIM.CallReturnInventoryIDFromInvoiceItemID(newItemInfo.intInvoiceItemID, objPageDetails);
//newItemInfo.fltItemPrice = Convert.ToDouble(((Label)grdCartItems.Rows[e.RowIndex].Cells[5].FindControl("price")).Text.Replace("$",""));
newItemInfo.fltItemDiscount = Convert.ToDouble(((TextBox)GrdCartItems.Rows[e.RowIndex].Cells[6].FindControl("txtAmnt")).Text);
newItemInfo.intItemQuantity = Convert.ToInt32(((TextBox)GrdCartItems.Rows[e.RowIndex].Cells[3].Controls[0]).Text);
newItemInfo.bitIsDiscountPercent = ((CheckBox)GrdCartItems.Rows[e.RowIndex].Cells[6].FindControl("ckbPercentageEdit")).Checked;
newItemInfo.bitIsClubTradeIn = ((CheckBox)GrdCartItems.Rows[e.RowIndex].Cells[7].FindControl("chkTradeIn")).Checked;
newItemInfo.intItemTypeID = Convert.ToInt32(((Label)GrdCartItems.Rows[e.RowIndex].Cells[8].FindControl("lblTypeID")).Text);
newItemInfo.invoiceItemTaxes = new List <InvoiceItemTax>();
CheckBoxList checkboxTaxes = (CheckBoxList)GrdCartItems.Rows[e.RowIndex].Cells[9].FindControl("cblTaxes");
foreach (ListItem item in checkboxTaxes.Items)
{
#pragma warning disable IDE0017 // Simplify object initialization
InvoiceItemTax iit = new InvoiceItemTax();
#pragma warning restore IDE0017 // Simplify object initialization
iit.intInvoiceItemID = newItemInfo.intInvoiceItemID;
iit.varTaxName = item.Text;
iit.bitIsTaxCharged = Convert.ToBoolean(item.Selected);
foreach (InvoiceItems itemCheck in invoice.invoiceItems)
{
foreach (InvoiceItemTax itemTaxCheck in itemCheck.invoiceItemTaxes)
{
if (itemCheck.intInvoiceItemID == iit.intInvoiceItemID)
{
if (itemTaxCheck.varTaxName == iit.varTaxName)
{
itemTaxCheck.bitIsTaxCharged = iit.bitIsTaxCharged;
newItemInfo.invoiceItemTaxes.Add(itemTaxCheck);
newItemInfo.fltItemPrice = itemCheck.fltItemPrice;
}
}
}
}
}
if (!IIM.ValidQTY(newItemInfo, objPageDetails))
{
if (newItemInfo.bitIsClubTradeIn)
{
IIM.UpdateItemFromCurrentSalesTable(newItemInfo, invoice.intTransactionTypeID, objPageDetails);
}
else
{
//if it is less than 0 then there is not enough in invenmtory to sell
lblInvalidQty.Visible = true;
//Display error message
lblInvalidQty.Text = "Quantity Exceeds the Remaining Inventory";
lblInvalidQty.ForeColor = System.Drawing.Color.Red;
}
}
else
{
IIM.UpdateItemFromCurrentSalesTable(newItemInfo, invoice.intTransactionTypeID, objPageDetails);
}
//Clears the indexed row
GrdCartItems.EditIndex = -1;
//Recalculates the new subtotal and Binds cart items to grid view
//Session["currentInvoice"] = invoice;
UpdateInvoiceTotals();
}
//Exception catch
catch (ThreadAbortException tae) { }
catch (Exception ex)
{
//Log all info into error table
ER.CallLogError(ex, CU.employee.intEmployeeID, Convert.ToString(Session["currPage"]) + "-V3.2", method, this);
//Display message box
MessageBoxCustom.ShowMessage("An Error has occurred and been logged. "
+ "If you continue to receive this message please contact "
+ "your system administrator.", this);
}
}
