How to keep track of user's log-in/out in mvc

Question

This question may sound trivial, but to me is complicated. I have created a table that stores user's log-in/out date and time. So in my MVC site, I need to be able to insert a new row when the user logs-in and update the row when user clicks on x button or navigates away, etc.

I did a bit of research on "void Session_Start(object sender, EventArgs e)" and thought that might be my solution. However, when I run my site in debug mode in VS, even when I log-out and log-in as another user to the site, the method doesnt get called. Am i missing something, or Session_Start is used for a different purpose?

Any help would be hugely appreciated.

I'm not an expert in this area, so I'm sorry if this is obvious and I'm not getting it. I just dont see how I can use the offered solution in my problem. The linked page discusses how to redirect user to the log-in page if the Context object is null when logging out. I simply need to detect when the user has logged-in and when s/he is logging-out. — houman_ag
– houman_ag, Commented May 4, 2017 at 4:18

Ashiquzzaman · Accepted Answer · 2017-05-05 03:38:45Z

2

Example:

     //Model

        {
    public class LoginHistory
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public long Id { get; set; }
        public DateTime LoginTime { get; set; }
        public DateTime? LogoutTime { get; set; }
        [StringLength(128)]
        public string UsertId { get; set; }
    }
//Controller
        public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
        {
            //............

            switch (result)
            {
                case SignInStatus.Success:
                    LoginTime(model.UserName);
                    return RedirectToLocal(returnUrl);
                //...........
            }
        }

                [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult LogOff()
        {
            //...............................

            LogOutTime(User.Identity.GetUserId());

            //...............................

            return RedirectToAction("Index", "Home");
        }

         public void LoginTime(string userName)
        {
            using (var db = new Applicationdbcontext())
            {
                var user = db.user.Find(u => u.UserName == userName);
                var model = new LoginHistory
                {
                    UserId = user.Id,
                    LoginTime = DateTime.UtcNow
                    LogoutTime = null,
                };
                db.loginhistory.Add(model);
                db.SaveChanges();
            }

        public void LogOutTime(string userId)
        {
            using (var db = new Applicationdbcontext())
            {
                var model = db.loginhistory.Where(u => u.Uid == userId).OrderByDescending(u => u.Id).First();
                model.LogoutTime = DateTime.UtcNow;
                _login.SaveChanges();
            }
        }

<script type='text/javascript'>
var inFormOrLink;
$('a').on('click', function() { inFormOrLink = true; });
$('form').on('submit', function() { inFormOrLink = true; });

$(window).on("beforeunload", function() { 
        if(!inFormOrLink){
            document.getElementById('logoutForm').submit();
        }
})

add this script in your layout page. I always follow this example. Hopefully it's help for you.

edited May 5, 2017 at 3:38

answered May 4, 2017 at 5:09

Ashiquzzaman

5,3144 gold badges30 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

houman_ag Over a year ago

Thanks @Ashiquzzaman for the code. The only thing that i dont understand here is when I'm in debug mode and i close the browser tab, the user doesnt log out somehow so the LogOff method doesnt get called. What am I missing?

houman_ag Over a year ago

Thanks for the help. My navbar is not only links, there is also some navigation using javascript so the script you included didnt completely work for me. What I ended up doing was to have some code in login/logoff/session_start and session_end methods. This way I catch all possible scenarios. Thanks again for your help.

Collectives™ on Stack Overflow

How to keep track of user's log-in/out in mvc

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related