c# - Multi User Editing -
i have system show warning user if there try , edit record been edited. if case user not able save record view it.
i have idea of using kind of class monitor activity of records been edited etc seams little on kill. my other concern if browser crashes or there shut computer down on how effect state of page.
another thought use last updated time stamp looks no go because way records been updated.
has got thoughts or resources on how implement this. no code necessary.
based on comments have added these additional details. database sql server 2008 asp.net 3.5 1 record many parts of database instance, booking table session table , row in interrupter table.
the user @ list of sessions need booking select booking , fill out booking form make booking. want stop else trying same booking @ same time or while else doing booking.
esentially maintain edit
(lookup) table in sql database comprising 4 fields userid, action, entityid , datestamp
, link each associated page , editable item.
so, example if user on edit foo webpage , clicks edit
link, program perform lookup of edit
table , if nobody else editing record insert, i.e: 4, 'edit foo', 123, getutcdate()
123 id of foo
being edited.
there many further functions process, example, if user in edit mode length of time record automatically removed table , item becomes editable again.
however, solution works in high use environment. hope idea.
Comments
Post a Comment