using System;
using System.Linq;
using System.Windows;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.WPF;
using InABox.Wpf;

namespace PRSDesktop
{
    internal class DeliveryRequiList : DynamicDataGrid<Requisition>, IMasterDetailControl<Delivery,Requisition>
    {

        public Delivery? Master { get; set; }

        public Filter<Requisition> MasterDetailFilter => Master != null && Master.ID != Guid.Empty
            ? new Filter<Requisition>(x => x.Delivery.ID).IsEqualTo(Master.ID)
            : new Filter<Requisition>().None();
        
        public DeliveryRequiList()
        {
            HiddenColumns.Add(x => x.Delivery.ID);
            ColumnsTag = "DeliveryRequi";
        }

        protected override void DoReconfigure(FluentList<DynamicGridOption> options)
        {
            base.DoReconfigure(options);
            options.AddRange(DynamicGridOption.RecordCount, DynamicGridOption.AddRows, DynamicGridOption.DeleteRows, DynamicGridOption.SelectColumns);
        }

        protected override DynamicGridColumns LoadColumns()
        {
            var columns = new DynamicGridColumns
            {
                new() { ColumnName = "Number", Width = 40, Caption = "Req.", Alignment = Alignment.MiddleCenter },
                new() { ColumnName = "Title", Width = 0, Caption = "Requisition" },
                new() { ColumnName = "Filled", Width = 50, Caption = "Done", Format = "dd MMM", Alignment = Alignment.MiddleCenter },
                new() { ColumnName = "Boxes", Width = 25, Caption = "#", Alignment = Alignment.MiddleCenter }
            };
            return columns;
        }

        protected override void DoAdd(bool OpenEditorOnDirectEdit = false)
        {
            if (Master.ID == Guid.Empty)
            {
                MessageBox.Show("Please select a Delivery First");
                return;
            }

            if (!Master.Completed.IsEmpty())
            {
                MessageBox.Show("You cannot modify a completed delivery!");
                return;
            }


            var grid = new MultiSelectDialog<Requisition>(
                new Filter<Requisition>(x => x.JobLink.ID).IsEqualTo(Master.Job.ID).And(x => x.Archived).IsEqualTo(DateTime.MinValue)
                    .And(x => x.Delivery).NotLinkValid(),
                null
            );
            if (grid.ShowDialog())
            {
                Progress.Show("Adding Requsition Items to Delivery");

                var requis = grid.Items();
                var filter = new Filter<DeliveryItem>(x => x.ID).IsEqualTo(CoreUtils.FullGuid);
                foreach (var requi in requis)
                {
                    filter = filter.Or(x => x.RequisitionLink.ID).IsEqualTo(requi.ID);
                    requi.Delivery.ID = Master.ID;
                }

                var items = new Client<DeliveryItem>().Query(
                    filter,
                    new Columns<DeliveryItem>(x => x.Delivery.ID).Add(x => x.ID)
                ).ToArray<DeliveryItem>();
                
                foreach (var item in items)
                {
                    item.Delivery.ID = Master.ID;
                    item.Delivery.Synchronise(Master);
                }

                new Client<DeliveryItem>().Save(items, "Added to Delivery");
                new Client<Requisition>().Save(requis, "Added to Delivery");

                DoChanged();

                Progress.Close();
            }
        }

        public override void DeleteItems(params CoreRow[] rows)
        {
            if (rows == null || !rows.Any())
            {
                MessageBox.Show("Please select a row first");
                return;
            }

            if (!Master.Completed.IsEmpty())
            {
                MessageBox.Show("You cannot modify a completed delivery!");
                return;
            }

            Progress.Show("Removing Items from Delivery");

            DeliveryItem[] items = { };

            foreach (var row in rows)
            {
                var reqid = row.Get<Requisition, Guid>(x => x.ID);
                items = new Client<DeliveryItem>().Query(
                    new Filter<DeliveryItem>(x => x.RequisitionLink.ID).IsEqualTo(reqid),
                    new Columns<DeliveryItem>(x => x.Delivery.ID).Add(x => x.ID)
                ).ToArray<DeliveryItem>();
                var requisition = new Client<Requisition>().Load(new Filter<Requisition>(x => x.ID).IsEqualTo(reqid)).FirstOrDefault();
                if (requisition != null)
                {
                    requisition.Delivery.ID = Guid.Empty;
                    new Client<Requisition>().Save(requisition, "Removed from Delivery");
                }

                if (items.Any())
                {
                    foreach (var item in items)
                        item.Delivery.ID = Guid.Empty;
                    new Client<DeliveryItem>().Save(items, "Removed From Delivery");
                }
            }

            DoChanged();

            Progress.Close();
        }

        protected override void Reload(Filters<Requisition> criteria, Columns<Requisition> columns, ref SortOrder<Requisition>? sort, Action<CoreTable?, Exception?> action)
        {
            criteria.Add(MasterDetailFilter);
            base.Reload(criteria, columns, ref sort, action);
        }
    }
}