protected override void LoadState(object navigationParameter, Dictionary<string, object> pageState) { var item = navigationParameter as Tuple<string, double, DateTime, DateTime>; if (item == null) return; var queryExp = App.Instance.TransDataSource.TransactionList.Where(i => i.TransactionType.Name == "Expense" && i.CreatedDate >= item.Item3 && i.CreatedDate <= item.Item4); var queryInc = App.Instance.TransDataSource.TransactionList.Where(i => i.TransactionType.Name == "Income" && i.CreatedDate >= item.Item3 && i.CreatedDate <= item.Item4); switch (item.Item1) { case ">": queryExp = from i in queryExp where i.Amount > item.Item2 select i; queryInc = from i in queryInc where i.Amount > item.Item2 select i; break; case "=": queryExp = from i in queryExp where i.Amount == item.Item2 select i; queryInc = from i in queryInc where i.Amount == item.Item2 select i; break; case "<": queryExp = from i in queryExp where i.Amount < item.Item2 select i; queryInc = from i in queryInc where i.Amount < item.Item2 select i; break; default: break; } DataVirtualization.Toolkit.DataItemCollection collection = new DataVirtualization.Toolkit.DataItemCollection(); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Euro", ID = 1, Name = "Expense", Value = queryExp.Sum(i => i.Amount) }); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Euro", ID = 2, Name = "Income", Value = queryInc.Sum(i=>i.Amount) }); chart.ItemsSource = collection; chart.ItemSelected += chart_ItemSelected; chart.ItemDeSelected += chart_ItemDeSelected; chart.legend.Foreground = new SolidColorBrush(new Windows.UI.Color(){A=255, R=0, G=0, B=0}); this.UpdateLayout(); }
protected override void LoadState(object navigationParameter, Dictionary<string, object> pageState) { var item = navigationParameter as Tuple<List<int>>; if (item == null) return; var budgets = from i in App.Instance.TransDataSource.BudgetList where item.Item1.Contains(i.BudgetId) select i; List<NameValueItem> groupedExp = new List<NameValueItem>(); List<NameValueItem> groupedInc = new List<NameValueItem>(); foreach (var budget in budgets) { var queryExp = (from i in budget.Transactions where i.TransactionType.Name == "Expense" group i by new { budget.Name } into d select new NameValueItem() { GroupDate = budget.Name, Count = d.Count(), SumAmount = d.Sum(k => k.Amount) }).ToList(); var queryInc = (from i in budget.Transactions where i.TransactionType.Name == "Income" group i by new { budget.Name } into d select new NameValueItem() { GroupDate = budget.Name, Count = d.Count(), SumAmount = d.Sum(k => k.Amount) }).ToList(); groupedExp.AddRange(queryExp); groupedInc.AddRange(queryInc); } DataVirtualization.Toolkit.DataItemCollection collection = new DataVirtualization.Toolkit.DataItemCollection(); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Euro", ID = 1, Name = "Expense", Value = groupedExp.Sum(i => i.SumAmount) }); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Euro", ID = 2, Name = "Income", Value = groupedInc.Sum(i => i.SumAmount) }); chart.ItemsSource = collection; chart.ItemSelected += chart_ItemSelected; chart.ItemDeSelected += chart_ItemDeSelected; }
protected override void LoadState(object navigationParameter, Dictionary<string, object> pageState) { var item = navigationParameter as Tuple<string, DateTime, DateTime>; if (item == null) return; var queryExp = App.Instance.TransDataSource.TransactionList.Where(i => i.TransactionType.Name == "Expense" && i.NameOfPlace == item.Item1 && i.CreatedDate >= item.Item2 && i.CreatedDate <= item.Item3); var queryInc = App.Instance.TransDataSource.TransactionList.Where(i => i.TransactionType.Name == "Income" && i.NameOfPlace == item.Item1 && i.CreatedDate >= item.Item2 && i.CreatedDate <= item.Item3); DataVirtualization.Toolkit.DataItemCollection collection = new DataVirtualization.Toolkit.DataItemCollection(); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Euro", ID = 1, Name = "Expense", Value = queryExp.Sum(i => i.Amount) }); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Euro", ID = 2, Name = "Income", Value = queryInc.Sum(i=>i.Amount) }); chart.ItemsSource = collection; chart.ItemSelected += chart_ItemSelected; chart.ItemDeSelected += chart_ItemDeSelected; }
public MainPage() { this.InitializeComponent(); DataVirtualization.Toolkit.DataItemCollection collection = new DataVirtualization.Toolkit.DataItemCollection(); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Dollars", ID = 1, Name = "Transporation", Value = 500 }); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Dollars", ID = 2, Name = "Meals", Value = 200 }); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Dollars", ID = 3, Name = "Meetings", Value = 100 }); collection.Add(new DataVirtualization.Toolkit.DataItem() { DataSymbol = "Dollars", ID = 4, Name = "Outings", Value = 700 }); chart.ItemsSource = collection; chart.ItemSelected += chart_ItemSelected; chart.ItemDeSelected += chart_ItemDeSelected; }