public List <TransactionsTestAPI> GetTransactions(int VirtualWalletID, int MerchantAccountID, String apiKey) { myDBCommand.CommandType = System.Data.CommandType.StoredProcedure; myDBCommand.CommandText = "tp_CheckForAPIKey"; myDBCommand.Parameters.AddWithValue("@theAPIKey", apiKey); DataSet selectedAPIKey = myDBConnect.GetDataSetUsingCmdObj(myDBCommand); if (selectedAPIKey.Tables.Count > 0 && selectedAPIKey != null) { myDBCommand.Parameters.Clear(); myDBCommand.CommandType = System.Data.CommandType.StoredProcedure; myDBCommand.CommandText = "tp_CheckForVirtualWalletID"; myDBCommand.Parameters.AddWithValue("@theVirtualWalletID", VirtualWalletID); DataSet selectedVirtualWalletID = myDBConnect.GetDataSetUsingCmdObj(myDBCommand); if (selectedVirtualWalletID.Tables.Count > 0 && selectedVirtualWalletID != null) { myDBCommand.Parameters.Clear(); myDBCommand.CommandType = System.Data.CommandType.StoredProcedure; myDBCommand.CommandText = "tp_GetTransactionsByMerchantAccountID"; myDBCommand.Parameters.AddWithValue("@theVirtualWalletID", VirtualWalletID); DataSet transactions = myDBConnect.GetDataSetUsingCmdObj(myDBCommand); DataTable transTable = transactions.Tables[0]; for (int i = 0; i < transTable.Rows.Count; i++) { DataRow transRows = transTable.Rows[i]; TransactionsTestAPI transaction = new TransactionsTestAPI(); transRows["TransactionsID"].ToString(); } } } List <TransactionsTestAPI> list = new List <TransactionsTestAPI>(); return(list); }
public List <TransactionsTestAPI> GetTransactions(int virtualWalletID, int merchantAccountID, String apiKey) { List <TransactionsTestAPI> list = new List <TransactionsTestAPI>(); myDBCommand.Parameters.Clear(); myDBCommand.CommandType = CommandType.StoredProcedure; myDBCommand.CommandText = "tp_CheckForAPIKey"; myDBCommand.Parameters.AddWithValue("@theAPIKey", apiKey); DataSet selectedAPIKey = myDBConnect.GetDataSetUsingCmdObj(myDBCommand); //checks if api key exists if (selectedAPIKey.Tables.Count > 0 && selectedAPIKey != null) { myDBCommand.Parameters.Clear(); myDBCommand.CommandType = CommandType.StoredProcedure; myDBCommand.CommandText = "tp_CheckForVirtualWalletID"; myDBCommand.Parameters.AddWithValue("@theVirtualWalletID", virtualWalletID); DataSet selectedVirtualWalletID = myDBConnect.GetDataSetUsingCmdObj(myDBCommand); //checks if virtual wallet id exists if (selectedVirtualWalletID.Tables.Count > 0 && selectedVirtualWalletID != null) { myDBCommand.Parameters.Clear(); myDBCommand.CommandType = CommandType.StoredProcedure; myDBCommand.CommandText = "tp_GetTransactionsByMerchantAccountID"; myDBCommand.Parameters.AddWithValue("@theVirtualWalletID", virtualWalletID); myDBCommand.Parameters.AddWithValue("@theMerchantAccountID", merchantAccountID); DataSet transactions = myDBConnect.GetDataSetUsingCmdObj(myDBCommand); DataTable transTable = transactions.Tables[0]; for (int i = 0; i < transTable.Rows.Count; i++) { DataRow transRows = transTable.Rows[i]; TransactionsTestAPI transaction = new TransactionsTestAPI(); transaction.TransactionsID = Convert.ToInt32(transRows["TransactionsID"].ToString()); transaction.TransactionsType = transRows["TransactionsType"].ToString(); transaction.SendingVirtualWalletID = transRows["SendingVirtualWalletID"].ToString(); transaction.ReceivingVirtualWalletID = transRows["ReceivingVirtualWalletID"].ToString(); transaction.Amount = Convert.ToDouble(transRows["Amount"].ToString()); list.Add(transaction); } } } return(list); }