prs/prs.classes/Entities/Employee/EmployeeLookups.cs

using System;
using System.Linq;
using InABox.Core;

namespace Comal.Classes
{
    public class EmployeeLookups : EntityLookup<Employee>
    {
        public override Columns<Employee> DefineColumns()
        {
            return Columns.None<Employee>().Add(
                x => x.ID,
                x => x.Name
            );
        }

        public override Filter<Employee> DefineFilter()
        {
            var filter = new Filter<Employee>(x => x.ID).IsNotEqualTo(Guid.Empty);
            filter.Ands.Add(new Filter<Employee>(x => x.StartDate).IsEqualTo(DateTime.MinValue).Or(x => x.StartDate)
                .IsLessThanOrEqualTo(FilterConstant.Today));
            filter.Ands.Add(new Filter<Employee>(x => x.FinishDate).IsEqualTo(DateTime.MinValue).Or(x => x.FinishDate)
                .IsGreaterThanOrEqualTo(FilterConstant.Today));
            return filter;
        }

        public override SortOrder<Employee> DefineSortOrder()
        {
            return new SortOrder<Employee>(x => x.Name);
        }
    }
}