prs/prs.desktop/Dashboards/Common/DigitalFormsDashboard.xaml.cs

using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.Reports;
using InABox.Core.Reports;
using InABox.Scripting;
using InABox.WPF;
using InABox.Wpf;
using PRSDesktop.Configuration;
using PRSDesktop.Forms;
using PRSDesktop.WidgetGroups;
using Syncfusion.UI.Xaml.Grid;
using Syncfusion.UI.Xaml.Grid.Converter;
using Syncfusion.XlsIO;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Diagnostics.CodeAnalysis;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using InABox.Configuration;
using SelectionChangedEventArgs = System.Windows.Controls.SelectionChangedEventArgs;
using InABox.Wpf.Reports;
using System.ComponentModel;
using Syncfusion.Windows.Shared;
using System.Globalization;
using System.Windows.Media.Imaging;
using System.Drawing;
using Image = System.Windows.Controls.Image;
using Microsoft.Win32;
using Syncfusion.CompoundFile.DocIO.Net;
using System.IO;
using com.healthmarketscience.jackcess.query;
using sun.security.krb5.@internal;
using Columns = InABox.Core.Columns;
using PanelAction = InABox.Wpf.PanelAction;

namespace PRSDesktop;

public enum DateFilterType
{
    Today,
    Yesterday,
    Week,
    SevenDays,
    Month,
    ThirtyDays,
    Year,
    TwelveMonths,
    Custom
}

public class DFFilter : BaseObject
{
    [EditorSequence(1)]
    [TextBoxEditor]
    public string Name { get; set; } = "";

    [EditorSequence(2)]
    [FilterEditor]
    public string Filter { get; set; } = "";
}

internal class MileStoneImageConverter : IValueConverter
{
    public object? Convert(object value, Type targetType, object parameter, CultureInfo culture)
    {
        return Equals(value, DateTime.MinValue) ? null : Resources.milestone.AsBitmapImage();
    }

    public object? ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
    {
        return null;
    }
}

public class DigitalFormsDashboardProperties : IUserConfigurationSettings, IDashboardProperties
{
    public bool ShowJobFilter { get; set; } = false;
    public bool ShowDateFilter { get; set; } = true;

    public bool ShowIncompleteForms { get; set; } = false;

    public bool UseIconsForFormTypes { get; set; } = false;

    public string? Category { get; set; }

    public Guid SelectedForm { get; set; }

    public Guid JobID { get; set; }

    public DateFilterType DateFilterType { get; set; } = DateFilterType.Today;

    public DateTime FromDate { get; set; }
    public DateTime ToDate { get; set; }

    public Dictionary<string, List<DFFilter>> Filters { get; set; } = new();
}

public class DigitalFormsDashboardElement : DashboardElement<DigitalFormsDashboard, Common, DigitalFormsDashboardProperties> { }

/// <summary>
/// Interaction logic for DigitalFormsDashboard.xaml
/// </summary>
public partial class DigitalFormsDashboard : UserControl,
    IDashboardWidget<Common, DigitalFormsDashboardProperties>,
    IBasePanel,
    IRequiresSecurity<CanViewDigitalFormsDashbaord>,
    IHeaderDashboard, IActionsDashboard
{
    public DigitalFormsDashboardProperties Properties { get; set; }
    public event LoadSettings<DigitalFormsDashboardProperties>? LoadSettings;
    public event SaveSettings<DigitalFormsDashboardProperties>? SaveSettings;

    private List<DigitalForm> DigitalForms;
    private List<Job> Jobs;

    private List<Tuple<string, Type?, string>> Categories;

    public DashboardHeader Header { get; set; } = new();

    private bool IsQAForm = false;
    private List<QAQuestion> Questions = new();

    private bool IsSetup = false;

    public DigitalFormsDashboard()
    {
        InitializeComponent();

        DataGrid.RowStyleSelector = new RowStyleSelector();
    }

    public void Setup()
    {
        var results = Client.QueryMultiple(
            new KeyedQueryDef<DigitalForm>(new Filter<DigitalForm>(x => x.Active).IsEqualTo(true)),
            new KeyedQueryDef<Job>(
                LookupFactory.DefineFilter<Job>(),
                Columns.None<Job>().Add(x => x.ID)
                    .Add(x => x.JobNumber)
                    .Add(x => x.Name)));

        DigitalForms = results.Get<DigitalForm>().ToObjects<DigitalForm>().ToList();

        var categories = new DigitalFormCategoryLookups(null);
        categories.OnAfterGenerateLookups += (sender, entries) => { entries.Insert(0, new LookupEntry("", "Select Category")); };

        Categories = categories.AsTable("AppliesTo")
            .Rows.Select(x =>
            {
                var appliesTo = x.Get<string>("AppliesTo");
                if (CategoryToType(appliesTo, out var formType, out var parentType))
                {
                    return new Tuple<string, Type?, string>(appliesTo, formType, x.Get<string>("Display"));
                }
                else
                {
                    return new Tuple<string, Type?, string>(appliesTo, null, x.Get<string>("Display"));
                }
            }).ToList();

        Jobs = results.Get<Job>().ToObjects<Job>().ToList();
        Jobs.Insert(0, new Job { ID = Guid.Empty, JobNumber = "ALL", Name = "All Jobs" });

        SetupHeader();
        SetupFilters();

        IsSetup = true;
    }

    #region Header

    private StackPanel CategoryButtonPanel;
    private Dictionary<Type, Button> CategoryButtons = new();
    private ComboBox CategoryBox;
    private ComboBox FormBox;
    private ComboBox JobBox;
    private ComboBox IncompleteFormsBox;

    private ComboBox DateTypeBox;

    private Label FromLabel;
    private DatePicker FromPicker;

    private Label ToLabel;
    private DatePicker ToPicker;

    private Button Print;
    private Button FilterBtn;

    private static Dictionary<DateFilterType, string> FilterTypes = new()
    {
        { DateFilterType.Today,         "Today" },
        { DateFilterType.Yesterday,     "Yesterday" },
        { DateFilterType.Week,          "Week to Date" },
        { DateFilterType.SevenDays,     "Last 7 Days" },
        { DateFilterType.Month,         "Month to Date" },
        { DateFilterType.ThirtyDays,    "Last 30 Days" },
        { DateFilterType.Year,          "Year to Date" },
        { DateFilterType.TwelveMonths,  "Last 12 Months" },
        { DateFilterType.Custom,        "Custom" }
    };

    private static readonly SolidColorBrush EnabledBrush = new SolidColorBrush(Colors.LightYellow);
    private static readonly SolidColorBrush DisabledBrush = new SolidColorBrush(Colors.LightGray);

    private static readonly Dictionary<Type, Bitmap> CategoryImages = new()
    {
        { typeof(AssignmentForm), PRSDesktop.Resources.assignments },
        { typeof(KanbanForm), PRSDesktop.Resources.kanban },
        { typeof(JobForm), PRSDesktop.Resources.project },
        { typeof(JobITPForm), PRSDesktop.Resources.checklist },
        { typeof(EmployeeForm), PRSDesktop.Resources.employees },
        { typeof(LeaveRequestForm), PRSDesktop.Resources.leave },
        { typeof(ManufacturingPacketStage), PRSDesktop.Resources.factory },
        { typeof(TimeSheetForm), PRSDesktop.Resources.time },
        { typeof(PurchaseOrderItemForm), PRSDesktop.Resources.purchase },
        { typeof(DeliveryForm), PRSDesktop.Resources.truck },
    };

    public void SetupHeader()
    {
        CategoryBox = new ComboBox
        {
            Width = 150,
            VerticalContentAlignment = VerticalAlignment.Center,
            Margin = new Thickness(0, 0, 5, 0)
        };
        CategoryBox.ItemsSource = Categories;
        CategoryBox.SelectedValuePath = "Item1";
        CategoryBox.DisplayMemberPath = "Item3";
        CategoryBox.SelectedValue = Properties.Category;
        CategoryBox.SelectionChanged += Category_SelectionChanged;

        CategoryButtonPanel = new StackPanel
        {
            Orientation = Orientation.Horizontal,
            Margin = new Thickness(0, 0, 5, 0)
        };
        
        CategoryButtons.Clear();
        foreach(var (appliesTo, category, display) in Categories)
        {
            if(category is null)
            {
                continue;
            }
            var button = new Button();
            button.Tag = appliesTo;
            button.Margin = new Thickness(0, 0, 2, 0);
            button.BorderBrush = new SolidColorBrush(Colors.Gray);
            button.BorderThickness = new Thickness(0.75);
            button.Width = 25D;
            button.Padding = new Thickness(2);
            button.ToolTip = category.EntityName().Split('.').Last().SplitCamelCase();
            if (CategoryImages.TryGetValue(category, out var image))
            {
                button.Content = new Image { Source = image.AsBitmapImage() };
            }
            else
            {
                button.Content = display;
            }

            button.Click += CatagoryButton_Click;
            CategoryButtons.Add(category, button);
            CategoryButtonPanel.Children.Add(button);
        }

        if (Properties.UseIconsForFormTypes)
        {
            CategoryButtonPanel.Visibility = Visibility.Visible;
            CategoryBox.Visibility = Visibility.Collapsed;
        }
        else
        {
            CategoryButtonPanel.Visibility = Visibility.Collapsed;
            CategoryBox.Visibility = Visibility.Visible;
        }

        FormBox = new ComboBox
        {
            Width = 250,
            VerticalContentAlignment = VerticalAlignment.Center,
            Margin = new Thickness(0, 0, 5, 0),
            IsEnabled = false
        };
        FormBox.SelectionChanged += FormBox_SelectionChanged;
        FormBox.ItemsSource = new Dictionary<DigitalForm, string> { };

        JobBox = new ComboBox
        {
            Width = 250,
            Margin = new Thickness(0, 0, 5, 0),
            VerticalContentAlignment = VerticalAlignment.Center
        };
        JobBox.ItemsSource = Jobs.ToDictionary(x => x.ID, x => $"{x.JobNumber} : {x.Name}");
        JobBox.SelectedIndex = 0;
        JobBox.SelectedValuePath = "Key";
        JobBox.DisplayMemberPath = "Value";
        JobBox.SelectionChanged += JobBox_SelectionChanged;

        DateTypeBox = new ComboBox
        {
            Width = 120,
            VerticalContentAlignment = VerticalAlignment.Center
        };
        DateTypeBox.ItemsSource = FilterTypes;
        DateTypeBox.SelectedValuePath = "Key";
        DateTypeBox.DisplayMemberPath = "Value";
        DateTypeBox.SelectedValue = Properties.DateFilterType;
        DateTypeBox.SelectionChanged += DateTypeBox_SelectionChanged;

        FromLabel = new Label { Content = "From", VerticalContentAlignment = VerticalAlignment.Center, Margin = new Thickness(0, 0, 5, 0) };
        FromPicker = new DatePicker
        {
            Width = 100,
            Background = new SolidColorBrush(Colors.LightYellow),
            VerticalContentAlignment = VerticalAlignment.Center,
            FirstDayOfWeek = DayOfWeek.Monday,
            Margin = new Thickness(0, 0, 5, 0)
        };
        FromPicker.SelectedDateChanged += FromPicker_SelectedDateChanged;

        ToLabel = new Label { Content = "To", VerticalContentAlignment = VerticalAlignment.Center, Margin = new Thickness(0, 0, 5, 0) };
        ToPicker = new DatePicker
        {
            Width = 100,
            Background = new SolidColorBrush(Colors.LightYellow),
            VerticalContentAlignment = VerticalAlignment.Center,
            FirstDayOfWeek = DayOfWeek.Monday,
            Margin = new Thickness(0, 0, 5, 0)
        };
        ToPicker.SelectedDateChanged += ToPicker_SelectedDateChanged;

        IncompleteFormsBox = new ComboBox
        {
            Width = 130,
            Margin = new Thickness(0, 0, 5, 0),
            VerticalContentAlignment = VerticalAlignment.Center
        };
        IncompleteFormsBox.ItemsSource = new List<Tuple<string, bool>>
        {
            new Tuple<string, bool>("Completed Forms", false),
            new Tuple<string, bool>("All Forms", true)
        };
        IncompleteFormsBox.DisplayMemberPath = "Item1";
        IncompleteFormsBox.SelectedValuePath = "Item2";
        IncompleteFormsBox.SelectedValue = Properties.ShowIncompleteForms;
        IncompleteFormsBox.SelectionChanged += IncompleteFormsBox_SelectionChanged;

        Print = new Button
        {
            Width = 25,
            Height = 25,
            Content = new Image { Source = PRSDesktop.Resources.printer.AsBitmapImage() }
        };
        Print.Click += Print_Click;

        FilterBtn = new Button
        {
            Width = 25,
            Height = 25,
            Content = new Image { Source = InABox.Wpf.Resources.filter.AsBitmapImage() },
            Margin = new Thickness(0, 0, 5, 0)
        };
        FilterBtn.Click += Filter_Click;

        Header.BeginUpdate()
            .Clear()
            .Add(CategoryBox)
            .Add(CategoryButtonPanel)
            .Add(FormBox)
            .Add(JobBox)
            .Add(DateTypeBox)
            .Add(FromLabel)
            .Add(FromPicker)
            .Add(ToLabel)
            .Add(ToPicker)
            .Add(IncompleteFormsBox)
            .AddRight(FilterBtn)
            .AddRight(Print)
            .EndUpdate();

        UpdateCategory(Properties.Category);
    }

    private void IncompleteFormsBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        Properties.ShowIncompleteForms = (bool)IncompleteFormsBox.SelectedValue;
        Refresh();
    }

    private void Filter_Click(object sender, RoutedEventArgs e)
    {
        var menu = new ContextMenu();

        menu.AddCheckItem("Use Form Type Icons", ToggleFormTypeIcons, isChecked: Properties.UseIconsForFormTypes);
        menu.AddCheckItem("Show Date Filter", ToggleDateFilter, Properties.ShowDateFilter);
        menu.AddCheckItem("Show Job Filter", ToggleJobFilter, Properties.ShowJobFilter);
        menu.AddSeparator();

        if (ParentType is not null)
        {
            if (Properties.Filters.TryGetValue(ParentType.Name, out var filters))
            {
                var i = 0;
                var items = new List<MenuItem>();
                foreach (var filter in filters)
                {
                    items.Add(menu.AddCheckItem(
                        filter.Name,
                        new Tuple<int, string, List<MenuItem>>(i, filter.Filter, items),
                        ExecuteFilter,
                        i == CustomFilterIndex));
                    ++i;
                }
            }
            menu.AddSeparatorIfNeeded();
            menu.AddItem("Manage Filters", InABox.Wpf.Resources.filter, ManageFilters_Click);
        }

        menu.IsOpen = true;
    }

    private void ToggleFormTypeIcons(bool isChecked)
    {
        Properties.UseIconsForFormTypes = !Properties.UseIconsForFormTypes;
        if (Properties.UseIconsForFormTypes)
        {
            CategoryButtonPanel.Visibility = Visibility.Visible;
            CategoryBox.Visibility = Visibility.Collapsed;
        }
        else
        {
            CategoryButtonPanel.Visibility = Visibility.Collapsed;
            CategoryBox.Visibility = Visibility.Visible;
        }
    }

    private void Print_Click(object sender, RoutedEventArgs e)
    {
        var menu = new ContextMenu();
        foreach (var report in ReportUtils.LoadReports(SectionName, DataModel(Selection.None)))
        {
            menu.AddItem(report.Name, PRSDesktop.Resources.printer, report, PrintReport_Click);
        }
        if (Security.IsAllowed<CanDesignReports>())
        {
            menu.AddSeparatorIfNeeded();
            menu.AddItem("Manage Reports", PRSDesktop.Resources.printer, ManageReports_Click);
        }
        menu.IsOpen = true;
    }
    private void PrintReport_Click(ReportTemplate obj)
    {
        Selection selection;
        if (obj.SelectedRecords && obj.AllRecords)
            selection = RecordSelectionDialog.Execute();
        else if (obj.SelectedRecords)
            selection = Selection.Selected;
        else if (obj.AllRecords)
            selection = Selection.All;
        else
            selection = Selection.None;

        ReportUtils.PreviewReport(obj, DataModel(selection), false, Security.IsAllowed<CanDesignReports>());
    }

    private void ManageReports_Click()
    {
        var manager = new ReportManager()
        {
            DataModel = DataModel(Selection.None),
            Section = SectionName,
            Populate = true
        };
        manager.ShowDialog();
    }

    private void Search_KeyUp(object sender, KeyEventArgs e)
    {
        Refresh();
    }

    private void JobBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        Properties.JobID = (Guid)JobBox.SelectedValue;
        Refresh();
    }

    private void SetDateFilterVisibility(bool visible)
    {
        var visibility = visible ? Visibility.Visible : Visibility.Collapsed;
        FromLabel.Visibility = visibility;
        FromPicker.Visibility = visibility;
        ToLabel.Visibility = visibility;
        ToPicker.Visibility = visibility;
        DateTypeBox.Visibility = visibility;
    }
    private void SetJobFilterVisibility(bool visible)
    {
        var visibility = visible ? Visibility.Visible : Visibility.Collapsed;
        JobBox.Visibility = visibility;
    }

    private void DateTypeBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        var filterType = (DateFilterType)DateTypeBox.SelectedValue;
        Properties.DateFilterType = filterType;
        if (filterType == DateFilterType.Custom)
        {
            if (FromPicker.SelectedDate == null || FromPicker.SelectedDate == DateTime.MinValue)
            {
                Properties.FromDate = DateTime.Today;
            }
            else
            {
                Properties.FromDate = FromPicker.SelectedDate.Value;
            }
            if (ToPicker.SelectedDate == null || ToPicker.SelectedDate == DateTime.MinValue)
            {
                Properties.ToDate = DateTime.Today;
            }
            else
            {
                Properties.ToDate = ToPicker.SelectedDate.Value;
            }
        }
        SetupDateFilters();
        Refresh();
    }

    private void FromPicker_SelectedDateChanged(object? sender, SelectionChangedEventArgs e)
    {
        Properties.FromDate = FromPicker.SelectedDate ?? DateTime.Today;
        Refresh();
    }

    private void ToPicker_SelectedDateChanged(object? sender, SelectionChangedEventArgs e)
    {
        Properties.ToDate = ToPicker.SelectedDate ?? DateTime.Today;
        Refresh();
    }

    private bool _changing = false;

    private void UpdateCategory(string? category)
    {
        _changing = true;
        
        Properties.Category = category;
        SetCategory(Properties.Category);

        foreach(var (type, button) in CategoryButtons)
        {
            if(type == FormType)
            {
                button.Background = EnabledBrush;
            }
            else
            {
                button.Background = DisabledBrush;
            }
        }

        var jobLink = FormType is not null ? GetJobLink("", FormType,true) : "";
        if (string.IsNullOrWhiteSpace(jobLink))
        {
            var jobID = Properties.JobID;
            JobBox.SelectedValue = Guid.Empty;
            JobBox.IsEnabled = false;
            Properties.JobID = jobID;
            
        }
        else
        {
            JobBox.SelectedValue = Properties.JobID;
            JobBox.IsEnabled = true;
        }

        string changeableJobLink = "";
        string changeableScopeLink = "";
        if (changeableLinks.TryGetValue(FormType, out Tuple<string,string> _tuple))
        {
            changeableJobLink = _tuple.Item1;
            changeableScopeLink = _tuple.Item2;
        }
        
        if (_jobAction != null)
            _jobAction.Visibility = string.IsNullOrWhiteSpace(changeableJobLink) ? Visibility.Collapsed : Visibility.Visible;
        
        if (_jobScopeAction != null)
            _jobScopeAction.Visibility = string.IsNullOrWhiteSpace(changeableScopeLink) ? Visibility.Collapsed : Visibility.Visible;

        if (ParentType is null)
        {
            FormBox.IsEnabled = false;
            FormBox.ItemsSource = new Dictionary<DigitalForm, string> { };
        }
        else
        {
            var forms = DigitalForms.Where(x => x.AppliesTo == ParentType.Name).ToList();
            forms.Insert(0, new DigitalForm { ID = Guid.Empty, Description = "Select Form" });
            FormBox.ItemsSource = forms;

            if (Properties.SelectedForm != Guid.Empty && forms.Where(x => x.ID == Properties.SelectedForm).FirstOrDefault() is DigitalForm form)
            {
                FormBox.SelectedItem = form;
            }
            else
            {
                FormBox.SelectedIndex = 0;
            }

            FormBox.DisplayMemberPath = "Description";

            FormBox.IsEnabled = true;
        }
        _changing = false;

        OnUpdateDataModel?.Invoke(SectionName, DataModel(Selection.None));
    }

    private void CatagoryButton_Click(object sender, RoutedEventArgs e)
    {
        UpdateCategory(((sender as Button)!.Tag as string)!);
        Refresh();
    }

    private void Category_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        UpdateCategory((CategoryBox.SelectedValue as string)!);
        Refresh();
    }

    private void FormBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        Form = FormBox.SelectedValue as DigitalForm;
        Properties.SelectedForm = Form?.ID ?? Guid.Empty;

        if (!_changing)
        {
            OnUpdateDataModel?.Invoke(SectionName, DataModel(Selection.None));
        }

        Refresh();
    }

    #endregion

    #region IBasePanel

    public bool IsReady { get; set; }

    public event DataModelUpdateEvent? OnUpdateDataModel;

    private PanelAction? _jobAction = null;
    private PanelAction? _jobScopeAction = null;
    public void CreateToolbarButtons(IPanelHost host)
    {
        host.CreatePanelAction(new PanelAction("Export Forms", PRSDesktop.Resources.disk, action => SaveToFolder_Click()));

        _jobAction ??= new PanelAction("Set Job Number", PRSDesktop.Resources.project, SetJobNumber);
        host.CreatePanelAction(_jobAction);

        _jobScopeAction ??= new PanelAction(
            "Set Job Scope",
            PRSDesktop.Resources.project,
            null,
            LoadJobScopes
        );
        host.CreatePanelAction(_jobScopeAction);
        
    }

    private IPanelActionEntry[] LoadJobScopes(PanelAction arg)
    {
        List<IPanelActionEntry> result = new();
        var linkcolumn = GetJobLink("", FormType, true);
        if (!string.IsNullOrWhiteSpace(linkcolumn))
        {
            linkcolumn = $"{linkcolumn.Replace(".","_")}_ID";
            var jobid = DataGrid.SelectedItems.Select(x => (x as DataRowView)!.Row[linkcolumn]).FirstOrDefault();
            if (jobid != null && !Guid.Equals(jobid, Guid.Empty))
            {
                var scopes =Client.Query<JobScope>(
                    new Filter<JobScope>(x => x.Job.ID).IsEqualTo((Guid)jobid),
                    Columns.None<JobScope>()
                        .Add(x => x.ID)
                        .Add(x => x.Number)
                        .Add(x => x.Description)
                ).ToObjects<JobScope>();
                foreach (var scope in scopes)
                {
                    var entry = new PanelActionEntry<Guid>($"{scope.Number}: {scope.Description}",
                        PRSDesktop.Resources.project, scope.ID, SetJobScope);
                    result.Add(entry);
                }
            }
        }

        return result.ToArray();
    }

    private void SetJobScope(PanelActionEntry<Guid> scopeid)
    {
        Type? _type = FormType == typeof(JobForm)
            ? FormType
            : ParentType;

        if (_type == null)
            return;

        string _idCol = FormType == typeof(JobForm)
            ? "ID"
            : "Parent_ID";
            
        Guid[] _ids = DataGrid.SelectedItems.Select(x => (x as DataRowView)!.Row[_idCol]).Distinct()
            .OfType<Guid>().ToArray();
            
        Progress.ShowModal("Updating Job Scopes", progress =>
        {
                
            var _updates = ClientFactory.CreateClient(_type)
                .Query(
                    Filter.Create(_type, "ID", Operator.InList, _ids),
                    Columns.Create(_type, ColumnTypeFlags.Required)
                ).ToObjects(_type).ToArray();
            var _scopelink = GetJobScopeLink("", _type, FormType == typeof(JobForm) ? 0 : 1);
            foreach (var _update in _updates)
                CoreUtils.SetPropertyValue(_update, _scopelink + ".ID", scopeid.Data);
            ClientFactory.CreateClient(_type).Save(_updates, "Updated Job Number");
        });
        Refresh();
    }

    private void SetJobNumber(PanelAction obj)
    {
        var dlg = new MultiSelectDialog<Job>(
            LookupFactory.DefineFilter<Job>(),
            Columns.None<Job>()
                .Add(x => x.ID)
                .Add(x => x.JobNumber)
                .Add(x => x.Name)
            , false
        );
        if (dlg.ShowDialog())
        {
            Guid _jobID = dlg.IDs().FirstOrDefault();
            
            Type? _type = FormType == typeof(JobForm)
                ? FormType
                : ParentType;

            if (_type == null)
                return;

            string _idCol = FormType == typeof(JobForm)
                ? "ID"
                : "Parent_ID";
            
            Guid[] _ids = DataGrid.SelectedItems.Select(x => (x as DataRowView)!.Row[_idCol]).Distinct()
                .OfType<Guid>().ToArray();
            
            Progress.ShowModal("Updating Job Numbers", progress =>
            {
                
                var _updates = ClientFactory.CreateClient(_type)
                    .Query(
                        Filter.Create(_type, "ID", Operator.InList, _ids),
                        Columns.Create(_type, ColumnTypeFlags.Required)
                    ).ToObjects(_type).ToArray();
                var _joblink = GetJobLink("", _type, false);
                foreach (var _update in _updates)
                    CoreUtils.SetPropertyValue(_update, _joblink + ".ID", _jobID);
                ClientFactory.CreateClient(_type).Save(_updates, "Updated Job Number");
            });
            Refresh();
        }
    }

    public void Heartbeat(TimeSpan time)
    {
    }

    public Dictionary<string, object[]> Selected()
    {
        return new Dictionary<string, object[]>();
    }

    #endregion

    public string SectionName
    {
        get
        {
            if (Form is null || Form.ID == Guid.Empty)
                return "Digital Forms";
            return Form.ID.ToString() ?? "Digital Forms";
        }
    }
    public DataModel DataModel(Selection selection)
    {
        if (FormType is null || Form is null || Form.ID == Guid.Empty)
        {
            return new AutoDataModel<DigitalForm>(new Filter<DigitalForm>().None());
        }

        IFilter filter;
        switch (selection)
        {
            case Selection.Selected:
                var formids = DataGrid.SelectedItems.Select(x => (x as DataRowView)!.Row["ID"]).ToArray();
                filter = Filter.Create<Entity>(FormType, x => x.ID).InList(formids);
                break;
            case Selection.All:
                filter = Filter.Create(FormType).All();
                break;
            case Selection.None:
            default:
                filter = Filter.Create(FormType).None();
                break;
        }

        return (Activator.CreateInstance(typeof(DigitalFormReportDataModel<>)!
            .MakeGenericType(FormType), new object?[] { filter, Form.ID }) as DataModel)!;
    }

    public void BuildActionsMenu(ContextMenu menu)
    {
        menu.AddItem("Export", InABox.Wpf.Resources.doc_xls, Export_Click, Form is not null && Form.ID != Guid.Empty);
        var loadingModules = menu.AddItem("Loading Modules...", null, null, false);
        Task.Run(() =>
        {
            return CustomModuleUtils.LoadCustomModuleThumbnails(SectionName, DataModel(Selection.None));
        }).ContinueWith((task) =>
        {
            var modules = task.Result;
            var index = menu.Items.IndexOf(loadingModules);
            menu.Items.RemoveAt(index);
            foreach (var (module, image) in modules)
            {
                menu.AddItem(module.Name, image, module, ExecuteModule_Click, index: index);
                ++index;
            }
        }, TaskScheduler.FromCurrentSynchronizationContext());

        if (Security.IsAllowed<CanCustomiseModules>())
        {
            menu.AddSeparatorIfNeeded();
            menu.AddItem("Manage Modules", PRSDesktop.Resources.script, ManageModules_Click);
        }
    }

    private void SaveToFolder_Click()
    {
        if (Form is null || FormType is null)
        {
            MessageWindow.ShowMessage("Please select a form first.", "Select form");
            return;
        }

        var model = DataModel(Selection.None);
        
        var reports = ReportUtils.LoadReports(Form.ID.ToString(), model).Where(x => x.Visible).ToList();

        var method = typeof(DigitalFormsDashboard).GetMethod("SaveToFolder", BindingFlags.Instance | BindingFlags.NonPublic)!.MakeGenericMethod(FormType);

        if (reports.Count == 0)
        {
            MessageWindow.ShowMessage("No reports are currently defined for this Digital Form!", "No report found");
            return;
        }
        
        if(reports.Count == 1)
        {
            method.Invoke(this, new object[] { reports[0] });
            return;
        }

        var menu = new ContextMenu();
        foreach (var report in reports)
            menu.AddItem(report.Name, null, report, r => method.Invoke(this, new[] { r }));
        menu.IsOpen = true;
    }

    private void SaveToFolder<TForm>(ReportTemplate report)
        where TForm : Entity, IDigitalFormInstance, IRemotable, IPersistent, new()
    {
        using (var dialog = new System.Windows.Forms.FolderBrowserDialog())
        {
            var result = dialog.ShowDialog();
            if(result == System.Windows.Forms.DialogResult.OK && !string.IsNullOrWhiteSpace(dialog.SelectedPath))
            {
                var data = DataGrid.SelectedItems.OfType<DataRowView>().Select(x => x.Row).ToList();
                Progress.ShowModal("Saving forms", progress =>
                {
                    foreach (var row in data)
                    {
                        var id = (Guid)row["ID"];
                        var number = (string)row["Number"];
                        progress.Report($"Saving form {number}");
                        var dataModel = new DigitalFormReportDataModel<TForm>(
                            new Filter<TForm>(x => x.ID).IsEqualTo(id),
                            Form!.ID);
                        var pdfData = ReportUtils.ReportToPDF(report, dataModel, true);

                        var expr = dataModel.EvaluateExpression(Form.ExportExpression)?.Trim();
                        var filename = String.IsNullOrWhiteSpace(expr)
                            ? number
                            : $"{number} - {CoreUtils.SanitiseFileName(expr)}";
                        File.WriteAllBytes(Path.Combine(dialog.SelectedPath, Path.ChangeExtension(filename, ".pdf")), pdfData);
                    }
                });
                Process.Start("explorer.exe" , dialog.SelectedPath);
            }
        }
    }

    private void Export_Click()
    {
        var formName = Regex.Replace(Form?.Description ?? "", "[^ a-zA-Z0-9]", "");
        var filename = string.Format("{0} - {1} - {2:yyyy-MM-dd} - {3:yyyy-MM-dd}.xlsx", ParentType!.Name, formName, From, To);

        var options = new ExcelExportingOptions();
        options.ExcelVersion = ExcelVersion.Excel2013;
        options.ExportStackedHeaders = true;
        var excelEngine = DataGrid.ExportToExcel(DataGrid.View, options);
        var workBook = excelEngine.Excel.Workbooks[0];
        var sheet = workBook.Worksheets[0];
        sheet.Name = "Summary";
        sheet.UsedRange.AutofitRows();
        sheet.UsedRange.AutofitColumns();

        sheet = workBook.Worksheets.Create("Questions");
        sheet.Move(0);
        var questions = new Client<QAQuestion>().Query(new Filter<QAQuestion>(x => x.Form.ID).IsEqualTo(Form!.ID));
        sheet.Range[1, 1].Text = Form?.Description ?? "";
        sheet.Range[1, 1, 1, 3].Merge();
        var i = 1;
        foreach (var row in questions.Rows)
            if (!row.Get<QAQuestion, QAAnswer>(x => x.Answer).Equals(QAAnswer.Comment))
            {
                sheet.Range[i + 2, 1].Text = string.Format("{0}.", i);
                sheet.Range[i + 2, 2].Text = string.Format("{0}", row.Get<QAQuestion, string>(x => x.Question));
                sheet.Range[i + 2, 3].Text = string.Format("[{0}]", row.Get<QAQuestion, string>(x => x.Code));
                i++;
            }

        sheet.UsedRange.AutofitRows();
        sheet.UsedRange.AutofitColumns();

        try
        {
            workBook.SaveAs(filename);

            var startInfo = new ProcessStartInfo(filename);
            startInfo.Verb = "open";
            startInfo.UseShellExecute = true;
            Process.Start(startInfo);
        }
        catch
        {
            MessageBox.Show(string.Format("Unable to Save/Launch [{0}]!\n\nIs the file already open?", filename));
        }
    }

    private void ManageFilters_Click()
    {
        var filters = Properties.Filters.GetValueOrDefault(ParentType!.Name) ?? new List<DFFilter>();
        var gridFilters = new CoreFilterDefinitions();
        gridFilters.AddRange(filters.Select(x => new CoreFilterDefinition { Name = x.Name, Filter = x.Filter }));

        var grid = new DynamicGridFilterEditor(gridFilters, FormType!);
        if (grid.ShowDialog() == true)
        {
            Properties.Filters[ParentType!.Name] = grid.Filters.Select(x => new DFFilter { Name = x.Name, Filter = x.Filter }).ToList();

            if (CustomFilterIndex != null)
            {
                Refresh();
            }
        }
    }

    private void ExecuteFilter(Tuple<int, string, List<MenuItem>> tag, bool isChecked)
    {
        var (index, filter, items) = tag;

        if (isChecked)
        {
            var i = 0;
            foreach (var item in items)
            {
                item.IsChecked = i == index;
                ++i;
            }
        }

        if (isChecked)
        {
            CustomFilter = Serialization.Deserialize(typeof(Filter<>).MakeGenericType(FormType!), filter) as IFilter;
            CustomFilterIndex = index;
            Refresh();
        }
        else if (index == CustomFilterIndex)
        {
            CustomFilter = null;
            CustomFilterIndex = null;
            Refresh();
        }
    }

    private void ExecuteModule_Click(CustomModule obj)
    {
        if (!string.IsNullOrWhiteSpace(obj.Script))
            try
            {
                Selection selection;
                if (obj.SelectedRecords && obj.AllRecords)
                    selection = RecordSelectionDialog.Execute();
                else if (obj.SelectedRecords)
                    selection = Selection.Selected;
                else if (obj.AllRecords)
                    selection = Selection.All;
                else
                    selection = Selection.None;

                var result = ScriptDocument.RunCustomModule(DataModel(selection), new Dictionary<string, object[]>(), obj.Script);
                if (result)
                    Refresh();
            }
            catch (CompileException c)
            {
                MessageBox.Show(c.Message);
            }
            catch (Exception err)
            {
                MessageBox.Show(CoreUtils.FormatException(err));
            }
        else
            MessageBox.Show("Unable to load " + obj.Name);
    }

    private void ManageModules_Click()
    {
        var section = SectionName;
        var dataModel = DataModel(Selection.Selected);

        var manager = new CustomModuleManager()
        {
            Section = section,
            DataModel = dataModel
        };
        manager.ShowDialog();
    }

    private void ToggleDateFilter(bool isChecked)
    {
        Properties.ShowDateFilter = isChecked;
        SetDateFilterVisibility(Properties.ShowDateFilter);
    }

    private void ToggleJobFilter(bool isChecked)
    {
        Properties.ShowJobFilter = isChecked;
        SetJobFilterVisibility(Properties.ShowJobFilter);
        Refresh();
    }

    #region Filtering

    private DateTime From { get; set; }
    private DateTime To { get; set; }
    private bool IsEntityForm { get; set; }
    private Type? ParentType { get; set; }
    private Type? FormType { get; set; }
    private DigitalForm? Form { get; set; }
    private IFilter? CustomFilter { get; set; }
    private int? CustomFilterIndex { get; set; }

    private readonly Dictionary<string, string> QuestionCodes = new();

    private static int WeekDay(DateTime date)
    {
        if (date.DayOfWeek == DayOfWeek.Sunday)
            return 7;
        return (int)date.DayOfWeek - 1;
    }

    private void SetupDateFilters()
    {
        switch (Properties.DateFilterType)
        {
            case DateFilterType.Today:
                From = DateTime.Today;
                To = DateTime.Today;
                break;
            case DateFilterType.Yesterday:
                From = DateTime.Today.AddDays(-1);
                To = DateTime.Today.AddDays(-1);
                break;
            case DateFilterType.Week:
                From = DateTime.Today.AddDays(-WeekDay(DateTime.Today));
                To = DateTime.Today;
                break;
            case DateFilterType.SevenDays:
                From = DateTime.Today.AddDays(-6);
                To = DateTime.Today;
                break;
            case DateFilterType.Month:
                From = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
                To = DateTime.Today;
                break;
            case DateFilterType.ThirtyDays:
                From = DateTime.Today.AddDays(-29);
                To = DateTime.Today;
                break;
            case DateFilterType.Year:
                From = new DateTime(DateTime.Today.Year, 1, 1);
                To = DateTime.Today;
                break;
            case DateFilterType.TwelveMonths:
                From = DateTime.Today.AddYears(-1).AddDays(1);
                To = DateTime.Today;
                break;
            case DateFilterType.Custom:
                From = Properties.FromDate;
                To = Properties.ToDate;
                break;
        }

        DateTypeBox.SelectedValue = Properties.DateFilterType;

        FromPicker.SelectedDate = From;
        ToPicker.SelectedDate = To;

        var enabledPicker = Properties.DateFilterType == DateFilterType.Custom;
        FromPicker.IsEnabled = enabledPicker;
        ToPicker.IsEnabled = enabledPicker;
    }

    private void SetupJobFilter()
    {
        JobBox.SelectedValue = Properties.JobID;
    }

    private void SetupFilters()
    {
        SetupDateFilters();
        SetupJobFilter();
        SetDateFilterVisibility(Properties.ShowDateFilter);
        SetJobFilterVisibility(Properties.ShowJobFilter);
    }

    #region Categories

    private static Dictionary<string, Tuple<Type, Type>>? FormInstanceTypes;

    private static readonly Dictionary<Type, List<Tuple<string, string>>> parentColumns = new()
    {
        { typeof(Kanban), new() { new("Parent.Number", "Task No") } },
        { typeof(JobITP), new() { new("Parent.Code", "Code") } },
        { typeof(Assignment), new() { new("Parent.Number", "Ass. No") } },
        { typeof(Employee), new() { new("Parent.Code", "Employee") } },
        { typeof(PurchaseOrderItem), new() { new("Parent.PONumber", "PO No") } }
    };

    private static Dictionary<Type, Tuple<string, string>> changeableLinks = new()
    {
        { typeof(JobForm), new( "Parent.ID", "Scope.ID") },
        { typeof(AssignmentForm), new( "JobLink.ID", "JobScope.ID") },
        { typeof(KanbanForm), new( "JobLink.ID", "") }
    };
    
    private static bool CategoryToType(string category, [NotNullWhen(true)] out Type? formType, [NotNullWhen(true)] out Type? parentType)
    {
        if (FormInstanceTypes == null)
        {
            var instancetypes = CoreUtils.Entities.Where(
                x => x.GetInterfaces().Contains(typeof(IDigitalFormInstance))
            ).Select(x =>
            {
                var inter = x.GetInterfaces()
                    .Where(x => x.IsGenericType && x.GetGenericTypeDefinition().Equals(typeof(IDigitalFormInstance<>)))
                    .FirstOrDefault();
                if (inter is not null)
                {
                    var link = inter.GenericTypeArguments[0];
                    var entityLinkDef = link.GetSuperclassDefinition(typeof(EntityLink<>));
                    if (entityLinkDef is not null)
                    {
                        var entityType = entityLinkDef.GenericTypeArguments[0];
                        return new Tuple<string, Type, Type>(entityType.Name, x, entityType);
                    }
                }

                return null;
            }).Where(x => x is not null);
            FormInstanceTypes =
                instancetypes.ToDictionary(x => x!.Item1, x => new Tuple<Type, Type>(x!.Item2, x!.Item3));
        }

        if (!FormInstanceTypes.TryGetValue(category, out var result))
        {
            formType = null;
            parentType = null;
            return false;
        }
        formType = result.Item1;
        parentType = result.Item2;
        return true;
    }

    private void SetCategory(string? category)
    {
        CustomFilter = null;
        CustomFilterIndex = null;
        if (category is null || !CategoryToType(category, out var formType, out var parentType))
        {
            IsEntityForm = false;
            ParentType = null;
            FormType = null;
            return;
        }
        IsEntityForm = formType.IsSubclassOfRawGeneric(typeof(EntityForm<,,>));
        ParentType = parentType;
        FormType = formType;
    }

    #endregion

    private string GetJobLink(string prefix, Type type, bool recursive)
    {
        var props = type.GetProperties().Where(x =>
            x.PropertyType.BaseType != null && x.PropertyType.BaseType.IsGenericType &&
            x.PropertyType.BaseType.GetGenericTypeDefinition() == typeof(EntityLink<>));
        foreach (var prop in props)
        {
            if (prop.PropertyType == typeof(JobLink))
                return (string.IsNullOrEmpty(prefix) ? "" : prefix + ".") + prop.Name;
            if (recursive)
            {
                var result = GetJobLink((string.IsNullOrEmpty(prefix) ? "" : prefix + ".") + prop.Name,
                    prop.PropertyType, recursive);
                if (!string.IsNullOrEmpty(result))
                    return result;
            }
        }

        return "";
    }
    
    private string GetJobScopeLink(string prefix, Type type, int recurselevel)
    {
        var props = type.GetProperties().Where(x =>
            x.PropertyType.BaseType != null && x.PropertyType.BaseType.IsGenericType &&
            x.PropertyType.BaseType.GetGenericTypeDefinition() == typeof(EntityLink<>));
        foreach (var prop in props)
        {
            if (prop.PropertyType == typeof(JobScopeLink))
                return (string.IsNullOrEmpty(prefix) ? "" : prefix + ".") + prop.Name;
            if (recurselevel > 0)
            {
                var result = GetJobScopeLink((string.IsNullOrEmpty(prefix) ? "" : prefix + ".") + prop.Name,
                    prop.PropertyType, recurselevel - 1);
                if (!string.IsNullOrEmpty(result))
                    return result;
            }
        }

        return "";
    }

    /// <summary>
    /// Find a link from the form type to an associated <see cref="Job"/>, allowing us to filter based on jobs.
    /// </summary>
    /// <returns>The property name of the <see cref="JobLink"/>.</returns>
    private string GetJobLink<T>(bool recursive) where T : IDigitalFormInstance
        => GetJobLink("", typeof(T), recursive);
    
    private string GetJobScopeLink<T>(int recurselevel) where T : IDigitalFormInstance
        => GetJobScopeLink("", typeof(T), recurselevel);

    private IKeyedQueryDef GetFormQuery<T>()
        where T : Entity, IRemotable, IPersistent, IDigitalFormInstance, new()
    {
        var sort = LookupFactory.DefineSort<T>();

        var jobLink = GetJobLink<T>(true);
        var jobScopeLink = GetJobScopeLink<T>(typeof(T) == typeof(JobForm) ? 0 : 1);

        var completedFilter = new Filter<T>(x => x.FormCompleted).IsGreaterThanOrEqualTo(From)
            .And(x => x.FormCompleted).IsLessThan(To.AddDays(1));
        if (Properties.ShowIncompleteForms)
        {
            completedFilter.Or(x => x.FormCompleted).IsEqualTo(FilterConstant.Null);
        }

        var filter = new Filter<T>(x => x.Form.ID).IsEqualTo(Form!.ID)
            .And(x => x.FormCancelled).IsEqualTo(DateTime.MinValue)
            .And(completedFilter);

        if (Properties.JobID != Guid.Empty && Properties.ShowJobFilter)
        {
            filter.And(jobLink + ".ID").IsEqualTo(Properties.JobID);
        }
        if (CustomFilter is not null)
        {
            filter.And(CustomFilter);
        }

        var columns = Columns.None<T>().Add(x => x.ID)
            .Add(x => x.Number)
            .Add(x => x.Description)
            .Add(x => x.CreatedBy)
            .Add(x => x.Created)
            .Add(x => x.Form.ID)
            .Add(x => x.FormData)
            .Add(x => x.FormStarted)
            .Add(x => x.FormCompleted)
            .Add(x => x.FormCompletedBy.UserID)
            .Add(x => x.Location.Timestamp)
            .Add(x => x.Location.Latitude)
            .Add(x => x.Location.Longitude);

        if (IsEntityForm)
            columns.Add(x => x.FormProcessed); //"Processed");

        var parentcols = LookupFactory.DefineColumns(ParentType!);
        foreach (var col in parentcols.ColumnNames())
            columns.Add("Parent." + col);
        if (parentColumns.TryGetValue(ParentType!, out var pColumns))
        {
            foreach (var (field, name) in pColumns)
                columns.Add(field);
        }

        if (!string.IsNullOrWhiteSpace(jobLink))
        {
            columns.Add(jobLink + ".ID");
            columns.Add(jobLink + ".JobNumber");
        }

        if (!string.IsNullOrWhiteSpace(jobScopeLink))
        {
            columns.Add(jobScopeLink + ".ID");
            columns.Add(jobScopeLink + ".Number");
        }

        return new KeyedQueryDef<T>(filter, columns, sort);
    }

    #endregion

    private void LoadDataIntoGrid(List<DigitalFormVariable> variables, List<QAQuestion> questions, CoreTable formData, List<string> additionalColumns, CoreTable? jobITPs)
    {
        var data = new DataTable();
        data.Columns.Add("ID", typeof(Guid));
        data.Columns.Add("Form_ID", typeof(Guid));
        data.Columns.Add("Parent_ID", typeof(Guid));
        data.Columns.Add("Location_Timestamp", typeof(DateTime));
        data.Columns.Add("Location_Latitude", typeof(double));
        data.Columns.Add("Location_Longitude", typeof(double));
        data.Columns.Add("FormData", typeof(string));
        
        data.Columns.Add("Number", typeof(string));

        if (parentColumns.TryGetValue(ParentType!, out var pColumns))
        {
            foreach (var (field, name) in pColumns)
                data.Columns.Add(field.Replace(".","_"), typeof(string));
        }
        
        var jobLink = GetJobLink("",FormType!,true);
        if (!string.IsNullOrWhiteSpace(jobLink))
        {
            if (!string.Equals(jobLink,"Parent"))
                data.Columns.Add(jobLink.Replace(".","_") + "_ID", typeof(Guid));
            data.Columns.Add(jobLink.Replace(".","_") + "_JobNumber", typeof(string));
        }

        var jobScopeLink = GetJobScopeLink("",FormType!,FormType == typeof(JobForm) ? 0 : 1);
        if (!string.IsNullOrWhiteSpace(jobScopeLink))
        {
            data.Columns.Add(jobScopeLink.Replace(".","_") + "_ID", typeof(Guid));
            data.Columns.Add(jobScopeLink.Replace(".","_") + "_Number", typeof(string));
        }
        

        data.Columns.Add("Description", typeof(string));
        
        data.Columns.Add("Parent_Description", typeof(string));
        data.Columns.Add("Created", typeof(DateTime));
        data.Columns.Add("Created By", typeof(string));
        data.Columns.Add("Completed", typeof(DateTime));
        data.Columns.Add("Completed By", typeof(string));
        if (IsEntityForm)
            data.Columns.Add("Processed", typeof(bool));

        if (variables.Any())
        {
            foreach (var variable in variables)
            {
                var code = variable.Code.Replace("/", " ");
                QuestionCodes[code] = Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(code.ToLower());
                try
                {
                    data.Columns.Add(code, typeof(string));
                }
                catch (DuplicateNameException)
                {
                    MessageBox.Show($"Error: duplicate variable code {code}");
                }
            }
        }
        else if (questions.Any())
        {
            Questions = questions;
            Progress.SetMessage("Loading Checks");
            QAGrid.Clear();
            QAGrid.LoadChecks(Form!.Description, Questions, new Dictionary<Guid, object>());
            QAGrid.CollapseMargins();

            var i = 1;
            foreach (var question in Questions)
            {
                var id = question.ID.ToString();
                if (!question.Answer.Equals(QAAnswer.Comment))
                {
                    data.Columns.Add(id, typeof(string));
                    var code = question.Code;
                    QuestionCodes[id] = string.IsNullOrEmpty(code) ? string.Format("{0}.", i) : code;
                    i++;
                }
            }
        }

        foreach (var row in formData.Rows)
        {
            var form = (row.ToObject(FormType!) as IDigitalFormInstance)!;
            if (true) //(!string.IsNullOrWhiteSpace(form.FormData))
            {
                var dataRow = data.NewRow();

                dataRow["ID"] = form.ID;
                dataRow["Form_ID"] = form.Form.ID;
                dataRow["Parent_ID"] = form.ParentID();
                dataRow["Location_Timestamp"] = form.Location.Timestamp;
                dataRow["Location_Latitude"] = form.Location.Latitude;
                dataRow["Location_Longitude"] = form.Location.Longitude;
                dataRow["FormData"] = form.FormData;
                dataRow["Number"] = form.Number;
                dataRow["Description"] = form.Description;
                
                var desc = new List<string>();
                foreach (var col in additionalColumns)
                {
                    var val = row[col];
                    if (val != null && val is not Guid)
                        desc.Add(val.ToString() ?? "");
                }

                dataRow["Parent_Description"] = string.Join(" : ", desc);

                dataRow["Created"] = (form as Entity)!.Created.IsEmpty()
                    ? form.FormStarted
                    : (form as Entity)!.Created;
                dataRow["Created By"] = (form as Entity)!.CreatedBy;
                dataRow["Completed"] = form.FormCompleted;
                dataRow["Completed By"] = form.FormCompletedBy.UserID;

                if (IsEntityForm)
                    dataRow["Processed"] = form.FormProcessed > DateTime.MinValue;
                
                
                // if (ParentType == typeof(JobITP))
                // {
                //     var jobITP = jobITPs!.Rows.FirstOrDefault(x => x.Get<JobITP, Guid>(x => x.ID) == form.ParentID());
                //     if (jobITP is not null)
                //     {
                //         var jobID = jobITP.Get<JobITP, Guid>(x => x.Job.ID);
                //         dataRow["Job No"] = Jobs.Where(x => x.ID == jobID).FirstOrDefault()?.JobNumber;
                //     }
                // }

                if (pColumns != null)
                {
                    foreach (var (field, name) in pColumns)
                        dataRow[field.Replace(".","_")] = $"{row[field]}";
                }

                if (!string.IsNullOrWhiteSpace(jobLink))
                {
                    dataRow[jobLink.Replace(".","_") + "_ID"] = row[jobLink + ".ID"];
                    dataRow[jobLink.Replace(".","_") + "_JobNumber"] = row[jobLink + ".JobNumber"]?.ToString();
                }

                if (!string.IsNullOrWhiteSpace(jobScopeLink))
                {
                    dataRow[jobScopeLink.Replace(".","_") + "_ID"] = row[jobScopeLink + ".ID"];
                    dataRow[jobScopeLink.Replace(".","_") + "_Number"] = row[jobScopeLink + ".Number"]?.ToString();
                }

                var bHasData = false;
                if (variables.Any())
                {
                    var dict = Serialization.Deserialize<Dictionary<string, object?>>(form.FormData);
                    if (dict is not null)
                    {
                        var storage = new DFLoadStorage(dict, null);
                        foreach (var variable in variables)
                        {
                            var value = variable.Deserialize(storage.GetEntry(variable.Code));
                            var format = variable.FormatValue(value);
                            var sKey = variable.Code.Replace("/", " ");
                            if (data.Columns.Contains(sKey))
                            {
                                dataRow[sKey] = format;
                                bHasData = true;
                            }
                        }
                    }
                }
                else
                {
                    var dict = Serialization.Deserialize<Dictionary<Guid, object>>(form.FormData);
                    if (dict is not null)
                        foreach (var key in dict.Keys)
                            if (data.Columns.Contains(key.ToString()))
                            {
                                dataRow[key.ToString()] = dict[key];
                                bHasData = true;
                            }
                }


                //if (bHasData)
                data.Rows.Add(dataRow);
            }
        }
        DataGrid.ItemsSource = data;

        IsQAForm = !variables.Any() && questions.Any();
        QAGrid.Visibility = IsQAForm ? Visibility.Visible : Visibility.Collapsed;
        DataGrid.Visibility = Visibility.Visible;
    }

    private void RefreshData<TForm>()
        where TForm : Entity, IRemotable, IPersistent, IDigitalFormInstance, new()
    {
        var formQuery = GetFormQuery<TForm>();

        var queries = new List<IKeyedQueryDef>()
            {
                new KeyedQueryDef<QAQuestion>(new Filter<QAQuestion>(x => x.Form.ID).IsEqualTo(Form!.ID)),
                new KeyedQueryDef<DigitalFormVariable>(
                    new Filter<DigitalFormVariable>(x => x.Form.ID).IsEqualTo(Form.ID),
                    null,
                    new SortOrder<DigitalFormVariable>(x => x.Sequence)),
                formQuery
            };
        if (ParentType == typeof(JobITP))
        {
            queries.Add(new KeyedQueryDef<JobITP>(
                new Filter<JobITP>(x => x.ID).InQuery((formQuery.Filter as Filter<JobITPForm>)!, x => x.Parent.ID),
                Columns.None<JobITP>().Add(x => x.ID, x => x.Job.JobNumber)));
        }

        var results = Client.QueryMultiple(queries);

        var questions = results.Get<QAQuestion>().ToObjects<QAQuestion>().ToList();
        var variables = results.Get<DigitalFormVariable>().ToObjects<DigitalFormVariable>().ToList();
        var formData = results.Get(formQuery.Key);

        LoadDataIntoGrid(
            variables, questions,
            formData,
            formQuery.Columns!.ColumnNames().Where(x => x.StartsWith("Parent.")).ToList(),
            ParentType == typeof(JobITP) ? results.Get<JobITP>() : null);
    }

    public void Refresh()
    {
        if (!IsSetup) return;

        Questions.Clear();
        QAGrid.Clear();
        QAGrid.LoadChecks("", Array.Empty<QAQuestion>(), new Dictionary<Guid, object>());
        DataGrid.ItemsSource = null;

        if (ParentType is null || FormType is null || Form is null || Form.ID == Guid.Empty)
        {
            QAGrid.Visibility = Visibility.Collapsed;
            DataGrid.Visibility = Visibility.Collapsed;
            return;
        }

        var refreshMethod = typeof(DigitalFormsDashboard).GetMethod(nameof(RefreshData), BindingFlags.Instance | BindingFlags.NonPublic)!.MakeGenericMethod(FormType);
        refreshMethod.Invoke(this, Array.Empty<object?>());
    }

    public void Shutdown(CancelEventArgs? cancel)
    {
    }

    #region DataGrid Configuration

    private class RowStyleSelector : StyleSelector
    {
        private Style NormalStyle;

        private Style IncompleteStyle;

        public RowStyleSelector()
        {
            NormalStyle = new Style();
            NormalStyle.Setters.Add(new Setter(VirtualizingCellsControl.BackgroundProperty, new SolidColorBrush(Colors.White)));

            IncompleteStyle = new Style();
            IncompleteStyle.Setters.Add(new Setter(VirtualizingCellsControl.BackgroundProperty, new SolidColorBrush(Colors.LightSalmon)));
        }

        public override Style SelectStyle(object item, DependencyObject container)
        {
            var row = (item as DataRowBase)?.RowData as DataRowView;
            if (row is null) return NormalStyle;

            return (DateTime)row["Completed"] == DateTime.MinValue
                ? IncompleteStyle
                : NormalStyle;
        }
    }

    private void DataGrid_AutoGeneratingColumn(object sender, Syncfusion.UI.Xaml.Grid.AutoGeneratingColumnArgs e)
    {

        var jobLink = GetJobLink("", FormType, true) ?? "";
        if (!string.IsNullOrWhiteSpace(jobLink))
            jobLink = $"{jobLink.Replace(".","_")}_JobNumber";
        
        var jobScopeLink = GetJobScopeLink("", FormType, FormType == typeof(JobForm) ? 0 : 1) ?? "";
        if (!string.IsNullOrWhiteSpace(jobScopeLink))
                jobScopeLink = $"{jobScopeLink.Replace(".","_")}_Number";
        
        e.Column.TextAlignment = TextAlignment.Center;
        e.Column.HorizontalHeaderContentAlignment = HorizontalAlignment.Center;
        e.Column.ColumnSizer = GridLengthUnitType.None;
        e.Column.ImmediateUpdateColumnFilter = true;
        e.Column.FilterRowCondition = FilterRowCondition.Contains;
        e.Column.FilterRowOptionsVisibility = Visibility.Collapsed;

        var value = (e.Column.ValueBinding as Binding)!;
        if (value.Path.Path.Equals("ID") || value.Path.Path.Equals("Form_ID") || value.Path.Path.Equals("Parent_ID") ||
            value.Path.Path.Equals("FormData") || value.Path.Path.Equals("Location_Latitude") || value.Path.Path.Equals("Location_Longitude"))
        {
            e.Cancel = true;
        }
        else if (value.Path.Path.Equals("Number"))
        {
            e.Column.Width = 80;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
        }
        else if (value.Path.Path.Equals("Description"))
        {
            e.Column.Width = 250;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            e.Column.TextAlignment = TextAlignment.Left;
            e.Column.HorizontalHeaderContentAlignment = HorizontalAlignment.Left;
        }
        else if (value.Path.Path.Equals("Location_Timestamp"))
        {
            e.Column = new GridImageColumn();
            e.Column.Width = DataGrid.RowHeight;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            e.Column.HeaderText = "";
            e.Column.Padding = new Thickness(4);
            e.Column.ValueBinding = new Binding
            {
                Path = new PropertyPath(value.Path.Path),
                Converter = new MileStoneImageConverter()
            };
            e.Column.MappingName = "Location_Timestamp";
        }
        else if (ParentType is not null && parentColumns.TryGetValue(ParentType, out var pColumns) && pColumns.Any(x => x.Item1.Replace(".","_").Equals(value.Path.Path)))
        {
            e.Column.ColumnSizer = GridLengthUnitType.Auto;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            e.Column.HeaderText = pColumns.FirstOrDefault(x => x.Item1.Replace(".","_").Equals(value.Path.Path))?.Item2 ?? "";
        }
        else if (value.Path.Path.Equals(jobLink))
        {
            e.Column.Width = 60;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            e.Column.HeaderText = "Job No";
        }
        else if (value.Path.Path.Equals(jobScopeLink))
        {
            e.Column.Width = 50;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            e.Column.HeaderText = "Scope";
        }
        else if (value.Path.Path.Equals("Parent_Description"))
        {
            e.Column.HeaderText = Categories.FirstOrDefault(x => x.Item2 == FormType)?.Item3 ?? "Parent";
            e.Column.TextAlignment = TextAlignment.Left;
            e.Column.HorizontalHeaderContentAlignment = HorizontalAlignment.Left;
            e.Column.Width = 250;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
        }
        else if (value.Path.Path.Equals("Completed"))
        {
            e.Column.Width = 100;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            (e.Column as GridDateTimeColumn)!.DisplayBinding = new Binding {
                Path = new PropertyPath(value.Path.Path),
                Converter = new DateTimeToStringConverter("dd MMM yy hh:mm")
            };
        }
        else if (value.Path.Path.Equals("Completed By"))
        {
            e.Column.Width = 100;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
        }
        else if (value.Path.Path.Equals("Processed"))
        {
            e.Column.Width = 100;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
        }
        else if (value.Path.Path.Equals("Created By"))
        {
            e.Column.Width = 100;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
        }
        else if (value.Path.Path.Equals("Created"))
        {
            e.Column.Width = 100;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            (e.Column as GridDateTimeColumn)!.DisplayBinding = new Binding {
                Path = new PropertyPath(value.Path.Path),
                Converter = new DateTimeToStringConverter("dd MMM yy hh:mm")
            };
        }
        else if (QuestionCodes.TryGetValue(e.Column.MappingName, out var header))
        {
            e.Column.Width = 100;
            e.Column.HeaderStyle = Application.Current.Resources["TemplateHeaderStyle"] as Style;
            e.Column.HeaderText = header;
        }
        else
            e.Cancel = true;
    }

    private Entity? GetEntityForm<T>(Guid id) where T : Entity, IDigitalFormInstance, IRemotable, IPersistent, new()
    {
        var columns = DynamicFormEditWindow.FormColumns<T>();

        return new Client<T>().Query(
            new Filter<T>(x => x.ID).IsEqualTo(id),
            columns).Rows.FirstOrDefault()?.ToObject<T>();
    }

    private void DataGrid_CellDoubleTapped(object sender, Syncfusion.UI.Xaml.Grid.GridCellDoubleTappedEventArgs e)
    {
        if (e.RowColumnIndex.RowIndex < 2)
            return;
        var rowOffset = -2;

        //var table = (DataGrid.ItemsSource as DataTable)!;
        var row = (e.Record as DataRowView)?.Row;
        if (row == null)
        {
            MessageBox.Show($"Unexpected Record type ({e.Record?.GetType().EntityName() ?? "NULL"}");
            return;
        }
        var formid = (Guid)row["Form_ID"];
        var formdata = (string)row["FormData"];
        var id = (Guid)row["ID"];

        if (FormType is null) return;

        if (IsQAForm)
        {
            var values = new Dictionary<Guid, object>();
            var formData = Serialization.Deserialize<Dictionary<string, object>>(formdata);
            if (formData is not null)
            {
                foreach (var (idStr, value) in formData)
                {
                    if (Guid.TryParse(idStr, out var codeID))
                    {
                        values[codeID] = value;
                    }
                }
            }

            QAGrid.Clear();
            QAGrid.LoadChecks(Form!.Description, Questions, values);
            QAGrid.CollapseMargins();
            return;
        }

        var entityForm = typeof(DigitalFormsDashboard)
            .GetMethod(nameof(GetEntityForm), BindingFlags.NonPublic | BindingFlags.Instance)!
            .MakeGenericMethod(FormType)
            .Invoke(this, new object[] { id }) as IDigitalFormInstance;
        if (entityForm is not null)
        {
            if (DynamicFormEditWindow.EditDigitalForm(entityForm, out var dataModel))
            {
                dataModel.Update(null);
                /*typeof(QADashboard)
                    .GetMethod(nameof(SaveEntityForm), System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance)!
                    .MakeGenericMethod(formType)
                    .Invoke(this, new object[] { entityForm });*/
                Refresh();
            }
        }
    }

    private void DataGrid_CellTapped(object sender, Syncfusion.UI.Xaml.Grid.GridCellTappedEventArgs e)
    {
        if (e.RowColumnIndex.ColumnIndex == 0)
        {
            var timestamp = (DateTime)(e.Record as DataRowView)!.Row["Location_Timestamp"];
            var latitude = (double)(e.Record as DataRowView)!.Row["Location_Latitude"];
            var longitude = (double)(e.Record as DataRowView)!.Row["Location_Longitude"];

            var form = new MapForm(latitude, longitude, timestamp);
            form.ShowDialog();
        }
    }

    #endregion

    private void DataGrid_SelectionChanged(object? sender, GridSelectionChangedEventArgs e)
    {
        var linkcolumn = GetJobLink("", FormType, true);
        if (!string.IsNullOrWhiteSpace(linkcolumn) && _jobScopeAction != null)
        {
            linkcolumn = $"{linkcolumn.Replace(".","_")}_ID";
            var jobids = DataGrid.SelectedItems.Select(x => (x as DataRowView)!.Row[linkcolumn]).Distinct().ToArray();
            _jobScopeAction.IsEnabled = jobids.Length == 1;
        }
    }
}