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