public ExpiredUserSession GetSessionIDByUserID(int userID)
{
ExpiredUserSession session = null;
_sqlObjectFactory.GetConnection().Using(connection =>
session = connection.QuerySingleOrDefault <ExpiredUserSession>("SELECT SessionID, UserID, LastTime FROM pf_UserSession WHERE UserID = @UserID", new { UserID = userID }));
return(session);
}
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);
}
