Advise on real time updates

Hot Topic

New Window
Changing Computer's Regional Setting Causes Lock Problems On Databound Controls
Is it possible to deploy Application using Windows Installer and upgrade it by clickonce?
XPanderControl
Save DataTable to dbf file
Determining Drive type at runtime
Redrawing buttons...using inheritance
Persist Hashtable property
windows distributed application and web application
ListView Grouping

Windows Forms

Extracting Email Ids from the emails
How to make a process.start as a showdialog??
Terrarium 1.2 not showing any text on buttons?
Can't DataBind Combobox (System.Data.DataRowView)
Desktop Shortcut
Hierarchical datagrid from one datatable
Don´t allow an application to be launched twice
ProcessStartInfo - Execute it in Hidden Window
Searching on a Column in a Datagrid
***FIX*** Error installing Winforms 2.0 application with ClickOnce deployment

Advise on real time updates

Hi guys, need your advice. Bascially I have built a Online Cinema Seat Reservation system using VB.NET Windows Forms. The system will be installed on probably 10 terminals.

e.g. Imagine going to a cinema booth and you see 10 ticket operators. Bascially what I am trying to implement is real-time updates. Meaning, if one operator selects a particular seat, another operator on another terminal should not be able to select the same seat.

I have considered employing an event listener that will listen forever but I suppose its extremely resource hogging and not productive at all.

Any kind advice to implement the above

Answer this question

Advise on real time updates

  • theguy2042000

    I understand that when looking at concurrency, it will be triggered from the database point of view and I totally agree that this is a good approach. However, on the client side, I wish to for eg, For 2 ticket operators having the same seat layout, when 1 operator selects a seat, the particular seat is instanteously shown as blocked in both operators screens.

    Probably, to explain in more detail, when a seat is selected, the seat colour is changed to red. When it is blocked, the seat button is just disabled. So i was looking at disabling the particular seat button across all screens whenever an operator selects the seat first.


    Any further advise As in what kind of programming approach should I look into for Windows Forms

  • JFS

    Take a look at this pattern: Pessimistic offline lock

    You might want to pick up Fowler's Patterns of Enterprise Application Architecture



  • GaneshMoorthy MC

    By the way, the "Offline Concurrency Patterns" section is the longest (after Object-Relational mapping) in the book.

  • Radhi

  • Advise on real time updates
Answer this question