aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.Statistics/ViewModels/MainViewVM.cs
blob: fd897e811ddd947b68b8ce69c77288ac222fe0d8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
pre { line-height: 125%; }
td.linenos .normal { color: inherit; background-color: transparent; padding-left: 5px; padding-right: 5px; }
span.linenos { color: inherit; background-color: transparent; padding-left: 5px; padding-right: 5px; }
td.linenos .special { color: #000000; background-color: #ffffc0; padding-left: 5px; padding-right: 5px; }
span.linenos.special { color: #000000; background-color: #ffffc0; padding-left: 5px; padding-right: 5px; }
.highlight .hll { background-color: #ffffcc }
.highlight .c { color: #888888 } /* Comment */
.highlight .err { color: #a61717; background-color: #e3d2d2 } /* Error */
.highlight .k { color: #008800; font-weight: bold } /* Keyword */
.highlight .ch { color: #888888 } /* Comment.Hashbang */
.highlight .cm { color: #888888 } /* Comment.Multiline */
.highlight .cp { color: #cc0000; font-weight: bold } /* Comment.Preproc */
.highlight .cpf { color: #888888 } /* Comment.PreprocFile */
.highlight .c1 { color: #888888 } /* Comment.Single */
.highlight .cs { color: #cc0000; font-weight: bold; background-color: #fff0f0 } /* Comment.Special */
.highlight .gd { color: #000000; background-color: #ffdddd } /* Generic.Deleted */
.highlight .ge { font-style: italic } /* Generic.Emph */
.highlight .ges { font-weight: bold; font-style: italic } /* Generic.EmphStrong */
.highlight .gr { color: #aa0000 } /* Generic.Error */
.highlight .gh { color: #333333 } /* Generic.Heading */
.highlight .gi { color: #000000; background-color: #ddffdd } /* Generic.Inserted */
.highlight .go { color: #888888 } /* Generic.Output */
.highlight .gp { color: #555555 } /* Generic.Prompt */
.highlight .gs { font-weight: bold } /* Generic.Strong */
.highlight .gu { color: #666666 } /* Generic.Subheading */
.highlight .gt { color: #aa0000 } /* Generic.Traceback */
.highlight .kc { color: #008800; font-weight: bold } /* Keyword.Constant */
.highlight .kd { color: #008800; font-weight: bold } /* Keyword.Declaration */
.highlight .kn { color: #008800; font-weight: bold } /* Keyword.Namespace */
.highlight .kp { color: #008800 } /* Keyword.Pseudo */
.highlight .kr { color: #008800; font-weight: bold } /* Keyword.Reserved */
.highlight .kt { color: #888888; font-weight: bold } /* Keyword.Type */
.highlight .m { color: #0000DD; font-weight: bold } /* Literal.Number */
.highlight .s { color: #dd2200; background-color: #fff0f0 } /* Literal.String */
.highlight .na { color: #336699 } /* Name.Attribute */
.highlight .nb { color: #003388 } /* Name.Builtin */
.highlight .nc { color: #bb0066; font-weight: bold } /* Name.Class */
.highlight .no { color: #003366; font-weight: bold } /* Name.Constant */
.highlight .nd { color: #555555 } /* Name.Decorator */
.highlight .ne { color: #bb0066; font-weight: bold } /* Name.Exception */
.highlight .nf { color: #0066bb; font-weight: bold } /* Name.Function */
.highlight .nl { color: #336699; font-style: italic } /* Name.Label */
.highlight .nn { color: #bb0066; font-weight: bold } /* Name.Namespace */
.highlight .py { color: #336699; font-weight: bold } /* Name.Property */
.highlight .nt { color: #bb0066; font-weight: bold } /* Name.Tag */
.highlight .nv { color: #336699 } /* Name.Variable */
.highlight .ow { color: #008800 } /* Operator.Word */
.highlight .w { color: #bbbbbb } /* Text.Whitespace */
.highlight .mb { color: #0000DD; font-weight: bold } /* Literal.Number.Bin */
.highlight .mf { color: #0000DD; font-weight: bold } /* Literal.Number.Float */
.highlight .mh { color: #0000DD; font-weight: bold } /* Literal.Number.Hex */
.highlight .mi { color: #0000DD; font-weight: bold } /* Literal.Number.Integer */
.highlight .mo { color: #0000DD; font-weight: bold } /* Literal.Number.Oct */
.highlight .sa { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Affix */
.highlight .sb { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Backtick */
.highlight .sc { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Char */
.highlight .dl { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Delimiter */
.highlight .sd { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Doc */
.highlight .s2 { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Double */
.highlight .se { color: #0044dd; background-color: #fff0f0 } /* Literal.String.Escape */
.highlight .sh { color: #dd2200; background-color: #fff0f0 } /* Literal.String.Heredoc */
.highlight .si { color: #3333bb; background-color: #fff0f0 } /* Literal.String.Interpol */
.highlight .sx { color: #22bb22; background-color: #f0fff0 } /* Literal.String.Other */
.highlight .sr { color: #008800; background-color: #fff0ff } /* Literal.String.Regex */
.highlight .s1 { color: 
using LiveCharts;
using LiveCharts.Wpf;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Media;
using Tango.BL;
using Tango.BL.Entities;
using Tango.BL.Enumerations;
using Tango.Core.Helpers;
using Tango.MachineStudio.Common;
using Tango.MachineStudio.Statistics.Models;

namespace Tango.MachineStudio.Statistics.ViewModels
{
    public class MainViewVM : StudioViewModel
    {
        private ObservablesContext _context;
        private List<JobRun> _job_runs;
        private bool rendered;

        private LabeledSeriesCollection _timelineJobStatusSeries;
        public LabeledSeriesCollection TimelineJobStatusSeries
        {
            get { return _timelineJobStatusSeries; }
            set { _timelineJobStatusSeries = value; RaisePropertyChangedAuto(); }
        }

        private LabeledSeriesCollection _pieJobFailedReasons;
        public LabeledSeriesCollection PieJobFailedReasons
        {
            get { return _pieJobFailedReasons; }
            set { _pieJobFailedReasons = value; RaisePropertyChangedAuto(); }
        }

        public MainViewVM()
        {

        }

        public override void OnApplicationReady()
        {
            Task.Factory.StartNew(() =>
            {
                _context = ObservablesContext.CreateDefault();
                DateTime start_date = DateTime.UtcNow.AddMonths(-1);
                _job_runs = _context.JobRuns.OrderBy(x => x.StartDate).ToList();
            });
        }

        private List<JobRun> GetJobRunsByStartDate(DateTime startDate, JobRunStatus? status = null)
        {
            return _job_runs.Where(x => x.StartDate.ToLocalTime() >= startDate && (status == null || x.JobRunStatus == status)).ToList();
        }

        private List<JobRun> GetJobRunsByDate(DateTime date, JobRunStatus? status = null)
        {
            return _job_runs.Where(x => x.StartDate.ToLocalTime().Date == date.Date && (status == null || x.JobRunStatus == status)).ToList();
        }

        private IEnumerable<DateTime> CreateDates(DateTime start, DateTime end)
        {
            for (DateTime date = start.Date; date.Date <= end.Date; date = date.AddDays(1))
            {
                yield return date;
            }
        }

        public override void OnNavigatedTo()
        {
            base.OnNavigatedTo();

            if (rendered) return;

            rendered = true;

            InvokeUIOnIdle(() =>
            {
                if (_job_runs.Count > 0)
                {
                    GenerateTimelineJobStatusChart();
                    GeneratePieFailedReasonsChart();
                }
            });
        }

        private void GenerateTimelineJobStatusChart()
        {
            TimelineJobStatusSeries = new LabeledSeriesCollection()
            {
                Title = "This Month Job Runs Status",
                ChartTitle = "Number Of Runs",
                LabelsTitle = "Date",
                SeriesColors = new List<Color>()
                    {
                         Colors.Green,
                         Colors.Orange,
                         Colors.Red,
                    },
            };

            var completed_job_runs = new ColumnSeries()
            {
                Title = "Completed",
                Values = new ChartValues<int>(),
                Fill = Brushes.Green,
            };
            var aborted_job_runs = new ColumnSeries()
            {
                Title = "Aborted",
                Values = new ChartValues<int>(),
                Fill = Brushes.Orange,
            };
            var failed_job_runs = new ColumnSeries()
            {
                Title = "Failed",
                Values = new ChartValues<int>(),
                Fill = Brushes.Red,
            };

            foreach (var date in CreateDates(DateTime.Now.AddMonths(-1), DateTime.Now))
            {
                completed_job_runs.Values.Add(GetJobRunsByDate(date, JobRunStatus.Completed).Count());
                aborted_job_runs.Values.Add(GetJobRunsByDate(date, JobRunStatus.Aborted).Count());
                failed_job_runs.Values.Add(GetJobRunsByDate(date, JobRunStatus.Failed).Count());

                TimelineJobStatusSeries.Labels.Add(date.ToShortDateString());
            }

            TimelineJobStatusSeries.SeriesCollection.Add(completed_job_runs);
            TimelineJobStatusSeries.SeriesCollection.Add(aborted_job_runs);
            TimelineJobStatusSeries.SeriesCollection.Add(failed_job_runs);
        }

        private void GeneratePieFailedReasonsChart()
        {
            var groups = GetJobRunsByStartDate(DateTime.Now.AddMonths(-1), JobRunStatus.Failed).GroupBy(x => x.FailedMessage).OrderBy(x => x.Count());

            List<Color> colors = new List<Color>();

            int max = groups.Max(x => x.Count());

            for (int i = 0; i < groups.Count(); i++)
            {
                int count = groups.ElementAt(i).Count();
                double alpha = Math.Max(((double)(count) / max * 200), 20);
                colors.Add(Color.FromArgb((byte)alpha, 200, 0, 0));
            }

            PieJobFailedReasons = new LabeledSeriesCollection()
            {
                Title = "This Month Job Failure Reasons",
                SeriesColors = colors,
            };

            int index = 0;

            foreach (var group in groups)
            {
                int count = group.Count();

                var series = new PieSeries()
                {
                    Title = group.First().FailedMessage,
                    Values = new ChartValues<int>() { count },
                    Fill = new SolidColorBrush(colors[index++]),
                    DataLabels = true,
                    ToolTip = group.First().FailedMessage,
                };

                PieJobFailedReasons.SeriesCollection.Add(series);
            }
        }
    }
}