prs/prs.desktop/Grids/StockBatchGrid.cs

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

namespace PRSDesktop
{
    public class StockBatchGrid : DynamicDataGrid<StockMovementBatch>
    {
        public StockBatchGrid()
        {
            Options.AddRange(DynamicGridOption.RecordCount, DynamicGridOption.SelectColumns, DynamicGridOption.FilterRows);
        }

        public DateTime StartDate { get; set; } = DateTime.MinValue;
        public DateTime EndDate { get; set; } = DateTime.MaxValue;

        protected override void Reload(Filters<StockMovementBatch> criteria, Columns<StockMovementBatch> columns,
            ref SortOrder<StockMovementBatch> sort,
            Action<CoreTable, Exception> action)
        {
            if (!DateTime.Equals(StartDate, DateTime.MinValue))
                criteria.Add(new Filter<StockMovementBatch>(x => x.TimeStamp).IsGreaterThanOrEqualTo(StartDate.Date));
            if (!DateTime.Equals(EndDate, DateTime.MaxValue))
                criteria.Add(new Filter<StockMovementBatch>(x => x.TimeStamp).IsLessThanOrEqualTo(EndDate.Date.AddDays(1)));
            base.Reload(criteria, columns, ref sort, action);
        }
    }
}