Need help on coordinating parts of program please
Program type: preferably windows service
<<Program Description>>
Part 1: polls sql table for recs with certain criteria (needs to check every minute or so)
Part 2: If part 1 finds recs that match, then part 2 needs to retrieve those records and do some work to them. (convert the records data into a xml document)
Part 3: The newly created xml document needs posted to a clients website (which gives a response of an error code or confirmation #)
Part 4: The original sql record needs updated with the confirmation and a flag signifying the task is done.
I am having problems figuring out how this should be done.. for instance if part 1 is checking every minute by using a timer if parts 2 - 4 haven't completed after part 1 has notified them the first time it might try to notify about the same records again
How would you keep everything organized
|