DylanZeller / INFO315GroupProject

Info 315 Group Project
1 stars 0 forks source link

Implement Working triggers for Database #7

Open DylanZeller opened 3 years ago

DylanZeller commented 3 years ago

Need to research how this is done with sqlite, or we can do some handler in the Database wrapper class.

DylanZeller commented 3 years ago

First Trigger could be When a Billable Items row is added to the database, we need to update the totalAmt on the Invoice linked to the billable items.

DylanZeller commented 3 years ago

2) When a payment is made to an invoice, then send an email to the business representative with the payment amount made and the new balance that is owed to the consulting firm.

DylanZeller commented 3 years ago

Not doing email, but balance update when payment is made complete.