namespace CMSDAL.Query.Navigation;
public static class NavigationQB
{
    public const string GET_NAVIGATION = @"
        SELECT
            n.NAVIGATIONID     AS NavigationId,
            n.SITEID           AS SiteId,
            n.NAVIGATIONCODE   AS NavigationCode,
            n.NAVIGATIONNAME   AS NavigationName,
            n.STATUS           AS Status,
            n.TENANTID         AS TenantId,
            n.CREATEDBYID      AS CreatedById,
            n.CREATEDON        AS CreatedOn,
            n.MODIFIEDBYID     AS ModifiedById,
            n.MODIFIEDON       AS ModifiedOn
        FROM DBO.MCMSNAVIGATION n
        WHERE n.NAVIGATIONID = @NavigationId AND n.TENANTID = @TenantId";

    public const string GET_BY_SITE = @"
        SELECT
            n.NAVIGATIONID   AS NavigationId, n.SITEID AS SiteId,
            n.NAVIGATIONCODE AS NavigationCode, n.NAVIGATIONNAME AS NavigationName,
            n.STATUS AS Status
        FROM DBO.MCMSNAVIGATION n
        WHERE n.SITEID = @SiteId AND n.TENANTID = @TenantId AND n.STATUS = 1
        ORDER BY n.NAVIGATIONNAME";

    public const string SAVE_NAVIGATION = @"
        INSERT INTO DBO.MCMSNAVIGATION
            (SITEID, NAVIGATIONCODE, NAVIGATIONNAME, STATUS, TENANTID,
             CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON)
        VALUES
            (@SiteId, @NavigationCode, @NavigationName, @Status, @TenantId,
             @CreatedById, @CreatedOn, @ModifiedById, @ModifiedOn);
        SELECT SCOPE_IDENTITY();";

    public const string UPDATE_NAVIGATION = @"
        UPDATE DBO.MCMSNAVIGATION
        SET
            NAVIGATIONCODE = @NavigationCode,
            NAVIGATIONNAME = @NavigationName,
            STATUS = @Status,
            MODIFIEDBYID = @ModifiedById,
            MODIFIEDON = @ModifiedOn
        WHERE NAVIGATIONID = @NavigationId AND TENANTID = @TenantId";

    public const string DELETE_NAVIGATION = @"
        UPDATE DBO.MCMSNAVIGATION SET STATUS = 0, MODIFIEDBYID = @ModifiedById, MODIFIEDON = GETDATE()
        WHERE NAVIGATIONID = @NavigationId AND TENANTID = @TenantId";

    // Used by the cross-tenant guard — deliberately NOT filtered by caller-claimed TenantId,
    // so BLL can verify a referenced NavigationId's true owner before attaching an item to it.
    public const string GET_NAVIGATION_TENANT = @"
        SELECT TENANTID FROM DBO.MCMSNAVIGATION WHERE NAVIGATIONID = @NavigationId";
}