protected string addProjectVersionArticle(projectVersionEditViewModel
viewModel, SASDdbContext db)
{
string ret;
tblArticle ta = new tblArticle(db);
tblProject tp = new tblProject();
string projectName = tp.nameById(viewModel.editModel.projectId.ToString());
article prjArticle = ta.GetByProjectId(viewModel.editModel.projectId.ToString());
article pva = new article();
pva.articleId = (Guid)viewModel.editModel.versionArticleId;
pva.createtime = DateTime.Now;
pva.articleTitle = $"project {projectName} version " +
$"{viewModel.editModel.version}";
pva.articleHtmlContent = string.Format(@"
<h1>{0} version {1}</h1>
<p>{2}</p>
", projectName, viewModel.editModel.version,
viewModel.editModel.versionDescription);
pva.articleContent = string.Format("{0} {1} {2}"
, projectName, viewModel.editModel.version
, viewModel.editModel.versionDescription);
pva.isDir = true;
pva.belongToArticleDirId = prjArticle.articleId;
pva.articleType = ARTICLE_TYPE.Project.ToString();
pva.articleStatus = ARTICLE_STATUS.New.ToString();
pva.priority = 1;
pva.projectId = viewModel.editModel.projectId;
ret = ta.Add(pva);
ret += ta.SaveChanges();
return(ret);
}
protected string addProjectArticle(projectEditViewModel viewModel
, SASDdbContext db)
{
string ret;
tblArticle ta = new tblArticle(db);
article pa = new article();
pa.articleId = (Guid)viewModel.editModel.projectArticleId;// Guid.NewGuid();
pa.createtime = DateTime.Now;
pa.articleTitle = viewModel.editModel.projectName;
pa.articleHtmlContent = string.Format(@"
<h1>{0}</h1>
<p>{1}</p>
", viewModel.editModel.projectName, viewModel.editModel.projectDescription);
pa.articleContent = string.Format("{0} {1}"
, viewModel.editModel.projectName
, viewModel.editModel.projectDescription);
pa.isDir = true;
pa.articleType = ARTICLE_TYPE.Project.ToString();
pa.articleStatus = ARTICLE_STATUS.New.ToString();
pa.priority = 1;
pa.projectId = viewModel.editModel.projectId;
ret = ta.Add(pa);
ret += ta.SaveChanges();
return(ret);
}
public IActionResult EditArticle(articleEditViewModel viewModel)
{
IActionResult ret;
string err;
//todo !!... edit article
// articles, ckeditor, paste base64 image
object obj = Request.Form;
switch (viewModel.cmd)
{
case "save":
err = checkForm(viewModel);
if (err.Length > 0)
{
viewModel.errorMsg = err;
ret = View(viewModel);
break;
}
//Article article2add = new Article();
//article2add.ArticleId = Guid.NewGuid();
//article2add.ArticleTitle =
// viewModel.ArticleTitle;
//article2add.ArticleHtmlContent =
// viewModel.ArticleHtmlContent;
string pureText;
err = htmlHelper.removeHtmlTags(
viewModel.ArticleHtmlContent, out pureText);
if (err.Length > 0)
{
viewModel.errorMsg = err;
ret = View(viewModel);
break;
}
viewModel.ArticleContent = pureText;
//article2add.IsDir = viewModel.IsDir ;
tblArticle tArticle = new tblArticle();
if (viewModel.changeMode == ARTICLE_CHANGE_MODE.CREATE)
{
viewModel.ArticleId = Guid.NewGuid();
err = tArticle.Add(viewModel);
err += tArticle.SaveChanges();
}
else if (viewModel.changeMode == ARTICLE_CHANGE_MODE.EDIT)
{
err = tArticle.Update(viewModel);
err += tArticle.SaveChanges();
}
else if (viewModel.changeMode == ARTICLE_CHANGE_MODE.REPLY_TO)
{
// transaction, 1. create replied article 2. change original article to be directory type
SASDdbBase db = new SASDdbBase();
using (var transaction = db.BeginTransaction())
{
viewModel.ArticleId = Guid.NewGuid();
err = tArticle.Add(viewModel);
err += tArticle.SaveChanges();
tblArticle tart = new tblArticle();
Article replied = tart.GetArticleById(viewModel.BelongToArticleDirId.ToString());
replied.IsDir = true;
tart.Update(replied);
tart.SaveChanges();
transaction.Commit();
}
}
if (err.Length > 0)
{
viewModel.errorMsg = err;
}
else
{
viewModel.successMsg = "new article successfully added";
}
//undone !!... notification failed
//todo !!...proceed to save article/directory
//ViewBag.Message = "article/directory saved";
ret = View(viewModel);
break;
default:
ret = View(viewModel);
break;
}
TempData["articleEditViewModel"] = jsonUtl.encodeJson(viewModel);
return(ret);
}
public ActionResult EditArticle(articleEditViewModel viewModel)
{
ActionResult ret;
ViewBag.articleTypeOption = SAdropdownOptions.articleTypeOption();
ViewBag.articleStatusOption = SAdropdownOptions.articleStatusOption();
ViewBag.articlePriorityOption = SAdropdownOptions.articlePriorityOption();
ViewBag.userList = PMdropdownOption.userList();
string err;
// articles, ckeditor, paste base64 image
switch (viewModel.cmd)
{
case "save":
err = checkForm(viewModel);
if (err.Length > 0)
{
viewModel.errorMsg = err;
ret = View(viewModel);
break;
}
//article article2add = new article();
//article2add.ArticleId = Guid.NewGuid();
//article2add.ArticleTitle =
// viewModel.ArticleTitle;
//article2add.ArticleHtmlContent =
// viewModel.ArticleHtmlContent;
string pureText;
err = htmlHelper.removeHtmlTags(
viewModel.editModel.articleHtmlContent, out pureText);
if (err.Length > 0)
{
viewModel.errorMsg = err;
ret = View(viewModel);
break;
}
viewModel.editModel.articleContent = pureText;
//article2add.IsDir = viewModel.IsDir ;
tblArticle tArticle = new tblArticle();
if (viewModel.changeMode == ARTICLE_CHANGE_MODE.CREATE)
{
viewModel.editModel.articleId = Guid.NewGuid();
viewModel.editModel.createtime = DateTime.Now;
//article art = new article();
//art.articleId = viewModel.articleId;
//art.createtime = DateTime.Now;
//art.articleTitle = viewModel.articleTitle;
//art.articleHtmlContent = viewModel.articleHtmlContent;
//art.articleContent = viewModel.articleContent;
//art.isDir = viewModel.isDir;
//art.belongToArticleDirId = viewModel.belongToArticleDirId;
err = tArticle.Add(viewModel.editModel); // as article);
err += tArticle.SaveChanges();
if (err.Length > 0)
{
viewModel.errorMsg = "error: " + err;
}
else
{
viewModel.successMsg = "new article successfully added";
viewModel.pageStatus = (int)modelsfwk.PAGE_STATUS.ADDSAVED;
}
}
else if (viewModel.changeMode == ARTICLE_CHANGE_MODE.EDIT)
{
err = tArticle.Update(viewModel.editModel);
err += tArticle.SaveChanges();
if (err.Length > 0)
{
viewModel.errorMsg = "error: " + err;
}
else
{
viewModel.successMsg = "article successfully updated";
viewModel.pageStatus = (int)modelsfwk.PAGE_STATUS.SAVED;
}
}
else if (viewModel.changeMode == ARTICLE_CHANGE_MODE.REPLY_TO)
{
// transaction, 1. create replied article 2. change original article to be directory type
string err1 = "";
SASDdbBase db = new SASDdbBase();
using (var transaction = db.BeginTransaction())
{
viewModel.editModel.articleId = Guid.NewGuid();
viewModel.editModel.createtime = DateTime.Now;
err1 = tArticle.Add(viewModel.editModel); // as article);
err1 += tArticle.SaveChanges();
tblArticle tart = new tblArticle();
article replied = tart.GetArticleById(viewModel.editModel.belongToArticleDirId.ToString());
replied.isDir = true;
err1 += tart.Update(replied);
err1 += tart.SaveChanges();
if (err1.Length == 0)
{
transaction.Commit();
}
else
{
err += err1;
}
}
if (err.Length > 0)
{
viewModel.errorMsg = "error: " + err;
}
else
{
viewModel.successMsg = "new article successfully added";
viewModel.pageStatus = (int)modelsfwk.PAGE_STATUS.ADDSAVED;
}
}
// notification failed, so, should use pure hidden field rather than html helped
//ViewBag.Message = "article/directory saved";
ret = View(viewModel);
break;
default:
ret = View(viewModel);
break;
}
TempData["articleEditViewModel"] = viewModel;
return(ret);
}
