public ExpiredUserSession GetSessionIDByUserID(int userID)
{
ExpiredUserSession session = null;
_sqlObjectFactory.GetConnection().Using(connection =>
connection.Command("SELECT SessionID, UserID, LastTime FROM pf_UserSession WHERE UserID = @UserID")
.AddParameter("@UserID", userID)
.ExecuteReader()
.ReadOne(r => session = new ExpiredUserSession { SessionID = r.GetInt32(0), UserID = r.GetInt32(1), LastTime = r.GetDateTime(2)}));
return session;
}
private void EndAndDeleteSession(ExpiredUserSession oldUserSession)
{
_securityLogService.CreateLogEntry(null, oldUserSession.UserID, String.Empty, oldUserSession.SessionID.ToString(), SecurityLogType.UserSessionEnd, oldUserSession.LastTime);
_userSessionRepository.DeleteSessions(oldUserSession.UserID, oldUserSession.SessionID);
}