Implement Database Transactions for Submission Operations

[leoraba]

Description
Implement database transactions when committing a Submission to ensure that all submission-related actions, including create, edit, and delete, are executed within the scope of a single database transaction. This will guarantee atomicity, ensuring that either all changes within a submission are successfully applied or, in the event of an error, none of the changes are committed. This approach will prevent partial updates and ensure data consistency across submission operations.