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