private void LoadItem(string invoiceNo) { DataTable dtInvoiceItem = new DataTable("INVOICE_ITEM"); dtInvoiceItem = InvoiceItemController.GetInvoiceItems(invoiceNo); gvDt.DataSource = dtInvoiceItem; gvDt.Visible = true; }
private void LoadDetail() { if (String.IsNullOrEmpty(this.invoiceNo)) { dtInvoiceItem = new DataTable("INVOICE_ITEM"); dtInvoiceItem = OrderItemController.GetOrderItemReadyToSell(this.orderNo); if (dtInvoiceItem.Rows.Count > 0) { decimal unitPrice; decimal unitPriceCurrent; decimal discPer; //decimal discountPer; Product product; for (int i = 0; i < dtInvoiceItem.Rows.Count; i++) { string productCode = dtInvoiceItem.Rows[i][ConstColumns.PRODUCT_CODE].ToString(); unitPrice = Globals.GetPriceList(cboCustomer.SelectedValue.ToString(), productCode, dtpInvoiceDate.Value); unitPriceCurrent = unitPrice; // Globals.GetPriceListCurrent(cboCustomer.SelectedValue.ToString(), productCode, dtpInvoiceDate.Value); discPer = 0; //Globals.GetDiscountPer(cboCustomer.SelectedValue.ToString(), dtpInvoiceDate.Value); product = ProductController.GetProduct(productCode); dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE_CURRENT] = unitPriceCurrent; dtInvoiceItem.Rows[i][ConstColumns.DISC_PER] = discPer; dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE] = unitPrice; dtInvoiceItem.Rows[i][ConstColumns.SALE_UNIT_METHOD] = product.SaleUnitMethod; if (dtInvoiceItem.Rows[i][ConstColumns.SALE_UNIT_METHOD].ToString() == "Q") { dtInvoiceItem.Rows[i][ConstColumns.GROSS_AMT] = Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE]) * Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.QTY]); } else { dtInvoiceItem.Rows[i][ConstColumns.GROSS_AMT] = Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.UNIT_PRICE]) * Convert.ToDecimal(dtInvoiceItem.Rows[i][ConstColumns.WGH]); } } dtInvoiceItem.AcceptChanges(); gv.Refresh(); } Calculate_Total(); } else { dtInvoiceItem = new DataTable("INVOICE_ITEM"); dtInvoiceItem = InvoiceItemController.GetInvoiceItems(this.invoiceNo); } gv.DataSource = dtInvoiceItem; }
public void TestInit() { _context = Utility.GetDbContext(); _InvoiceItemController = new InvoiceItemController(_context); }