Improve the MagmaCoreService

[twalmsley]

• Try to make the methods more coherent.
• Add manual transaction control.
• Add javadoc to the class to explain when to use manual vs automatic transaction control.
• Consider using a separate class to replace all the find* methods.