Thread: Customer Login Status

I'm working on integrating another website with ASPDNSF 8.0 ML.
Given the CustomerID, how to check whether the Customer is logged in or not ?

Basically querying on Database is preferred.

Any other ideas too welcome.

Thanks,
Nizam

A list of ALL live CustomerSessions

Code:

SELECT cs.CustomerID, cs.LastActivity, c.email
FROM CustomerSession AS cs (NOLOCK)
JOIN Customer AS c (NOLOCK) ON c.CustomerID = cs.CustomerID
WHERE c.IsRegistered=1

Thanks for the right direction.
The entry in Session table *still exists* though I logged out of the site leaving me in confused state whether customer really loggedout ?

I think you'll find that most of your customers/users won't actually logout; they'll just move away from your site, by going to another site or closing their browser. I've checked, CustomerSession.LoggedOut doesn't get set on our system, but what does happen is that a CustomerSession is removed after the AppConfig.Name.SessionTimeoutInMinutes inactivity (in our case 60 minutes). This seems to be actioned from CustomerSession.cs.StaticClear() which calls the stored proc aspdnsf_SessionAge which when called without a CustomerID removes all CustomerSessions which are inactive over the timeout period.

So, you can determine that they've gone, and any left in the CustomerSession table are possibly still around, but check their LastActivity time.