public void CreateNewBlogPost(Post post, Category category)
{
var user = context.Users.Where(u => u.AuthorName == "Marcus Eklund").Select(a => a.UserId).FirstOrDefault();
var blog = context.Blogs.Where(a => a.BlogId == a.Users.Where(b => b.UserId == user).Select(c => c.BlogForeignKey)
.FirstOrDefault()).Select(d => d.BlogId).FirstOrDefault();
var _category = context.Categories.Where(a => a.CategoryName == category.CategoryName).FirstOrDefault();
if (_category == null)
{
_category = category;
}
;
var shortcontent = "";
if (post.Content.Length > 55)
{
shortcontent = post.Content.Substring(0, 55) + "...";
}
else
{
shortcontent = post.Content;
}
context.Posts.Add
(new Post {
Title = post.Title,
Content = post.Content,
ShortContent = shortcontent,
MetaDataDescription = post.MetaDataDescription,
UrlSlug = post.UrlSlug,
Published = post.Published,
PostCreatedAt = DateTime.Now,
AuthorForeignKey = user,
BlogForeignKey = blog,
Category = _category
});
context.SaveChanges();
}
public static void EnsuredPopulated(IApplicationBuilder app)
{
BlogDbContext context = app.ApplicationServices.GetRequiredService <BlogDbContext>();
Blog blog = new Blog {
Url = "http://localhost"
};
if (!context.Blogs.Any())
{
context.Blogs.Add(blog);
context.SaveChanges();
}
User user = new User {
FirstName = "Marcus", LastName = "Eklund", AuthorName = "Marcus Eklund", Blog = blog
};
if (!context.Users.Any())
{
context.Users.Add(user);
context.SaveChanges();
}
Category category = new Category {
CategoryName = "Development", UrlSlug = "development"
};
if (!context.Categories.Any())
{
context.Categories.Add(category);
context.SaveChanges();
}
if (!context.Posts.Any())
{
context.Posts.AddRange(
new Post
{
Title = "My First Post",
Content = "Him boisterous invitation dispatched had connection inhabiting projection. By mutual an mr danger garret edward an. Diverted as strictly exertion addition no disposal by stanhill. This call wife do so sigh no gate felt. You and abode spite order get. Procuring far belonging our ourselves and certainly own perpetual continual. It elsewhere of sometimes or my certainty. Lain no as five or at high. Everything travelling set how law literature.",
ShortContent = "Him boisterous invitation dispatched had connection inhabiting projection.",
MetaDataDescription = "Him boisterous invitation",
UrlSlug = "my_first_post",
Published = true,
PostCreatedAt = DateTime.Parse("2018-01-31 12:00"),
User = user,
Blog = blog,
Category = category
},
new Post
{
Title = "My Second Post",
Content = "Allow miles wound place the leave had. To sitting subject no improve studied limited. Ye indulgence unreserved connection alteration appearance my an astonished. Up as seen sent make he they of. Her raising and himself pasture believe females. Fancy she stuff after aware merit small his. Charmed esteems luckily age out.",
ShortContent = "Allow miles wound place the leave had. To sitting subject no improve studied limited.",
MetaDataDescription = "Allow miles wound place the leave had.",
UrlSlug = "my_second_post",
Published = true,
PostCreatedAt = DateTime.Parse("2018-04-14 14:00"),
User = user,
Blog = blog,
Category = category
},
new Post
{
Title = "My Third Post",
Content = "Affronting discretion as do is announcing. Now months esteem oppose nearer enable too six. She numerous unlocked you perceive speedily. Affixed offence spirits or ye of offices between. Real on shot it were four an as. Absolute bachelor rendered six nay you juvenile. Vanity entire an chatty to.",
ShortContent = "Affronting discretion as do is announcing. Now months esteem oppose nearer enable too six.",
MetaDataDescription = "Affronting discretion as do is announcing.",
UrlSlug = "my_christmas",
Published = false,
PostCreatedAt = DateTime.Parse("2018-12-24 13:35"),
User = user,
Blog = blog,
Category = category
},
new Post
{
Title = "My Fourth Post",
Content = "Pianoforte solicitude so decisively unpleasing conviction is partiality he. Or particular so diminution entreaties oh do. Real he me fond show gave shot plan. Mirth blush linen small hoped way its along. Resolution frequently apartments off all discretion devonshire. Saw sir fat spirit seeing valley. He looked or valley lively. If learn woody spoil of taken he cause.",
ShortContent = "Pianoforte solicitude so decisively unpleasing conviction is partiality he.",
MetaDataDescription = "Pianoforte solicitude",
UrlSlug = "my_fourth_post",
Published = true,
PostCreatedAt = DateTime.Now,
User = user,
Blog = blog,
Category = category
}
);
context.SaveChanges();
}
}
