ASP Message Board

ASP Message Board - ASP.NET http://www.aspmessageboard.com/ en Wed, 19 Jun 2013 02:39:14 GMT vBulletin 60 http://www.aspmessageboard.com/images/misc/rss.png ASP Message Board - ASP.NET http://www.aspmessageboard.com/ I am having all kinds of problems with this http://www.aspmessageboard.com/showthread.php?237619-I-am-having-all-kinds-of-problems-with-this&goto=newpost Mon, 17 Jun 2013 03:12:45 GMT Hi again Experts,

This issue is really, really driving me nuts.

Please take a look at code below:

Code:

s = "INSERT INTO tblTrainings (CourseId, tblLocations.LocationId, dateId,AvailableSeats,username) VALUES (@CosID, @LocID, @dat, @Available_Seating, @Username)"

                Dim cmd = New SqlCommand(s, conn)

                cmd.Parameters.AddWithValue("@cosID", Request.QueryString("cosId"))

                cmd.Parameters.AddWithValue("@locID", Request.QueryString("locid"))

                cmd.Parameters.AddWithValue("@dat", Request.QueryString("iddate"))

                cmd.Parameters.AddWithValue("@Available_Seating", 45 - 1)

                cmd.Parameters.AddWithValue("@UserName", username)

                conn.Open()

                cmd.ExecuteNonQuery()

                conn.Close()

We have 2 fieldnames, one field called Capacity is on a table called Location.

This Capacity is of integer data type and has a value of 45.

The other fieldname is called Available and is also of integer data type.

This fieldname is on a table called trainings.

The idea is to show Capacity Seating (which is 45) and to show Available Seats.

Initially, the Available fieldname has no value.

This trainings table is used to store information about people who register for a class.

The first time a user signs up for a class, Available will show 44 seats remaining. You can see this from the code above:

cmd.Parameters.AddWithValue("@Available_Seating", 45 - 1)

The problem is that after this initial decrease from 45 to 44, it doesn't decrease anymore.

The idea is that each time someone signs up, the number decreases by 1 and will continue to decrease until the number is now 0.

Of course, when it is 0, any attempt to sign up again by a user, a message will go out that class is full and user will be on a waiting list. This means that the user's registration info will be saved on the waiting list table.

Not really worried about this waitinglist part.

I just want to be able to have Available decrease by 1 each time a user signs up until 0.

How do I make this work?

Thanks as always for your continued assistance
. ]]> ASP.NET IheChi http://www.aspmessageboard.com/showthread.php?237619-I-am-having-all-kinds-of-problems-with-this How do I send my user to a custom login page if/when they time out? http://www.aspmessageboard.com/showthread.php?237595-How-do-I-send-my-user-to-a-custom-login-page-if-when-they-time-out&goto=newpost Tue, 21 May 2013 10:46:14 GMT I have implemented a timeout with slidingexpiration in my web.config which by default sends the user to the default.aspx page which has the login... I have implemented a timeout with slidingexpiration in my web.config which by default sends the user to the default.aspx page which has the login control. I woulf like to change this behavior such that the user would be directed to a page that will have a login control plus information telling them that they have arrived at this page due to a timeout. I'm trying to avoid the following scenario. A user leaves their computer while logged in to my application intending to return shortly and thus does not log out. However they get distracted and do not return within the allowed timeout period and find that when they make an entry they are immediately looking at the login page without any indication as to why they have been sent here. I have found some blogs with ideas for presenting an alert that a timeout is about to occur, but with the slidingexpiration this would not occur unless they were not activiely using the application and thus would not be present to see the alert. Thank you for any suggestions you choose to offer..............................Phil Hoop ]]> ASP.NET PhilHoop@mm.com http://www.aspmessageboard.com/showthread.php?237595-How-do-I-send-my-user-to-a-custom-login-page-if-when-they-time-out