prs/prs.desktop/Panels/Jobs/Employees/JobEmployeeGrid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Media.Imaging;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.WPF;
using InABox.Wpf;
using System.Threading;

namespace PRSDesktop
{
    internal class JobEmployeeGrid : DynamicDataGrid<JobEmployee>, IMasterDetailControl<Job,JobEmployee>
    {
        private CoreTable EmployeeQualifications;
        private CoreTable JobQualifications;
        private readonly Dictionary<Guid, Tuple<List<string>, List<string>>> warnings = new();
        
        public Job? Master { get; set; }

        public Filter<JobEmployee> MasterDetailFilter => (Master?.ID ?? Guid.Empty) != Guid.Empty
            ? new Filter<JobEmployee>(x => x.JobLink.ID).IsEqualTo(Master)
            : new Filter<JobEmployee>().None();
        
        protected override void Init()
        {
            base.Init();
            HiddenColumns.Add(x => x.EmployeeLink.ID);
            HiddenColumns.Add(x => x.JobLink.ID);
            ActionColumns.Add(new DynamicImageColumn(QualificationImage) { Position = DynamicActionColumnPosition.Start, ToolTip = QualificationIssues});
            AddButton("Edit Employee", PRSDesktop.Resources.employee.AsBitmapImage(), EditEmployee);
        }



        protected override void DoReconfigure(DynamicGridOptions options)
        {
            base.DoReconfigure(options);
            options.MultiSelect = true;
            options.SelectColumns = true;
        }
        
        private bool EditEmployee(Button arg1, CoreRow[] rows)
        {
            if (rows?.Length == 1)
            {
                var emps = new Client<Employee>().Query(
                    new Filter<Employee>(x => x.ID).IsEqualTo(rows.First().Get<JobEmployee, Guid>(x => x.EmployeeLink.ID)));
                if (emps.Rows.Count == 1)
                {
                    var emp = emps.Rows.First().ToObject<Employee>();
                    var grid = new EmployeeGrid();
                    return grid.EditItems(new[] { emp });
                }

                MessageBox.Show("Unable to Load Employee Card");
            }
            else
            {
                MessageBox.Show("Please select a single employee to edit!");
            }

            return false;
        }

        private BitmapImage QualificationImage(CoreRow arg)
        {
            BitmapImage result = null;

            CheckEmployeeQualifications();
            CheckJobQualifications();

            var empid = arg != null ? arg.Get<JobEmployee, Guid>(x => x.EmployeeLink.ID) : Guid.Empty;
            var erows = EmployeeQualifications.Rows.Where(r => r.Get<EmployeeQualification, Guid>(c => c.Employee.ID).Equals(empid));

            var CheckedQualifications = new List<Guid>();

            // Check Job Requirements
            var jrows = JobQualifications.Rows.Where(r => r.Get<JobQualification, bool>(x => x.Required).Equals(true));
            foreach (var jrow in jrows)
            {
                var qualificationid = jrow.Get<JobQualification, Guid>(x => x.Qualification.ID);
                var erow = erows.FirstOrDefault(r =>
                    r.Get<EmployeeQualification, Guid>(c => c.Employee.ID).Equals(empid) &&
                    r.Get<EmployeeQualification, Guid>(c => c.Qualification.ID).Equals(qualificationid));
                if (erow == null)
                {
                    Warn(empid,
                        string.Format("{0} is missing",
                            jrow.Get<JobQualification, string>(c => c.Qualification.Description)
                        ),
                        ""
                    );
                    result = PRSDesktop.Resources.disabled.AsBitmapImage();
                }
                else
                {
                    var expiry = erow.Get<EmployeeQualification, DateTime>(c => c.Expiry);
                    var permanent = erow.Get<EmployeeQualification, QualificationRenewal>(c => c.Qualification.Renewal) == QualificationRenewal.Permanent;
                    if (!permanent && expiry < DateTime.Today)
                    {
                        Warn(empid,
                            string.Format("{0} expired on {1: dd MMM yy}",
                                jrow.Get<JobQualification, string>(c => c.Qualification.Description),
                                expiry
                            ),
                            ""
                        );
                        result = PRSDesktop.Resources.disabled.AsBitmapImage();
                    }
                    else if (!permanent && expiry < DateTime.MaxValue.Date)
                    {
                        Warn(empid,
                            string.Format("{0} is valid until {1:dd MMM yy}",
                                jrow.Get<JobQualification, string>(c => c.Qualification.Description),
                                erow.Get<EmployeeQualification, DateTime>(c => c.Expiry)
                            ),
                            ""
                        );
                    }
                    else
                    {
                        Warn(empid,
                            string.Format("{0} is valid",
                                jrow.Get<JobQualification, string>(c => c.Qualification.Description)
                            ),
                            ""
                        );
                    }
                }

                CheckedQualifications.Add(erow.Get<EmployeeQualification, Guid>(x => x.ID));
            }

            // Check Qualification Expiry
            foreach (var erow in erows)
                if (!CheckedQualifications.Contains(erow.Get<EmployeeQualification, Guid>(x => x.ID)))
                {
                    var expiry = erow.Get<EmployeeQualification, DateTime>(x => x.Expiry);
                    var permanent = erow.Get<EmployeeQualification, QualificationRenewal>(c => c.Qualification.Renewal) == QualificationRenewal.Permanent;
                    if (!permanent && expiry < DateTime.Today)
                    {
                        Warn(empid,
                            "",
                            string.Format("{0} has expired",
                                erow.Get<EmployeeQualification, string>(c => c.Qualification.Description)
                            )
                        );
                        if (result == null)
                            result = PRSDesktop.Resources.warning.AsBitmapImage();
                    }
                    else if (!permanent && expiry < DateTime.MaxValue.Date)
                    {
                        Warn(empid,
                            "",
                            string.Format("{0} is valid until {1:dd MMM yy}",
                                erow.Get<JobQualification, string>(c => c.Qualification.Description),
                                expiry
                            )
                        );
                    }
                    else
                    {
                        Warn(empid,
                            "",
                            string.Format("{0} is valid",
                                erow.Get<JobQualification, string>(c => c.Qualification.Description)
                            )
                        );
                    }
                }

            if (result == null && erows.Any())
                result = PRSDesktop.Resources.tick.AsBitmapImage();
            return result;
        }
        
        private FrameworkElement? QualificationIssues(DynamicActionColumn column, CoreRow? row)
        {
            var empid = row != null ? row.Get<JobEmployee, Guid>(x => x.EmployeeLink.ID) : Guid.Empty;
            if (warnings.ContainsKey(empid))
            {
                var summary = new List<string>();

                if (warnings[empid].Item1.Any())
                {
                    summary.Add("Required Qualifications:");
                    foreach (var warning in warnings[empid].Item1)
                        summary.Add("- " + warning);
                    summary.Add("");
                }

                if (warnings[empid].Item2.Any())
                {
                    summary.Add("Other Qualifications:");
                    foreach (var warning in warnings[empid].Item2)
                        summary.Add("- " + warning);
                }

                if (summary.Any())
                    return column.TextToolTip(string.Join("\n", summary));
            }

            return null;

        }

        private void CheckJobQualifications()
        {
            if (JobQualifications == null)
            {
                if ((Master?.ID ?? Guid.Empty) != Guid.Empty)
                {
                    JobQualifications = new Client<JobQualification>().Query(new Filter<JobQualification>(x => x.Job.ID).IsEqualTo(Master.ID));
                }
                else
                {
                    JobQualifications = new CoreTable();
                    JobQualifications.LoadColumns(typeof(JobQualification));
                }
            }
        }

        private void CheckEmployeeQualifications()
        {
            if (EmployeeQualifications == null)
            {
                var emps = new List<Guid>();
                foreach (var row in Data.Rows)
                {
                    var emp = row.Get<JobEmployee, Guid>(x => x.EmployeeLink.ID);
                    if (!emps.Contains(emp))
                        emps.Add(emp);
                }

                if (emps.Any())
                {
                    EmployeeQualifications =
                        new Client<EmployeeQualification>().Query(new Filter<EmployeeQualification>(x => x.Employee.ID).InList(emps.ToArray()));
                }
                else
                {
                    EmployeeQualifications = new CoreTable();
                    EmployeeQualifications.LoadColumns(typeof(EmployeeQualification));
                }
            }
        }

        private bool QualificationsCheck(CoreRow arg)
        {
            
            return false;
        }

        private void Warn(Guid empid, string required, string optional)
        {
            if (!warnings.ContainsKey(empid))
                warnings[empid] = new Tuple<List<string>, List<string>>(new List<string>(), new List<string>());
            if (!string.IsNullOrWhiteSpace(required))
                warnings[empid].Item1.Add(required);
            if (!string.IsNullOrWhiteSpace(optional))
                warnings[empid].Item2.Add(optional);
        }

        protected override void Reload(
        	Filters<JobEmployee> criteria, Columns<JobEmployee> columns, ref SortOrder<JobEmployee>? sort,
        	CancellationToken token, Action<CoreTable?, Exception?> action)
        {
            EmployeeQualifications = null;
            JobQualifications = null;
            warnings.Clear();

            criteria.Add(
                MasterDetailFilter
                    .And(new Filter<JobEmployee>(x => x.EmployeeLink.StartDate).IsEqualTo(DateTime.MinValue)
                        .Or(x => x.EmployeeLink.StartDate).IsLessThanOrEqualTo(DateTime.Today))
                    .And(new Filter<JobEmployee>(x => x.EmployeeLink.FinishDate).IsEqualTo(DateTime.MinValue)
                        .Or(x => x.EmployeeLink.FinishDate).IsGreaterThanOrEqualTo(DateTime.Today))
            );
            base.Reload(criteria, columns, ref sort, token, action);
        }

        protected override bool CanCreateItems()
        {
            return base.CanCreateItems() &&  (Master?.ID ?? Guid.Empty) != Guid.Empty;
        }

        protected override void DoAdd(bool OpenEditorOnDirectEdit = false)
        {
            var ids = ExtractValues(x => x.EmployeeLink.ID, Selection.All).ToArray();
            var msd = new MultiSelectDialog<Employee>(
                new Filter<Employee>(x => x.ID).NotInList(ids), 
                Columns.None<Employee>().Add(x=>x.ID), 
                true
            );
            if (msd.ShowDialog() == true)
            {
                List<JobEmployee> updates = new List<JobEmployee>();
                foreach (var row in msd.Data().Rows)
                {
                    var jobemp = new JobEmployee();
                    jobemp.JobLink.ID = Master?.ID ?? Guid.Empty;
                    jobemp.JobLink.Synchronise(Master ?? new Job());
                    jobemp.EmployeeLink.ID = row.Get<Employee, Guid>(x => x.ID);
                    updates.Add(jobemp);
                }

                using (new WaitCursor())
                {
                    new Client<JobEmployee>().Save(updates, "Added By Job Employee Screen");
                    Refresh(false,true);
                }
            }
        }
    }
}