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