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); }