// // GET: /Posts/ public ActionResult Index(int?Id) { int id = 0; if (Id != 0 && Id != null) { id = (int)Id; tbl_Post p = PostProvider.GetPost(id); List <tbl_Comment> c = CommentProvider.GetAllCommentByPostId(id); PostModel _PostModel = new PostModel { Id = p.Id, ContentMsg = p.ContentMsg, Title = p.Title, UpdatedBy = p.UpdatedBy }; List <CommentModel> _commentModel = (from temp in c select new CommentModel { Id = temp.Id, CommentText = temp.CommentText, PostId = temp.PostId, CommentedBy = temp.CommentedBy }).ToList(); PostViewModel Model = new PostViewModel(); Model.Comments = _commentModel; Model.Post = _PostModel; return(View(Model)); } else { return(View()); } }
public static string Update(int ID, string Title, string Content, string Image, int Featured, int CategoryID, int Status, string PostSlug, string ModifiedBy, DateTime ModifiedDate) { using (var dbe = new inventorymanagementEntities()) { tbl_Post ui = dbe.tbl_Post.Where(a => a.ID == ID).SingleOrDefault(); if (ui != null) { ui.Title = Title; ui.Content = Content; ui.Image = Image; ui.Featured = Featured; ui.CategoryID = CategoryID; ui.Status = Status; ui.ModifiedBy = ModifiedBy; ui.ModifiedDate = ModifiedDate; ui.Slug = checkSlug(Slug.ConvertToSlug(PostSlug != "" ? PostSlug : Title), ui.ID); int kq = dbe.SaveChanges(); return(ui.ID.ToString()); } else { return(null); } } }
public static tbl_Post Insert(tbl_Post data) { using (var con = new inventorymanagementEntities()) { con.tbl_Post.Add(data); con.SaveChanges(); return(data); } }
public void addData() { for (int i = 1; i <= 100; i++) { var newItem = new tbl_Post { Title = "Mohammad", Body = "bensaeed" }; _db.tbl_Post.Add(newItem); } _db.SaveChanges(); }
public static tbl_Post GetByID(int ID) { using (var dbe = new inventorymanagementEntities()) { tbl_Post ai = dbe.tbl_Post.Where(a => a.ID == ID).SingleOrDefault(); if (ai != null) { return(ai); } else { return(null); } } }
public static string Delete(int ID) { using (var dbe = new inventorymanagementEntities()) { tbl_Post ui = dbe.tbl_Post.Where(o => o.ID == ID).FirstOrDefault(); if (ui != null) { dbe.tbl_Post.Remove(ui); int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string UpdateImage(int ID, string Image) { using (var dbe = new inventorymanagementEntities()) { tbl_Post ui = dbe.tbl_Post.Where(a => a.ID == ID).SingleOrDefault(); if (ui != null) { ui.Image = Image; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string updateWebPublish(int id, bool value) { using (var dbe = new inventorymanagementEntities()) { tbl_Post ui = dbe.tbl_Post.Where(a => a.ID == id).SingleOrDefault(); if (ui != null) { ui.WebPublish = value; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string Insert(string Title, string Content, string Image, int Featured, int CategoryID, int Status, string CreatedBy, DateTime CreatedDate) { using (var dbe = new inventorymanagementEntities()) { tbl_Post ui = new tbl_Post(); ui.Title = Title; ui.Content = Content; ui.Image = Image; ui.Featured = Featured; ui.CategoryID = CategoryID; ui.Status = Status; ui.CreatedBy = CreatedBy; ui.CreatedDate = CreatedDate; dbe.tbl_Post.Add(ui); dbe.SaveChanges(); int kq = ui.ID; return(kq.ToString()); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string username = Request.Cookies["usernameLoginSystem"].Value; var acc = AccountController.GetByUsername(username); DateTime currentDate = DateTime.Now; int cateID = hdfParentID.Value.ToInt(); if (cateID > 0) { string Title = txtTitle.Text.Trim(); string PostSlug = Slug.ConvertToSlug(txtSlug.Text.Trim()); string Content = pContent.Content.ToString(); var newPost = new tbl_Post() { Title = Title, Content = Content, Image = "", Featured = ddlFeatured.SelectedValue.ToInt(), CategoryID = cateID, Status = 1, CreatedBy = acc.Username, CreatedDate = currentDate, ModifiedBy = acc.Username, ModifiedDate = currentDate, WebPublish = false, WebUpdate = currentDate, Slug = PostSlug }; var post = PostController.Insert(newPost); if (post != null) { //Phần thêm ảnh đại diện string path = "/uploads/images/posts/"; string Image = ""; if (ProductThumbnailImage.UploadedFiles.Count > 0) { foreach (UploadedFile f in ProductThumbnailImage.UploadedFiles) { var o = path + "post-" + post.ID + "-" + Slug.ConvertToSlug(Path.GetFileName(f.FileName), isFile: true); try { f.SaveAs(Server.MapPath(o)); Image = o; } catch { } } } string updateImage = PostController.UpdateImage(post.ID, Image); //Phần thêm thư viện ảnh string IMG = ""; if (hinhDaiDien.UploadedFiles.Count > 0) { foreach (UploadedFile f in hinhDaiDien.UploadedFiles) { var o = path + "post-" + post.ID + "-" + Slug.ConvertToSlug(Path.GetFileName(f.FileName), isFile: true); try { f.SaveAs(Server.MapPath(o)); IMG = o; PostImageController.Insert(post.ID, IMG, username, currentDate); } catch { } } } PJUtils.ShowMessageBoxSwAlertCallFunction("Tạo bài viết thành công", "s", true, "redirectTo(" + post.ID + ")", Page); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string username = Request.Cookies["usernameLoginSystem"].Value; var acc = AccountController.GetByUsername(username); DateTime currentDate = DateTime.Now; int cateID = hdfParentID.Value.ToInt(); if (cateID > 0) { int CategoryID = ddlCategory.Value.ToInt(); var category = PostPublicCategoryController.GetByID(CategoryID); string CategorySlug = category.Slug; string Title = txtTitle.Text.Trim(); string Slugs = Slug.ConvertToSlug(txtSlug.Text.Trim()); string Link = txtLink.Text.Trim(); string Content = pContent.Content.ToString(); string Summary = HttpUtility.HtmlDecode(pSummary.Content.ToString()); string Action = ddlAction.SelectedValue.ToString(); string ActionValue = ""; if (Action == "view_more") { ActionValue = Slugs; } else if (Action == "show_web") { ActionValue = Link; } bool AtHome = ddlAtHome.SelectedValue.ToBool(); bool IsPolicy = false; var newPostPublic = new PostPublic() { CategoryID = CategoryID, CategorySlug = CategorySlug, Title = Title, Thumbnail = "", Summary = Summary, Content = Content, Action = Action, ActionValue = ActionValue, AtHome = AtHome, IsPolicy = IsPolicy, CreatedDate = currentDate, CreatedBy = acc.Username, ModifiedDate = currentDate, ModifiedBy = acc.Username }; var post = PostPublicController.Insert(newPostPublic); if (post != null) { // Thêm ảnh đại diện string path = "/uploads/images/posts/"; string Image = ""; if (PostPublicThumbnailImage.UploadedFiles.Count > 0) { foreach (UploadedFile f in PostPublicThumbnailImage.UploadedFiles) { var o = path + "post-app-" + post.ID.ToString() + "-" + Slug.ConvertToSlug(Path.GetFileName(f.FileName), isFile: true); try { f.SaveAs(Server.MapPath(o)); Image = o; } catch { } } } string updateImage = PostPublicController.UpdateImage(post.ID, Image); // Thêm thư viện ảnh string IMG = ""; if (ImageGallery.UploadedFiles.Count > 0) { foreach (UploadedFile f in ImageGallery.UploadedFiles) { var o = path + "post-app-" + post.ID.ToString() + "-" + Slug.ConvertToSlug(Path.GetFileName(f.FileName), isFile: true); try { f.SaveAs(Server.MapPath(o)); IMG = o; PostPublicImageController.Insert(post.ID, IMG, username, currentDate); } catch { } } } // Copy bài viết vào hệ thống gốc if (ddlCopyToSystem.SelectedValue == "True" && post.Action == "view_more") { var categorySystem = PostCategoryController.GetByName(category.Name); var postSystem = new tbl_Post() { Title = post.Title, Content = post.Content, Image = Image, Featured = 1, CategoryID = categorySystem != null ? categorySystem.ID : 0, Status = 1, CreatedBy = post.CreatedBy, CreatedDate = post.CreatedDate, ModifiedBy = post.ModifiedBy, ModifiedDate = post.ModifiedDate, WebPublish = true, WebUpdate = post.CreatedDate, Slug = post.ActionValue }; PostController.Insert(postSystem); // Copy image if (postSystem != null) { var imagePostPublic = PostPublicImageController.GetByPostID(post.ID); if (imagePostPublic.Count > 0) { foreach (var item in imagePostPublic) { PostImageController.Insert(postSystem.ID, item.Image, postSystem.CreatedBy, DateTime.Now); } } } } // Tạo phiên bản cho wordpress if (!String.IsNullOrEmpty(hdfPostVariants.Value)) { JavaScriptSerializer serializer = new JavaScriptSerializer(); var variants = serializer.Deserialize <List <PostClone> >(hdfPostVariants.Value); if (variants != null) { foreach (var item in variants) { var newPostClone = new PostClone() { PostPublicID = post.ID, Web = item.Web, PostWebID = 0, CategoryID = post.CategoryID, CategoryName = category.Name, Title = !String.IsNullOrEmpty(item.Title) ? item.Title : post.Title, Summary = post.Summary, Content = post.Content, Thumbnail = Image, CreatedDate = post.CreatedDate, CreatedBy = acc.Username, ModifiedDate = post.ModifiedDate, ModifiedBy = acc.Username }; PostCloneController.Insert(newPostClone); } } } PJUtils.ShowMessageBoxSwAlertCallFunction("Tạo bài viết thành công", "s", true, "redirectTo(" + post.ID.ToString() + ")", Page); } } }