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