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