internal bool IsSystemDisabled(string employeeID, string systemDescription)
        {
            return (from esd in this.emailOrgDB.EmployeeDisabledSystems
                    where string.Equals(esd.EmployeeID.Trim().ToLower(), employeeID.Trim().ToLower()) &&
                    esd.EmailingSystem != null &&
                    !esd.EmailingSystem.IsDeleted &&
                    esd.EmailingSystem.IsActive &&
                    string.Equals(esd.EmailingSystem.SystemDescription.ToLower(), systemDescription.ToLower()) && (
                        (!esd.EnablingDate.HasValue) ||
                        (esd.EnablingDate.HasValue && DateTime.Compare(esd.EnablingDate.Value, DateTime.Now) > 1)                                                                                    )
                    select esd).Any();
        }

{SELECT [t0].[ID], [t0].[SystemID], [t0].[EmployeeID],
[t0].[EnablingDate], [t0].[CreationDate], [t0].[CreatedBy]
FROM [EmailOrganizer].[EmployeeDisabledSystem] AS [t0]
INNER JOIN [EmailOrganizer].[EmailingSystem] AS [t1] ON [t1].[ID] = [t0].[SystemID]
WHERE (LOWER(LTRIM(RTRIM([t0].[EmployeeID]))) IS NOT NULL)
AND (LOWER(LTRIM(RTRIM([t0].[EmployeeID]))) = @p0) AND
(NOT ([t1].[IsDeleted] = 1)) AND ([t1].[IsActive] = 1) AND (LOWER([t1].[SystemDescription]) IS NOT NULL)
AND (LOWER([t1].[SystemDescription]) = @p1)
AND ((NOT ([t0].[EnablingDate] IS NOT NULL)) OR (([t0].[EnablingDate] IS NOT NULL)
AND ((
    (CASE
        WHEN ([t0].[EnablingDate]) < @p2 THEN -1
        WHEN ([t0].[EnablingDate]) = @p2 THEN 0
        ELSE 1
     END)) > @p3)))
}

internal bool IsSystemDisabled(string employeeID, string systemDescription)
        {
            var x = (from esd in this.emailOrgDB.EmployeeDisabledSystems
                     where string.Equals(esd.EmployeeID.Trim().ToLower(), employeeID.Trim().ToLower()) &&
                     esd.EmailingSystem != null &&
                     !esd.EmailingSystem.IsDeleted &&
                     esd.EmailingSystem.IsActive &&
                     string.Equals(esd.EmailingSystem.SystemDescription.ToLower(), systemDescription.ToLower())
                     select esd);
            //   (esd.EnablingDate.HasValue == false ) ||
            //    (esd.EnablingDate.HasValue && DateTime.Compare(esd.EnablingDate.Value, DateTime.Now) > 1)
            //                                                                                               )
            //select esd);
            if (x.Where(p => !p.EnablingDate.HasValue).Any())
                return true;

            return x.Where(p => p.EnablingDate.HasValue && DateTime.Compare(DateTime.Now, p.EnablingDate.Value) == -1).Any();
        }