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