prs/prs.desktop/Panels/Suppliers/PurchaseOrders/SupplierPurchaseOrderItemOneToMany.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 FastReport.DevComponents.WinForms.Drawing;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.WPF;
using static InABox.DynamicGrid.DynamicMenuColumn;

namespace PRSDesktop
{
    public class SupplierPurchaseOrderItemOneToMany : DynamicOneToManyGrid<PurchaseOrder,PurchaseOrderItem>
    {
        private Button bill;
        private Button? consign;
        private Button? viewconsign;
        private Button receive;
        private Button assignLocation;

        public SupplierPurchaseOrderItemOneToMany() : base()
        {
            HiddenColumns.Add(x => x.ID);

            HiddenColumns.Add(x => x.BillLine.ID);
            HiddenColumns.Add(x => x.BillLine.Deleted);
            HiddenColumns.Add(x => x.Consignment.ID);

            HiddenColumns.Add(x => x.Product.Code);
            HiddenColumns.Add(x => x.Product.Name);
            HiddenColumns.Add(x => x.Description);
            HiddenColumns.Add(x => x.TaxCode.ID);
            HiddenColumns.Add(x => x.TaxCode.Code);
            HiddenColumns.Add(x => x.TaxCode.Description);
            HiddenColumns.Add(x => x.TaxCode.Rate);
            HiddenColumns.Add(x => x.TaxRate);
            HiddenColumns.Add(x => x.ExTax);
            HiddenColumns.Add(x => x.Tax);
            HiddenColumns.Add(x => x.IncTax);
            HiddenColumns.Add(x => x.ReceivedDate);

            HiddenColumns.Add(x => x.PurchaseOrderLink.SupplierLink.ID);
            HiddenColumns.Add(x => x.PurchaseOrderLink.Category.ID);

            HiddenColumns.Add(x => x.Product.DigitalForm.ID);
            HiddenColumns.Add(x => x.Product.DigitalForm.Description);

            HiddenColumns.Add(x => x.Product.Image.ID);
            HiddenColumns.Add(x => x.Product.Image.FileName);
            ActionColumns.Add(new DynamicImageManagerColumn<PurchaseOrderItem>(this, x => x.Product.Image, true)
            { Position = DynamicActionColumnPosition.Start });

            HiddenColumns.Add(x => x.FormCount);
            HiddenColumns.Add(x => x.OpenForms);
            ActionColumns.Add(new DynamicMenuColumn(BuildFormsMenu) { Position = DynamicActionColumnPosition.End });
            ActionColumns.Add(new DynamicImageColumn(FormsImage) { Position = DynamicActionColumnPosition.Start, ToolTip = FormsToolTip });
        }

        protected override void Init()
        {
            base.Init();

            if (Security.IsAllowed<CanViewConsignmentModule>())
            {
                consign = AddButton("Create Consignment", null, CreateConsignment);
                consign.IsEnabled = false;

                viewconsign = AddButton("View Consignment", null, ViewConsignment);
                viewconsign.Visibility = Visibility.Collapsed;
            }

            receive = AddButton("Receive Items", null, ReceiveItems);
            receive.IsEnabled = false;

            bill = AddButton("Enter Bill", null, EnterBill);
            bill.IsEnabled = false;

            assignLocation = AddButton("Assign Location", null, AssignLocation);
        }

        protected override void DoReconfigure(FluentList<DynamicGridOption> options)
        {
            base.DoReconfigure(options);
            if (!ReadOnly && Security.CanEdit<PurchaseOrderItem>())
            {
                options.AddRange(DynamicGridOption.DirectEdit);
            }
        }

        public override void Load(object item, Func<Type, CoreTable>? PageDataHandler)
        {
            Reconfigure();
            Refresh(true, false);
            base.Load(item, type =>
            {
                var data = PageDataHandler?.Invoke(type);
                if (data is null && type == typeof(PurchaseOrderItem))
                {
                    data = new Client<PurchaseOrderItem>().Query(
                        new Filter<PurchaseOrderItem>(x => x.PurchaseOrderLink.ID).IsEqualTo(Item.ID),
                        DynamicGridUtils.LoadEditorColumns(DataColumns()),
                        LookupFactory.DefineSort<PurchaseOrderItem>());
                }
                return data;
            });
        }

        private void BuildFormsMenu(DynamicMenuColumn column, CoreRow? row)
        {
            if (row == null) return;
            var formsItem = column.AddItem("Digital Forms", PRSDesktop.Resources.kanban, null);
            DynamicGridUtils.PopulateFormMenu<PurchaseOrderItemForm, PurchaseOrderItem, PurchaseOrderItemLink>(
                formsItem,
                row.Get<PurchaseOrderItem, Guid>(x => x.ID),
                row.ToObject<PurchaseOrderItem>);
        }

        private FrameworkElement? FormsToolTip(DynamicActionColumn arg1, CoreRow? arg2)
        {
            var text = arg2 == null || arg2.Get<PurchaseOrderItem, Guid>(x => x.Product.DigitalForm.ID) == Guid.Empty
                ? ""
                : arg2.Get<PurchaseOrderItem, int>(c => c.FormCount) == 0
                    ? "No forms found for this item"
                    : arg2.Get<PurchaseOrderItem, int>(c => c.OpenForms) > 0
                        ? "Incomplete forms found"
                        : "All forms completed";
            return string.IsNullOrWhiteSpace(text) ? null : arg1.TextToolTip(text);
        }

        private BitmapImage? FormsImage(CoreRow? arg)
        {
            if (arg == null)
                return PRSDesktop.Resources.quality.AsBitmapImage();
            return arg.Get<PurchaseOrderItem, Guid>(x => x.Product.DigitalForm.ID) == Guid.Empty
                ? null
                : arg.Get<PurchaseOrderItem, int>(c => c.FormCount) == 0
                    ? PRSDesktop.Resources.warning.AsBitmapImage()
                    : arg.Get<PurchaseOrderItem, int>(c => c.OpenForms) > 0
                        ? PRSDesktop.Resources.warning.AsBitmapImage()
                        : PRSDesktop.Resources.quality.AsBitmapImage();
        }

        private bool CreateConsignment(Button sender, CoreRow[] rows)
        {
            if (!rows.Any())
            {
                MessageBox.Show("Please select a row first");
                return false;
            }

            var consign = new Consignment();
            consign.Supplier.ID = rows.First().Get<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.SupplierLink.ID);
            consign.Category.ID = rows.First().Get<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.Category.ID);
            return new DynamicDataGrid<Consignment>().EditItems(new[] { consign }, LoadConsignmentLines, true);
        }

        private bool ViewConsignment(Button sender, CoreRow[] rows)
        {
            if (!rows.Any())
            {
                MessageBox.Show("Please select a row first");
                return false;
            }

            var consign = new Consignment();
            consign.Supplier.ID = rows.First().Get<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.SupplierLink.ID);
            consign.Category.ID = rows.First().Get<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.Category.ID);
            return new DynamicDataGrid<Consignment>().EditItems(new[] { consign }, LoadConsignmentLines, true);
        }

        private CoreTable LoadConsignmentLines(Type arg)
        {
            var result = new CoreTable();
            result.LoadColumns(typeof(PurchaseOrderItem));
            result.LoadRows(SelectedRows);
            return result;
        }

        private static bool EnterBill(Button sender, CoreRow[] rows)
        {
            if (!rows.Any())
            {
                MessageBox.Show("Please select a row first");
                return false;
            }

            var bill = new Bill();
            bill.SupplierLink.ID = rows.First()
                .Get<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.SupplierLink.ID);
            bill.BillDate = DateTime.Today;
            return new DynamicDataGrid<Bill>().EditItems(new[] { bill }, (type) =>
            {
                return LoadBillLines(type, rows);
            }, true);
        }
        private static CoreTable LoadBillLines(Type type, CoreRow[] rows)
        {
            var result = new CoreTable();
            result.LoadColumns(typeof(BillLine));
            foreach (var row in rows)
            {
                var billrow = result.NewRow();
                billrow.Set<BillLine, Guid>(x => x.OrderItem.ID, row.Get<PurchaseOrderItem, Guid>(x => x.ID));

                var description = new List<string>();
                if (row.Get<PurchaseOrderItem, Guid>(x => x.Product.ID) != Guid.Empty)
                    description.Add(string.Format("{0} : {1}", row.Get<PurchaseOrderItem, string>(x => x.Product.Code),
                        row.Get<PurchaseOrderItem, string>(x => x.Product.Name)));
                var Description = row.Get<PurchaseOrderItem, string>(x => x.Description);
                if (!string.IsNullOrEmpty(Description))
                    description.Add(Description);
                billrow.Set<BillLine, string>(x => x.Description, string.Join("\n", description));

                billrow.Set<BillLine, Guid>(x => x.TaxCode.ID, row.Get<PurchaseOrderItem, Guid>(x => x.TaxCode.ID));
                billrow.Set<BillLine, string>(x => x.TaxCode.Code, row.Get<PurchaseOrderItem, string>(x => x.TaxCode.Code));
                billrow.Set<BillLine, string>(x => x.TaxCode.Description, row.Get<PurchaseOrderItem, string>(x => x.TaxCode.Description));
                billrow.Set<BillLine, double>(x => x.TaxCode.Rate, row.Get<PurchaseOrderItem, double>(x => x.TaxCode.Rate));
                billrow.Set<BillLine, double>(x => x.TaxRate, row.Get<PurchaseOrderItem, double>(x => x.TaxRate));
                billrow.Set<BillLine, double>(x => x.ExTax, row.Get<PurchaseOrderItem, double>(x => x.ExTax));
                billrow.Set<BillLine, double>(x => x.Tax, row.Get<PurchaseOrderItem, double>(x => x.Tax));
                billrow.Set<BillLine, double>(x => x.IncTax, row.Get<PurchaseOrderItem, double>(x => x.IncTax));
                result.Rows.Add(billrow);
            }

            return result;
        }

        private bool ReceiveItems(Button sender, CoreRow[] rows)
        {
            if (!rows.Any())
            {
                MessageBox.Show("Please select a row first");
                return false;
            }

            var now = DateTime.Now;
            using (new WaitCursor())
            {
                var items = LoadItems(rows);
                foreach (var item in items)
                    item.ReceivedDate = now;
                new Client<PurchaseOrderItem>().Save(items, "Consignment Items Received");
            }

            return true;
        }

        public static bool AssignLocation(Button btn, CoreRow[] rows)
        {
            if (!rows.Any())
            {
                MessageBox.Show("Please select at least one row to assign");
                return false;
            }

            var menu = new ContextMenu();
            menu.AddItem("Create New Location", null, () =>
            {
                var grid = new StockLocationGrid();
                var location = new StockLocation();
                if (grid.EditItems(new StockLocation[] { location }))
                    AssignLocationToItems(location.ID, rows);
            });
            menu.AddItem("Choose Existing", null, () =>
            {
                var popup = new PopupList(typeof(StockLocation), Guid.Empty, new string[] { });
                if (popup.ShowDialog() == true)
                    AssignLocationToItems(popup.ID, rows);
            });
            menu.IsOpen = true;
            return true;
        }

        private static void AssignLocationToItems(Guid locationID, CoreRow[] rows)
        {
            List<PurchaseOrderItem> items = new List<PurchaseOrderItem>();
            foreach (CoreRow row in rows)
            {
                var item = row.ToObject<PurchaseOrderItem>();
                item.StockLocation.ID = locationID;
                items.Add(item);
            }
            new Client<PurchaseOrderItem>()
                .Save(items, "Added stock location from PurchaseOrderItem Grid");
        }

        /*private StockLocation[] QueryLocations()
        {
            CoreTable table = new Client<StockLocation>().Query(new Filter<StockLocation>(x => x.Active).IsEqualTo(true), new Columns<StockLocation>(x => x.ID));
            List<StockLocation> locations = new List<StockLocation>();
            foreach (CoreRow row in table.Rows)
                locations.Add(row.ToObject<StockLocation>());

            return locations.ToArray();
        }*/


        protected override void SelectItems(CoreRow[]? rows)
        {
            if (consign != null && viewconsign != null)
            {
                consign.IsEnabled =
                    rows != null
                    && !rows.Any(r => Entity.IsEntityLinkValid<PurchaseOrderItem, ConsignmentLink>(x => x.Consignment, r))
                    && !rows.Any(r => r.Get<PurchaseOrderItem, DateTime>(c => c.ReceivedDate).IsEmpty() == false)
                    && !ReadOnly && Security.CanEdit<Consignment>();

                viewconsign.Visibility =
                    rows == null
                    || consign.IsEnabled
                    || rows.Select(r =>r.Get<PurchaseOrderItem, Guid>(x => x.Consignment.ID)).Distinct().Count() != 1
                        ? Visibility.Collapsed
                        : Visibility.Visible;

                consign.Visibility = viewconsign.Visibility == Visibility.Visible ? Visibility.Collapsed : Visibility.Visible;
            }

            receive.IsEnabled =
                rows != null
                && !rows.Any(r => Entity.IsEntityLinkValid<PurchaseOrderItem, ConsignmentLink>(x => x.Consignment, r))
                && !rows.Any(r => r.Get<PurchaseOrderItem, DateTime>(c => c.ReceivedDate).IsEmpty() == false)
                && !ReadOnly && Security.CanEdit<PurchaseOrderItem>();

            bill.IsEnabled =
                rows != null
                && !rows.Any(r => r.IsEntityLinkValid<PurchaseOrderItem, BillLineLink>(x => x.BillLine))
                && !ReadOnly && Security.CanEdit<PurchaseOrderItem>();

            assignLocation.IsEnabled =
                rows != null && !ReadOnly && Security.CanEdit<PurchaseOrderItem>();

            base.SelectItems(rows);
        }

        protected override void OnAfterEditorValueChanged(DynamicEditorGrid grid, PurchaseOrderItem[] items, string columnnname, Dictionary<string, object?> changes)
        {
            base.OnAfterEditorValueChanged(grid, items, columnnname, changes);
            if (columnnname.Equals("Product.ID") || columnnname.Equals("Job.ID") || columnnname.StartsWith("Dimensions."))
            {
                PurchaseOrder.UpdateCosts(
                    items, 
                    Item.SupplierLink.ID,
                    changes
                );
            }
        }

        protected override Dictionary<string, object?> EditorValueChanged(IDynamicEditorForm editor, PurchaseOrderItem[] items, string name,
            object value)
        {
            var results = base.EditorValueChanged(editor, items, name, value);
            if (name.Equals("ProductLink.TaxCode.ID"))
                DynamicGridUtils.UpdateEditorValue(items, "TaxCode.ID", (Guid)value, results);
            return results;
        }
    }
}