public DataTable getInvoiceChargesDs(int iv_no)
{
IVChManager = new IVChargeItemsManager(elt_account_number);
return(IVChManager.getIVChargeItems(iv_no));
}
public InvoiceRecord getInvoiceRecord(int invoice_no)
{
SQL = "select * from Invoice where elt_account_number = " + elt_account_number + " and invoice_no=" + invoice_no;
DataTable dt = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(SQL, Con);
InvoiceRecord ivRec = new InvoiceRecord();
try
{
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
GeneralUtility util = new GeneralUtility();
util.removeNull(ref dt);
ivRec.accounts_receivable = Int32.Parse(dt.Rows[0]["accounts_receivable"].ToString());
ivRec.agent_profit = Decimal.Parse(dt.Rows[0]["agent_profit"].ToString());
ivRec.air_ocean = dt.Rows[0]["air_ocean"].ToString();
ivRec.inland_type = dt.Rows[0]["inland_type"].ToString(); //added by stanley on 12/14
ivRec.amount_charged = Decimal.Parse(dt.Rows[0]["amount_charged"].ToString());
ivRec.amount_paid = Decimal.Parse(dt.Rows[0]["amount_paid"].ToString());
ivRec.Arrival_Dept = dt.Rows[0]["Arrival_Dept"].ToString();
ivRec.balance = Decimal.Parse(dt.Rows[0]["balance"].ToString());
ivRec.Carrier = dt.Rows[0]["Carrier"].ToString();
ivRec.consignee = dt.Rows[0]["consignee"].ToString();
ivRec.Customer_info = dt.Rows[0]["Customer_info"].ToString();
ivRec.Customer_Name = dt.Rows[0]["Customer_Name"].ToString();
ivRec.Customer_Number = Int32.Parse(dt.Rows[0]["Customer_Number"].ToString());
// ivRec.deposit_to = Int32.Parse((dt.Rows[0]["deposit_to"].ToString()));
ivRec.Description = dt.Rows[0]["Description"].ToString();
ivRec.dest = dt.Rows[0]["dest"].ToString();
ivRec.entry_date = dt.Rows[0]["entry_date"].ToString();
ivRec.entry_no = dt.Rows[0]["entry_no"].ToString();
ivRec.existing_credits = Decimal.Parse(dt.Rows[0]["existing_credits"].ToString());
ivRec.hawb_num = dt.Rows[0]["hawb_num"].ToString();
ivRec.import_export = dt.Rows[0]["import_export"].ToString();
ivRec.in_memo = dt.Rows[0]["in_memo"].ToString();
ivRec.invoice_date = ((DateTime)dt.Rows[0]["invoice_date"]).ToShortDateString();
ivRec.Invoice_no = Int32.Parse(dt.Rows[0]["invoice_no"].ToString());
ivRec.invoice_type = dt.Rows[0]["invoice_type"].ToString();
ivRec.is_org_merged = dt.Rows[0]["is_org_merged"].ToString();
ivRec.lock_ap = dt.Rows[0]["lock_ap"].ToString();
ivRec.lock_ar = dt.Rows[0]["lock_ar"].ToString();
ivRec.mawb_num = dt.Rows[0]["mawb_num"].ToString();
ivRec.origin = dt.Rows[0]["origin"].ToString();
ivRec.Origin_Dest = dt.Rows[0]["Origin_Dest"].ToString();
ivRec.pay_status = dt.Rows[0]["pay_status"].ToString();
ivRec.pmt_method = dt.Rows[0]["pmt_method"].ToString();
ivRec.received_amt = Decimal.Parse(dt.Rows[0]["received_amt"].ToString());
ivRec.ref_no = dt.Rows[0]["ref_no"].ToString();
ivRec.ref_no_Our = dt.Rows[0]["ref_no_Our"].ToString();
ivRec.AMS_No = dt.Rows[0]["AMS_No"].ToString(); //added by stanley on 12/13/2007
ivRec.inland_type = dt.Rows[0]["inland_type"].ToString(); //added by stanley on 12/14/2007
ivRec.remarks = dt.Rows[0]["remarks"].ToString();
ivRec.sale_tax = Decimal.Parse(dt.Rows[0]["sale_tax"].ToString());
ivRec.shipper = dt.Rows[0]["shipper"].ToString();
ivRec.subtotal = Decimal.Parse(dt.Rows[0]["subtotal"].ToString());
ivRec.term_curr = Int32.Parse(dt.Rows[0]["term_curr"].ToString());
ivRec.term30 = dt.Rows[0]["term30"].ToString();
ivRec.term60 = dt.Rows[0]["term60"].ToString();
ivRec.term90 = dt.Rows[0]["term90"].ToString();
ivRec.Total_Charge_Weight = dt.Rows[0]["Total_Charge_Weight"].ToString();
ivRec.total_cost = Decimal.Parse(dt.Rows[0]["total_cost"].ToString());
ivRec.Total_Gross_Weight = dt.Rows[0]["Total_Gross_Weight"].ToString();
ivRec.Total_Pieces = dt.Rows[0]["Total_Pieces"].ToString();
DataTable dtIVCh = IVChManager.getIVChargeItems(invoice_no);
DataTable dtIVCost = IVCostManager.getIVCostItems(invoice_no);
ArrayList dtBDetail = bdMgr.getBillDetailListForInvoice(invoice_no);
ivRec.setChargeItemListWithDataTable(dtIVCh);
ivRec.setCostItemListWithDataTable(dtIVCost);
ivRec.BillDetailList = dtBDetail;
}
}
catch (Exception ex)
{
//15
throw ex;
}
return(ivRec);
}
