INCLUDE in classic ADO.NET

using System;

using EncodeFirst.TestService.BusinessObjects.Types.Filters;
using EncodeFirst.TestService.BusinessObjects.Types.DataModel;

namespace EncodeFirst.TestService.BusinessObjects.Contracts
{
    public interface ITransactionRepository
    {
        /// <summary>
        /// Gets the transaction.
        /// </summary>
        /// <param name="id">The transaction id.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        Transaction GetTransaction(long id);

        /// <summary>
        /// Gets the transactions list by reference id.
        /// </summary>
        /// <param name="referenceId">The reference id.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        Transaction[] GetTransactionsListByReferenceId(long referenceId);

        /// <summary>
        /// Gets the transactions list by merchant id.
        /// </summary>
        /// <param name="merchantId">The merchant id.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        Transaction[] GetTransactionsListByMerchantId(long merchantId);

        /// <summary>
        /// Gets the approved transactions list by.
        /// </summary>
        /// <param name="merchantId">The merchant id.</param>
        /// <param name="type">The transaction type.</param>
        /// <param name="fromDate">From date.</param>
        /// <param name="toDate">To date.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        Transaction[] GetApprovedTransactionsListBy(long merchantId, Transaction.TransactionType? type, DateTime? dateFrom, DateTime? dateTo);

        /// <summary>
        /// Gets the disapproved transactions list by.
        /// </summary>
        /// <param name="merchantId">The merchant id.</param>
        /// <param name="type">The transaction type.</param>
        /// <param name="fromDate">From date.</param>
        /// <param name="toDate">To date.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        Transaction[] GetDisapprovedTransactionsListBy(long merchantId, Transaction.TransactionType? type, DateTime? dateFrom, DateTime? dateTo);

        /// <summary>
        /// Inserts the specified Transaction.
        /// </summary>
        /// <param name="Transaction">The Transaction.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        bool Insert(Transaction Transaction);

        /// <summary>
        /// Updates the specified Transaction.
        /// </summary>
        /// <param name="Transaction">The Transaction.</param>
        /// <returns></returns>
        /// <remarks></remarks>
        bool Update(Transaction Transaction);
    }
}