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