HTL Class Numbers

[kutting]

A Heavy that is part of an HTL (HCL) actually has two class numbers, one for the Heavy and one for the HTL. Currently, there is no way to track HTL Class Numbers in Event manager.

[kutting]

There are a number of possible ways to address this. The simplest is to have the GROM put a brief statement on the HTL class number into the Event Description or Notes. Another is to add a second class number field to Events, and allow users to type any number into any Event. Or you could restrict it to just Heavys. Or just events with records in the Event.EventCrossSellEvent table. Another is to add an optional Class Number field to the Event.EventCrossSellEvent itself. The UI would enforce a single value for the cross-sold events. Another is to add a sort of parallel table like EventCrossSellEvent specifically for HCLs. Perhaps like: HCLEventId HCLClassNumber HeavyEventId ToughEventId LightEventId

Design Questions: Does anyone want to do any searching on this number, e.g. to figure out what the next available number is?

[kutting]

Add field to Event.EventCrossSellEvent, Add input to Cross-Sell tab of Event Display Group Event Number in Event History Report On Cadre's Assignents table, show Class Number, and Group Class Number. Also, replace Capacity column with names of all cadre assigned to event.

[kutting]

Table Changes (Event.EventGroup) Modified: Event.CadreAssignedSearchAllByCadreId Event.CadreCompletedSearchAllByCadreId Report.EventHistory New: Event.EventGroupUpsert Event.EventGroupGet