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();
}
public static string[,] getPieValues(long account)
{
DataAbstract DA = new DataAbstract();
DateTime DT = System.DateTime.Now;
DateTime before = DT.AddMonths(-1);
DataSet accountData = DA.returnAccounts(userID);
System.Data.DataTable accountsTable = accountData.Tables[0]; //table holding all account entries for the user
//object accountObject = accountsTable.Rows[0].Field<object>("AcctNumber");
//long accountNumber = Convert.ToInt64(accountObject);
DataSet catData = DA.returnCategories(userID);
System.Data.DataTable catTable = catData.Tables[0];
int resLength = catTable.Rows.Count;
string[,] result = new string[resLength, 3];
double totalTransactions = 0;
for (int i = 0; i < catTable.Rows.Count; ++i) //get name and total spent for each category
{
object catIDData = catTable.Rows[i].Field <object>("CategoryID");
object nameData = catTable.Rows[i].Field <object>("Name");
int catID = Convert.ToInt32(catIDData);
string category = Convert.ToString(nameData);
DateTime start = DateTime.Now.AddMonths(-1);
DateTime end = DateTime.Now;
//double catSum = DA.returnTransactionCategoryBoundTotals(catID, account, start, end); //one month span
//TEMPORARY RANGE WITH USEABLE DATA
double catSum = DA.returnTransactionCategoryBoundTotals(catID, account, Convert.ToDateTime("12/1/2016"), Convert.ToDateTime("1/1/2017")); //other span
totalTransactions += catSum;
result[i, 0] = category;
result[i, 1] = Convert.ToString(catSum);
} //end of for loop
//result has names and totals of each category
double degreeCheck = 0;
for (int i = 0; i < catTable.Rows.Count; ++i) //get degrees of pie chart for each category
{
double catSum = Convert.ToDouble(result[i, 1]);
double percent = catSum / totalTransactions;
if (catSum == 0)
{
percent = 0;
}
double degrees = percent * 360;
result[i, 2] = Convert.ToString(Math.Round(degrees));
degreeCheck += degrees;
}
return(result);
}
