prs/prs.desktop/Panels/Suppliers/Bills/SupplierBillLineGrid.cs

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

namespace PRSDesktop;

public class SupplierBillLineGrid : DynamicOneToManyGrid<Bill, BillLine>
{
    private static readonly BitmapImage pencil = InABox.Wpf.Resources.pencil.AsBitmapImage();

    public SupplierBillLineGrid()
    {

        AddButton("Import", PRSDesktop.Resources.purchase.AsBitmapImage(), ImportLines);

        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.Description);
        
        HiddenColumns.Add(x=>x.Product.ID);
        HiddenColumns.Add(x=>x.Product.Code);
        HiddenColumns.Add(x=>x.Product.Name);
        HiddenColumns.Add(x=>x.Product.TaxCode.ID);
        HiddenColumns.Add(x=>x.Product.PurchaseGL.ID);
        HiddenColumns.Add(x=>x.Product.SellGL.ID);
        HiddenColumns.Add(x=>x.Product.CostCentre.ID);
        
        HiddenColumns.Add(x=>x.Consignment.ID);
        HiddenColumns.Add(x=>x.Consignment.Number);

        HiddenColumns.Add(x=>x.OrderItem.ID);
        HiddenColumns.Add(x=>x.OrderItem.PurchaseOrderLink.ID);
        HiddenColumns.Add(x=>x.OrderItem.PurchaseOrderLink.PONumber);
        HiddenColumns.Add(x=>x.OrderItem.Product.Code);
        HiddenColumns.Add(x=>x.OrderItem.Description);
        HiddenColumns.Add(x=>x.OrderItem.Qty);
        HiddenColumns.Add(x=>x.OrderItem.ExTax);
        HiddenColumns.Add(x=>x.OrderItem.TaxCode.ID);
        HiddenColumns.Add(x=>x.OrderItem.Tax);
        HiddenColumns.Add(x=>x.OrderItem.IncTax);

        ActionColumns.Add(
            new DynamicTextColumn(DisplayLinkText,DisplayLinkClick)
            {
                Position = DynamicActionColumnPosition.Start, 
                Width = 30,
                HeaderText = "?",
                ToolTip = DisplayLinkToolTip,
                Alignment = Alignment.MiddleCenter
            }
        );
        
        ActionColumns.Add(new DynamicImageColumn(pencil, BillLineEdit_Click));
    }

    private object DisplayLinkText(CoreRow? row)
    {
        if (row == null)
            return "";
        var prodid = row.Get<BillLine, Guid>(x => x.Product.ID);
        var poid = row.Get<BillLine, Guid>(x => x.OrderItem.PurchaseOrderLink.ID);
        var conid = row.Get<BillLine, Guid>(x => x.Consignment.ID);
        return !Guid.Equals(poid,Guid.Empty) 
            ? "O"
            : !Guid.Equals(conid,Guid.Empty)
                ? "C"
                : !Guid.Equals(prodid,Guid.Empty)
                    ? "P"
                    : "--";
    }

    private bool DisplayLinkClick(CoreRow? row)
    {
        return false;
    }
    
    private FrameworkElement? DisplayLinkToolTip(DynamicActionColumn column, CoreRow? row)
    {
        var text = !Guid.Equals(Guid.Empty, row?.Get<BillLine, Guid>(x => x.OrderItem.PurchaseOrderLink.ID) ?? Guid.Empty)
            ? String.Format("Purchase Order: {0}: {1:F2} x {2}",
                row?.Get<BillLine, String>(x => x.OrderItem.PurchaseOrderLink.PONumber),
                row?.Get<BillLine, double>(x => x.OrderItem.Qty),
                row?.Get<BillLine, String>(x => x.OrderItem.Description)
                )
            : !Guid.Equals(Guid.Empty, row?.Get<BillLine, Guid>(x => x.Consignment.ID) ?? Guid.Empty)
                ? String.Format("Consignment: {0}: {1}",
                    row?.Get<BillLine, String>(x => x.Consignment.Number),
                    row?.Get<BillLine, String>(x => x.Consignment.Description)
                )
                : !Guid.Equals(Guid.Empty, row?.Get<BillLine, Guid>(x => x.Product.ID) ?? Guid.Empty)
                    ? String.Format("Product: {0}: {1}",
                        row?.Get<BillLine, String>(x => x.Product.Code),
                        row?.Get<BillLine, String>(x => x.Product.Name))
                    : "";
    
        return String.IsNullOrWhiteSpace(text)
            ? column.TextToolTip(text)
            : null;
    }

    // private class BillLineConverter : IValueConverter
    // {
    //     public Func<CoreTable> Data { get; set; }
    //
    //     public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
    //     {
    //         if (value is null)
    //             return value;
    //         
    //         var datarow = (value as DataRowView).Row;
    //         var index = datarow.Table.Rows.IndexOf(datarow);
    //         var row = Data().Rows[index];
    //         

    //     }
    //
    //     public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
    //     {
    //         throw new NotImplementedException();
    //     }
    // }
    //
    // private FrameworkElement DisplayLink()
    // {
    //     var button = new Button();
    //     button.SetBinding(Button.ContentProperty, new Binding(".") { Converter = new BillLineConverter() { Data = () => Data} });
    //     button.SetBinding(Button.DataContextProperty, new Binding("."));
    //     button.Click += (sender, args) =>
    //     {
    //         var datarow = ((sender as Button)?.DataContext as DataRowView)?.Row;
    //         if (datarow != null)
    //         {
    //             var index = datarow.Table.Rows.IndexOf(datarow);
    //             var row = Data.Rows[index];
    //
    //             ContextMenu menu = new ContextMenu();
    //             
    //             var cons = new MenuItem() { Header = "Consignment" };
    //             cons.Click += (o,e) => SelectConsignment(row);
    //             menu.Items.Add(cons);
    //             
    //             var po = new MenuItem() { Header = "PO Item" };
    //             po.Click += (o,e) => SelectPOItem(row);
    //             menu.Items.Add(po);
    //
    //             menu.IsOpen = true;
    //         }
    //     };
    //     
    //     return button;
    // }
    //
    // private void SelectPOItem(CoreRow row)
    // {
    //     if (ImportPOLines(row))
    //         InvalidateRow(row);
    // }
    //
    // private void SelectConsignment(CoreRow row)
    // {
    //     throw new NotImplementedException();
    // }

    public override DynamicGridColumns GenerateColumns()
    {
        if (IsDirectEditMode())
        {
            var columns = new DynamicGridColumns();

            columns.Add<BillLine, string>(x => x.Description, 0, "Description", "", Alignment.MiddleLeft);
            columns.Add<BillLine, Guid>(x => x.OrderItem.ID, 100, "POItem", "", Alignment.MiddleLeft);
            columns.Add<BillLine, Guid>(x => x.PurchaseGL.ID, 100, "Purchase GL", "", Alignment.MiddleLeft);
            columns.Add<BillLine, double>(x => x.ExTax, 70, "Ex. Tax", "", Alignment.MiddleLeft);
            columns.Add<BillLine, Guid>(x => x.TaxCode.ID, 70, "Tax Code", "", Alignment.MiddleLeft);
            columns.Add<BillLine, double>(x => x.Tax, 70, "Tax", "", Alignment.MiddleLeft);
            columns.Add<BillLine, double>(x => x.IncTax, 70, "Inc. Tax", "", Alignment.MiddleLeft);

            return columns;
        }
        else
        {
            return base.GenerateColumns();
        }
    }

    protected override void CustomiseEditor(BillLine[] items, DynamicGridColumn column, BaseEditor editor)
    {
        base.CustomiseEditor(items, column, editor);

        if(editor is CurrencyEditor curr)
        {
            var settings = new GlobalConfiguration<SupplierBillPanelProperties>().Load();
            curr.Digits = settings.CurrencyDecimalPlaces;
        }
    }

    protected override void DoReconfigure(DynamicGridOptions options)
    {
        base.DoReconfigure(options);
        options.AddRows = true;
        options.DeleteRows = true;
        options.SelectColumns = true;
        options.DirectEdit = true;
        options.DragTarget = true;
    }

    private bool BillLineEdit_Click(CoreRow? row)
    {
        if(row is null)
        {
            return false;
        }
        var item = LoadItem(row);
        if (EditItems(new BillLine[] { item }))
        {
            SaveItem(item);
            DoChanged();
            return true;
        }
        return false;
    }
    
    private bool ImportLines(Button button, CoreRow[] rows)
    {
        ContextMenu menu = new ContextMenu();
        
        var cons = new MenuItem() { Header = "Consignment" };
        cons.Click += (o,e) => ImportConsignments();
        menu.Items.Add(cons);
        
        var po = new MenuItem() { Header = "PO Item" };
        po.Click += (o, e) => ImportPOLines();
        menu.Items.Add(po);
        
        menu.IsOpen = true;
        return false;
    }

    private void ImportConsignments()
    {
        var consignments = ExtractValues(x => x.Consignment.ID, Selection.All).ToArray();

        var dlg = new MultiSelectDialog<Consignment>(
            new Filter<Consignment>(x => x.Supplier.ID).IsEqualTo(Item.SupplierLink.ID)
                .And(x => x.BillLine.ID).IsEqualTo(Guid.Empty)
                .And(x => x.ID).NotInList(consignments),
            Columns.None<Consignment>().Add(
                x => x.ID));
        if (dlg.ShowDialog() == true)
        {
            var imports = dlg.Data();
            var consids = imports.ExtractValues<PurchaseOrderItem, Guid>(x => x.Consignment.ID).Distinct().ToArray();

            var results = Client.QueryMultiple(
                new KeyedQueryDef<Consignment>(
                    new Filter<Consignment>(x => x.ID).InList(dlg.IDs()),
                    Columns.None<Consignment>().Add(x => x.ID)
                        .Add(x => x.Number)
                        .Add(x => x.Description)
                        .Add(x => x.TaxCode.ID)
                        .Add(x => x.TaxCode.Code)
                        .Add(x => x.TaxCode.Description)
                        .Add(x => x.TaxCode.Rate)
                        .Add(x => x.TaxRate)
                        .Add(x => x.ExTax)
                        .Add(x => x.Tax)
                        .Add(x => x.IncTax)
                        .Add(x => x.Created)),
                new KeyedQueryDef<ConsignmentDocument>(
                    new Filter<ConsignmentDocument>(x => x.EntityLink.ID).InList(consids),
                    Columns.None<ConsignmentDocument>().Add(x => x.DocumentLink.ID)
                        .Add(x => x.DocumentLink.FileName)
                        .Add(x => x.Thumbnail)));

            var items = results.Get<Consignment>();
            
            CreateItems(() =>
            {
                List<BillLine> lines = new List<BillLine>();
                foreach (var row in items.Rows)
                {
                    var line = CreateItem();
                    line.Consignment.ID = row.Get<Consignment, Guid>(x => x.ID);
                    line.Consignment.Number = row.Get<Consignment, String>(x => x.Number);
                    line.Consignment.Description = row.Get<Consignment, string>(x => x.Description);

                    line.ExTax = row.Get<Consignment, double>(x => x.ExTax);
                    line.TaxCode.ID = row.Get<Consignment, Guid>(x => x.TaxCode.ID);
                    line.TaxCode.Code = row.Get<Consignment, string>(x => x.TaxCode.Code);
                    line.TaxCode.Description = row.Get<Consignment, string>(x => x.TaxCode.Description);
                    line.TaxCode.Rate = row.Get<Consignment, double>(x => x.TaxCode.Rate);
                    line.TaxRate = row.Get<Consignment, double>(x => x.TaxRate);
                    line.Tax = row.Get<Consignment, double>(x => x.Tax);
                    line.IncTax = row.Get<Consignment, double>(x => x.IncTax);

                    line.Description =
                        $"{row.Get<Consignment, string>(x => x.Number)} : {row.Get<Consignment, String>(x => x.Description)}";
                    lines.Add(line);
                }

                return lines;
            });
            
            
            var docpage = EditorGrid.Pages.FirstOrDefault(x=>x is BillDocumentGrid) as BillDocumentGrid;
            if (!docpage.Ready)
                docpage.Load(Item,null);
            
            if (docpage != null)
            {
                var docIDs = docpage.Data.ExtractValues<BillDocument, Guid>(x => x.DocumentLink.ID).ToHashSet();
                foreach(var eDoc in results.GetObjects<ConsignmentDocument>())
                {
                    if (!docIDs.Contains(eDoc.DocumentLink.ID))
                    {
                        var doc = new BillDocument();
                        doc.EntityLink.ID = Item.ID;
                        doc.DocumentLink.ID = eDoc.DocumentLink.ID;
                        doc.DocumentLink.FileName = eDoc.DocumentLink.FileName;
                        doc.Thumbnail = eDoc.Thumbnail;
                        docpage.SaveItem(doc);
                        docIDs.Add(eDoc.DocumentLink.ID);
                    }
                }

                docpage.Refresh(false,true);
            }
            DoChanged();
            Refresh(false,false);
        }
        
    }
    
    private void ImportPOLines()
    {
        var poItems = ExtractValues(x => x.OrderItem.ID, Selection.All).ToArray();

        var dlg = new MultiSelectDialog<PurchaseOrderItem>(
            new Filter<PurchaseOrderItem>(x => x.PurchaseOrderLink.SupplierLink.ID).IsEqualTo(Item.SupplierLink.ID)
                .And(x => x.BillLine.ID).IsEqualTo(Guid.Empty)
                .And(x => x.ID).NotInList(poItems),
            Columns.None<PurchaseOrderItem>().Add(
                x => x.ID,
                x => x.Consignment.ID,
                x => x.PurchaseOrderLink.ID));
        if (dlg.ShowDialog() == true)
        {
            var imports = dlg.Data();
            var poids = imports.ExtractValues<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.ID).Distinct().ToArray();
            var consids = imports.ExtractValues<PurchaseOrderItem, Guid>(x => x.Consignment.ID).Distinct().ToArray();

            var results = Client.QueryMultiple(
                new KeyedQueryDef<PurchaseOrderItem>(
                    new Filter<PurchaseOrderItem>(x => x.ID).InList(dlg.IDs()),
                    Columns.None<PurchaseOrderItem>().Add(x => x.ID)
                        .Add(x => x.Description)
                        .Add(x => x.TaxCode.ID)
                        .Add(x => x.TaxCode.Code)
                        .Add(x => x.TaxCode.Description)
                        .Add(x => x.TaxCode.Rate)
                        .Add(x => x.Qty)
                        .Add(x => x.TaxRate)
                        .Add(x => x.ExTax)
                        .Add(x => x.Tax)
                        .Add(x => x.IncTax)
                        .Add(x => x.Created)
                        .Add(x => x.PurchaseOrderLink.ID)
                        .Add(x => x.PurchaseOrderLink.PONumber)
                        .Add(x => x.Consignment.ID)
                        .Add(x => x.Product.ID)
                        .Add(x => x.Product.Code)
                        .Add(x => x.Product.Name)
                        .Add(x => x.PurchaseGL.ID)
                        .Add(x => x.CostCentre.ID)),
                new KeyedQueryDef<PurchaseOrderDocument>(
                    new Filter<PurchaseOrderDocument>(x => x.EntityLink.ID).InList(poids),
                    Columns.None<PurchaseOrderDocument>().Add(x => x.DocumentLink.ID)
                        .Add(x => x.DocumentLink.FileName)
                        .Add(x => x.Thumbnail)),
                new KeyedQueryDef<ConsignmentDocument>(
                    new Filter<ConsignmentDocument>(x => x.EntityLink.ID).InList(consids),
                    Columns.None<ConsignmentDocument>().Add(x => x.DocumentLink.ID)
                        .Add(x => x.DocumentLink.FileName)
                        .Add(x => x.Thumbnail)));
            
            var items = results.Get<PurchaseOrderItem>();
            CreateItems(() =>
            {
                List<BillLine> lines = new List<BillLine>();
                foreach (var row in items.Rows)
                {

                    var line = CreateItem();

                    line.OrderItem.ID = row.Get<PurchaseOrderItem, Guid>(x => x.ID);
                    line.OrderItem.PurchaseOrderLink.ID = row.Get<PurchaseOrderItem, Guid>(x => x.PurchaseOrderLink.ID);
                    line.OrderItem.PurchaseOrderLink.PONumber =
                        row.Get<PurchaseOrderItem, String>(x => x.PurchaseOrderLink.PONumber);

                    line.OrderItem.Product.ID = row.Get<PurchaseOrderItem, Guid>(x => x.Product.ID);
                    line.OrderItem.Product.Code = row.Get<PurchaseOrderItem, string>(x => x.Product.Code);
                    line.OrderItem.Product.Name = row.Get<PurchaseOrderItem, string>(x => x.Product.Name);

                    line.OrderItem.Description = row.Get<PurchaseOrderItem, string>(x => x.Description);
                    line.OrderItem.Qty = row.Get<PurchaseOrderItem, double>(x => x.Qty);
                    line.OrderItem.ExTax = row.Get<PurchaseOrderItem, double>(x => x.ExTax);
                    line.OrderItem.TaxCode.ID = row.Get<PurchaseOrderItem, Guid>(x => x.TaxCode.ID);
                    line.OrderItem.TaxCode.Code = row.Get<PurchaseOrderItem, string>(x => x.TaxCode.Code);
                    line.OrderItem.TaxCode.Description = row.Get<PurchaseOrderItem, string>(x => x.TaxCode.Description);
                    line.OrderItem.TaxCode.Rate = row.Get<PurchaseOrderItem, double>(x => x.TaxCode.Rate);
                    line.OrderItem.PurchaseGL.ID = row.Get<PurchaseOrderItem, Guid>(x => x.PurchaseGL.ID);
                    line.OrderItem.CostCentre.ID = row.Get<PurchaseOrderItem, Guid>(x => x.CostCentre.ID);

                    line.ExTax = row.Get<PurchaseOrderItem, double>(x => x.ExTax);
                    line.TaxCode.ID = row.Get<PurchaseOrderItem, Guid>(x => x.TaxCode.ID);
                    line.TaxCode.Code = row.Get<PurchaseOrderItem, string>(x => x.TaxCode.Code);
                    line.TaxCode.Description = row.Get<PurchaseOrderItem, string>(x => x.TaxCode.Description);
                    line.TaxCode.Rate = row.Get<PurchaseOrderItem, double>(x => x.TaxCode.Rate);
                    line.TaxRate = row.Get<PurchaseOrderItem, double>(x => x.TaxRate);
                    line.Tax = row.Get<PurchaseOrderItem, double>(x => x.Tax);
                    line.IncTax = row.Get<PurchaseOrderItem, double>(x => x.IncTax);
                    line.PurchaseGL.ID = row.Get<PurchaseOrderItem, Guid>(x => x.PurchaseGL.ID);
                    line.CostCentre.ID = row.Get<PurchaseOrderItem, Guid>(x => x.CostCentre.ID);
                    var description = row.Get<PurchaseOrderItem, String>(x => x.Description);
                    if (String.IsNullOrWhiteSpace(description))
                        description = row.Get<PurchaseOrderItem, String>(x => x.Product.Name);
                    line.Description = $"{row.Get<PurchaseOrderItem, double>(x => x.Qty):F2} x {description}";

                    lines.Add(line);
                }
                return lines;
            });

            var docpage = EditorGrid.Pages.FirstOrDefault(x=>x is BillDocumentGrid) as BillDocumentGrid;
            if (!docpage.Ready)
                docpage.Load(Item,null);
            
            if (docpage != null)
            {
                var docIDs = docpage.Data.ExtractValues<BillDocument, Guid>(x => x.DocumentLink.ID).ToHashSet();
                foreach(var eDoc in (results.GetObjects<PurchaseOrderDocument>() as IEnumerable<IEntityDocument>)
                        .Concat(results.GetObjects<ConsignmentDocument>()))
                {
                    if (!docIDs.Contains(eDoc.DocumentLink.ID))
                    {
                        var doc = new BillDocument();
                        doc.EntityLink.ID = Item.ID;
                        doc.DocumentLink.ID = eDoc.DocumentLink.ID;
                        doc.DocumentLink.FileName = eDoc.DocumentLink.FileName;
                        doc.Thumbnail = eDoc.Thumbnail;
                        docpage.SaveItem(doc);
                        docIDs.Add(eDoc.DocumentLink.ID);
                    }
                }

                docpage.Refresh(false,true);
            }
            DoChanged();
            Refresh(false,false);
        }
        
    }

    protected override void HandleDragOver(object sender, DragEventArgs e)
    {
        base.HandleDragOver(sender, e);

        if (e.Data.GetDataPresent(typeof(Product)))
        {
            if (e.Data.GetData(typeof(Product)) is Product product)
            {
                if (!Security.CanEdit<Bill>() || !Security.CanEdit<BillLine>())
                {
                    e.Effects = DragDropEffects.None;
                }
            }
        }
    }

    protected override void HandleDragDrop(object sender, DragEventArgs e)
    {
        base.HandleDragDrop(sender, e);

        if (e.Data.GetDataPresent(typeof(Product)))
        {
            if (e.Data.GetData(typeof(Product)) is Product product)
            {
                if (Security.CanEdit<Bill>() && Security.CanEdit<BillLine>())
                {
                    var item = CreateItem();
                    item.Product.ID = product.ID;
                    item.Product.Synchronise(product);
                    item.Description = product.Name;

                    SaveItem(item);
                    DoChanged();
                    Refresh(false, true);
                }
            }
        }
    }
}