How to tackle this session problem?

vishal narvekar

16y15k.NET

I have a question regarding storing the status of user.

The following requirement are there:

When authorized user logs into the system.he/she is not allowed to login from another computer or in different browser other than he is using right this time.-

Remedy we applied here as : We have kept " Is_Loggedin" as a column with data type "bit" in a mst_vendor as a table name. when a user logs in we set the flag to Is_Loggedin as "1" and each time when someone tries to log in using this account,the system is showing the error "The user is already logged in"

When he logs out it turns to "0" as logout procedure calls as soon as he clicks log out button.

Problem scenario:

1.When user closes the browser the flag remains the same i.e "1"

2.When power gets off,It remains the same as "1"

3.If session timeouts after a predefined value it remains the same.

4.There may be different scenarios other than this.

Is there any way so that we can store this internal flagging for user's login status using application object.

It may improve efficiency of the system and also eliminates the above problematic scenarios.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Crish16y ago
hi

set session state in web.config for solution of session problem in asp.net.
Manikavelu Velayutham16y ago
1.When user closes the browser the flag remains the same i.e "1" - You have to call the function that will change the flag in OnUnload event of the body tag of the page.

2.When power gets off,It remains the same as "1" - You have to create the job in sql server that could run every 10 or 20 minutes based on your need to update the flag in the database.

3.If session timeouts after a predefined value it remains the same. - You have to handle the session_end event in the global.asax page.

If you follow the above steps, your problem could get solved.