What would be the best approach to implement a realtime reservation system?

Question

0.00/5 (No votes)

See more:

What would be the best approach to implement a realtime reservation system?

So what I would need is the system should not allow two people to select a seat (say seat no :10) at the same time and also it should lock the seat for sometime (if the seat is selected by someone) till he finish his transaction.

Please suggest best approached to meet this.

Looking forward to get this done using asp.net and c# (with the assistance of jquery /signalr)

Thanks,
Vinod

Posted 11-Sep-13 23:14pm

vinod chattergee

Updated 12-Sep-13 2:15am

v3

Add a Solution

Comments

Richard MacCutchan 12-Sep-13 5:59am

This question is far too broad for a quick answers forum. There is much more to a seat reservation system than simply preventing two users from trying to allocate the same seat. You require a complete analysis of the business requirements before you can even think about starting to write code.

vinod chattergee 12-Sep-13 8:18am

Hi Richard,
This is more of curiosity, I see many places as in when booking movie tickets , airtickets etc the round trip is happening as in less than 0 sec!!!!

Hows that achieved!!!!

any inputs???

Thanks,
Vinod

Richard MacCutchan 12-Sep-13 8:28am

Then you should be using Google to find samples and suggestions.

vinod chattergee 12-Sep-13 8:49am

but, can you think of someway this can be achieved? give a shot!

Richard MacCutchan 12-Sep-13 9:14am

Yes, type www.google.com into your browser address bar.

Seriously, this is a research question, not a technical one, and the answer depends on far too many factors. If you really cannot understand why, then you need to do some more studying into application development.

Thanks7872 12-Sep-13 6:02am

if the seat is selected by someone If i select all the seats at a time,than? No one would be able to book them. The best would be to make it sure at the time of confirm. If taken by some body it should not be available for transaction.

Looking forward to get this done using asp.net and c# No one would ever do this.

Remember,all here are those who love to help others. They love TO HELP,not HOMEWORK.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-09-12T01:39:00

You'll just need to add a flag to your database table, perhaps a timestamp so that when someone new starts querying your reservations the ones that still have a timestamp within the last 10 minutes or so don't show up as being available.

There's no one way to do it so you just need to decide on an approach and go for it.