public ActionResult EditBlog(FormCollection form) { var Articles = new b2bArticle(); var svCompany = new Company.CompanyService(); if (!string.IsNullOrEmpty(form["ArticleID"])) { Articles = svCompany.SelectData <b2bArticle>("*", " IsDelete = 0 AND ArticleID =" + form["ArticleID"]).First(); } return(Json(new { ArticleID = Articles.ArticleID, CompID = Articles.CompID, RowVersion = Articles.RowVersion, ArticleTypeID = Articles.ArticleTypeID, ArticleName = Articles.ArticleName, pageTitle = Articles.PageTitle, ImgPath = Articles.ImgPath, Description = Articles.Description, ShortDescription = Articles.ShortDescription })); }
public ActionResult EditArticle(FormCollection form) { var Articles = new b2bArticle(); var emArticles = new emArticle(); int ArticleTypeID = DataManager.ConvertToInteger(form["ArticleTypeID"]); int CompID = DataManager.ConvertToInteger(form["hideCompID"]); int OldCompID = DataManager.ConvertToInteger(form["OldCompID"]); Articles = svArticle.SelectData <b2bArticle>("*", " ArticleID = " + form["ArticleID"] + " AND RowVersion = " + form["RowVersion"]).First(); #region set ค่า b2bArticle // set Value var ArticleImgPath = Articles.ImgPath; var a = form["ImgPath"]; Articles.ArticleName = form["ArticleName"]; Articles.ArticleTypeID = ArticleTypeID; Articles.Description = ReplaceText(form["Description"]); Articles.ShortDescription = ReplaceText(form["ShortDescription"]); if (!string.IsNullOrEmpty(form["ImgPath"]) && form["ImgPath"] != ArticleImgPath) { Articles.ImgPath = form["ImgPath"]; } else { Articles.ImgPath = Articles.ImgPath; } Articles.PageTitle = form["PageTitle"]; Articles.Owner = form["Owner"]; Articles.Position = form["Position"]; Articles.IsHot = DataManager.ConvertToBool(form["IsHot"]); if (ArticleTypeID == 7) { Articles.CompID = CompID; } else { Articles.CompID = DataManager.ConvertToInteger(Articles.CompID); } #endregion Articles.ModifiedDate = DateTime.Now; Articles.RowVersion = DataManager.ConvertToShort(Articles.RowVersion + 1); emArticles.RowVersion = DataManager.ConvertToShort(emArticles.RowVersion + 1); #region Save b2bArticle Articles = svArticle.SaveData <b2bArticle>(Articles, "ArticleID"); if (svArticle.IsResult) { emArticles.ModifiedDate = DateTime.Now; emArticles.RowVersion = Articles.RowVersion; #region Save emArticle emArticles = svArticle.SaveData <emArticle>(emArticles, "ArticleID"); #endregion if (svArticle.IsResult && svArticle.IsResult) { #region SaveArticleImg if (!string.IsNullOrEmpty(form["ImgPath"])) { /* Check New Company */ if (OldCompID != CompID) { /* New Img */ if (Articles.ImgPath != ArticleImgPath) { imgManager = new FileHelper(); imgManager.DirPath = "Article/" + Articles.CompID + "/" + Articles.ArticleID; imgManager.DirTempPath = "Temp/Article/" + LogonCompID; imgManager.ImageName = form["ImgPath"]; imgManager.FullHeight = 0; imgManager.FullWidth = 0; imgManager.ThumbHeight = 150; imgManager.ThumbWidth = 150; imgManager.SaveImageFromTemp(); } /* Old Img */ else { var svBlobStorage = new BlobStorageService(); string fromFilePath = "Article/" + OldCompID + "/" + Articles.ArticleID + "/" + form["ImgPath"]; string descFilePath = "Article/" + Articles.CompID + "/" + Articles.ArticleID + "/" + form["ImgPath"]; svBlobStorage.CopyBlob(fromFilePath, descFilePath); } } /* Check Old Company */ else { if (Articles.ImgPath != ArticleImgPath) { imgManager = new FileHelper(); imgManager.DirPath = "Article/" + Articles.CompID + "/" + Articles.ArticleID; imgManager.DirTempPath = "Temp/Article/" + LogonCompID; imgManager.ImageName = form["ImgPath"]; imgManager.FullHeight = 0; imgManager.FullWidth = 0; imgManager.ThumbHeight = 150; imgManager.ThumbWidth = 150; imgManager.SaveImageFromTemp(); } } } #endregion } } #endregion return(Redirect("~/Admin/Article/list")); }
public ActionResult NewArticle(FormCollection form) { var Articles = new b2bArticle(); var emArticles = new emArticle(); int ArticleTypeID = DataManager.ConvertToInteger(form["ArticleTypeID"]); int CompID = DataManager.ConvertToInteger(form["hideCompID"]); #region set ค่า b2bArticle //Set Default Articles.ViewCount = 0; Articles.RowFlag = 1; Articles.RowVersion = 1; Articles.CreatedBy = "sa"; Articles.ModifiedBy = "sa"; Articles.ModifiedDate = DateTimeNow; Articles.CreatedDate = DateTimeNow; Articles.IsShow = true; // set Value var ArticleImgPath = Articles.ImgPath; Articles.CompID = DataManager.ConvertToInteger(LogonCompID); Articles.ArticleName = form["ArticleName"]; Articles.ArticleTypeID = ArticleTypeID; Articles.Description = ReplaceText(form["Description"]); Articles.ShortDescription = ReplaceText(form["ShortDescription"]); Articles.ImgPath = form["ImgPath"]; Articles.PageTitle = form["PageTitle"]; Articles.Owner = form["Owner"]; Articles.Position = form["Position"]; Articles.IsHot = DataManager.ConvertToBool(form["IsHot"]); // new set Articles.ListNo = DataManager.ConvertToInteger(form["ListNo"]); Articles.IsShow = DataManager.ConvertToBool(form["IsShowArticle"]); #endregion #region Save b2bArticle Articles = svArticle.SaveData <b2bArticle>(Articles, "ArticleID"); if (svArticle.IsResult) { emArticles.CompID = DataManager.ConvertToInteger(LogonEMCompID); emArticles.ArticleName = Articles.ArticleName; emArticles.ArticleTypeID = Articles.ArticleTypeID; emArticles.Description = Articles.Description; emArticles.ShortDescription = Articles.ShortDescription; emArticles.ImgPath = Articles.ImgPath; emArticles.PageTitle = Articles.PageTitle; emArticles.ViewCount = Articles.ViewCount; // new save emArticles.ListNo = Articles.ListNo; emArticles.IsShow = Articles.IsShow; #region Save emArticle emArticles = svArticle.SaveData <emArticle>(emArticles, "ArticleID"); #endregion if (svArticle.IsResult && svArticle.IsResult) { #region SaveArticleImg if (!string.IsNullOrEmpty(form["ImgPath"])) { if (Articles.ImgPath != ArticleImgPath) { imgManager = new FileHelper(); if (ArticleTypeID == 7) { imgManager.DirPath = "Article/" + CompID + "/" + Articles.ArticleID; } else { imgManager.DirPath = "Article/" + LogonCompID + "/" + Articles.ArticleID; } imgManager.DirTempPath = "Temp/Article/" + LogonCompID; imgManager.ImageName = form["ImgPath"]; imgManager.FullHeight = 0; imgManager.FullWidth = 0; imgManager.ThumbHeight = 150; imgManager.ThumbWidth = 150; imgManager.SaveImageFromTemp(); } } #endregion } } #endregion return(Redirect("~/Admin/Article/List")); }
public bool SaveBlog(FormCollection form) { int objState = DataManager.ConvertToInteger(form["objState"]);//objState 1 คือ insert objState 2 คือ update var Articles = new b2bArticle(); var emArticles = new emArticle(); var svMember = new Common.MemberService(); var svCompany = new Company.CompanyService(); if (objState == 2)// update { Articles = svCompany.SelectData <b2bArticle>("*", " ArticleID = " + form["ArticleID"] + " AND RowVersion = " + form["RowVersion"]).First(); } #region set ค่า b2bArticle var ArticleImgPath = Articles.ImgPath; Articles.CompID = DataManager.ConvertToInteger(LogonCompID); Articles.ArticleName = form["ArticleName"]; Articles.ArticleTypeID = DataManager.ConvertToInteger(form["ArticleTypeID"]); Articles.Description = ReplaceText(form["Description"]); Articles.ShortDescription = ReplaceText(form["ShortDescription"]); Articles.ImgPath = form["ImgPath"]; Articles.PageTitle = form["PageTitle"]; if (objState == 2)// update { Articles.RowVersion = DataManager.ConvertToShort(Articles.RowVersion + 1); emArticles.RowVersion = DataManager.ConvertToShort(emArticles.RowVersion + 1); } else { Articles.ViewCount = 0; Articles.RowFlag = 1; Articles.RowVersion = 1; Articles.CreatedBy = "sa"; Articles.ModifiedBy = "sa"; Articles.ModifiedDate = DateTime.Now; Articles.CreatedDate = DateTime.Now; } #endregion #region Save b2bArticle Articles = svCompany.SaveData <b2bArticle>(Articles, "ArticleID"); if (svCompany.IsResult) { if (objState == 2)// update { emArticles.RowVersion = Articles.RowVersion; } else { emArticles.CompID = DataManager.ConvertToInteger(Request.Cookies[res.Common.lblWebsite].Values["emCompID"]); emArticles.ArticleName = Articles.ArticleName; emArticles.ArticleTypeID = Articles.ArticleTypeID; emArticles.Description = Articles.Description; emArticles.ShortDescription = Articles.ShortDescription; emArticles.ImgPath = Articles.ImgPath; emArticles.PageTitle = Articles.PageTitle; emArticles.ViewCount = Articles.ViewCount; } #region Save emArticle emArticles = svMember.SaveData <emArticle>(emArticles, "ArticleID"); #endregion if (svCompany.IsResult && svMember.IsResult) { #region SaveArticleImg if (!string.IsNullOrEmpty(form["ImgPath"])) { if (Articles.ImgPath != ArticleImgPath) { imgManager = new FileHelper(); imgManager.DirPath = "Article/" + LogonCompID + "/" + Articles.ArticleID; imgManager.DirTempPath = "Temp/Article/" + LogonCompID; imgManager.ImageName = form["ImgPath"]; //imgManager.ImageThumbName = "Thumb_" + form["ImgPath"]; imgManager.FullHeight = 0; imgManager.FullWidth = 0; imgManager.ThumbHeight = 150; imgManager.ThumbWidth = 150; imgManager.SaveImageFromTemp(); } } #endregion } } #endregion return(svCompany.IsResult); }