prs/prs.desktop/Grids/EmployeeQualificationGrid.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using Comal.Classes;
using InABox.Core;
using InABox.Clients;
using InABox.DynamicGrid;
using Microsoft.Win32;
using SaveFileDialog = Microsoft.Win32.SaveFileDialog;

namespace PRSDesktop;

public class QualificationManyToManyGrid<T> : DynamicManyToManyGrid<EmployeeQualification, T> where T : Entity, new()
{
    public QualificationManyToManyGrid()
    {
        HiddenColumns.Add(x => x.Qualification.Renewal);
        HiddenColumns.Add(x => x.Expiry);
    }
    protected override void DoReconfigure(FluentList<DynamicGridOption> options)
    {
        base.DoReconfigure(options);
        options.AddRange(DynamicGridOption.RecordCount, DynamicGridOption.SelectColumns, DynamicGridOption.MultiSelect);
    }

    protected override void DoReconfigureEditors(DynamicEditorGrid grid, EmployeeQualification[] items)
    {
        base.DoReconfigureEditors(grid, items);
        var renewal = grid.GetPropertyValue("Qualification.Renewal");
        var expiry = grid.FindEditor("Expiry");
        expiry.SetEnabled(true);// renewal.Equals(QualificationRenewal.Manual));
    }

    protected override Dictionary<string, object?> EditorValueChanged(IDynamicEditorForm editor, EmployeeQualification[] items, string name,
        object value)
    {
        var result = base.EditorValueChanged(editor, items, name, value);
        if (name.Equals("Qualification.Renewal"))
            foreach (var item in items)
            {
                var expiry = item.CalculateExpiry(item.Qualified, (QualificationRenewal)value, item.Qualification.Period, item.Expiry);
                if (expiry != item.Expiry)
                {
                    item.Expiry = expiry;
                    result["Expiry"] = expiry;
                }
            }

        return result;
    }

}

public class QualificationEmployeeGrid : QualificationManyToManyGrid<Qualification>
{
}

public class EmployeeQualificationGrid : QualificationManyToManyGrid<Employee>
{

    private readonly Button LoadQualificationTemplate;
    private readonly Button SaveQualificationTemplate;


    public EmployeeQualificationGrid()
    {
        LoadQualificationTemplate = AddButton("Load Template", null, "Load Template", LoadQualificationTemplate_Click);
        LoadQualificationTemplate.Visibility = Visibility.Collapsed;

        SaveQualificationTemplate = AddButton("Save Template", null, "Save Template", SaveQualificationTemplate_Click);
        SaveQualificationTemplate.Visibility = Visibility.Collapsed;

        HiddenColumns.Add(x => x.Qualification.ID);
    }

    private bool LoadQualificationTemplate_Click(Button sender, CoreRow[] selectedRows)
    {
        var dialog = new MultiSelectDialog<EmployeeQualificationTemplate>(null, null, false);

        if (dialog.ShowDialog())
        {
            var templateID = dialog.IDs().First();

            var qualificationIds = Client.Query(
                new Filter<EmployeeQualificationTemplateItem>(x => x.Template.ID).IsEqualTo(templateID),
                new Columns<EmployeeQualificationTemplateItem>(x => x.Qualification.ID))
                .ExtractValues<EmployeeQualificationTemplateItem, Guid>(x => x.Qualification.ID);

            var qualifications = new Client<Qualification>().Load(new Filter<Qualification>(x => x.ID).InList(qualificationIds));
            var guids = CurrentGuids();
            var newItems = new List<EmployeeQualification>();
            foreach (var qualification in qualifications)
            {
                if (!guids.Contains(qualification.ID))
                {
                    var newQualification = CreateItem();

                    newQualification.Qualification.ID = qualification.ID;
                    newQualification.Qualification.Synchronise(qualification);

                    newItems.Add(newQualification);
                }
            }
            SaveItems(newItems.ToArray());

            return true;
        }

        return false;

        /*var dlg = new OpenFileDialog();
        dlg.Filter = "JSON files (*.json)|*.json|All files (*.*)|*.*";
        if(dlg.ShowDialog() == true)
        {
            Guid[] list;
            using (var stream = dlg.OpenFile())
            {
                list = Serialization.Deserialize<Guid[]>(stream);
            }
            var qualifications = new Client<Qualification>().Load(
                new Filter<Qualification>(x => x.ID).InList(list));

            var guids = CurrentGuids();
            var newItems = new List<EmployeeQualification>();
            foreach (var qualification in qualifications)
            {
                if (!guids.Contains(qualification.ID))
                {
                    var newQualification = CreateItem();

                    newQualification.Qualification.ID = qualification.ID;
                    newQualification.Qualification.Synchronise(qualification);

                    newItems.Add(newQualification);
                }
            }
            SaveItems(newItems.ToArray());

            return true;
        }
        return false;*/
    }

    private bool SaveQualificationTemplate_Click(Button sender, CoreRow[] selectedRows)
    {
        var dialog = new MultiSelectDialog<EmployeeQualificationTemplate>(null, null, false);

        if (dialog.ShowDialog())
        {
            var templateID = dialog.IDs().First();

            var templateItems = Client.Query(
                new Filter<EmployeeQualificationTemplateItem>(x => x.Template.ID).IsEqualTo(templateID),
                new Columns<EmployeeQualificationTemplateItem>(x => x.ID)).Rows.Select(x => x.ToObject<EmployeeQualificationTemplateItem>()).ToArray();

            Client.Delete(templateItems, "Deleted because re-save of template");

            List<EmployeeQualificationTemplateItem> newItems = new();
            foreach(var item in Data.Rows)
            {
                var newItem = new EmployeeQualificationTemplateItem();
                newItem.Template.ID = templateID;
                newItem.Qualification.ID = item.Get<EmployeeQualification, Guid>(x => x.Qualification.ID);
                newItems.Add(newItem);
            }

            Client.Save(newItems, "Save to template");
        }

        return false;
        /*
        var list = new List<Guid>();

        foreach(var item in Data.Rows)
        {
            var qualification = item.ToObject<EmployeeQualification>();
            list.Add(qualification.Qualification.ID);
        }

        var dlg = new SaveFileDialog();
        dlg.Filter = "JSON files (*.json)|*.json|All files (*.*)|*.*";
        dlg.AddExtension = true;
        if(dlg.ShowDialog() == true)
        {
            using(var stream = dlg.OpenFile())
            {
                Serialization.Serialize(list, stream);
            }
        }
        return false;
        */
    }

    protected override void DoAdd(bool OpenEditorOnDirectEdit = false)
    {
        var filter = GetFilter() as Filter<Qualification>;

        var dlg = new MultiSelectDialog<Qualification>(filter, null, true);
        if (dlg.ShowDialog())
        {
            var guids = CurrentGuids();
            var items = dlg.Items(null);
            var single = items.Length == 1;

            if (single)
            {
                var item = items.First();
                var newItem = CreateItem();
                newItem.Qualification.ID = item.ID;
                newItem.Qualification.Synchronise(item);

                if (EditItems(new EmployeeQualification[] { newItem }))
                {
                    Refresh(false, true);
                }
            }
            else
            {
                foreach (var item in items)
                {
                    if (!guids.Contains(item.ID))
                    {
                        var newItem = CreateItem();
                        newItem.Qualification.ID = item.ID;
                        newItem.Qualification.Synchronise(item);
                        SaveItem(newItem);
                    }
                }
                Refresh(false, true);
            }
        }
    }

}