Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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 });
        }
Esempio n. 3
0
        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;
        }