public int Compare(object x, object y) { VendorBalanceEntry X = (VendorBalanceEntry)x; VendorBalanceEntry Y = (VendorBalanceEntry)y; return(DateTime.Compare(X.TRANSACTION_DATE, Y.TRANSACTION_DATE)); }
protected void saveVendorBalanceEntry(VendorBalanceEntry vbe) { if (vbe != null) { VendorBalanceEntryRepository.Save(m_command, vbe); } }
public static VendorBalanceEntry FindVendorBalanceEntryByEventItem(MySql.Data.MySqlClient.MySqlCommand cmd, int itemID, VendorBalanceEntryType scetype) { cmd.CommandText = VendorBalanceEntry.FindByEventJournalItem(itemID, scetype); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); VendorBalanceEntry res = VendorBalanceEntry.TransformReader(r); r.Close(); return(res); }
public override bool Equals(object obj) { VendorBalanceEntry sce = (VendorBalanceEntry)obj; if (sce == null) { return(false); } return(sce.ID == ID); }
public static void Save(MySql.Data.MySqlClient.MySqlCommand cmd, VendorBalance sc) { cmd.CommandText = sc.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = VendorBalance.SelectMaxIDSQL(); sc.ID = Convert.ToInt32(cmd.ExecuteScalar()); foreach (VendorBalanceEntry sce in sc.VENDOR_BALANCE_ENTRIES) { cmd.CommandText = sce.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = VendorBalanceEntry.SelectMaxIDSQL(); sce.ID = Convert.ToInt32(cmd.ExecuteScalar()); } }
public static void Save(MySql.Data.MySqlClient.MySqlCommand cmd, VendorBalanceEntry sce) { if (sce.ID == 0) { cmd.CommandText = sce.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = VendorBalanceEntry.SelectMaxIDSQL(); sce.ID = Convert.ToInt32(cmd.ExecuteScalar()); } else { cmd.CommandText = sce.GetUpdateSQL(); cmd.ExecuteNonQuery(); } }
public static IList TransformReaderList(MySql.Data.MySqlClient.MySqlDataReader aReader) { IList result = new ArrayList(); while (aReader.Read()) { VendorBalanceEntry tr = new VendorBalanceEntry(); tr.ID = Convert.ToInt32(aReader["vbe_id"]); tr.VENDOR_BALANCE = new VendorBalance(Convert.ToInt32(aReader["vb_id"])); tr.VENDOR_BALANCE_ENTRY_TYPE = (VendorBalanceEntryType)Enum.Parse(typeof(VendorBalanceEntryType), aReader["vbe_vendorbalanceentrytype"].ToString()); tr.TRANSACTION_DATE = Convert.ToDateTime(aReader["vbe_date"]); tr.CURRENCY = new Currency(Convert.ToInt32(aReader["ccy_id"])); tr.AMOUNT = Convert.ToDouble(aReader["vbe_amount"]); tr.EVENT_JOURNAL_ITEM = new EventJournalItem(Convert.ToInt32(aReader["eventjournalitem_id"])); result.Add(tr); } return(result); }
public static VendorBalance FindVendorBalance(MySql.Data.MySqlClient.MySqlCommand cmd, long vendor, long currency, long periodId, VendorBalanceType type) { cmd.CommandText = String.Format("select * from table_vendorbalance where vendor_id = {0} and ccy_id = {1} and period_id = {2} and vb_vendorbalancetype = '{3}'", vendor, currency, periodId, type.ToString()); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); VendorBalance sc = VendorBalance.TransformReader(r); r.Close(); if (sc != null) { sc.PERIOD = PeriodRepository.FindPeriod(cmd, sc.PERIOD.ID); cmd.CommandText = VendorBalanceEntry.FindByVendorBalance(sc.ID); MySql.Data.MySqlClient.MySqlDataReader rx = cmd.ExecuteReader(); sc.VENDOR_BALANCE_ENTRIES = VendorBalanceEntry.TransformReaderList(rx); rx.Close(); } return(sc); }
public void ProcessPosting(EventJournalItem eventItem) { assertSameCurrency(eventItem.CURRENCY); assertPeriodIsCurrent(); assertInPeriodRange(eventItem.EVENT_JOURNAL.TRANSACTION_DATE); double qty = eventItem.AMOUNT; switch (eventItem.VENDOR_BALANCE_ENTRY_TYPE) { case VendorBalanceEntryType.SupplierOutStandingInvoice: BALANCE += qty; break; case VendorBalanceEntryType.CustomerOutStandingInvoice: BALANCE += qty; break; case VendorBalanceEntryType.SupplierInvoice: BALANCE += qty; break; case VendorBalanceEntryType.CustomerInvoice: BALANCE += qty; break; case VendorBalanceEntryType.Payment: BALANCE -= qty; assertNotMinusBalanceAmount(); break; case VendorBalanceEntryType.Receipt: BALANCE -= qty; assertNotMinusBalanceAmount(); break; default: break; } VendorBalanceEntry sce = new VendorBalanceEntry(this, eventItem); VENDOR_BALANCE_ENTRIES.Add(sce); }
public IList GetVendorBalanceEntry(int supID) { ArrayList result = new ArrayList(); OpenConnection(); MySql.Data.MySqlClient.MySqlDataReader r; m_cmd.CommandText = VendorBalanceEntry.FindByVendorBalanceByCustomer(supID, VendorBalanceType.Customer); r = m_cmd.ExecuteReader(); IList vbe = VendorBalanceEntry.TransformReaderList(r); r.Close(); foreach (VendorBalanceEntry v in vbe) { result.Add(v); } result.Sort(new VendorBalanceEntryDateComparer()); return(result); }
public static void Update(MySql.Data.MySqlClient.MySqlCommand cmd, VendorBalance sc) { cmd.CommandText = sc.GetUpdateSQL(); cmd.ExecuteNonQuery(); foreach (VendorBalanceEntry sce in sc.VENDOR_BALANCE_ENTRIES) { if (sce.ID == 0) { cmd.CommandText = sce.GetInsertSQL(); cmd.ExecuteNonQuery(); cmd.CommandText = VendorBalanceEntry.SelectMaxIDSQL(); sce.ID = Convert.ToInt32(cmd.ExecuteScalar()); } else { cmd.CommandText = sce.GetUpdateSQL(); cmd.ExecuteNonQuery(); } } cmd.CommandText = VendorBalanceEntry.FindByVendorBalance(sc.ID); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); IList sces = VendorBalanceEntry.TransformReaderList(r); r.Close(); foreach (VendorBalanceEntry sce in sces) { sce.UPDATED = sc.VENDOR_BALANCE_ENTRIES.Contains(sce); } foreach (VendorBalanceEntry sce in sces) { if (!sce.UPDATED) { cmd.CommandText = VendorBalanceEntry.DeleteSQL(sce.ID); cmd.ExecuteNonQuery(); } } }
public static void Delete(MySql.Data.MySqlClient.MySqlCommand cmd, VendorBalanceEntry sc) { cmd.CommandText = VendorBalanceEntry.DeleteSQL(sc.ID); cmd.ExecuteNonQuery(); }
protected void deleteVendorBalanceEntry(VendorBalanceEntry vbe) { VendorBalanceEntryRepository.Delete(m_command, vbe); }