void ViewReport(int seconds){ TableDataSet TransactionTableDataSet; stringstream AAID(""); // active account id stringstream AUID(""); // active user id stringstream SECS(""); AAID << ActiveAccountID; AUID << ActiveUserID; SECS << (time(0)-seconds); TransactionTableDataSet.push_back(make_pair("AcctID", AAID.str().c_str())); TransactionTableDataSet.push_back(make_pair("UserID", AUID.str().c_str())); TransactionTableDataSet.push_back(make_pair(" TransDate >", SECS.str().c_str())); DB.ShowTable(TRANSACTION_TABLE, TransactionTableDataSet, 2); }
// get user prompts for table fields and add a new row // to a table, with an auto-incremented id. void CreateInTable(TableDefinition Def, char* Table, char* key){ string name, val; DB.UseTableDefinition(Def); //cout << "key: " << key; TableRow Columns = DB.GetColumnsForTable(Table); // get all the columns TableDataSet NewDataSet; for(unsigned int i=0; i<Columns.size(); i++){ if(Columns[i] == key){ int maxID = DB.GetMaxField(Table, key); int newID = maxID+1; stringstream ID(""); ID << newID; NewDataSet.push_back(make_pair(key, (char*)ID.str().c_str())); } else{ cout << Columns[i] << ": "; getline(cin, val); FieldDefinition WorkingFieldDefinition = DB.GetFieldDefinition((char*)Columns[i].c_str()); if((WorkingFieldDefinition.getLength() > 0) && (WorkingFieldDefinition.Validate((char*)val.c_str()))){ NewDataSet.push_back(make_pair(Columns[i],val)); } else{ cout << "validation failed for the field " << WorkingFieldDefinition.getName(); return; } } } DB.Create(Table, NewDataSet); DB.ShowTable(Table, NewDataSet); return; }
// view transactions for the current account id and user id void ViewTransactions(){ TableDataSet TransactionTableDataSet; stringstream AAID(""); // active account id stringstream AUID(""); // active user id AAID << ActiveAccountID; AUID << ActiveUserID; if(!validate::string::numeric(AAID.str())){ cout << "invalid account id"; return; } if(!validate::string::numeric(AUID.str())){ cout << "invalid user id"; return; } if(DB.FieldExists(USER_TABLE, "UserID", (char*)AUID.str().c_str()) == false){ ActiveUserID = -1; cout << "User ID selected does not exist."; return; } else if(DB.FieldExists(ACCOUNT_TABLE, "AcctID", (char*)AAID.str().c_str()) == false){ ActiveAccountID = -1; cout << "Account ID selected does not exist."; return; } TransactionTableDataSet.push_back(make_pair("AcctID", AAID.str().c_str())); TransactionTableDataSet.push_back(make_pair("UserID", AUID.str().c_str())); DB.ShowTable(TRANSACTION_TABLE, TransactionTableDataSet, 2); }
void ViewAccounts(){ DB.ShowTable(ACCOUNT_TABLE, DB.GetColumnsForTable(ACCOUNT_TABLE)); cout << endl; }
void ViewProfiles(){ DB.ShowTable(USER_TABLE, DB.GetColumnsForTable(USER_TABLE)); cout << endl; }
// add a transaction to the table. void TransactAmount(bool isCredit){ if(isCredit){ cout << "Deposit" << endl; } else{ cout << "Withdraw" << endl; } stringstream AAID(""); // active account id stringstream AUID(""); // active user id stringstream TNUM(""); // transaction number stringstream TAMT(""); // transaction amount stringstream DATE(""); // timestamp stringstream NBAL(""); // updated balance // create a new transaction id int TransNum = DB.GetMaxField(TRANSACTION_TABLE, "TransNum"); int newTransNum = TransNum+1; // get the transaction amount double transAmt = GetUserInput("Enter Transaction Amount", INT_MAX); stringstream sM(""); sM << transAmt; // validation. Minimal validation. Better than nothing. if(!validate::string::money(sM.str())){ cout << "that does not appear to be a valid monetary amount."; return; } AAID << ActiveAccountID; AUID << ActiveUserID; if(!validate::string::numeric(AAID.str())){ ActiveAccountID = -1; cout << "The account id is invalid. " << endl; return; } if(!validate::string::numeric(AUID.str())){ ActiveUserID = -1; cout << "the user id is invalid. " << endl; return; } stringstream clause(""); // this is terrible, but it works. clause << " UserID = '" << ActiveUserID << "' and AcctID = '" << ActiveAccountID << "' "; double exSum = DB.GetSumField(TRANSACTION_TABLE, "TransAmount", (char*)clause.str().c_str()); TNUM << newTransNum; DATE << time(0); if(isCredit){ TAMT << transAmt; NBAL << (exSum+transAmt); } else{ TAMT << "-" << transAmt; NBAL << (exSum-transAmt); } TableDataSet NewDataSet; NewDataSet.push_back(make_pair("AcctID", AAID.str().c_str())); NewDataSet.push_back(make_pair("UserID", AUID.str().c_str())); NewDataSet.push_back(make_pair("TransNum", TNUM.str().c_str())); NewDataSet.push_back(make_pair("TransAmount", TAMT.str().c_str())); NewDataSet.push_back(make_pair("TransDate", DATE.str().c_str())); NewDataSet.push_back(make_pair("Balance", NBAL.str().c_str())); DB.Create(TRANSACTION_TABLE, NewDataSet); DB.ShowTable(TRANSACTION_TABLE, NewDataSet, 2); }