namespace AutomationDAL.Query.Calendar;

public static class CalendarCheckQB
{
    // MCALENDAR/MCALENDARDETAIL is not employee-scoped — CALENDARID is already used as a direct
    // FK on MORGANIZATIONUNIT/MDEPARTMENT/MLOCATION (see PayRollDAL/Query/TeamCalendar/TeamCalendarQB.cs
    // for the proven zero-employee-join pattern this mirrors). DETAILTYPE = 0 marks a holiday.
    public const string IS_HOLIDAY = @"
        SELECT CASE WHEN EXISTS (
            SELECT 1
            FROM   MCALENDARDETAIL
            WHERE  CALENDARID = @CalendarId
            AND    DETAILDATE = @CheckDate
            AND    DETAILTYPE = 0
        ) THEN 1 ELSE 0 END";
}