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
            };
        }
예제 #2
0
        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
        }