namespace FAMDAL.Query.AssetSchedule
{
    // Confirmed against the real MASSETSCHEDULE DDL (no TENANTID column — global master).
    public static class AssetScheduleQB
    {
        public const string GET_ASSETSCHEDULE = @"SELECT
                AS_.ASSETSCHEDULEID          AS AssetScheduleId,
                AS_.ASSETSCHEDULECODE        AS AssetScheduleCode,
                AS_.ASSETSCHEDULENAME        AS AssetScheduleName,
                AS_.MAINHEAD                 AS AssetScheduleMainHead,
                AS_.SUBHEAD                  AS AssetScheduleSubHead,
                AS_.SECTION                  AS AssetScheduleSection,
                AS_.ISEXTRASHIFT             AS AssetScheduleIsExtraShift,
                AS_.STANDARDUSEFULLLIFE      AS AssetScheduleStandardUsefullLife,
                AS_.ACTUALUSEFULLLIFE        AS AssetScheduleActualUsefullLife,
                AS_.WDVPERCENTAGE            AS AssetScheduleWDVPercentage,
                AS_.SLPERCENTAGE             AS AssetScheduleSLPercentage,
                AS_.REMARKS                  AS AssetScheduleRemarks,
                AS_.SORTORDER                AS AssetScheduleSortOrder,
                AS_.STATUS                   AS AssetScheduleStatus,
                AS_.VERSION                  AS AssetScheduleVersion,
                AS_.SOURCETYPE               AS AssetScheduleSourceType,
                AS_.CREATEDBYID              AS AssetScheduleCreatedById,
                AS_.CREATEDON                AS AssetScheduleCreatedOn,
                AS_.MODIFIEDBYID             AS AssetScheduleModifiedById,
                AS_.MODIFIEDON               AS AssetScheduleModifiedOn
            FROM MASSETSCHEDULE AS_
            WHERE AS_.ASSETSCHEDULEID = @AssetScheduleId;";

        public const string SAVE_ASSETSCHEDULE = @"INSERT INTO MASSETSCHEDULE (
                ASSETSCHEDULEID, ASSETSCHEDULECODE, ASSETSCHEDULENAME, MAINHEAD, SUBHEAD, SECTION,
                ISEXTRASHIFT, STANDARDUSEFULLLIFE, ACTUALUSEFULLLIFE, WDVPERCENTAGE, SLPERCENTAGE,
                REMARKS, SORTORDER, STATUS, VERSION, SOURCETYPE,
                CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON)
            VALUES (
                @AssetScheduleId, @AssetScheduleCode, @AssetScheduleName, @AssetScheduleMainHead, @AssetScheduleSubHead, @AssetScheduleSection,
                @AssetScheduleIsExtraShift, @AssetScheduleStandardUsefullLife, @AssetScheduleActualUsefullLife, @AssetScheduleWDVPercentage, @AssetScheduleSLPercentage,
                @AssetScheduleRemarks, @AssetScheduleSortOrder, @AssetScheduleStatus, @AssetScheduleVersion, @AssetScheduleSourceType,
                @AssetScheduleCreatedById, @AssetScheduleCreatedOn, @AssetScheduleModifiedById, @AssetScheduleModifiedOn);";

        public const string UPDATE_ASSETSCHEDULE = @"UPDATE MASSETSCHEDULE SET
                ASSETSCHEDULECODE = @AssetScheduleCode,
                ASSETSCHEDULENAME = @AssetScheduleName,
                MAINHEAD = @AssetScheduleMainHead,
                SUBHEAD = @AssetScheduleSubHead,
                SECTION = @AssetScheduleSection,
                ISEXTRASHIFT = @AssetScheduleIsExtraShift,
                STANDARDUSEFULLLIFE = @AssetScheduleStandardUsefullLife,
                ACTUALUSEFULLLIFE = @AssetScheduleActualUsefullLife,
                WDVPERCENTAGE = @AssetScheduleWDVPercentage,
                SLPERCENTAGE = @AssetScheduleSLPercentage,
                REMARKS = @AssetScheduleRemarks,
                SORTORDER = @AssetScheduleSortOrder,
                STATUS = @AssetScheduleStatus,
                VERSION = VERSION + 1,
                MODIFIEDBYID = @AssetScheduleModifiedById,
                MODIFIEDON = @AssetScheduleModifiedOn
            WHERE ASSETSCHEDULEID = @AssetScheduleId;";

        public const string DELETE_ASSETSCHEDULE = @"DELETE FROM MASSETSCHEDULE
            WHERE ASSETSCHEDULEID = @AssetScheduleId;";

        // CriteriaBuilder's ApplyCriteria wraps this in a derived table and strips table-alias
        // prefixes from the WHERE clause, so criteria FieldNames must resolve against the OUTER
        // SELECT aliases exposed here (Id/Code/Name) — which already match this picklist's shape.
        public const string GET_SELECTLIST_ASSETSCHEDULE = @"SELECT
                ASSETSCHEDULEID   AS Id,
                ASSETSCHEDULECODE AS Code,
                ASSETSCHEDULENAME AS Name
            FROM MASSETSCHEDULE
            WHERE STATUS = 1
            {DYNAMIC_WHERE}";
    }
}