namespace OKRDAL.QueryBuilders;

public static class OKRPerspectiveQB
{
    public const string GET_PERSPECTIVE = @"
        SELECT  p.PERSPECTIVEID  AS PerspectiveId,
                p.CODE           AS Code,
                p.NAME           AS Name,
                p.DISPLAYORDER   AS DisplayOrder,
                p.STATUS         AS Status,
                p.TENANTID       AS TenantId
        FROM    MOKRPERSPECTIVE p
        WHERE   p.PERSPECTIVEID = @PerspectiveId
        AND     p.TENANTID      = @TenantId";

    public const string GET_PERSPECTIVE_LIST = @"
        SELECT  p.PERSPECTIVEID  AS PerspectiveId,
                p.CODE           AS Code,
                p.NAME           AS Name,
                p.DISPLAYORDER   AS DisplayOrder,
                p.STATUS         AS Status,
                p.TENANTID       AS TenantId
        FROM    MOKRPERSPECTIVE p
        WHERE   p.TENANTID = @TenantId
        AND     p.STATUS   = 1
        ORDER BY p.DISPLAYORDER";

    public const string INSERT_PERSPECTIVE = @"
        INSERT INTO MOKRPERSPECTIVE
               (PERSPECTIVEID, CODE, NAME, DISPLAYORDER, STATUS, TENANTID)
        VALUES (@PerspectiveId, @Code, @Name, @DisplayOrder, @Status, @TenantId)";

    public const string UPDATE_PERSPECTIVE = @"
        UPDATE MOKRPERSPECTIVE
        SET    CODE         = @Code,
               NAME         = @Name,
               DISPLAYORDER = @DisplayOrder,
               STATUS       = @Status
        WHERE  PERSPECTIVEID = @PerspectiveId
        AND    TENANTID      = @TenantId";
}