refactored transactions all work except Show.get()
updated corresponding transaction calls