struct insert use db transaction

[mnasruls]

is it possible to use db transaction using struct insert? because it's confussing when i want to start transaction in handler and i want to execute the query in repository. if it possible, how can i implement to my code?

I'm trying to implement it in my code like the picture below, but I'm a bit unsure if my implementation is good or not.