public StoryKickCollection FetchAll() { StoryKickCollection coll = new StoryKickCollection(); Query qry = new Query(StoryKick.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public static void RemoveStoryKick(int storyID, int userID, int hostID) { //PERF: there will be performance benefits if we use a hashtable here StoryKickCollection storyKicks = GetUserStoryKicks(userID); foreach (StoryKick storyKick in storyKicks) { if (storyID == storyKick.StoryID) { storyKicks.Remove(storyKick); return; } } }
public static StoryKickCollection GetUserStoryKicks(int userID) { string cacheKey = String.Format("Kick_StoryKickTable_{0}", userID); CacheManager <string, StoryKickCollection> storyKickCache = GetStoryKickCache(); StoryKickCollection storyKicks = storyKickCache[cacheKey]; if (storyKicks == null) { //TODO: get the latest n kicks for this userIdentifier storyKicks = StoryKick.FetchByUserID(userID); storyKickCache.Insert(cacheKey, storyKicks, CacheHelper.CACHE_DURATION_IN_SECONDS, System.Web.Caching.CacheItemPriority.NotRemovable); } return(storyKicks); }
public static StoryKickCollection FetchByUserID(int userID) { StoryKickCollection storyKicks = new StoryKickCollection(); storyKicks.LoadAndCloseReader(StoryKick.FetchByParameter(StoryKick.Columns.UserID, userID)); return storyKicks; }
public StoryKickCollection FetchByQuery(Query qry) { StoryKickCollection coll = new StoryKickCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public StoryKickCollection FetchByID(object StoryKickID) { StoryKickCollection coll = new StoryKickCollection().Where("StoryKickID", StoryKickID).Load(); return coll; }