namespace MarketingDAL.Query.GrowthPlay;

/// <summary>SQL constants for MGROWTHPLAY — MarketMind AI GrowthPlay data. No inline SQL elsewhere.</summary>
public static class GrowthPlayQB
{
    public const string GET_GROWTHPLAY = @"
SELECT
    G.GROWTHPLAYID       AS GrowthPlayId,
    G.GROWTHPLAYCODE     AS GrowthPlayCode,
    G.GROWTHPLAYNAME     AS GrowthPlayName,
    G.HYPOTHESISTEXT     AS HypothesisText,
    G.SEGMENTID          AS SegmentId,
    S.SEGMENTCODE        AS SegmentCode,
    S.SEGMENTNAME        AS SegmentName,
    G.GROWTHPLAYSTATUS   AS GrowthPlayStatus,
    G.STARTDATE          AS StartDate,
    G.ENDDATE            AS EndDate,
    G.RESULTTEXT         AS ResultText,
    G.REMARKS            AS Remarks,

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

    G.SORTORDER          AS SortOrder,
    G.STATUS             AS Status,
    G.VERSION            AS Version,
    G.TENANTID           AS TenantId
FROM MGROWTHPLAY G
LEFT JOIN MSEGMENT S ON S.SEGMENTID = G.SEGMENTID
LEFT JOIN MUSER CB ON CB.USERID = G.CREATEDBYID
LEFT JOIN MUSER MB ON MB.USERID = G.MODIFIEDBYID
WHERE G.GROWTHPLAYID = @GrowthPlayId;
";

    public const string SAVE_GROWTHPLAY = @"
INSERT INTO MGROWTHPLAY (
    GROWTHPLAYID, GROWTHPLAYCODE, GROWTHPLAYNAME, HYPOTHESISTEXT, SEGMENTID, GROWTHPLAYSTATUS,
    STARTDATE, ENDDATE, RESULTTEXT, REMARKS,
    CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON, SORTORDER, STATUS, VERSION, TENANTID
)
VALUES (
    @GrowthPlayId, @GrowthPlayCode, @GrowthPlayName, @HypothesisText, @SegmentId, @GrowthPlayStatus,
    @StartDate, @EndDate, @ResultText, @Remarks,
    @CreatedById, @CreatedOn, @ModifiedById, @ModifiedOn, @SortOrder, @Status, @Version, @TenantId
);
";

    public const string UPDATE_GROWTHPLAY = @"
UPDATE MGROWTHPLAY
SET
    GROWTHPLAYCODE     = @GrowthPlayCode,
    GROWTHPLAYNAME     = @GrowthPlayName,
    HYPOTHESISTEXT     = @HypothesisText,
    SEGMENTID          = @SegmentId,
    GROWTHPLAYSTATUS   = @GrowthPlayStatus,
    STARTDATE          = @StartDate,
    ENDDATE            = @EndDate,
    RESULTTEXT         = @ResultText,
    REMARKS            = @Remarks,
    MODIFIEDBYID       = @ModifiedById,
    MODIFIEDON         = @ModifiedOn,
    SORTORDER          = @SortOrder,
    STATUS             = @Status,
    VERSION            = @Version
WHERE GROWTHPLAYID = @GrowthPlayId;
";

    public const string DELETE_GROWTHPLAY = @"
DELETE FROM MGROWTHPLAY
WHERE GROWTHPLAYID = @GrowthPlayId;
";

    public const string GET_SELECTLIST_GROWTHPLAY = @"
SELECT
    GROWTHPLAYID    AS Id,
    GROWTHPLAYCODE  AS Code,
    GROWTHPLAYNAME  AS Name
FROM MGROWTHPLAY
WHERE STATUS = 1
ORDER BY GROWTHPLAYNAME;
";
}