Hi!

I have a question about a bunch of services I work on.

Basically I have 4 stored procedures I will now design a service that will use them. But I am not sure if I really need to create a new service or if I can use an existing one.

The new procedures handle bonuses. Basically you can create a bonus and then add it to a specific user.

There already is an existing user service. So I am thoughtful about if I should add these methods

- create bonus
- delete bonus
- get bonuses

to the existing user service or if I should create a new bonus service.

What is the general patter to use when designing services like this? That have dependencies on other entities in the database.

Other examples are block lists. It is possible to block a user by adding it to a block list. There are three tables in the database that are affected by this.

BLOCK_REASONS

USER

USERS_BLOCKED (FK to USERS and BLOCK_REASONS + comment and date field)

The first table contain all block reasons that you select in a drop down list when you are about to block a user. And the USER table consist of the user to be blocked and the USERS_BLOCKED contain all blocked users along with dates and comment fields.

How should this be designed in the SOA? What services a and methods should you design for this?

kind regards
Henrik