prs/prs.desktop/Panels/Jobs/JobRequisitionGrid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using com.healthmarketscience.jackcess;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.WPF;
using NPOI.SS.Formula.Functions;

namespace PRSDesktop
{
    internal class JobRequisitionGrid : DynamicDataGrid<JobRequisition>, IJobControl
    {

        private readonly Button _approve;
        private readonly Button _createtask;

        public JobRequisitionGrid()
        {
            Options.AddRange(
                DynamicGridOption.SelectColumns,
                DynamicGridOption.FilterRows
                );
            HiddenColumns.Add(x => x.ID);
            HiddenColumns.Add(x => x.Job.ID);
            HiddenColumns.Add(x => x.Approved);

            if (Security.IsAllowed<CanApproveJobRequisitions>())
                _approve = AddButton("Approve", null, ApproveClick);

            _createtask = AddButton("Create Task", null, CreateTask);
        }

        private bool ApproveClick(Button button, CoreRow[] rows)
        {
            if (rows == null || !rows.Any())
            {
                MessageBox.Show("Please select a row first!");
                return false;
            }

            var requi = rows[0].ToObject<JobRequisition>();
            requi.Approved = requi.Approved.IsEmpty() ? DateTime.Now : DateTime.MinValue;
            UpdateRow<DateTime?>(rows[0], "Approved", requi.Approved.IsEmpty() ? null : requi.Approved, true);
            new Client<JobRequisition>().Save(requi, requi.Approved.IsEmpty() ? "Cleared Approval" : "Marked as Approved");
            UpdateButton(_approve, null,
                _approve.IsEnabled && !requi.Approved.IsEmpty() ? "Unapprove" : "Approve");
            _createtask.IsEnabled = !requi.Approved.IsEmpty();
            return false;
        }

        protected override void SelectItems(CoreRow[] rows)
        {
            base.SelectItems(rows);
            if (rows?.Length == 1)
            {
                _approve.Visibility = Visibility.Visible;
                _createtask.Visibility = Visibility.Visible;
                UpdateButton(_approve, null,
                    _approve.IsEnabled && !rows[0].Get<JobRequisition, DateTime>(c => c.Approved).IsEmpty() ? "Unapprove" : "Approve");
                _createtask.IsEnabled = !rows[0].Get<JobRequisition, DateTime>(c => c.Approved).IsEmpty();
            }
            else
            {
                _approve.Visibility = Visibility.Collapsed;
                _createtask.Visibility = Visibility.Collapsed;
            }
        }

        private bool CreateTask(System.Windows.Controls.Button btn, CoreRow[] rows)
        {
            if (!rows.Any())
            {
                MessageBox.Show("Please select at least one row to add to Task!");
                return false;
            }
            Progress.Show("Working");
            JobRequisition jobrequi = rows.FirstOrDefault().ToObject<JobRequisition>();
            Kanban kanban = new Kanban();
            kanban.ManagerLink.ID = Guid.Parse(new Client<Employee>().Query(new Filter<Employee>(x => x.UserLink.UserID).IsEqualTo(ClientFactory.UserID), new Columns<Employee>(x => x.ID)).Rows.FirstOrDefault().Values[0].ToString());
            string jobnumber = new Client<Job>().Query(new Filter<Job>(x => x.ID).IsEqualTo(JobID), new Columns<Job>(x => x.JobNumber)).Rows.FirstOrDefault().Values[0].ToString();
            kanban.JobLink.ID = JobID;
            kanban.Title = "New Job Requisition Raised for Ordering (Job " + jobnumber + " (" + jobrequi.Number + ")" + ")";
            kanban.Category = "Open";
            kanban.Description = "Requisition number: " + jobnumber + " (" + jobrequi.Number + "):" + System.Environment.NewLine;
            CoreTable table = new Client<JobRequisitionItem>().Query
                (
                    new Filter<JobRequisitionItem>(x => x.Requisition.ID).IsEqualTo(jobrequi.ID),
                    new Columns<JobRequisitionItem>(x => x.ID)
                    );
            if (table.Rows.Any())
            {
                kanban.Description = kanban.Description + "Requisition contains " + table.Rows.Count + " items.";
            }
            Progress.Close();
            var page = new KanbanGrid();
            page.OnAfterSave += (form, items) =>
            {
                KanbanAfterSave(form, items);
            };
            return page.EditItems(new[] { kanban });
        }

        private void KanbanAfterSave(DynamicEditorForm form, Kanban[] items)
        {
            Progress.Show("Saving documents");
            JobRequisition jobrequi = SelectedRows.FirstOrDefault().ToObject<JobRequisition>();
            CoreTable table = new Client<JobRequisitionDocument>().Query(new Filter<JobRequisitionDocument>(x => x.EntityLink.ID).IsEqualTo(jobrequi.ID),
                new Columns<JobRequisitionDocument>(x => x.DocumentLink.ID, x => x.DocumentLink.FileName));
            if (table.Rows.Any())
            {
                List<KanbanDocument> docs = new List<KanbanDocument>();
                foreach (CoreRow row in table.Rows)
                {
                    KanbanDocument doc = new KanbanDocument();
                    doc.DocumentLink.ID = Guid.Parse(row.Values[0].ToString());
                    if (row.Values[1] != null)
                        doc.DocumentLink.FileName = row.Values[1].ToString();
                    doc.EntityLink.ID = items[0].ID;
                    docs.Add(doc);
                }
                new Client<KanbanDocument>().Save(docs, "Created From Job Requi Screen");
            }
            Progress.Close();
        }

        public Guid JobID { get; set; }

        protected override void Reload(Filters<JobRequisition> criteria, Columns<JobRequisition> columns, ref SortOrder<JobRequisition> sort,
            Action<CoreTable, Exception> action)
        {
            if (!Security.IsAllowed<CanApproveJobRequisitions>())
                criteria.Add(new Filter<JobRequisition>(x => x.Approved).IsNotEqualTo(DateTime.MinValue));

            criteria.Add(new Filter<JobRequisition>(x => x.Job.ID).IsEqualTo(JobID));

            base.Reload(criteria, columns, ref sort, action);
        }

        protected override void DoAdd()
        {
            if (JobID.Equals(Guid.Empty) || JobID.Equals(CoreUtils.FullGuid))
                MessageBox.Show("Please select a Job first!");
            else
                base.DoAdd();
        }

        protected override JobRequisition CreateItem()
        {
            var result = base.CreateItem();
            result.Job.ID = JobID;
            return result;
        }
    }
}