public static PostPublic Update(PostPublic data) { using (var con = new inventorymanagementEntities()) { var post = con.PostPublics.Where(o => o.ID == data.ID).FirstOrDefault(); if (post != null) { post.Action = data.Action; post.ActionValue = data.ActionValue; post.AtHome = data.AtHome; post.CategoryID = data.CategoryID; post.CategorySlug = data.CategorySlug; post.Content = data.Content; post.CreatedBy = data.CreatedBy; post.CreatedDate = data.CreatedDate; post.IsPolicy = data.IsPolicy; post.ModifiedBy = data.ModifiedBy; post.ModifiedDate = data.ModifiedDate; post.Summary = data.Summary; post.Thumbnail = data.Thumbnail; post.Title = data.Title; con.SaveChanges(); return(post); } return(null); } }
public static PostPublic Insert(PostPublic data) { using (var con = new inventorymanagementEntities()) { con.PostPublics.Add(data); con.SaveChanges(); return(data); } }
public static string copyPostToApp(int id) { var post = PostController.GetByID(id); if (post != null) { var postCategory = PostCategoryController.GetByID(post.CategoryID.Value); PostCategory postPublicCategory = new PostCategory(); if (postCategory != null) { postPublicCategory = PostPublicCategoryController.GetByName(postCategory.Title); } var newPostPublic = new PostPublic() { CategoryID = postPublicCategory != null ? postPublicCategory.ID : 0, CategorySlug = postPublicCategory != null ? postPublicCategory.Slug : "", Title = post.Title, Thumbnail = post.Image, Summary = "", Content = post.Content, Action = "view_more", ActionValue = PostPublicController.checkSlug(post.Slug), AtHome = false, IsPolicy = false, CreatedDate = DateTime.Now, CreatedBy = post.CreatedBy, ModifiedDate = DateTime.Now, ModifiedBy = post.CreatedBy }; var newpost = PostPublicController.Insert(newPostPublic); if (newpost != null) { // Copy image gallery var postImage = PostImageController.GetToCopyByPostID(post.ID); if (postImage.Count > 0) { foreach (var img in postImage) { if (!string.IsNullOrEmpty(img.Image)) { string newImage = PostPublicImageController.Insert(newpost.ID, img.Image, newpost.CreatedBy, DateTime.Now); } } } return(newpost.ID.ToString()); } } return("false"); }
public static PostPublic GetByID(int ID) { using (var dbe = new inventorymanagementEntities()) { PostPublic ai = dbe.PostPublics.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()) { PostPublic ui = dbe.PostPublics.Where(o => o.ID == ID).FirstOrDefault(); if (ui != null) { dbe.PostPublics.Remove(ui); int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string UpdateImage(int ID, string Thumbnail) { using (var dbe = new inventorymanagementEntities()) { PostPublic ui = dbe.PostPublics.Where(a => a.ID == ID).SingleOrDefault(); if (ui != null) { ui.Thumbnail = Thumbnail; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
public static string updateAtHome(int id, bool value) { using (var dbe = new inventorymanagementEntities()) { PostPublic ui = dbe.PostPublics.Where(a => a.ID == id).SingleOrDefault(); if (ui != null) { ui.AtHome = value; int kq = dbe.SaveChanges(); return(kq.ToString()); } else { return(null); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string username = Request.Cookies["usernameLoginSystem"].Value; var acc = AccountController.GetByUsername(username); DateTime currentDate = DateTime.Now; int PostID = ViewState["ID"].ToString().ToInt(0); var post = PostPublicController.GetByID(PostID); if (post != null) { int CategoryID = hdfParentID.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 = ddlIsPolicy.SelectedValue.ToBool(); //Phần thêm ảnh đại diện sản phẩm string path = "/uploads/images/posts/"; string Thumbnail = ListPostPublicThumbnail.Value; if (PostPublicThumbnailImage.UploadedFiles.Count > 0) { foreach (UploadedFile f in PostPublicThumbnailImage.UploadedFiles) { var o = path + "post-app-" + PostID + '-' + Slug.ConvertToSlug(Path.GetFileName(f.FileName), isFile: true); try { f.SaveAs(Server.MapPath(o)); Thumbnail = o; } catch { } } } // Delete Image Gallery string deleteImageGallery = hdfDeleteImageGallery.Value; if (deleteImageGallery != "") { string[] deletelist = deleteImageGallery.Split(','); for (int i = 0; i < deletelist.Length - 1; i++) { var img = PostPublicImageController.GetByID(Convert.ToInt32(deletelist[i])); if (img != null) { string delete = PostPublicImageController.Delete(img.ID); } } } // Update post var oldPostPublic = new PostPublic() { ID = PostID, CategoryID = CategoryID, CategorySlug = CategorySlug, Title = Title, Thumbnail = Thumbnail, Summary = Summary, Content = Content, Action = Action, ActionValue = ActionValue, AtHome = AtHome, IsPolicy = IsPolicy, CreatedDate = post.CreatedDate, CreatedBy = acc.Username, ModifiedDate = currentDate, ModifiedBy = acc.Username }; var updatePost = PostPublicController.Update(oldPostPublic); if (updatePost != null) { // Cập nhật thư viện ảnh cho bài viết if (UploadImages.HasFiles) { foreach (HttpPostedFile uploadedFile in UploadImages.PostedFiles) { var o = path + "post-app-" + PostID + '-' + Slug.ConvertToSlug(Path.GetFileName(uploadedFile.FileName), isFile: true); uploadedFile.SaveAs(Server.MapPath(o)); PostPublicImageController.Insert(PostID, o, username, 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 getpostClone = PostCloneController.Get(updatePost.ID, item.Web); if (getpostClone == null) { continue; } var oldPostClone = new PostClone() { ID = getpostClone.ID, PostPublicID = updatePost.ID, Web = getpostClone.Web, PostWebID = getpostClone.PostWebID, CategoryName = category.Name, CategoryID = updatePost.CategoryID, Title = !String.IsNullOrEmpty(item.Title) ? item.Title : updatePost.Title, Summary = updatePost.Summary, Content = updatePost.Content, Thumbnail = updatePost.Thumbnail, CreatedBy = getpostClone.CreatedBy, CreatedDate = getpostClone.CreatedDate, ModifiedDate = currentDate, ModifiedBy = acc.Username }; PostCloneController.Update(oldPostClone); } } } PJUtils.ShowMessageBoxSwAlertCallFunction("Cập nhật bài viết thành công", "s", true, "redirectTo(" + updatePost.ID.ToString() + ")", 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); } } }