private void LoadFeed(Feed feed) { _user = feed.User; _notifications.InsertRange(0, feed.Notifications); RebuildContent(); }
public Feed LoadFeedFromDatabase() { FeedUser user; var notifications = new List <FeedNotification>(); using (var ctx = _db.OpenContext()) { using (var reader = ctx.ExecuteReader("SELECT name, points, badges_bronze, badges_silver, badges_gold FROM user")) { if (!reader.Read()) { return(null); } user = new FeedUser( (string)reader["name"], (int)reader["points"], new[] { new FeedUserBadge("bronze", (int)reader["badges_bronze"]), new FeedUserBadge("silver", (int)reader["badges_silver"]), new FeedUserBadge("gold", (int)reader["badges_gold"]) } ); } using (var reader = ctx.ExecuteReader("SELECT rowid, datetime, kind, user, poster, title, message, parentid, postid FROM notification ORDER BY datetime DESC")) { while (reader.Read()) { notifications.Add(new FeedNotification( (long)reader["rowid"], DbUtil.ParseDateTime((string)reader["datetime"]), (string)reader["kind"], reader["user"] as string, reader["poster"] as string, (string)reader["title"], reader["message"] as string, reader["parentid"] as int?, reader["postid"] as int? )); } } } return(new Feed(user, notifications)); }
public static FeedItems DefaultFeedItemListModel() { const string TOOK_OUT_GARBAGE = "Took Out Garbage"; var feedItems = new List <FeedItem>(); var feedUser = new FeedUser("Nick", string.Empty); feedItems.Add(new FeedItem("Garbage", TOOK_OUT_GARBAGE, feedUser, DateTimeOffset.Now)); feedItems.Add(new FeedItem("Garbage", TOOK_OUT_GARBAGE, feedUser, DateTimeOffset.Now.AddMinutes(-10))); feedItems.Add(new FeedItem("Groceries", "Purchahsed Groceries", feedUser, DateTimeOffset.Now.AddHours(-3))); feedItems.Add(new FeedItem("Groceries", "Purchahsed Groceries", feedUser, new DateTime(1989, 10, 9, 2, 7, 0, 0))); return(new FeedItems(feedItems)); }