using System;

namespace FrameworkDAL.Query.ECMRole
{
    public static class ECMRoleQB
    {
        public const string GET_ECMROLE = @"
            SELECT
                ER.ECMROLEID AS ECMRoleId,
                ER.ECMROLECODE AS ECMRoleCode,
                ER.ECMROLENAME AS ECMRoleName,
                ER.REMARKS AS ECMRoleRemarks,
                ER.OWNCONTENTRIGHTS AS ECMRoleOwnContentRights,
                ER.OTHERSCONTENTRIGHTS AS ECMRoleOthersContentRights,
                ER.SORTORDER AS ECMRoleSortOrder,
                ER.STATUS AS ECMRoleStatus,
                ER.VERSION AS ECMRoleVersion,
                ER.CREATEDBYID AS ECMRoleCreatedById,
                ER.CREATEDON AS ECMRoleCreatedOn,
                ER.MODIFIEDBYID AS ECMRoleModifiedById,
                ER.MODIFIEDON AS ECMRoleModifiedOn,
                ER.SOURCETYPE AS ECMRoleSourceType,
                ER.TENANTID AS TenantId
            FROM MECMROLE ER
            WHERE ER.ECMROLEID = @ECMRoleId;";

        public const string SAVE_ECMROLE = @"
            INSERT INTO MECMROLE(
               --ECMROLEID,
                ECMROLECODE,
                ECMROLENAME,
                REMARKS,
                OWNCONTENTRIGHTS,
                OTHERSCONTENTRIGHTS,
                SORTORDER,
                STATUS,
                VERSION,
                CREATEDBYID,
                CREATEDON,
                MODIFIEDBYID,
                MODIFIEDON,
                SOURCETYPE,
                TENANTID
            )
            VALUES(
                --@ECMRoleId,
                @ECMRoleCode,
                @ECMRoleName,
                @ECMRoleRemarks,
                @ECMRoleOwnContentRights,
                @ECMRoleOthersContentRights,
                @ECMRoleSortOrder,
                @ECMRoleStatus,
                @ECMRoleVersion,
                @ECMRoleCreatedById,
                @ECMRoleCreatedOn,
                @ECMRoleModifiedById,
                @ECMRoleModifiedOn,
                @ECMRoleSourceType,
                @TenantId
            );";

        public const string UPDATE_ECMROLE = @"
            UPDATE MECMROLE
            SET
                ECMROLECODE = @ECMRoleCode,
                ECMROLENAME = @ECMRoleName,
                REMARKS = @ECMRoleRemarks,
                OWNCONTENTRIGHTS = @ECMRoleOwnContentRights,
                OTHERSCONTENTRIGHTS = @ECMRoleOthersContentRights,
                SORTORDER = @ECMRoleSortOrder,
                STATUS = @ECMRoleStatus,
                VERSION = @ECMRoleVersion,
                CREATEDBYID = @ECMRoleCreatedById,
                CREATEDON = @ECMRoleCreatedOn,
                MODIFIEDBYID = @ECMRoleModifiedById,
                MODIFIEDON = @ECMRoleModifiedOn,
                SOURCETYPE = @ECMRoleSourceType,
                TENANTID = @TenantId
            WHERE ECMROLEID = @ECMRoleId;
        ";

        public const string DELETE_ECMROLE = @"
            DELETE FROM MECMROLE WHERE ECMROLEID = @ECMRoleId;
        ";
        public const string GET_SELECTLIST_ECMROLE = @"
WITH PagedEcmRole AS (
    SELECT
        ER.ECMROLEID AS id,
        ER.ECMROLECODE AS code,
        ER.ECMROLENAME AS name,
        ROW_NUMBER() OVER (ORDER BY ER.ECMROLEID) AS rowNum
    FROM MECMROLE ER
)
SELECT id, code, name
FROM PagedEcmRole
WHERE rowNum BETWEEN (@firstNumber + 1) AND (@firstNumber + @maxResult);";

    }
}