public bool Draft(VMDraftBlog data)
{
if (data != null)
{
var user = db.Users.FirstOrDefault(m => m.UserId == data.UserId);
var blog = new Blog()
{
BlogStatus = 3,
Title = data.BlogTitle,
Description = data.BlogContent,
CreationTime = DateTime.Now,
LastEditTime = DateTime.Now,
CreatedBy = user.Email,
EditedBy = user.Email,
User = user,
TopicId = data.SubTopic
};
db.Blogs.Add(blog);
var blogCount = new BlogStatusCount()
{
LikesCount = 0,
DislikesCount = 0,
SpamCount = 0,
CommentsCount = 0,
GetBlogs = blog,
UserId = blog.UserId
};
db.GetBlogStatusCount.Add(blogCount);
var tag = new Tag()
{
TagTitle = user.Name,
Blog = blog
};
db.Tags.Add(tag);
db.SaveChanges();
return(true);
}
return(false);
}
public bool Create(VMBlog blog)
{
if (blog.Title != null && blog.SubTopic != 0)
{
var blogPost = new Blog()
{
Title = blog.Title,
Description = blog.Description,
CreationTime = DateTime.Now,
UserId = blog.UserId,
TopicId = blog.SubTopic,
CreatedBy = blog.Email,
LastEditTime = DateTime.Now,
BlogStatus = 1
};
dbReference.Blogs.Add(blogPost);
var blogCount = new BlogStatusCount()
{
LikesCount = 0,
DislikesCount = 0,
SpamCount = 0,
CommentsCount = 0,
GetBlogs = blogPost,
UserId = blog.UserId
};
dbReference.GetBlogStatusCount.Add(blogCount);
var tag = new Tag()
{
TagTitle = blog.Tag,
Blog = blogPost
};
dbReference.Tags.Add(tag);
dbReference.SaveChanges();
return(true);
}
return(false);
}
public VMBloggerDetails GetBloggerDetails(int id)
{
var user = dbReference.Users.FirstOrDefault(m => m.UserId == id);
var blogs = dbReference.Blogs.Where(m => m.UserId == user.UserId && m.BlogStatus == 1).ToList();
var stats = new BlogStatusCount();
foreach (var item in blogs)
{
var dataFetched = dbReference.GetBlogStatusCount.FirstOrDefault(m => m.BlogId == item.BlogId);
if (dataFetched != null)
{
stats.CommentsCount = stats.CommentsCount + dataFetched.CommentsCount;
stats.LikesCount = stats.LikesCount + dataFetched.LikesCount;
}
}
var data = new VMBloggerDetails()
{
Blogs = blogs,
User = user,
Stats = stats
};
return(data);
}
