prs/prs.desktop/Panels/Jobs/JobSummaryGrid.cs

using System;
using Comal.Classes;
using InABox.Core;
using InABox.DynamicGrid;

namespace PRSDesktop
{
    internal class JobSummaryGrid : DynamicDataGrid<JobMaterial>, IJobControl, IDataModelSource
    {
        public JobSummaryGrid() : base()
        {
            Options.AddRange(
                DynamicGridOption.RecordCount,
                DynamicGridOption.SelectColumns,
                DynamicGridOption.FilterRows,
                DynamicGridOption.ExportData
            );

            HiddenColumns.Add(x => x.BillOfMaterials);
            HiddenColumns.Add(x => x.TotalRequired);
            HiddenColumns.Add(x => x.BalanceRequired);
            HiddenColumns.Add(x => x.ReservedStock);
            HiddenColumns.Add(x => x.OnOrder);
            HiddenColumns.Add(x => x.Issued);
            HiddenColumns.Add(x => x.Received);

            HiddenColumns.Add(x => x.Product.Image.ID);
            HiddenColumns.Add(x => x.Product.Image.FileName);
            ActionColumns.Add(new DynamicImageColumn<JobMaterial>(this, x => x.Product.Image, false)
                { Position = DynamicActionColumnPosition.Start });
        }

        public event DataModelUpdateEvent OnUpdateDataModel;

        public string SectionName => "Job Summary";

        public DataModel DataModel(Selection selection)
        {
            return new AutoDataModel<JobMaterial>(new Filter<JobMaterial>(x => x.Job.ID).IsEqualTo(JobID));
        }

        public Guid JobID { get; set; }

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

        protected override void Reload(Filters<JobMaterial> criteria, Columns<JobMaterial> columns, ref SortOrder<JobMaterial> sort,
            Action<CoreTable, Exception> action)
        {
            if (JobID == Guid.Empty)
                criteria.Add(new Filter<JobMaterial>().None());
            else
                criteria.Add(new Filter<JobMaterial>(x => x.Job.ID).IsEqualTo(JobID)
                    .And(x=>x.Product.ID).IsNotEqualTo(Guid.Empty));
            base.Reload(criteria, columns, ref sort, action);
        }

        protected override bool FilterRecord(CoreRow row)
        {
            var result = base.FilterRecord(row);
            if (result)
                result = (result && row.Get<JobMaterial, double>(x => x.BillOfMaterials) != 0.0F) ||
                         row.Get<JobMaterial, double>(x => x.TotalRequired) != 0.0F ||
                         row.Get<JobMaterial, double>(x => x.BalanceRequired) != 0.0F ||
                         row.Get<JobMaterial, double>(x => x.OnOrder) != 0.0F ||
                         row.Get<JobMaterial, double>(x => x.Issued) != 0.0F ||
                         row.Get<JobMaterial, double>(x => x.Received) != 0.0F ||
                         row.Get<JobMaterial, double>(x => x.ReservedStock) != 0.0F;
            return result;
        }
    }
}