namespace CMSDAL.Query.RenderingProfile;
public static class RenderingProfileQB
{
    public const string GET_LIST = @"
        SELECT RENDERINGPROFILEID AS RenderingProfileId, PROFILECODE AS ProfileCode,
               PROFILENAME AS ProfileName, OUTPUTTYPE AS OutputType, STATUS AS Status
        FROM DBO.MRENDERINGPROFILE
        WHERE TENANTID = @TenantId AND STATUS = 1
        ORDER BY PROFILENAME";

    public const string GET_SELECT_LIST = @"
        SELECT RENDERINGPROFILEID AS RenderingProfileId, PROFILECODE AS ProfileCode,
               PROFILENAME AS ProfileName, OUTPUTTYPE AS OutputType
        FROM DBO.MRENDERINGPROFILE
        WHERE TENANTID = @TenantId AND STATUS = 1
        ORDER BY PROFILENAME";

    public const string INSERT = @"
        INSERT INTO DBO.MRENDERINGPROFILE (PROFILECODE, PROFILENAME, OUTPUTTYPE, DESIGNSYSTEMID, TEMPLATEJSON, STATUS, TENANTID, CREATEDBYID, MODIFIEDBYID)
        VALUES (@ProfileCode, @ProfileName, @OutputType, @DesignSystemId, @TemplateJson, @Status, @TenantId, @CreatedById, @ModifiedById)";

    public const string UPDATE = @"
        UPDATE DBO.MRENDERINGPROFILE SET PROFILENAME=@ProfileName, OUTPUTTYPE=@OutputType,
               DESIGNSYSTEMID=@DesignSystemId, TEMPLATEJSON=@TemplateJson, STATUS=@Status,
               MODIFIEDBYID=@ModifiedById, MODIFIEDON=GETDATE()
        WHERE RENDERINGPROFILEID=@RenderingProfileId AND TENANTID=@TenantId";

    public const string INSERT_OUTPUT = @"
        INSERT INTO DBO.TCONTENTOUTPUT (CONTENTID, RENDERINGPROFILEID, STATUS, TENANTID, CREATEDBYID)
        VALUES (@ContentId, @RenderingProfileId, 0, @TenantId, @CreatedById)";

    public const string UPDATE_OUTPUT_STATUS = @"
        UPDATE DBO.TCONTENTOUTPUT SET STATUS=@Status, MODIFIEDON=GETDATE()
        WHERE CONTENTOUTPUTID=@ContentOutputId AND TENANTID=@TenantId";
}