public override void DeleteComment(int id)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Comments {Id = id};
context.AttachTo("tblBlogs_Comments", obj);
context.DeleteObject(obj);
context.SaveChanges();
}
public override IList<Post> GetAllPosts(int blogId)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Posts.Where(item => item.BlogId == blogId).OrderByDescending(item => item.CreatedDate).
ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override void DeleteBlog(int id)
{
var context = new BlogsEntities();
var obj = context.tblBlogs_Blogs.Where(item => item.Id == id).FirstOrDefault();
if (obj != null)
{
context.DeleteObject(obj);
context.SaveChanges();
}
}
public override void DeletePost(int id)
{
var context = new BlogsEntities();
using (var transaction = new TransactionScope())
{
var post = context.tblBlogs_Posts.Include("Categories").Where(item => item.Id == id).FirstOrDefault();
post.Categories.Clear();
context.SaveChanges();
var comments = context.tblBlogs_Comments.Where(item => item.PostId == post.Id);
foreach (var comment in comments)
{
context.DeleteObject(comment);
}
context.DeleteObject(post);
context.SaveChanges();
transaction.Complete();
}
}
public override List<Post> GetPostsOfBlog(int blogId, PostOptions option)
{
var context = new BlogsEntities();
List<tblBlogs_Posts> list;
switch (option)
{
case PostOptions.Published:
list =
context.tblBlogs_Posts.Where(item => item.BlogId == blogId && item.Published).OrderByDescending(
item => item.CreatedDate).ToList();
break;
case PostOptions.NotPublished:
list =
context.tblBlogs_Posts.Where(item => item.BlogId == blogId && item.Published == false).
OrderByDescending(item => item.CreatedDate).ToList();
break;
default:
list =
context.tblBlogs_Posts.Where(item => item.BlogId == blogId).OrderByDescending(
item => item.CreatedDate).ToList();
break;
}
return list.ConvertAll(obj => Convert(obj));
}
public override int InsertPost(Post post)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Posts();
post.CopyToObject(obj);
if (post.Categories != null)
{
foreach (var category in post.Categories)
{
var item = new tblBlogs_Categories {Id = category.Id};
context.AttachTo("tblBlogs_Categories", item);
obj.Categories.Add(item);
}
}
context.AddTotblBlogs_Posts(obj);
context.SaveChanges();
return obj.Id;
}
public override int InsertComment(Comment comment)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Comments();
BizObject<Comment, int>.CopyToObject(comment, obj);
context.AddTotblBlogs_Comments(obj);
context.SaveChanges();
return obj.Id;
}
public override List<Category> GetCategoriesOfBlog(int blogId)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Categories.Where(item => item.BlogId == blogId).OrderBy(item => item.Name).ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override Blog GetBlogByName(string name)
{
var context = new BlogsEntities();
var obj = context.tblBlogs_Blogs.Where(item => item.CreatedBy == name).FirstOrDefault();
return Convert(obj);
}
public override void UpdateComment(Comment comment)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Comments {Id = comment.Id};
context.AttachTo("tblBlogs_Comments", obj);
BizObject<Comment, int>.CopyToObject(comment, obj);
context.SaveChanges();
}
public override void UpdateBlogroll(Blogroll blogroll)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Blogrolls {Id = blogroll.Id};
context.AttachTo("tblBlogs_Blogrolls", obj);
BizObject<Blogroll, int>.CopyToObject(blogroll, obj);
context.SaveChanges();
}
public override IList<Post> Search(int blogId, string keyword)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Posts.Where(
item => item.BlogId == blogId && (item.Title.Contains(keyword) || item.Content.Contains(keyword))).
ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override Post GetPostBySlug(int blogId, string slug)
{
var context = new BlogsEntities();
var obj = context.tblBlogs_Posts.Where(item => item.BlogId == blogId && item.Slug == slug).FirstOrDefault();
return Convert(obj);
}
public override IList<Blog> GetNewesUsers(int numberOfUsers)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Blogs.OrderByDescending(item => item.CreatedDate).Skip(0).Take(numberOfUsers).ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override List<Comment> GetCommentsOfPost(int postId, int indexOfPage, int sizeOfPage, out int total)
{
var context = new BlogsEntities();
indexOfPage--;
total = context.tblBlogs_Comments.Where(item => item.PostId == postId).Count();
var list =
context.tblBlogs_Comments.Where(item => item.PostId == postId && item.IsApproved).OrderBy(
item => item.CreatedDate).Skip(
indexOfPage*sizeOfPage).Take(sizeOfPage).ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override List<Comment> GetCommentsOfPost(int postId)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Comments.Where(item => item.PostId == postId && item.IsApproved).OrderBy(
item => item.CreatedDate).ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override Comment GetCommentById(int id)
{
var context = new BlogsEntities();
var obj = context.tblBlogs_Comments.Where(item => item.Id == id).FirstOrDefault();
return Convert(obj);
}
public override List<Category> GetCategoriesOfPost(int postId)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Posts.Where(item => item.Id == postId).SelectMany(item => item.Categories).OrderBy(
item => item.Name).ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override void UpdateBlog(Blog blog)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Blogs {Id = blog.Id};
context.AttachTo("tblBlogs_Blogs", obj);
blog.CopyToObject(obj);
context.SaveChanges();
}
public override List<Post> GetPostsOfCategory(int categoryId, PostOptions option, int indexOfPage,
int sizeOfPage, out int total)
{
var context = new BlogsEntities();
List<tblBlogs_Posts> list;
switch (option)
{
case PostOptions.Published:
total =
context.tblBlogs_Categories.Where(item => item.Id == categoryId).SelectMany(item => item.Posts).
Where(item => item.Published).Count();
list =
context.tblBlogs_Categories.Where(item => item.Id == categoryId).SelectMany(item => item.Posts).
Where(item => item.Published).OrderByDescending(item => item.CreatedDate).Skip(indexOfPage*
sizeOfPage).
Take(sizeOfPage).ToList();
break;
case PostOptions.NotPublished:
total =
context.tblBlogs_Categories.Where(item => item.Id == categoryId).SelectMany(item => item.Posts).
Where(item => item.Published == false).Count();
list =
context.tblBlogs_Categories.Where(item => item.Id == categoryId).SelectMany(item => item.Posts).
Where(item => item.Published == false).OrderByDescending(item => item.CreatedDate).Skip(
indexOfPage*sizeOfPage).Take(sizeOfPage).ToList();
break;
default:
total =
context.tblBlogs_Categories.Where(item => item.Id == categoryId).SelectMany(item => item.Posts).
Count();
list =
context.tblBlogs_Categories.Where(item => item.Id == categoryId).SelectMany(item => item.Posts).
OrderByDescending(item => item.CreatedDate).
Skip(indexOfPage*sizeOfPage).Take(sizeOfPage).ToList();
break;
}
return list.ConvertAll(obj => Convert(obj));
}
public override void UpdateCategory(Category category)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Categories {Id = category.Id};
context.AttachTo("tblBlogs_Categories", obj);
BizObject<Category, int>.CopyToObject(category, obj);
context.SaveChanges();
}
public override List<Post> GetRecentPosts(int blogId, int numberOfPosts)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Posts.Where(item => item.BlogId == blogId && item.Published).OrderByDescending(
item => item.CreatedDate).Skip(0).Take(numberOfPosts).ToList();
return list.ConvertAll(obj => Convert(obj));
}
public override void UpdatePost(Post post)
{
var context = new BlogsEntities();
var obj = context.tblBlogs_Posts.Include("Categories").Where(item => item.Id == post.Id).FirstOrDefault();
post.CopyToObject(obj);
obj.Categories.Clear();
if (post.Categories.Count > 0)
{
var categories =
context.tblBlogs_Categories.Where(
Utils.BuildContainsExpression<tblBlogs_Categories, int>(item => item.Id,
post.Categories.Select(item => item.Id)));
foreach (var category in categories)
{
obj.Categories.Add(category);
}
}
context.SaveChanges();
}
public override void IncreaseViewCount(int postId)
{
var context = new BlogsEntities();
var post = context.tblBlogs_Posts.Where(item => item.Id == postId).First();
post.ViewCount++;
context.SaveChanges();
}
public override int InsertBlogroll(Blogroll blogroll)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Blogrolls();
BizObject<Blogroll, int>.CopyToObject(blogroll, obj);
context.AddTotblBlogs_Blogrolls(obj);
context.SaveChanges();
return obj.Id;
}
public override int InsertCategory(Category category)
{
var context = new BlogsEntities();
var obj = new tblBlogs_Categories();
BizObject<Category, int>.CopyToObject(category, obj);
context.AddTotblBlogs_Categories(obj);
context.SaveChanges();
return obj.Id;
}
public override Blogroll GetBlogrollById(int id)
{
var context = new BlogsEntities();
var obj = context.tblBlogs_Blogrolls.Where(item => item.Id == id).FirstOrDefault();
return Convert(obj);
}
public override List<Blogroll> GetBlogrolls(int blogId)
{
var context = new BlogsEntities();
var list =
context.tblBlogs_Blogrolls.Where(item => item.BlogId == blogId).OrderBy(item => item.Name).ToList();
return list.ConvertAll(obj => Convert(obj));
}