Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
Dears,
 
I am developing a project where I use the database of the aspnet membership to my login, assign roles, etc..
 
my idea is to develop an area to audit my system where I need to know and record the following: when User login to the system, must save the day and time that this started, and do logof also need to take the day and time of output to be stored in a database.
 
the body of my table, I'm thinking this way:
id_auditoria (int) autoincrement
id_user FK(User of membership)
login datetime
logof datetime
 

I want this system through a Stored procedure, capable of catching and storing login date, and end to catch logof date and save too. I will use this table to check which user a certain day and time he accessed the system and see how long he was inside of it, just to control ...
 
appreciate some ideas ...
Posted 12-Jul-13 14:42pm
Comments
dholakiyaankit at 12-Jul-13 23:43pm
   
you have to do a lot for this one user function with calculation of how long he stay in and also login logoff timings needed for this one
fasher_the_one at 13-Jul-13 8:09am
   
what I need is just a way to get the date and time the User to perform the logout, because as already get login. I know what to do to insert the database after the data is available.

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

  Print Answers RSS
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 184
0 OriginalGriff 7,660
1 Sergey Alexandrovich Kryukov 7,072
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,665


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 12 Jul 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100