public MonthlyReport() { InitializeComponent(); SizeChanged += MonthlyReport_SizeChanged; ExpensesDatabaseController expenses = new ExpensesDatabaseController(); IncomeDabataseController income = new IncomeDabataseController(); var balance = income.Total(DateTime.Now.Month, DateTime.Now.Year) - expenses.Total(DateTime.Now.Month, DateTime.Now.Year); List <Entry> entries = new List <Entry> { new Entry(Convert.ToSingle(expenses.Total(DateTime.Now.Month, DateTime.Now.Year))) { Color = SKColor.Parse("#dc151c"), Label = "Expenses", ValueLabel = expenses.Total(DateTime.Now.Month, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(DateTime.Now.Month, DateTime.Now.Year))) { Color = SKColor.Parse("#228B22"), Label = "Income", ValueLabel = income.Total(DateTime.Now.Month, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(balance)) { Color = SKColor.Parse("#7f93ff"), Label = "Balance", ValueLabel = balance.ToString() } }; MonthlyChart.Chart = new DonutChart { Entries = entries }; }
public ExpensesList() { InitializeComponent(); ExpenseDatabase = new ExpensesDatabaseController(); if (ExpenseDatabase.GetExpenses() != null) { _expenses = new ObservableCollection <Expense>(ExpenseDatabase.GetExpenses()); } _ExpensesList.ItemsSource = _expenses; // GetExpenses();//display Expenses }
public Home() { InitializeComponent(); IncomeDatabase = new IncomeDabataseController(); ExpensesDatabase = new ExpensesDatabaseController(); GetEverything(); today = DateTime.Today; string _month = ""; //workaround if (today.Date.Month == 1) { _month = "January"; } else if (today.Date.Month == 2) { _month = "February"; } else if (today.Date.Month == 3) { _month = "March"; } else if (today.Date.Month == 4) { _month = "April"; } else if (today.Date.Month == 5) { _month = "May"; } else if (today.Date.Month == 6) { _month = "June"; } else if (today.Date.Month == 7) { _month = "July"; } else if (today.Date.Month == 8) { _month = "August"; } else if (today.Date.Month == 9) { _month = "September"; } else if (today.Date.Month == 10) { _month = "October"; } else if (today.Date.Month == 11) { _month = "November"; } else if (today.Date.Month == 12) { _month = "December"; } month.Text = _month + " " + today.Date.Year.ToString(); Device.StartTimer(TimeSpan.FromSeconds(5), () => { GetEverything();//totals recalculated every 5 seconds just to give an impression of real time calculations //the ideal is to have processing done after any change in the calculated figures...I'm too tired for that! return(true); // True = Repeat again, False = Stop the timer }); }
public All_Reports() { InitializeComponent(); ExpensesDatabaseController expenses = new ExpensesDatabaseController(); IncomeDabataseController income = new IncomeDabataseController(); List <Entry> entries = new List <Entry> { new Entry(Convert.ToSingle(expenses.Total(1, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "January", ValueLabel = expenses.Total(1, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(1, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(1, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(2, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "February", ValueLabel = expenses.Total(2, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(2, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(2, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(3, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "March", ValueLabel = expenses.Total(3, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(3, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(3, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(4, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "April", ValueLabel = expenses.Total(4, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(4, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(4, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(5, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "May", ValueLabel = expenses.Total(5, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(5, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(5, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(6, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "June", ValueLabel = expenses.Total(6, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(6, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(6, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(7, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "July", ValueLabel = expenses.Total(7, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(7, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(7, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(8, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "August", ValueLabel = expenses.Total(8, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(8, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(8, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(9, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "September", ValueLabel = expenses.Total(9, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(9, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(9, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(10, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "October", ValueLabel = expenses.Total(10, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(10, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(10, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(11, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "November", ValueLabel = expenses.Total(11, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(11, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(11, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(expenses.Total(12, DateTime.Now.Year))) { Color = SKColor.Parse("#FF0000"), Label = "Decemeber", ValueLabel = expenses.Total(12, DateTime.Now.Year).ToString() }, new Entry(Convert.ToSingle(income.Total(12, DateTime.Now.Year))) { Color = SKColor.Parse("#008000"), ValueLabel = income.Total(12, DateTime.Now.Year).ToString() } }; //list income //List<Entry> entriesIncome = new List<Entry> //{ // new Entry(Convert.ToSingle(income.Total(1,DateTime.Now.Year))) // { // Color = SKColor.Parse("#228B22"), // Label ="January", // ValueLabel =income.Total(1,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(2,DateTime.Now.Year))) // { // Color = SKColor.Parse("#530023"), // Label ="February", // ValueLabel =income.Total(2,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(3,DateTime.Now.Year))) // { // Color = SKColor.Parse("#f15277"), // Label ="March", // ValueLabel =income.Total(3,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(4,DateTime.Now.Year))) // { // Color = SKColor.Parse("#551a8b"), // Label ="April", // ValueLabel =income.Total(4,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(5,DateTime.Now.Year))) // { // Color = SKColor.Parse("#7face8"), // Label ="May", // ValueLabel =income.Total(5,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(6,DateTime.Now.Year))) // { // Color = SKColor.Parse("#ab82ff"), // Label ="June", // ValueLabel =income.Total(6,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(7,DateTime.Now.Year))) // { // Color = SKColor.Parse("#00cc66"), // Label ="July", // ValueLabel =income.Total(7,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(8,DateTime.Now.Year))) // { // Color = SKColor.Parse("#d01679"), // Label ="August", // ValueLabel =income.Total(8,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(9,DateTime.Now.Year))) // { // Color = SKColor.Parse("#6464b6"), // Label ="September", // ValueLabel =income.Total(9,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(10,DateTime.Now.Year))) // { // Color = SKColor.Parse("#d4e3ff"), // Label ="October", // ValueLabel =income.Total(10,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(11,DateTime.Now.Year))) // { // Color = SKColor.Parse("#f22232"), // Label ="November", // ValueLabel =income.Total(11,DateTime.Now.Year).ToString() // }, // new Entry(Convert.ToSingle(income.Total(12,DateTime.Now.Year))) // { // Color = SKColor.Parse("#241707"), // Label ="Decemeber", // ValueLabel =income.Total(12,DateTime.Now.Year).ToString() // }, //}; Chart1.Chart = new BarChart { Entries = entries }; //from the xaml end }