animallocation: write entries for death and exit

[bobintetley]

animallocation records need to be written when an exit movement is recorded and when the animal dies.

Primary reason is so that reports on animallocation do not need to look elsewhere and do union queries to fill in this data, like the "animal location history" report does.

Keeping the two in sync is going to be difficult. Add two new columns to animallocationhistory:

MovementID int
IsDeath int

This will make it easier for the update code to find the existing record and update it if necessary

[bobintetley]

No, it's a lot easier to just write this into the report. I used a simple coalesce to pick the next animallocation, movement or death date.

[bobintetley]

A similar exit needs to be written for when boarding records end as well possibly which would mean an AnimalBoardingID column. Are we already writing an animallocation row into the internal location when boarding starts?