public IEnumerable <PostModel> Posts([FromUri] int page = 1)
{
if (page > 0)
{
// paging
int skip = (page - 1) * MAX_POST_COUNT;
// posts
List <PostModel> posts = (from p in _repo.Query <Post>()
orderby p.Created descending
select new PostModel
{
Id = p.PostId,
Title = p.Title,
ImageUrl = p.ImageUrl,
SourceUrl = "http://www.reddit.com/" + p.RedditId
}).Skip(skip).Take(MAX_POST_COUNT).ToList();
// comments
foreach (var post in posts)
{
post.Comments = (from c in _repo.Query <Comment>()
where c.Post.PostId == post.Id
select c.Text).ToList();
}
return(posts);
}
return(null);
}
public IEnumerable <TagModel> Tags()
{
var tags = from t in _repo.Query <Tag>()
select new TagModel
{
Id = t.TagId,
Name = t.Name
};
return(tags.ToList());
}
public ActionResult Index()
{
var model = from s in _repo.Query <Snipplet>()
where s.Tags.Any(t => t.TagId == CsTagId)
orderby s.Headline
select new CSharpSnippletListItem {
Id = s.SnippletId, Headline = s.Headline
};
return(View(model));
}
public ActionResult ReadingView(int?id = null)
{
if (id != null)
{
var article = (from a in _repo.Query <Article>()
where a.ArticleId == (int)id
select new ArticleModel
{
Id = a.ArticleId,
Title = a.Title,
Description = a.Description,
Content = a.Content,
ImageUrl = a.ImageUrl,
SourceUrl = a.SourceUrl,
Date = a.Date
}).FirstOrDefault();
if (article != null)
{
return(View(article as ArticleModel));
}
}
return(new HttpStatusCodeResult(HttpStatusCode.NotFound));
}
