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 .
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 RepliesIn 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 Repliesi 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]....
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 RepliesI want to know how to handle the concurrency throughy code ? ie: I want to access the Concurrency issue or error ? Because if i get the concurrency user or issue I have to do some manipulation.
View 4 RepliesIm 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.
How to control concurrent requests for web sites?
View 1 RepliesIn 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.
My project includes a grid view with some updtable fields, some fields throw an error on update and some do not and it does not really make sense. WORK_STATION_ID does not cause an error, ROOM _ID cause an error, both are int? (I am using c#) and for update I use the code liste below.
[Code]....
[Code]....
I am trying to handle concurrency in my application. Basically if user A has a support ticket open which currently has a status of 'Active' and user 'B' opens the same ticket and closes it (changing its status to closed), I would expect a confict execepton to be thown when user 'A' tries to close the support ticket. For some reason this is not happening. I have checked that Update check is set to 'Always' in the dbml file. Here is an exerpt of my code. // Update 'Active' lead to 'Close'
[Code]....
I have the following problem:- I have a Settings table which has a value column, that is incremented everytime a Job is created (I use Entity framework to add the job and to update the value increment). So, I have something like this:
[Code]....
The problem is: I have a asp.net with concurrent calls to SaveJob Method. In this code, the value is shared, and if I call SaveJob 5 times for instance, the value column is 3, because the scope is not "locking" the other transactions until It's done, and the value is shared. I want to have the following scenario: Call SaveJob 5 times;Value column in Settings table is 5;Call SaveJob 3 more times;Value Column in Settings table is 8. I tried to implement something like pessimistic concurrency in EF, but I had no success. Whats the best way to handle that without using SQL Server queries directly? (like 'lock' and 'unlock' etc)
I tried to implement Optimistic Concurrency in the Movie MVC 3 project.
1. I added a new property
[Timestamp]
[ConcurrencyCheck]
[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public byte[] RowVersion { get; set; }
2. Modified controller to execute
var movie = db.Movies.Find(model.Id);
db.Movies.Attach(movie);
TryUpdateModel(movie);
db.SaveChanges();
return RedirectToAction("Index");
3. Added the RowVersion as a hidden field to the View page
@Html.HiddenFor(model => model.RowVersion)
It didnot work for me, can someone pls point me to the right direction?
i am in the process of creating a restful service with WCF, the service is likely to be consumed by at least 500 people at any given time. What settings would i need to set in order to deal with this.
Here is a sample of what i have so far;
[Code]....
And this is an example of a method being called;
[Code]....
I've been quite impressed with dynamic data and how easy and quick it is to get a simple site up and running. I'm planning on using it for a simple internal HR admin site for registering people's skills/degrees/etc.
I've been watching the intro videos at www.asp.net/dynamicdata and one thing they never mention is how to handle concurrency control.
It seems that DD does not handle it right out of the box (unless there is some setting I haven't seen) as I manually generated a change conflict exception and the app failed without any user friendly message.
Anybody know if DD handles it out of the box? Or do you have to somehow build it into the site?
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 RepliesActaully i developed an Asp.net website which has a PDA app part. The case is that employees from company come in the morning and get data in their PDA's and they work on them the whole day and in Evening they again come to office or from any web access they update the data on server. We did this through Web services because web services are remote methods so they could access that by only web access..
Now the problem is Concurrency that while syncing through web servies how to control Concurrency however their could be many employee who try to update data at a time.In web servies we receive DataTable from PDA application and do update or insert operations through LINQ with Sql Server.
Made my first application in aspx, and connect to mysql, the issue is how concurrency control (transactions), ie that when users log dam not, nor information loss...
View 3 RepliesHow should I solve simulation update, when one user updates already updated entery by another user?
First user request 'Category' entityobject, second user does the same. Second user updates this object and first user updates. I have field timestamp field in database that wa set to Concurrency Mode - Fixed.
This is how I update:
[Code]....
Exception never jumps...How should I handle this?
I added a column of type "timestamp" to a table in SQL Server to use for concurrency control. I deleted all my tables from the Linq surface and then added them back. I see that the "Time Stamp" attribute is set to True for the timestamp column and False for all the other columns. I also see that the "Update Check" attribute is set to Never for all columns, including the timestamp column.
After watching some demo videos and reading some tutorials, I had expected to have to manually set the "Update Check" attribute values on the columns - to Never for all columns but the timestamnp column where it should be set to Always. But, before setting the "Update Check" to Always on the timestamp column, I decided to test it the way it was, and Linq seems to be doing the right thing - it seems to be using the timestamp column for concurrency control correctly even with "Update Check" set to Never on the timestamp column.
So my question is - does the fact that "Time Stamp" is set to True trump the "Update Check"? Or is there any other reason one could or should set "Update Check" to Always on a timestamp column? Is there any change in behavior?
I have a strange problem in my ASP.Net 3.5 application. When multiple users try to access the same page (which has some long running methods), the application crashes at a point where it tries to open a connection to the database (a static method inside a static class). It appears that the connection is already open. However, this does not happen when there is only one user using the application. What I cannot understand is that how do actions of one user affect the other in a web application?
I double checked that all my open connections are being closed after performing their operation by appending a line of text to a text file whenever a connection is opened or closed. The number of opened and closed connections was equal. Also, the connections are opened and closed from one place only, where the close method is inside a Finally() block.
i work with visual studio 2005 and asp net 2.0. i have a method method as this :
[Code]....
this problem is follow if i run the web method and don't enter a string and a int a receive this message : System.ArgumentException: Cannot convert to System.Int32. ok when i arrive in the method i can check if lists is empty but how i can do if int is NULL because i don't want to returns a error if people run my web method and don't enter the parameters.
im tryign to move a listbox item from one listbox to another heres my c# for moving from populated listbox to unpopulated
[Code]....
when i run the addtable function on one of my buttons it doesnt work, so i tried just outputing to a label the value of the slected item, didnt work
i opened google chrome console to find the below which led me to belive i need to add System.Windows.Forms; to get it working?
ScriptResource.axd?d=eapqzlwXhBFph23Pl_2pOrzTVt5-WN-w1AJhJtJAxUGjg5h6xiIW5VowmUQ2aKwAieU-I4882cg5dWnZWQpkyvximpbl-emU1vXDRe137NMq7e8sEJ6W-wJLYpPH8ryr7g79lqLpeL1CaNGbVvthubXLUxDQz86JoZP_jf82s1h2aflGevqjjph2odUMt3SI0&t=2610f696:868Uncaught
Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException:
Object reference not set to an instance of an object.
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'.
[code]....
Basically, what I did is that: I have a table in SQL database and some of data fields allow null. I built Objectdatasource through dataset. When I built update page using dataset. It generate the following error before showing the update page correctly. It seems I have issue to retrieve the null value from the database through using objectdatasource through dataset. Any suggestions?An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code
View 6 Replies