I am building a Time Card application. I have several collections
I have a gallery for the workorders and crew list
I have a colletion that created when selecting a crew member it knows who is selected and who is not
I have a variable created when a workorder is selected
Another variable is TimeType ST (Strait Time), OT (Over TIme), DT (Double Time)
Instance is equivelent to a date
When I select one or more crew members I try to use the ForAll to update any existing records in the collection for the same crew member on the same day and same work order I just want to update the Hours for that record, if there is no record I want to add a new record.
I first started out that if you select a work order from the work order gallery, then for when you select a crew member it will update an existing record if it exists or add a new record if it does not exist. That worked fine. This is all being done on the app locally. And when the day is done the user can push a button and all records get sent to a SQL Server on Premis.
I want to make a feature that the user first selects all the crew members that he wants to update or add a new record and then push a button and the ForAll will go through each employee that is selected and add it to the collection or update the collection.
I have been strugling with this for many hours and with no success.