protected override EventJournal doGet(int ID) { m_command.CommandText = ARCreditNote.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); ARCreditNote st = ARCreditNote.TransformReader(r); r.Close(); m_command.CommandText = ARCreditNoteItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = ARCreditNoteItem.TransformReaderList(r); r.Close(); foreach (ARCreditNoteItem sti in stis) { sti.EVENT_JOURNAL = st; //sti.VENDOR = PartRepository.GetByID(m_command, sti.PART.ID); sti.VENDOR_BALANCE_ENTRY = VendorBalanceEntryRepository.FindVendorBalanceEntryByEventItem(m_command, sti.ID, sti.VENDOR_BALANCE_ENTRY_TYPE); //sti.GRN_ITEM = GoodReceiveNoteRepository.FindGoodReceiveNoteItem(m_command, sti.GRN_ITEM.ID); //sti.GRN_ITEM.PART = PartRepository.GetByID(m_command, sti.GRN_ITEM.PART.ID); if (sti.SALES_RETURN != null) { if (sti.SALES_RETURN.ID > 0) { sti.SALES_RETURN = SalesReturnRepository.GetSalesReturnForCreditNote(m_command, sti.SALES_RETURN); } } st.EVENT_JOURNAL_ITEMS.Add(sti); } return(st); }
protected override EventJournal doGet(int ID) { m_command.CommandText = Receipt.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); Receipt st = Receipt.TransformReader(r); r.Close(); if (st == null) { return(null); } m_command.CommandText = ReceiptItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = ReceiptItem.TransformReaderList(r); r.Close(); foreach (ReceiptItem sti in stis) { sti.EVENT_JOURNAL = st; //sti.VENDOR = PartRepository.GetByID(m_command, sti.PART.ID); sti.VENDOR_BALANCE_ENTRY = VendorBalanceEntryRepository.FindVendorBalanceEntryByEventItem(m_command, sti.ID, sti.VENDOR_BALANCE_ENTRY_TYPE); //sti.GRN_ITEM = GoodReceiveNoteRepository.FindGoodReceiveNoteItem(m_command, sti.GRN_ITEM.ID); //sti.GRN_ITEM.PART = PartRepository.GetByID(m_command, sti.GRN_ITEM.PART.ID); if (sti.VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE == VendorBalanceEntryType.CustomerInvoice) { if (sti.CUSTOMER_INVOICE_JOURNAL_ITEM != null) { sti.CUSTOMER_INVOICE_JOURNAL_ITEM = CustomerInvoiceJournalRepository.FindCIJournalItemlistForReceipt(m_command, sti.CUSTOMER_INVOICE_JOURNAL_ITEM.GetID()); } } if (sti.VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE == VendorBalanceEntryType.CustomerOutStandingInvoice) { if (sti.CUSTOMER_INVOICE_JOURNAL_ITEM != null) { sti.CUSTOMER_INVOICE_JOURNAL_ITEM = CustomerOutStandingInvoiceRepository.FindCOIItemlistForReceipt(m_command, sti.CUSTOMER_INVOICE_JOURNAL_ITEM.GetID()); } } if (sti.PAYMENT_TYPE == ReceiptType.Bank) { sti.BANK = getBank(sti.BANK.ID); } if (sti.PAYMENT_TYPE == ReceiptType.ARCreditNote) { sti.AR_CREDIT_NOTE = ARCreditNoteRepository.FindARCRForReceipt(m_command, sti.AR_CREDIT_NOTE.ID); } st.EVENT_JOURNAL_ITEMS.Add(sti); } return(st); }
protected override EventJournal doGet(int ID) { m_command.CommandText = Payment.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); Payment st = Payment.TransformReader(r); r.Close(); m_command.CommandText = PaymentItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = PaymentItem.TransformReaderList(r); r.Close(); foreach (PaymentItem sti in stis) { sti.EVENT_JOURNAL = st; //sti.VENDOR = PartRepository.GetByID(m_command, sti.PART.ID); sti.VENDOR_BALANCE_ENTRY = VendorBalanceEntryRepository.FindVendorBalanceEntryByEventItem(m_command, sti.ID, sti.VENDOR_BALANCE_ENTRY_TYPE); //sti.GRN_ITEM = GoodReceiveNoteRepository.FindGoodReceiveNoteItem(m_command, sti.GRN_ITEM.ID); //sti.GRN_ITEM.PART = PartRepository.GetByID(m_command, sti.GRN_ITEM.PART.ID); if (sti.VENDOR_BALANCE_SUPPLIER_INVOICE_TYPE == VendorBalanceEntryType.SupplierInvoice) { if (sti.SUPPLIER_INVOICE_JOURNAL_ITEM != null) { sti.SUPPLIER_INVOICE_JOURNAL_ITEM = SupplierInvoiceJournalRepository.FindSIJournalItemlistForPayment(m_command, sti.SUPPLIER_INVOICE_JOURNAL_ITEM.GetID()); } } if (sti.VENDOR_BALANCE_SUPPLIER_INVOICE_TYPE == VendorBalanceEntryType.SupplierOutStandingInvoice) { if (sti.SUPPLIER_INVOICE_JOURNAL_ITEM != null) { sti.SUPPLIER_INVOICE_JOURNAL_ITEM = SupplierOutStandingInvoiceRepository.FindSOIItemlistForPayment(m_command, sti.SUPPLIER_INVOICE_JOURNAL_ITEM.GetID()); } } if (sti.PAYMENT_TYPE == PaymentType.Bank) { sti.BANK = getBank(sti.BANK.ID); } if (sti.PAYMENT_TYPE == PaymentType.APDebitNote) { sti.AP_DEBIT_NOTE = APDebitNoteRepository.FindAPDNForPayment(m_command, sti.AP_DEBIT_NOTE.ID); } st.EVENT_JOURNAL_ITEMS.Add(sti); } return(st); }
protected override EventJournal doGet(int ID) { m_command.CommandText = SupplierInvoiceJournal.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); SupplierInvoiceJournal st = SupplierInvoiceJournal.TransformReader(r); r.Close(); m_command.CommandText = SupplierInvoiceJournalItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = SupplierInvoiceJournalItem.TransformReaderList(r); r.Close(); foreach (SupplierInvoiceJournalItem sti in stis) { sti.EVENT_JOURNAL = st; //sti.VENDOR = PartRepository.GetByID(m_command, sti.PART.ID); sti.VENDOR_BALANCE_ENTRY = VendorBalanceEntryRepository.FindVendorBalanceEntryByEventItem(m_command, sti.ID, sti.VENDOR_BALANCE_ENTRY_TYPE); //sti.GRN_ITEM = GoodReceiveNoteRepository.FindGoodReceiveNoteItem(m_command, sti.GRN_ITEM.ID); //sti.GRN_ITEM.PART = PartRepository.GetByID(m_command, sti.GRN_ITEM.PART.ID); st.EVENT_JOURNAL_ITEMS.Add(sti); } return(st); }