|1/3/20||Documentation||SQL Server & IIS installation instructions added|
|1/3/20||Database||Bug found in [BROE].[List Entries Refunded Online] (only applies to BRC events with discounted entry fees).
We need to get the refund amount from BROE, not the local discounted rate...
Bedford RC gives a discount to its members. If the payment is recorded as manual (ie BACS Transfer, cash, cheque) then the discounted rate is used. If it is Online (ie Stripe payment), then the rate used is that defined on BROE.
|29/2/20||BROE API||Payment Type is the wrong way around in the API export - 'Manual' & 'Online' refer to Online & Manual, respectively.|
|22/2/20||Docs||The key to good documentation is having screenshots. I have therfore obfuscated names in an ENTIRE regatta - nobody is identifiable.|
|21/2/20||Database||ALL Stored Procedures have finally been removed from the dbo schema.|
[List - Statuses in Draw on Specified Day] & [List - Statuses in Draw on Specified Day (Divisional)] have been removed and been replaced by [Regatta.PostDraw].[ListStatuses]
It turned out that ASPX needed both due to a bug! statuses.aspx was flawed...
|21/2/20||Head Draw||Abingdon are pressing me for a build. So I have bitten the bullet, and removed StatusID from [Head.StartOrder]. This is painful, and it turns out that there are quite a few queries that all appear to do pretty much the same thing. [head].[GenerateRandomDraw] appears to be the most complete & logically written.|
|20/2/20||EventCreation||GetStatusID did not handle primary correctly; GetStatusDescription didn't handle Lightweights.|
|11/1/20||Race Manager||Head Timing now available here. Can't figure out a way of displaying start time less than finish time though...|
|9/1/20||Database||The Changes table requires wider fields, since Stowe have decided that their crew name contains ALL crew members. 134 characters long.|