Add Transaction Support #716
Description
User story
Refactor the older services and controllers to remove the deprecated solutions and add transaction support to all methods that use multiple modifying db operations.
Acceptance criteria
Tests need to be green after the refactor as well.