private void LoadItem(string invoiceNo) { DataTable dtInvoiceItem = new DataTable("INVOICE_ITEM"); dtInvoiceItem = InvoiceItemController.GetInvoiceItems(invoiceNo); gvDt.DataSource = dtInvoiceItem; gvDt.Visible = true; }
public void GetInvoiceItemsTest() { var id = Guid.Parse("75A3489C-6321-4D5C-9061-1AABA0FC8BBA"); Assert.IsNotNull(_context.Invoice.Find(id), "Null. No invoice by Id."); var result = _InvoiceItemController.GetInvoiceItems(id).Value.ToList(); Assert.IsNotNull(result, "Null. No items by invoice Id."); var resultDB = _context.InvoiceItem.Where(x => x.InvoiceId == id).ToList(); Assert.IsTrue(result.Count() == resultDB.Count(), "False. Count of items is not equal."); }
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; }