public static StoryCollection GetUserSubmittedStories(int userID, int hostID, int pageNumber, int pageSize)
{
StoryCollection stories = new StoryCollection();
stories.Load(SPs.Kick_GetPagedSubmittedStoriesByUserIDAndHostID(userID, hostID, pageNumber, pageSize).GetReader());
return(stories);
}
public StoryCollection FetchByQuery(Query qry)
{
StoryCollection coll = new StoryCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static StoryCollection GetStoriesByIsPublishedAndHostIDAndPublishedDate(int hostID, bool isPublished, DateTime startDate, DateTime endDate)
{
StoryCollection stories = new StoryCollection();
stories.Load(GetStoryQuery(hostID, isPublished, startDate, endDate).ExecuteReader());
return(stories);
}
public StoryCollection FetchAll()
{
StoryCollection coll = new StoryCollection();
Query qry = new Query(Story.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public static StoryCollection GetUserTaggedStories(int?tagID, int userID, int hostID, int pageNumber, int pageSize)
{
StoryCollection stories = new StoryCollection();
if (tagID.HasValue)
{
stories.Load(SPs.Kick_GetPagedStoriesByTagIDAndHostIDAndUserID(tagID, hostID, userID, pageNumber, pageSize).GetReader());
}
return(stories);
}
public static StoryCollection GetStoriesByCategoryKickedStateAndHostID(short categoryID, bool isPublished, int hostID, int pageIndex, int pageSize)
{
Query query = GetStoryQuery(hostID, isPublished, categoryID);
query = query.ORDER_BY(Story.Columns.PublishedOn, "DESC");
query.PageIndex = pageIndex;
query.PageSize = pageSize;
StoryCollection stories = new StoryCollection();
stories.Load(query.ExecuteReader());
return(stories);
}
public static StoryCollection GetPopularStories(int hostID, bool isPublished, StoryListSortBy sortBy, int pageIndex, int pageSize)
{
Query query = GetStoryQuery(hostID, isPublished, GetStartDate(sortBy), DateTime.Now);
query = query.ORDER_BY(Story.Columns.KickCount, "DESC");
query.PageIndex = pageIndex;
query.PageSize = pageSize;
StoryCollection stories = new StoryCollection();
stories.Load(query.ExecuteReader());
return(stories);
}
/// <summary>
/// Returns a StoryCollection of stories that have been modified after the
/// given DateTime value
/// </summary>
/// <remarks>this is used by lucene to create an incremental update of the search
/// index without having to do a full index again</remarks>
/// <param name="updatedAfter"></param>
/// <returns></returns>
public static StoryCollection GetUpdatedStories(int hostID, DateTime updatedAfter, int pageIndex, int pageSize)
{
Query q = Story.Query();
q.WHERE(Story.Columns.HostID, hostID).AND(Story.Columns.UpdatedOn, Comparison.GreaterOrEquals, updatedAfter);
q.PageIndex = pageIndex;
q.PageSize = pageSize;
StoryCollection stories = new StoryCollection();
stories.LoadAndCloseReader(q.ExecuteReader());
return(stories);
}
/// <summary>
/// Get all the stories for a given host
/// </summary>
/// <param name="hostID"></param>
/// <returns></returns>
public static StoryCollection GetAllStories(int hostID, int pageIndex, int pageSize)
{
Query q = Story.Query();
q.WHERE(Story.Columns.HostID, hostID).AND(Story.Columns.IsSpam, false);
q.PageIndex = pageIndex;
q.PageSize = pageSize;
StoryCollection stories = new StoryCollection();
stories.LoadAndCloseReader(q.ExecuteReader());
return(stories);
}
/// <summary>
/// Returns all the stories flagged as spam in a collection
/// </summary>
/// <returns></returns>
public StoryCollection SpamStories()
{
StoryCollection spamStories = new StoryCollection();
foreach (Story s in this)
{
if (s.IsSpam)
{
spamStories.Add(s);
}
}
return(spamStories);
}
public static Story FetchStoryByParameter(string columnName, object value)
{
//NOTE: GJ: maybe we should add support for this in SubSonic? (like rails does)
StoryCollection t = new StoryCollection();
t.Load(Story.FetchByParameter(columnName, value));
if (t.Count == 0)
{
return(null);
}
else
{
return(t[0]);
}
}
/// <summary>
/// Returns a StoryCollection for a given IList of storyIds
/// </summary>
/// <param name="storyId"></param>
/// <returns></returns>
public static StoryCollection GetStoriesByIds(IList <int> storyId)
{
Query q = Story.Query();
object[] storyIdArray = new object[storyId.Count];
for (int i = 0; i < storyId.Count; i++)
{
storyIdArray[i] = storyId[i];
}
q.IN("storyID", storyIdArray);
StoryCollection stories = new StoryCollection();
stories.LoadAndCloseReader(q.ExecuteReader());
return(stories);
}
public StoryCollection FetchByID(object StoryID)
{
StoryCollection coll = new StoryCollection().Where("StoryID", StoryID).Load();
return(coll);
}
