Unnecessary duplicate database lookups

[LeoCodes21]

There are several places in the code where the same entity is fetched by primary key more than once. This is an obvious performance issue that can be alleviated by passing around entities rather than IDs.