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