bool NoteList::createNote(int idx)
{
SQLiteStatement *q = g_mainWindow->getFoundNote(idx);
bool ret = false;
if(q->FetchRow()) {
NoteItem* noteItem;
noteItem = new NoteItem(this,q->GetColumnInt(0),true);
noteItem->autoSize();
m_notes[idx] = noteItem;
int delta = noteItem->height() - UNIT_PADDING;
if(delta) {
m_heightDelta += delta;
adjustSize();
}
ret = true;
}
return ret;
}
//Returns transaction log
void Database::getTransactions(int accountId){
//Opens database
SQLiteDatabase *pDatabase = this->connect();
SQLiteStatement *pStmt = this->createStatement(pDatabase);
//Holds the number of transactions for this account
int transactionCount = 0;
vector<int> transactionIds;
//Query to poll the database for all transactions by accountId
pStmt->Sql("Select * FROM Transactions1 where accountId = ?");
pStmt->BindInt(1, accountId);
pStmt->Execute();
//Controls the loop to add all transactions to the vector
bool moreRows=true;
//While there are additional rows of transactions, add them to the transaction log
while (moreRows = pStmt->FetchRow())
{
// if transactioncount+1=8, then you got to clear the screen. Want 8 transactions at a time.
if (transactionCount == 0 || transactionCount % 8 == 0)
{
//if no transactions have been included, place zero.
if (transactionCount == 0)
{
system("cls");
cout << "Id \t" << "Amount \t" << "Transaction Type \t" << "Transaction Date \t" << endl << endl;
}
//Control to Display only 10 transactions at a time.
if (transactionCount % 8 == 0 && transactionCount > 0)
{
int choice = 0;
if (moreRows == false)
{
cout << endl << endl << "1) View Specific Transaction?" << endl;
cout << endl << endl << "2) Exit Transaction Log?" << endl << endl;
cout << "Select Option Number: ";
cin >> choice;
if (choice == 1)
{
int selection;
cout << "View Transaction Number: ";
cin >> selection;
//view specific selection
getTransaction(transactionIds[selection - 1]);
//return to base account screen.
pStmt->FreeQuery();
return;
}
}
if (moreRows == true)
{
cout << endl << "1) View Specific Transaction?";
cout << endl << "2) View More Transactions?";
cout << endl << "3) Exit Transaction Log?" << endl << endl;
cout << "Select Option Number: ";
cin >> choice;
if (choice == 1)
{
int selection;
cout << "View Transaction Number: ";
cin >> selection;
getTransaction(transactionIds[selection - 1]);
pStmt->FreeQuery();
return;//leave loop.
}
