namespace FMDAL.Query.AssetTypeActivity
{
    // Confirmed against the real MASSETTYPEACTIVITY DDL via the legacy NHibernate mapping
    // (DAL/FMDAL/HibernateMapFile/AssetTypeActivity.hbm.xml). Note the real PK column is
    // ASSETTYPEACTIIVTYID (typo preserved from the legacy schema, not a transcription error here).
    // No STATUS/VERSION/CREATEDBYID/etc — this table genuinely carries no audit trail, confirmed
    // by both the mapping and the existing AssetTypeActivityDTO's matching absence of those fields.
    public static class AssetTypeActivityQB
    {
        public const string GET_ASSETTYPEACTIVITY = @"SELECT
                ATA.ASSETTYPEACTIIVTYID AS AssetTypeActivityId,
                ATA.ASSETTYPEID         AS AssetTypeId,
                ATA.SLNO                AS AssetTypeActivitySlno,
                ATA.ACTIVITYID          AS ActivityId,
                ATA.FREQUENCY           AS AssetTypeActivityFrequency,
                ATA.PERIOD              AS AssetTypeActivityPeriod,
                ATA.DURATION            AS AssetTypeActivityDuration
            FROM MASSETTYPEACTIVITY ATA
            WHERE ATA.ASSETTYPEACTIIVTYID = @AssetTypeActivityId;";

        public const string GET_ASSETTYPEACTIVITY_LIST_BY_ASSETTYPE = @"SELECT
                ATA.ASSETTYPEACTIIVTYID AS AssetTypeActivityId,
                ATA.ASSETTYPEID         AS AssetTypeId,
                ATA.SLNO                AS AssetTypeActivitySlno,
                ATA.ACTIVITYID          AS ActivityId,
                ATA.FREQUENCY           AS AssetTypeActivityFrequency,
                ATA.PERIOD              AS AssetTypeActivityPeriod,
                ATA.DURATION            AS AssetTypeActivityDuration
            FROM MASSETTYPEACTIVITY ATA
            WHERE ATA.ASSETTYPEID = @AssetTypeId
            ORDER BY ATA.SLNO;";

        public const string SAVE_ASSETTYPEACTIVITY = @"INSERT INTO MASSETTYPEACTIVITY (
                ASSETTYPEACTIIVTYID, ASSETTYPEID, SLNO, ACTIVITYID, FREQUENCY, PERIOD, DURATION)
            VALUES (
                @AssetTypeActivityId, @AssetTypeId, @AssetTypeActivitySlno, @ActivityId,
                @AssetTypeActivityFrequency, @AssetTypeActivityPeriod, @AssetTypeActivityDuration);";

        public const string UPDATE_ASSETTYPEACTIVITY = @"UPDATE MASSETTYPEACTIVITY SET
                ASSETTYPEID = @AssetTypeId, SLNO = @AssetTypeActivitySlno, ACTIVITYID = @ActivityId,
                FREQUENCY = @AssetTypeActivityFrequency, PERIOD = @AssetTypeActivityPeriod, DURATION = @AssetTypeActivityDuration
            WHERE ASSETTYPEACTIIVTYID = @AssetTypeActivityId;";

        public const string DELETE_ASSETTYPEACTIVITY = @"DELETE FROM MASSETTYPEACTIVITY
            WHERE ASSETTYPEACTIIVTYID = @AssetTypeActivityId;";
    }
}