aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/FSE/Modules/Tango.FSE.Procedures/ViewModels/ResultsViewVM.cs
blob: dfad0017daa0c79a2d072ab6f7808811df30c151 (plain)
1
2
3
4
5
6
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.S
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using Tango.Core.Commands;
using Tango.Core.DI;
using Tango.CSV;
using Tango.FSE.Common;
using Tango.FSE.Common.Notifications;
using Tango.FSE.Procedures.CSV;
using Tango.FSE.Procedures.Dialogs;

namespace Tango.FSE.Procedures.ViewModels
{
    public class ResultsViewVM : FSEViewModel
    {
        private List<Result> _results;
        public List<Result> Results
        {
            get { return _results; }
            set { _results = value; RaisePropertyChangedAuto(); }
        }

        public RelayCommand<Result> DisplayResultGridCommand { get; set; }
        public RelayCommand<Result> ExportResultGridCommand { get; set; }

        public ResultsViewVM()
        {
            TangoIOC.Default.Inject(this);

            Results = new List<Result>();
            DisplayResultGridCommand = new RelayCommand<Result>(DisplayResultGrid);
            ExportResultGridCommand = new RelayCommand<Result>(ExportResultGrid);
        }

        private void DisplayResultGrid(Result result)
        {
            if (result != null)
            {
                ResultGridViewVM vm = new ResultGridViewVM(result);
                NotificationProvider.ShowDialog(vm);
            }
        }

        private async void ExportResultGrid(Result result)
        {
            if (result != null && result.IsValueArray && (result.Value as IList).Count > 0)
            {
                var r = await StorageProvider.SaveFile("Export procedure result", "CSV Files|*.csv", result.Name + ".csv", ".csv");
                if (r.Confirmed)
                {
                    using (NotificationProvider.PushTaskItem("Exporting csv file..."))
                    {
                        try
                        {
                            await Task.Factory.StartNew(() =>
                            {
                                List<Object> values = (result.Value as IEnumerable).Cast<Object>().ToList();

                                var model = values.First();

                                if (model.GetType().IsValueTypeOrString())
                                {
                                    CsvFile<CsvRow> csvFile = new CsvFile<CsvRow>(new CsvDestination(r.SelectedItem), new CsvDefinition() { Columns = new List<String>() { "Values" } });

                                    foreach (var value in values)
                                    {
                                        csvFile.Append(new CsvRow()
                                        {
                                            V0 = value
                                        });
                                    }

                                    csvFile.Dispose();
                                }
                                else
                                {
                                    List<CsvColumn> columns = new List<CsvColumn>();

                                    //prop columns
                                    foreach (var prop in model.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance))
                                    {
                                        var att = prop.GetCustomAttribute<DescriptionAttribute>();
                                        columns.Add(new CsvColumn()
                                        {
                                            Name = prop.Name,
                                            Description = att != null ? att.Description : prop.Name,
                                            IsProperty = true,
                                            PropertyInfo = prop
                                        });
                                    }

                                    //field columns
                                    foreach (var field in model.GetType().GetFields(BindingFlags.Public | BindingFlags.Instance))
                                    {
                                        var att = field.GetCustomAttribute<DescriptionAttribute>();
                                        columns.Add(new CsvColumn()
                                        {
                                            Name = field.Name,
                                            Description = att != null ? att.Description : field.Name,
                                            FieldInfo = field
                                        });
                                    }

                                    CsvFile<CsvRow> csvFile = new CsvFile<CsvRow>(new CsvDestination(r.SelectedItem), new CsvDefinition() { Columns = columns.Select(x => x.Description).ToList() });

                                    List<PropertyInfo> rowProps = typeof(CsvRow).GetProperties().ToList();

                                    foreach (var value in values)
                                    {
                                        CsvRow row = new CsvRow();

                                        for (int i = 0; i < columns.Count; i++)
                                        {
                                            var column = columns[i];
                                            rowProps[i].SetValue(row, column.GetValue(value));
                                        }

                                        csvFile.Append(row);
                                    }

                                    csvFile.Dispose();
                                }
                            });

                            NotificationProvider.PushSnackbarItem(MessageType.Success, "CSV file exported", true, "Procedure result was exported to file.\nTap to browse the file location.", TimeSpan.FromSeconds(5), null, () => 
                            {
                                StorageProvider.ShowInExplorer(r.SelectedItem);
                            });
                        }
                        catch (Exception ex)
                        {
                            LogManager.Log(ex, "Error exporting csv file.");
                            await NotificationProvider.ShowError($"Error occurred while exporting the csv file.\n{ex.FlattenMessage()}");
                        }
                    }
                }
            }
        }
    }
}