public void ribbonimageChoose(object sender, EventArgs e) //selects the current badge for your number of completed goals
{
Image x = (Image)sender;
DataAbstract DA = new DataAbstract();
int completed_goals = DA.returnCompleteGoalsCount(Convert.ToInt32(Session["userID"]));
if (completed_goals == 0)
{
//show "no goals completed yet"
}
else if (completed_goals >= 1 && completed_goals < 3)
{
//show " One Goal Completed " , green ribbon image
x.Attributes["src"] = "images/ribbon1.png";
}
else if (completed_goals >= 3 && completed_goals < 5)
{
//show " Three Goals Completed " , red ribbon image
x.Attributes["src"] = "images/ribbon2.png";
}
else if (completed_goals >= 5 && completed_goals < 10)
{
//show " 5 Goals Completed " , blue ribbon image
x.Attributes["src"] = "images/ribbon3.png";
}
else
{
//show " 10 Goals Completed " , gold ribbon image
x.Attributes["src"] = "images/ribbon4.png";
}
sender = x;
}
public void label_text(object sender, EventArgs e) //sets the label for the current badge level
{
DataAbstract DA = new DataAbstract();
int completed_goals = DA.returnCompleteGoalsCount(Convert.ToInt32(Session["userID"]));
if (completed_goals == 0)
{
//show "no goals completed yet"
Ribbon_Label.Text = "No goals completed";
}
else if (completed_goals >= 1 && completed_goals < 3)
{
//show " One Goal Completed " , green ribbon image
Ribbon_Label.Text = "You have completed your first goal!";
}
else if (completed_goals >= 3 && completed_goals < 5)
{
//show " Three Goals Completed " , red ribbon image
Ribbon_Label.Text = "You have completed 3 goals";
}
else if (completed_goals >= 5 && completed_goals < 10)
{
//show " 5 Goals Completed " , blue ribbon image
Ribbon_Label.Text = "You have completed 5 goals";
}
else
{
//show " 10 Goals Completed " , gold ribbon image
Ribbon_Label.Text = "You have completed 10 goals, great job!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataAbstract DA = new DataAbstract();
DateTime d1 = new DateTime(2016, 11, 14);
DateTime d2 = new DateTime(2017, 5, 15);
//DA.updateGoalAmt(19, 200.00, 211111110);
//DA.updateGoalEndDate(19, d2, 211111110);
//DA.updateGoalTotalAmt(19, 10000.00,211111110);
//DA.updateGoalName(19, "pet dog", 211111110);
DA.addGoal(3011111130, "Summer Vacation", 3100.00, d2, "Monthly", 125, "trip to Mars");
//DA.returnGoals(211111110);
//DA.create_Category("Travel");
//DA.updateTransactionCategory(320, 9, 211111110);
//DA.addBudget(211111110, 1, d1, d2, 300.00, 1);
//DA.deleteBudget(10);
int cat = DA.returnCompleteGoalsCount(211111110);
double t__ = DA.returnTransactionCategoryBoundTotals(2, 211111110, d1, d2);
System.Diagnostics.Debug.WriteLine("goals count = " + cat);
DA.returnCategoryName(1);
DataSet t1 = new DataSet();
t1 = DA.returnTransactionsSearch(211111110, d1, d2, "bes");
GridView1.DataSource = t1;
GridView1.DataBind();
}
