Category: ASP.NET

22 May 2017 14:31

Joined:	09/08/2016
Level:	Bronze
Points:	70

Points:	3

Track user login and logout timings in and save to database

i am having an admin panel who can see the users login and logout timings...
my requirement is how to design table and how to save loin and logout time every time user logs in and logs out into application and how can if same user logs in two or three times a days how can we save his details as i cannot create seperate tables for every user.

#769226

22 May 2017 19:53

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	4

Hi,

This can be easily done in the .NET based application.
In .NET architecture all the application can have unique ID and Session_Start function.
So you need to implement your table logic in the Session_Start and Session_end functionality with login and logout.

In Session_Start, store the session ID along with user ID and system date. So every time when the user logs in we can validate the user with these 3 parameters. So if he logs in more than thrice then we can show the message to the user that you have logged in 3 times.

Thanks,
Mani

#769228

24 May 2017 13:03

Joined:	12/11/2009
Level:	Gold
Points:	5981

Points:	3

create separate table with two columns like logintime and logout time with sessionids
a) while login insert the logintime
b) while logout update the samerow based on sessionid's

should probably handle
1. while logout need to regenerate the sessionids
2. idle session timeout should be handle.
3. Force browser closing should be handle.

hope this help!

thnx
Muhil

#769229

24 May 2017 15:13

Joined:	09/08/2016
Level:	Bronze
Points:	70

Points:	1

Thanks Manigandan and MuhiReks. i have done the same way muhireks has suggested. during logout i should regenerate or get the session id?? and after doing logout should i remove sessions ????? like session.abandon or seesion.removeAll()...

#769230

24 May 2017 16:19

Joined:	12/11/2009
Level:	Gold
Points:	5981

Points:	3

create separate table with two columns like logintime and logout time with sessionids
a) while login insert the logintime
b) while logout update the samerow based on sessionid's

should probably handle
1. while logout need to regenerate the sessionids
2. idle session timeout should be handle.
3. Force browser closing should be handle.

hope this help!

thnx
Muhil

Track user login and logout timings in and save to database

About dotnetspider.com

Quick Links

General

Services