Calculate each user's overall login period.

Question

User944339287 posted

Hi guys.. I want to create a landing page for logged-in users to visit, and store his/her total login period in the database.

1) calculation start when the user logged in successfully. (session)
2) calculation stop when the logged-in user accidentally close that page, or
3) calculation continue if the user re-login again.

Please advise how to accomplish my requirement by using session (or other state management)

TQ~

Answer 1

User1535942433 posted

Hi kengkit,

As far as I think, you can record the user log in time and log out time in login and log out event! And then you could stored username, logintime and logouttime to the database, then calculate the interval of all records of the user!

In login method:

 // inside login method after successful authenticateion then put this
            Session["login_time"] = DateTime.Now;

In log out method:

 if (Session["login_time"] != null)
            {
                DateTime loginTime = (DateTime)Session["login_time"];
                var loginTimeDurationInMinutes = (DateTime.Now - loginTime).Minutes;
             // now put logic to save this duration in db
            }

Or,you could use timespan.

More details,you could refer to below articles:

https://www.c-sharpcorner.com/UploadFile/225740/introduction-of-session-in-Asp-Net/

https://stackoverflow.com/questions/41830817/calculate-each-users-overall-login-period-in-asp-net-c-sharp

Best regards,

Yijing Sun