Update LogOut Time in SQL server on lost connection of an ASP.Net Web Application

Question

0.00/5 (No votes)

See more:

Hi,

I'm going through this problem of updating LogOut time on Server connection lost(Internet) from my web application. I need to update the logout time on below scenario's. Help needed in this.. I'm new to Asp.Net

1. On abrupt closing of Browser tab or window.
2. On Connection lost with the server.(When one has logged into application and the internet connection is lost)

Your replies are very much needed....

Thanks & regards,
Puneeth

Posted 31-Dec-14 19:34pm

Puneeth_CS

Add a Solution

3 solutions

Solution 1

There is no way to do this directly.
Your application could be using many browsers and each of them would behave differently on closing using the cross button.

Have a session timeout so that the user is logged out successfully.

Posted 31-Dec-14 19:52pm

Abhinav S

Solution 2

SQL

the Session_End event is only fired if you have InProc sessions. SQL or state server session management will not fire this event. If you can, get back to InProc sessions and use this event.

The next best thing would be to have a "last access time" stored somewhere for your users and use that to detect a timeout of the session. The implementation of such a job is complicated though (you can miss logout events if a user logs in/out rapidly for example)...

Posted 31-Dec-14 20:25pm

Manoj Kumar Choubey

Updated 1-Jan-15 1:48am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Puneeth_CS · Accepted Answer · 2014-12-31T20:37:00

Hi Guys,

Thanks for the reply...

For scenario 1, I'm trying to handle in the below way in the Master Page.

I'm calling Logout.aspx using ajax on mousedown event of my Master page <body> element.
Till now working fine with IE, Chrome and Firefox.

<body onbeforeunload="bodyUnload();" onmousedown="clicked=true;">

<script language="javascript" type="text/javascript">
var clicked = false;

function bodyUnload() {
if (clicked == false)//browser is closed
{
$.ajax({
type: 'POST',
url: './../Common/LogOut.aspx',
data: {},
dataType: 'json',
contentType: 'application/json; charset=utf-8',
success: function (r) { },
error: function (e) { }
});
}
}
</script>

public partial class Aspx_Common_LogOut : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Session.Abandon();
}
}

But Scenario 2 is not implemented. How can I track whether my client is connected with the server or not. If the connection is lost I need to update the logout time in Database.</body>