public void InitializeBudgetInfo(db database)
{
string queryString = "select * from budgetInfo order by DatabaseIndex";
database.ExecuteQuery(queryString);
while (database.QueryStep())
{
budgetCategories.Add(database.QueryReturnString(1));
budgetedAmount.Add(database.QueryReturnFloat(2));
if (database.QueryReturnBool(3))
{
budgetVerIndex.Add(database.QueryReturnInt(0)-1);
verificationString.Add(database.QueryReturnString(1));
verificationPerYear.Add(database.QueryReturnInt(4));
verificationDate.Add(database.QueryReturnInt(5));
monthStart.Add(database.QueryReturnInt(6));
transactionVerificationIndex.Add(totalVerifications);
totalVerifications++;
}
else
{
budgetVerIndex.Add(-1);
verificationString.Add("");
verificationPerYear.Add(-1);
verificationDate.Add(-1);
monthStart.Add(-1);
transactionVerificationIndex.Add(-1);
}
budgetIndexer.Add(database.QueryReturnInt(7));
layoutIndexer.Add(database.QueryReturnInt(8));
yearlyColumn.Add(database.QueryReturnBool(9));
showBudget.Add(database.QueryReturnBool(10));
inputColumn.Add(database.QueryReturnBool(11));
numBudget++;
}
}
public void SetTransactions(db DBConnection, string commandValue)
{
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
addedTrans = new Transaction();
addedTrans.date = DBConnection.QueryReturnInt(0);
addedTrans.type = DBConnection.QueryReturnInt(2);
addedTrans.amount = DBConnection.QueryReturnFloat(3);
addedTrans.verified = DBConnection.QueryReturnBool(4);
addedTrans.description = DBConnection.QueryReturnString(1);
//dbListNum = System.Convert.ToInt32(reader[5]);
dbTransList.Add(DBConnection.QueryReturnInt(5),addedTrans);
dbListNum++;
}
}
