I have written a SP which maintains users log in and log out history,it works fine when any user logs in or clicks on log out, problem is that as per need its not to allowed to keep the screen idle for 1 minute or more then in the log out column Null value is passed.
SP
Create proc usp_trackuserlogindetails @username varchar(50) = null, @command int = 0 as BEGIN if(@command = 0) begin insert into userlog (USERNAME,LOGIN,LOGOUT) values (@username,Getdate(),Null)
[Code] ....
Here when user manually clicks the log out button then 1(table above) is the output.
When user leaves the screen idle then after 1 minute the page goes to the Login.aspx page if the user tries to do something on the current page,here 2(table above) is the output can i store some hard core value instead of Null like Session expire or the exact session expires time.
By using above query its fine to save logout time in database, if the user unfortunately close the browser without logout then how to store logout time in database...
Users will purchase Items and as soon as it reaches the products min value it will mail and process to all people who purchased in past but not processed as the min value not reached.
Let's suppose there is products called PRD01 which has min value of 10. A person (Per1) purchased 3 qty but it will not processed immediately as the min value not reached. Now another person (Per2) purchased 7 qty since it has reached the min value it should mail the Per1, Per2 confirming their order.
I have created a function which whill check if the MinValue reached Once the person does checkout. User Order should be processed imediately and if the Min value reached he should be mailed even he has closed the browser.
I have two asp page first is login page. I enter username and password then after submit click goes second page their is a logout option. then thr URL of second page is copy and paste in another browser then it will second page it is not logout,I want to after paste URL it goes Login page.
writing code for Session_Start() and Session_End() such that whenever a user closes the browser without logging out he is automatically forcely logged out......And too when a user logs out normally he is re-directed to the LogOn page....
We have a web application with feature for logging in with credientials The important requirement is once the user logs in he is not allowed to login from any other system or even another browser on same system We used following solution which is mssql based : We have kept " Is_Loggedin" as a column with data type "bit" in a table. when a user logs in we set the flag as "1" sowhen someone tries to log again ,the system is showing the error "The user is already logged in"When user logsout bit turns to "0"indicating user logged out. However this logic is failing in following scenarios Problem scenario:When user closes the browser the flag is "1"and user is locked in or situations when user gets system problem and unable to log out.
My application is written VS 2008 and .net framework 3.5. Sometimes when a user picks a value in the drop-down menu, this action closes the whole window. I cannot repeat this error on my box, but one of my users gets it consistently. Have anyone ever experienced anything like this?
i need to store opening and closing time of Restaurants in database as well as compare them with current time to see whether it is closed or open when user is viewing it... How to do??
i am not able think how to desing UI through which resturant owner can save opening n closing time for their resturant ? like what control.
I am selecting time from dropdownlist. and want to convert it in datetime and store it in database. When I am converting it to Datetime using following statement.
I need to store time in database and then show in using gridview.I wonder how to store and show data so that user will see correct datetime depanding on his timezone?
Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.
The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?
