public IEnumerable <Category> GetCategories()
{
using (var db = new GroupNewsContext())
{
return(db.Categories.OrderBy(o => o.Name).ToList());
}
}
public IEnumerable <Story> GetStories()
{
using (var db = new GroupNewsContext())
{
return(db.Stories.Include(i => i.Category).Include(i => i.Author).OrderBy(o => o.Headline).ToList());
}
}
public IHttpActionResult GetOneStory(int storyID)
{
using (var db = new GroupNewsContext())
{
var query = db.Stories.Include(i => i.Author).Include(i => i.Category).SingleOrDefault(s => s.ID == storyID);
return(Ok(query));
}
}
public IHttpActionResult PostStory([FromBody] EnterStory StoryData)
{
using (var db = new GroupNewsContext())
{
var AllStories = db.Stories.Include(i => i.Author).Include(i => i.Category);
// If author exists, save them.
var author = db.Authors.SingleOrDefault(s => s.Name == StoryData.UserName);
// Otherwise, create them.
if (author == null)
{
author = new Author
{
Name = StoryData.UserName
};
db.Authors.Add(author);
db.SaveChanges();
}
// Similar deal for category.
var category = db.Categories.SingleOrDefault(s => s.Name == StoryData.Category);
if (category == null)
{
category = new Category
{
Name = StoryData.Category
};
db.Categories.Add(category);
db.SaveChanges();
}
// Then, create and save the post.
var newPost = new Story
{
Headline = StoryData.Headline,
Body = StoryData.Body,
CreationDate = DateTime.Now,
Author = author,
Category = category
};
db.Stories.Add(newPost);
db.SaveChanges();
return(Ok(newPost));
}
}
