namespace MarketingDAL.Query.EmotionalDriver;

/// <summary>SQL constants for MEMOTIONALDRIVER — MarketMind AI emotional driver master data.</summary>
public static class EmotionalDriverQB
{
    public const string GET_EMOTIONALDRIVER = @"
SELECT
    E.EMOTIONALDRIVERID   AS EmotionalDriverId,
    E.PERSONAID           AS PersonaId,
    P.PERSONACODE         AS PersonaCode,
    P.PERSONANAME         AS PersonaName,
    E.[TRIGGER]           AS [Trigger],
    E.RESPONSE            AS Response,
    E.INTENSITYRATING     AS IntensityRating,

    E.CREATEDBYID         AS CreatedById,
    E.CREATEDON           AS CreatedOn,
    CB.USERNAME           AS CreatedByName,
    E.MODIFIEDBYID        AS ModifiedById,
    E.MODIFIEDON          AS ModifiedOn,
    MB.USERNAME           AS ModifiedByName,

    E.SORTORDER           AS SortOrder,
    E.STATUS              AS Status,
    E.VERSION             AS Version,
    E.TENANTID            AS TenantId
FROM MEMOTIONALDRIVER E
LEFT JOIN MPERSONA P ON P.PERSONAID = E.PERSONAID
LEFT JOIN MUSER CB ON CB.USERID = E.CREATEDBYID
LEFT JOIN MUSER MB ON MB.USERID = E.MODIFIEDBYID
WHERE E.EMOTIONALDRIVERID = @EmotionalDriverId;
";

    public const string SAVE_EMOTIONALDRIVER = @"
INSERT INTO MEMOTIONALDRIVER (
    EMOTIONALDRIVERID, PERSONAID, [TRIGGER], RESPONSE, INTENSITYRATING,
    CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON, SORTORDER, STATUS, VERSION, TENANTID
)
VALUES (
    @EmotionalDriverId, @PersonaId, @Trigger, @Response, @IntensityRating,
    @CreatedById, @CreatedOn, @ModifiedById, @ModifiedOn, @SortOrder, @Status, @Version, @TenantId
);
";

    public const string UPDATE_EMOTIONALDRIVER = @"
UPDATE MEMOTIONALDRIVER
SET
    PERSONAID         = @PersonaId,
    [TRIGGER]         = @Trigger,
    RESPONSE          = @Response,
    INTENSITYRATING   = @IntensityRating,
    MODIFIEDBYID      = @ModifiedById,
    MODIFIEDON        = @ModifiedOn,
    SORTORDER         = @SortOrder,
    STATUS            = @Status,
    VERSION           = @Version
WHERE EMOTIONALDRIVERID = @EmotionalDriverId;
";

    public const string DELETE_EMOTIONALDRIVER = @"
DELETE FROM MEMOTIONALDRIVER
WHERE EMOTIONALDRIVERID = @EmotionalDriverId;
";

    public const string GET_SELECTLIST_EMOTIONALDRIVER = @"
SELECT
    EMOTIONALDRIVERID   AS Id,
    [TRIGGER]           AS Code,
    RESPONSE            AS Name
FROM MEMOTIONALDRIVER
WHERE STATUS = 1
ORDER BY EMOTIONALDRIVERID;
";
}