Get a user login/logof date - an autit table

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 ...