private string getGoalText(int accountNum)
{
string result = ""; //accrues text to be returned throughout function
DataAbstract DA = new DataAbstract();
DataTable goals = DA.returnIncompleteGoals(accountNum).Tables[0];
result += "Your current Goal Updates \n";
for (int j = 0; j < goals.Rows.Count; ++j) //iterate through all goals of account
{
DataRow g = goals.Rows[j];
int notificationCount = Convert.ToInt32(g.Field <object>("NotificationCount"));
int goalID = Convert.ToInt32(g.Field <object>("GoalID"));
string goalName = Convert.ToString(g.Field <object>("Name"));
double currentAmt = Convert.ToDouble(g.Field <object>("CurrentAmt"));
double totalAmt = Convert.ToDouble(g.Field <object>("TotalAmt"));
double percent = currentAmt / totalAmt;
Notifications N = new Notifications();
int notificationCountUpdate = N.Check("goals", percent * 100);
if (notificationCountUpdate > notificationCount)
{
DA.updateNotificationGoals(goalID, notificationCountUpdate);
string percentString = Convert.ToString(percent);
percentString = percentString.Remove(percentString.IndexOf('.') + 2);
string goalString = goalName + " has reached " + (percent * 100).ToString("N0") + "%\n";
result += goalString;
}
}//end of specific goal
return(result);
}
