public TransactionCollection FetchByQuery(Query qry)
{
TransactionCollection coll = new TransactionCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public TransactionCollection FetchAll()
{
TransactionCollection coll = new TransactionCollection();
Query qry = new Query(Transaction.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Fetch by order id.
/// </summary>
/// <param name="orderId">The order id.</param>
/// <returns></returns>
public TransactionCollection FetchByOrderId(int orderId)
{
IDataReader reader = SPs.FetchAssociatedOrderTransactions(orderId).GetReader();
TransactionCollection transactionCollection = new TransactionCollection();
transactionCollection.LoadAndCloseReader(reader);
transactionCollection.Sort(Transaction.Columns.TransactionDate, true);
return(transactionCollection);
}
public TransactionCollection FetchByID(object TransactionId)
{
TransactionCollection coll = new TransactionCollection().Where("TransactionId", TransactionId).Load();
return(coll);
}