Hi,
   I am working on an app that will display the list of all scheduled call
records in our database to the users. All users of the application will see
the same list of call records and will select any record and try to call the
contact person for that record and edit the record. Now, my question is how
do I prevent more than one user from selecting the same call record and
calling the same person?

Thanks in advance.

I think the way I would probably approach this is as follows:

Each user has the list of calls. To begin a call, the user must double click
on the line in the list that corresponds to the person they want to call.

You immediately retrieve the record and check whether there is an operator
name attached to it. If not, you write this operators name to the database
(remembering to put a Where OpeatorName = '' in the SQL), checking to ensure
that the update works. IF the update fails, then someone else got in first,
so you tell the operator to pick another record.

If you were able to enter the operators name, then you pop up a window with
the call details, ready for the user to edit it. When they're finished, the
save or cancel and the window closes. At that stage, you save the data (if
requested). Presumably you also update a last contacted date to ensure that
the person isn't called again.

Only problem it gives you is where the operator does not close their system
properly and leaves with a record open. For this, I would probably also save
an "allocated to operator" date and time. Assuming no call takes more than
30 minutes, you could check, when you retrieve a record to see if the record
is over 30 minutes old. If it is, then reset the operator name and date and
assume the record isn't being attended to.

Hope that makes some sense.

Steve

Show quoteHide quote

Mark the record as 'IsCalled' or so when a user selects on.
After edit and Lost_Focus set the Mark back.
Also edit a dattime with it, in case something goes wrong.
All the IsCalled records older than 1 or 2 days need to be reset.

Something like that, maybe?



Show quoteHide quote

I would question the design a little. A simple example will perhaps help.
You have someone on your list who is called Rajakanistaremd
Juditrixidisticad. I will appear on everyones list every day and because the
users can pick and choose who they call I can bet that a year will go by and
no one will call that person. Generally call lists are done 2 ways. One is
to assign calls to a particular user. This is done if follow up calls need
to be performed by the same user. The other is a "Next Call" scenario where
you have to call the name the system gives you. Then you can prioritize the
calls so that for example a certain region or demographic can be put to the
top of the list and the user has no choice but to call who you want. This
also avoids alot of the concurrency issues that occur when you display data
but immediately that data is out of date.

SP

MS's Excruciating Update Cycles
Datagrid with VB 2005
Translation of CreateFile dll in dot net
My computer seems to be to slow to run VS2005
Late Binding Question
large arrays and system.outofmemoryexception
Calendar with custom tooltip over days with events
Is it possible to use Field Names instead of Item(0) with Data Row using VB.Net 2005 ?
Web Panel?
XML into datagrid