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