protected override void doUpdate(EventJournal en) { MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction(); m_command.Transaction = trc; try { Payment e = (Payment)en; m_command.CommandText = e.GetUpdateSQL(); m_command.ExecuteNonQuery(); foreach (PaymentItem sti in e.EVENT_JOURNAL_ITEMS) { sti.VENDOR_BALANCE_SUPPLIER_INVOICE_TYPE = sti.SUPPLIER_INVOICE_JOURNAL_ITEM.GET_EVENT_JOURNAL.VENDOR_BALANCE_ENTRY_TYPE; if (sti.ID > 0) { m_command.CommandText = sti.GetUpdateSQL(); m_command.ExecuteNonQuery(); } else { m_command.CommandText = sti.GetInsertSQL(); m_command.ExecuteNonQuery(); m_command.CommandText = PaymentItem.SelectMaxIDSQL(); sti.ID = Convert.ToInt32(m_command.ExecuteScalar()); } if (sti.PAYMENT_TYPE == PaymentType.APDebitNote) { m_command.CommandText = APDebitNote.UpdateUsedForPayment(sti.AP_DEBIT_NOTE.ID, true); m_command.ExecuteNonQuery(); } } m_command.CommandText = PaymentItem.GetNotInTypeAPDN(e.ID, e.EVENT_JOURNAL_ITEMS); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); IList pymnts = PaymentItem.TransformReaderList(r); r.Close(); foreach (PaymentItem itm in pymnts) { m_command.CommandText = APDebitNote.UpdateUsedForPayment(itm.AP_DEBIT_NOTE.ID, false); m_command.ExecuteNonQuery(); } m_command.CommandText = PaymentItem.DeleteUpdate(e.ID, e.EVENT_JOURNAL_ITEMS); m_command.ExecuteNonQuery(); trc.Commit(); } catch (Exception x) { trc.Rollback(); throw x; } }
internal static IList FindPaymentUsingAPDN(MySql.Data.MySqlClient.MySqlCommand cmd, int apDNID) { cmd.CommandText = PaymentItem.GetPaymentItemByAPDN(apDNID); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); IList result = PaymentItem.TransformReaderList(r); r.Close(); foreach (PaymentItem i in result) { cmd.CommandText = Payment.GetByIDSQL(i.EVENT_JOURNAL.ID); r = cmd.ExecuteReader(); i.EVENT_JOURNAL = Payment.TransformReader(r); r.Close(); } return(result); }
internal static IList FindPaidCustomerInvoice(MySql.Data.MySqlClient.MySqlCommand cmd, int siID) { cmd.CommandText = PaymentItem.GetSupplierInvoiceBySOIID(siID, VendorBalanceEntryType.CustomerInvoice); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); IList result = PaymentItem.TransformReaderList(r); r.Close(); foreach (PaymentItem i in result) { cmd.CommandText = Payment.GetByIDSQL(i.EVENT_JOURNAL.ID); r = cmd.ExecuteReader(); i.EVENT_JOURNAL = Payment.TransformReader(r); r.Close(); } return(result); }
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); }