/// <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("@UserId", item.UserId),
new SqlParameter("@CreditCardNumber", item.CreditCardNumber),
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),
new SqlParameter("@InventoryId", item.InventoryId),
new SqlParameter("@RentalDateStart", item.RentalDateStart),
new SqlParameter("@RentalDateEnd", item.RentalDateEnd),
new SqlParameter("@Price", item.Price)
};
DataSet set = DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_GetTransaction", parameters);
IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
return ConvertToEntityObject(dataRows);
}
/// <summary>
/// Searches for Transaction
/// </summary>
/// <param name="search" />
/// <returns>An IEnumerable set of Transaction</returns>
public static IEnumerable<Transaction> Search(SearchTransaction search)
{
return search == null ? new List<Transaction>() : TransactionDao.Search(search);
}
