/// <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); }