SQL Server :: Concurrency In Online Flight Reservation System?
Oct 7, 2010
I have an online flight reservation system that users can reserve flight ticket,my problem is in concurrency,i have a 'remaincapacity' field in my flight table(keep flight properties) and when a user want to get a ticket i first check this field an if the value is greater than number of ticket that user requested i subtract 'remaincapacity' and after that i allow user to reserve that ,how do in control concurrency?
View 2 Replies
Similar Messages:
Oct 14, 2010
i have a hotle reservation system.
when a user select a room i want that it lockes and an other person can not select it.
i think it`s better that i have a flag in my table and when a user select room value of is false and if cancle reservation ,i changed it true.an other person can see room that they have true value .
View 7 Replies
Mar 3, 2011
i want to make website where users can book tiket online. i want to make quickbook like [URL] in this webiste to make this quick book like to work. how to do this type of quick book methods for booking online.
View 3 Replies
Oct 26, 2010
Im about to create a very simple online event reservation application and currently have 3 tables:
User
PK_UserID
UserName
Event
PK_EventID
EventName
EventDescription
EventStartDate
EventEndDate
SeatsAvailable
BookedEvents
ID
FK_UserID
FK_EventID
Do you have any experience of how to handle SeatsAvailable? I mean if SeatsAvailable is set to 5 and there are 5 users online and want to book event. And some user has started to fill out the form then changed his mind. Then seats in database can just leak. I was thinking about sessions - like to limit every user to 5 minutes to complete the booking but i dont really know.
View 2 Replies
May 16, 2010
how this is achievable, not so much in the "build the whole project" as to how the reservation website gets quotes for all the flights from all the flight companies. I assume that in the website's code you have to use a webservice which will quote say website A, and get its ticket prices.
View 2 Replies
Aug 24, 2013
In bus reservation mutiple end-user are requested for single seat at a time. How we can handle the multiple user request. how we can reserved the seat for one requester and how to handle the other requests for that seat.
View 1 Replies
Aug 6, 2010
In what way is used optimistic concurrency?
I need to connect two tables together.
If you use optimistic concurrency at the same time, users will store data in a table?
In particular, I wonder what the difference is, if I save the aspx, or use optimistic concurrency.
View 1 Replies
Mar 25, 2010
I have an application, that is accessing by number of users at the same time. Those users, who are accessing the application getting the same id. Here what i am doing in the code is, when they are creating new user i am getting a max id from DB and increasing the value to 1. So that they are getting same ID. so that i am facing concurrency in this situation. How to solve this problem. I need to display different numbers when the users click on NewUser. I am using SQL server 2008 and .NET 3.5 and C#.NET
View 2 Replies
Jul 18, 2010
I have tried using asp.net createuserwizard and login control.But i m not able to customized them according to my liking.so i created my own user registration webform and login control with the records getting stored in sql database.I dont know whether its a correct way of using asp.net..but its working.Now I am creating a online attendace system which lets user to enter username, logged in and logged out time of each day in thedatabase .The problem is that my user logins in the morning and closes the website and again logins in the evening and exitsthe website.So how to perform this task since i am using a same login form to enter both login time and logout time?Is this possible?my table has colums id,username,logintime,logout timeThe thing is I am using a login from created earlier to enter the username,logindateandtime,logoutdateandtime fields in the databasein which logintime and logouttime gets values from system.
View 33 Replies
May 2, 2010
my project is on online multiplex ticket booking system, In my system when a user selects a movie it will show timings of the show and according to selected time on which screen movie is available is shown. So i just want to know when user selects all the details as i mentioned, according to that seats available should be shown and when user books seats that user has to type in textbox ,available seats should be deducted. how to perform all calculation from database and coding for the same.
View 1 Replies
Mar 3, 2011
there will be 8 combo box
1. contain select state after slecting this state
2. contain select city for previousely selected state
3. contain cinema hall for previousely selected city
4. contain select movies option for selected city
5. conatin show date for previously selected movie
6. contain show time for previously selected date
7. contain class for previously selected show time
8. contain ticket quantity for previously slected tiket class
View 2 Replies
Dec 8, 2010
I am in need for a little advice and I hope you can guide me in the right direction.
View 3 Replies
Sep 17, 2012
I am developing traveling site, in this i have to integrate flight booking,cars booking,hotel booking and vacation booking API in my website.
How can i integrate the above API's in my website.
View 1 Replies
Jun 11, 2010
i am trying to make a reservation page now i need to control the date i.e only last 2 days should remain clickable from today onwards i.e if today is 11th june the user can select(9th june and 10th june)the only last two dates in the following month and same year and obviously rest of month date should remain un-selectable for him i tired this but its making unselectable even today's date Void Calendar1_DayRender
[Code]....
View 4 Replies
Nov 1, 2010
OLE DB provider "SQLNCLI" for linked server "xx.xxx.xxx.xxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
View 1 Replies
Dec 6, 2010
I am developing a simple online DBMS to browse my database online.... the main concern for me is to clear everything from the PC when the user disconnect so no body can go and click (Back) on the browser and see the pages if the user forgot to close it.. what I have done so far is :
[Code]....
I am sure this is not enough.. am I right? so what else I should include there?
View 13 Replies
Feb 25, 2010
I want to create a Online Exam site in ASP.NET .In that i want to display Test based on the Date and time and the user can take the test at the time set my the Teacher.
For Example:
Teacher want to take C Test for the Mid Semester Test and the test is schedule on 1 May 2010,then the test should appear on the test page on the 1st may only and the user should be able to take the test on the set time.
The problem is that if i use System time then user can change the system time and can take the test schedule in future.
So i want to know how can implement this thing.I have given many online test but dont know how they work out the time and date logic.
View 2 Replies
Apr 16, 2010
My question is the same as my subject: how to put asp.net website with sql server database online.
I've never done this on my own before so can anyone explain it?
Where can i put it online and so on..
bob3s
View 7 Replies
Feb 3, 2011
I'm creating an online Clock-in/out tool. An employee may have to leave work for a bit and return at a later time in the same day. This would cause multiple entries for the same date. I need to be able to show the daily total for each date. I have not been able to get SQL to total up the times and only display the date once. The image below shows some data in my table and the outcome that I am trying to achieve. The first table has 2 rows highlighted. They have the same date. The second table shows how I would like it to add the two rows and display them as one.
View 10 Replies
Aug 29, 2010
for my website, i am trying to connect to the online DB from my local PC.when i put the following connectionstring:Data Source=88.8.88.88; Initial Catalog=dbname;user id=dbuser; password=dbpass; Min Pool size=50;Packet Size=32767;Connect Timeout = 200;pooling='true' 88.8.88.88 is the server ip, the databse over the server is sqlexpress 2008. the connection string is working with no issues over the server.i got the following error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)thanks
View 5 Replies
Sep 29, 2010
I want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 1 Replies
Mar 31, 2011
I have a scenario where i have to pass the array list to the WebService.
WebService:
[WebMethod]
public void GetCommission(List<BOLibrary.Flight.DTContract> Loc)
{
CommissionManager test = new CommissionManager();
}
Client:
List<BOLibrary.Flight.DTContract> BoList = new List<BOLibrary.Flight.DTContract>();
BOLibrary.Flight.DTContract dtConboj = new BOLibrary.Flight.DTContract();
dtConboj.ValidatingCarrier = "AA";
DTContract[] loc1 = BoList .ToArray();
service.GetCommission(loc1);
when i am trying to do this i am getting the exception that cannot convert the BOLibrary.Flight.DTContract to DTContract This is because when webservice create proxey consider Type(DTContract) not namespace(BOLibrary.Flight.DTContract)and i have to pass the list or arraylist of BOLibrary.Flight.DTContract Type.
View 1 Replies
Feb 3, 2011
I want to merge a software with a website.I have no source code of software, but i want to the database of online data and offline data will automatically synchronize. I have only control over website, online database and offline database.. Is it possible, if yes how?
[code]....
but when i feed data in offline database, online database automatically updated.
View 5 Replies
Aug 19, 2010
I want to develop a Online Exam Management Project using asp.net and sql server. I want to know whether there is any open source project available for the same.
View 2 Replies
Sep 1, 2010
Here i want to export my data from local sql server 2000 DB to online sql server 2008 DB.
View 6 Replies
