public static PostWithCategories Get(int id = 0)
{
try {
EcommercePlatformDataContext db = new EcommercePlatformDataContext();
PostWithCategories post = new PostWithCategories();
post = (from p in db.BlogPosts
where p.blogPostID.Equals(id)
select new PostWithCategories {
blogPostID = p.blogPostID,
post_title = p.post_title,
slug = p.slug,
profileID = p.profileID,
post_text = p.post_text,
publishedDate = p.publishedDate,
createdDate = p.createdDate,
lastModified = p.lastModified,
keywords = p.keywords,
meta_title = p.meta_title,
meta_description = p.meta_description,
active = p.active,
author = GetAuthor(p.profileID),
categories = (from c in db.BlogCategories join pc in db.BlogPost_BlogCategories on c.blogCategoryID equals pc.blogCategoryID where pc.blogPostID.Equals(p.blogPostID) select c).ToList<BlogCategory>(),
comments = (from cm in db.Comments where cm.blogPostID.Equals(p.blogPostID) && cm.approved.Equals(true) && cm.active.Equals(true) select cm).ToList<Comment>(),
mod_comments = (from cm in db.Comments where cm.blogPostID.Equals(p.blogPostID) && cm.approved.Equals(false) && cm.active.Equals(true) select cm).ToList<Comment>()
}).First<PostWithCategories>();
return post;
} catch (Exception e) {
return new PostWithCategories();
}
}
public ActionResult SavePost(List<string> categories, int id = 0, int profileid = 0, bool publish = false, string post_title = "", int contentID = 0, string content = "", string meta_title = "", string meta_description = "", string keywords = "") {
string message = "Saved Successfully";
PostWithCategories p = new PostWithCategories {
blogPostID = id,
profileID = profileid,
post_title = post_title.Trim(),
slug = UDF.GenerateSlug(post_title.Trim()),
post_text = content.Trim(),
createdDate = DateTime.UtcNow,
lastModified = DateTime.UtcNow,
meta_title = meta_title.Trim(),
meta_description = meta_description.Trim(),
keywords = keywords.Trim(),
categories = BlogCategoryModel.GetList(categories),
active = true
};
try {
if (p.post_title.Length == 0) { throw new Exception("You must enter a title for the post"); }
p.blogPostID = BlogPostModel.Save(p,publish);
} catch (Exception e) {
TempData["post"] = p;
message = e.Message;
}
return RedirectToAction("EditPost", new { id = p.blogPostID, error = message });
}
public static int Save(PostWithCategories p, bool publish = false)
{
EcommercePlatformDataContext db = new EcommercePlatformDataContext();
BlogPost post = new BlogPost();
if (p.blogPostID == 0) {
post = new BlogPost {
profileID = p.profileID,
post_title = p.post_title,
slug = p.slug,
post_text = p.post_text,
createdDate = DateTime.Now,
lastModified = DateTime.Now,
meta_title = p.meta_title,
meta_description = p.meta_description,
keywords = p.keywords,
active = true
};
if (publish)
post.publishedDate = DateTime.Now;
db.BlogPosts.InsertOnSubmit(post);
db.SubmitChanges();
if (p.categories.Count() > 0) {
foreach (BlogCategory cat in p.categories) {
if (cat.blogCategoryID != 0) {
try {
BlogPost_BlogCategory postcat = new BlogPost_BlogCategory {
blogPostID = post.blogPostID,
blogCategoryID = cat.blogCategoryID
};
db.BlogPost_BlogCategories.InsertOnSubmit(postcat);
} catch { }
}
}
}
} else {
post = db.BlogPosts.Where(x => x.blogPostID == p.blogPostID).FirstOrDefault<BlogPost>();
post.meta_title = p.meta_title;
post.meta_description = p.meta_description;
post.keywords = p.keywords;
post.profileID = p.profileID;
post.lastModified = DateTime.Now;
post.post_title = p.post_title;
post.slug = p.slug;
post.post_text = p.post_text;
if (publish) {
if (post.publishedDate == null) { post.publishedDate = DateTime.Now; }
} else {
post.publishedDate = null;
}
List<BlogPost_BlogCategory> postcats = db.BlogPost_BlogCategories.Where(x => x.blogPostID == post.blogPostID).ToList<BlogPost_BlogCategory>();
db.BlogPost_BlogCategories.DeleteAllOnSubmit<BlogPost_BlogCategory>(postcats);
db.SubmitChanges();
if (p.categories.Count() > 0) {
foreach (BlogCategory cat in p.categories) {
if (cat.blogCategoryID != 0) {
try {
BlogPost_BlogCategory postcat = new BlogPost_BlogCategory {
blogPostID = post.blogPostID,
blogCategoryID = cat.blogCategoryID
};
db.BlogPost_BlogCategories.InsertOnSubmit(postcat);
} catch { }
}
}
}
}
db.SubmitChanges();
return post.blogPostID;
}