namespace KmsDAL.Query.KmGovernance
{
    public static class KmGovernanceQB
    {
        public const string INSERT_GOVERNANCE_TRANSITION = @"
            INSERT INTO KMS.LKMGOVERNANCE
                (ARTIFACTID, FROMSTATE, TOSTATE, TRANSITIONEDBYID, TRANSITIONEDON,
                 NOTES, REJECTIONREASON, CREATEDBYID, CREATEDON)
            VALUES
                (@ArtifactId, @FromState, @ToState, @TransitionedById, GETDATE(),
                 @Notes, @RejectionReason, @CreatedById, GETDATE())";

        public const string GET_GOVERNANCE_HISTORY = @"
            SELECT  g.LKMGOVERNANCEID  AS LkmGovernanceId,
                    g.ARTIFACTID       AS ArtifactId,
                    g.FROMSTATE        AS FromState,
                    g.TOSTATE          AS ToState,
                    g.TRANSITIONEDBYID AS TransitionedById,
                    g.TRANSITIONEDON   AS TransitionedOn,
                    g.NOTES            AS Notes,
                    g.REJECTIONREASON  AS RejectionReason
            FROM    KMS.LKMGOVERNANCE g
            WHERE   g.ARTIFACTID = @ArtifactId
            ORDER BY g.TRANSITIONEDON ASC";

        public const string INSERT_ARTIFACT_VERSION = @"
            INSERT INTO KMS.MKMARTIFACTVERSION
                (ARTIFACTID, VERSIONNUMBER, SNAPSHOTJSON, GOVERNANCESTATE,
                 CHANGESUMMARY, CREATEDBYID, CREATEDON)
            VALUES
                (@ArtifactId, @VersionNumber, @SnapshotJson, @GovernanceState,
                 @ChangeSummary, @CreatedById, GETDATE())";

        public const string GET_ARTIFACT_CURRENT_STATE = @"
            SELECT GOVERNANCESTATE, VERSIONNUMBER, OWNERUSERID, REVIEWERUSERID, TENANTID
            FROM   KMS.MKMARTIFACT
            WHERE  ARTIFACTID = @ArtifactId
            AND    TENANTID   = @TenantId
            AND    STATUS     NOT IN (2)";

        public const string INCREMENT_ARTIFACT_VERSION = @"
            UPDATE KMS.MKMARTIFACT
            SET    VERSIONNUMBER  = VERSIONNUMBER + 1,
                   MODIFIEDBYID  = @ModifiedById,
                   MODIFIEDON    = GETDATE()
            WHERE  ARTIFACTID = @ArtifactId
            AND    TENANTID   = @TenantId";
    }
}