Modernize/Update database procedures

[johnhenley]

Description of task

A number of issues/pull requests are impacting the legacy stored procedures. In particular,

• cascading deletes were added (Add table relationships to use cascading deletes #217), so where previously there were a number of DELETE commands in a stored procedure, those may not be required anymore.
• as entities are modernized (Refactor/Modernize Entities and Controllers #266) to use DAL2 for simple database CRUD operations, some stored procedures can be removed or simplified.

Note that this does not imply that existing stored procedures are incorrect or broken, just that there are opportunities for improvement to the overall code base.

This issue is a placeholder/reference for related pull requests.

What general area(s)/component(s) are affected?

[] User interface
[X] Database schema
[] Business Logic
[] Dependencies
[] Installation/manifest

[WillStrohl]

This sounds like a no-brainer to address. Do you already have an idea of what the effort might be to get this one completed?

[johnhenley]

This sounds like a no-brainer to address. Do you already have an idea of what the effort might be to get this one completed?

@WillStrohl with this module, nothing is a no-brainer 😀

This issue is really just a placeholder/stake to remind us of more work to be done after the major refactoring is done in #266 #264. It will be a matter of

• reviewing/updating database dependencies graph and determining which cascading deletes supersede need for separate deletes from code or stored procedures
• as entities (at least simple ones) are moved to use repository/DAL2 in Refactor/Modernize Entities and Controllers #266, removing simple CRUD stored procedures. I'm working on that part now.