/// <summary>
/// Searches for Transaction
/// </summary>
/// <param name="item" />
/// <returns>An IEnumerable set of Transaction</returns>
public static IEnumerable<Transaction> Search(SearchTransaction item)
{
List<SqlParameter> parameters
= new List<SqlParameter>
{
new SqlParameter("@TransactionId", item.TransactionId),
new SqlParameter("@EventId", item.EventId),
new SqlParameter("@UserId", item.UserId),
new SqlParameter("@FeeTypeId", item.FeeType),
new SqlParameter("@FeeAdjustmentId", item.FeeAdjustment),
new SqlParameter("@Fee", item.Fee),
new SqlParameter("@CreditCardNumber", item.CreditCardNumber),
new SqlParameter("@CreditCardTypeId", item.CreditCardType),
new SqlParameter("@ExpirationDate", item.ExpirationDate),
new SqlParameter("@CCV", item.CCV),
new SqlParameter("@BillingAddress", item.BillingAddress),
new SqlParameter("@BillingCity", item.BillingCity),
new SqlParameter("@BillingState", item.BillingState),
new SqlParameter("@BillingZip", item.BillingZip),
new SqlParameter("@TransactionDate", item.TransactionDate)
};
DataSet set = DataManager.ExecuteProcedure(ConferencePlusConnectionString, "Transaction_Get", parameters);
IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
return ConvertToEntityObject(dataRows);
}
/// <summary>
/// Loads Transaction by the id parameter
/// </summary>
/// <param name="transactionId">Primary Key of Transaction table</param>
/// <returns>Transaction entity</returns>
public static Transaction Load(int transactionId)
{
SearchTransaction search
= new SearchTransaction
{
TransactionId = transactionId
};
return Search(search).FirstOrDefault();
}
/// <summary>
/// Searches for Transaction
/// </summary>
/// <param name="search" />
/// <returns>An IEnumerable set of Transaction</returns>
public static IEnumerable<Transaction> Search(SearchTransaction search)
{
return TransactionDao.Search(search);
}