static public void notifyOne(int userID)
{
Boolean notifyGoals;
Boolean notifyBudgets;
DataAbstract DA = new DataAbstract();
notifyBudgets = Convert.ToBoolean(DA.returnUser(userID).Tables[0].Rows[0].Field <object>("GoalsNotifications"));
notifyGoals = Convert.ToBoolean(DA.returnUser(userID).Tables[0].Rows[0].Field <object>("BudgetsNotifications"));
DataTable accounts = DA.returnAccounts(userID).Tables[0];
string emailMsg = "Report on your financial status \n";
for (int i = 0; i < accounts.Rows.Count; ++i) //iterate through all accounts of the user
{
long accountNum = Convert.ToInt64(accounts.Rows[i].Field <object>("AcctNumber"));
//Section for proceessing Goal portion of email
if (notifyGoals)
{
//emailMsg += getGoalText(accountNum);
}//end of goals section
//Section for processing Budget section of email
if (notifyBudgets)
{
DataTable budgets = DA.returnBudgets(accountNum).Tables[0];
emailMsg += "\n\nYour current Budget Updates \n";
for (int j = 0; j < budgets.Rows.Count; ++j)
{
DataRow b = budgets.Rows[j];
int notificationCount = Convert.ToInt32(b.Field <object>("NotificationCount"));
int budgetID = Convert.ToInt32(b.Field <object>("BudgetID"));
string categoryName = DA.returnCategoryName(Convert.ToInt32(b.Field <object>("CategoryID")));
double currentAmt = Convert.ToDouble(b.Field <object>("CurrentAmt"));
double maxAmt = Convert.ToDouble(b.Field <object>("MaxAmt"));
double percent = currentAmt / maxAmt;
Notifications N = new Notifications();
int notificationCountUpdate = N.Check("budget", percent * 100);
if (notificationCountUpdate > notificationCount)
{
DA.updateNotificationBudgets(budgetID, notificationCountUpdate);
string budgetString = categoryName + " has reached " + (percent * 100).ToString("N0") + "%\n";
emailMsg += budgetString;
}
}//end of budgets
}
string[] m = emailMsg.Trim().Split();
Notifications Note = new Notifications();
Note.sendEmail(emailMsg, accountNum.ToString());
}//end of specific account
}
protected void Page_PreRender()
{
if (!IsPostBack)
{
DataAbstract DA = new DataAbstract();
if (Convert.ToInt32(Session["userID"]) != 0)
{
userID = Convert.ToInt32(Session["userID"]);
DataSet userData = DA.returnUser(userID); //gets the user
DataTable userTable = userData.Tables[0];
object goal = userTable.Rows[0].Field <object>("GoalsNotifications");
object budget = userTable.Rows[0].Field <object>("BudgetsNotifications");
goal_notify.Checked = Convert.ToBoolean(goal);
budget_notify.Checked = Convert.ToBoolean(budget);
DataSet accountData = DA.returnAccounts(userID); //gets all accounts
System.Data.DataTable accountsTable = accountData.Tables[0]; //table holding all account entries for the user
object s = accountsTable.Rows[0].Field <object>("AcctNumber"); //sets the default account to the first of the user's accounts. LIKELY CHANGE LATER.
if (Convert.ToInt64(Session["account"]) == 0)
{
Session["account"] = Convert.ToInt64(s); //saves the first account as the default account during the session
}
}
else
{
Session["userID"] = 1; //temporary solution for demo 3/19/2017
Session["account"] = 211111110;
DataSet userData = DA.returnUser(userID); //gets the user
DataTable userTable = userData.Tables[0];
object goal = userTable.Rows[0].Field <object>("GoalsNotifications");
object budget = userTable.Rows[0].Field <object>("BudgetsNotifications");
object email = userTable.Rows[0].Field <object>("EmailNotifications");
object text = userTable.Rows[0].Field <object>("TextNotifications");
goal_notify.Checked = Convert.ToBoolean(goal);
budget_notify.Checked = Convert.ToBoolean(budget);
email_notifications.Checked = Convert.ToBoolean(email);
text_notifications.Checked = Convert.ToBoolean(text);
}
DataTable accounts = DA.returnAccounts(userID).Tables[0];
DropDownList DDL = acctSelect;
DDL.Items.Insert(0, new ListItem("Select Account", "0"));
DDL.DataSource = accounts;
DDL.DataTextField = "AcctNumber";
DDL.DataValueField = "AcctNumber";
DDL.DataBind();
ListItem LVI = DDL.Items.FindByValue(Convert.ToString(Session["account"]));
if (LVI != null)
{
int index = DDL.Items.IndexOf(LVI);
acctSelect.SelectedIndex = index;
}
currAcct.Text = "Current account: " + Session["account"].ToString();
}
}