//public static SupplierOutStandingInvoiceItem FindGRNItem(MySql.Data.MySqlClient.MySqlCommand cmd, int grnIID)
//{
// cmd.CommandText = SupplierOutStandingInvoiceItem.FindByGrnItemIDSQL(grnIID);
// MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
// SupplierOutStandingInvoiceItem res = SupplierOutStandingInvoiceItem.TransformReader(r);
// r.Close();
// cmd.CommandText = SupplierOutStandingInvoice.GetByIDSQL(res.EVENT.ID);
// r = cmd.ExecuteReader();
// res.EVENT = SupplierOutStandingInvoice.TransformReader(r);
// r.Close();
// return res;
//}
protected override IList doSearch(string find)
{
try
{
m_command.CommandText = SupplierOutStandingInvoice.GetSearch(find);
MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
IList rest = SupplierOutStandingInvoice.TransformReaderList(r);
r.Close();
return(rest);
}
catch (Exception x)
{
throw x;
}
}
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);
}
