protected override void doUpdateStatus(Event e, bool posted)
{
m_command.CommandText = PurchaseOrder.GetUpdateStatusSQL(e);
m_command.ExecuteNonQuery();
}
public static void UpdateAgainstStatus(MySql.Data.MySqlClient.MySqlCommand cmd, PurchaseOrder po, PurchaseOrderItem poi)
{
cmd.CommandText = poi.UpdateAgainstStatus();
cmd.ExecuteNonQuery();
cmd.CommandText = po.UpdateAgainstStatus();
cmd.ExecuteNonQuery();
}
public IList GetAllTransactions(int supID)
{
ArrayList result = new ArrayList();
OpenConnection();
MySql.Data.MySqlClient.MySqlDataReader r;
m_cmd.CommandText = PurchaseOrder.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList po = PurchaseOrder.TransformReaderList(r);
r.Close();
foreach (Event e in po)
{
result.Add(e);
}
m_cmd.CommandText = GoodReceiveNote.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList grn = GoodReceiveNote.TransformReaderList(r);
r.Close();
foreach (Event e in grn)
{
result.Add(e);
}
m_cmd.CommandText = SupplierInvoice.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList si = SupplierInvoice.TransformReaderList(r);
r.Close();
foreach (Event e in si)
{
result.Add(e);
}
m_cmd.CommandText = PurchaseReturn.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList pr = PurchaseReturn.TransformReaderList(r);
r.Close();
foreach (Event e in pr)
{
result.Add(e);
}
m_cmd.CommandText = APDebitNote.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList apdn = APDebitNote.TransformReaderList(r);
r.Close();
foreach (EventJournal e in apdn)
{
result.Add(e);
}
m_cmd.CommandText = Payment.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList py = Payment.TransformReaderList(r);
r.Close();
foreach (EventJournal e in py)
{
result.Add(e);
}
m_cmd.CommandText = SupplierOutStandingInvoice.GetBySupplierSQL(supID);
r = m_cmd.ExecuteReader();
IList soi = SupplierOutStandingInvoice.TransformReaderList(r);
r.Close();
foreach (EventJournal e in soi)
{
result.Add(e);
}
result.Sort(new EventDateComparer());
return(result);
}