[Cleanup] Improve Repository Layer

[marcelfolaron]

There are various improvement needs to our repository layer:

Repositories
Interface: IRepository (query, get, create, update, patch, delete)

Returns
Collection (search() )
T (get())
Bool (delete(), update(), patch )
Int (create() )

In case of failures it would throw exceptions
Additionally we should split up some of the queries. Our repo return objects are quite large and often times contain various domain objects (tickets and projects for example).
Instead the repos should focus on the objects they are dealing with. The services can then concatenate the data from multiple repositories if needed. With our move to htmx we may not actually need to do that very often and can just kick of an asynchronous call.