public ActionResult CreateArticle(string editorContent, string tagSelect, string stringTitle)
{
var appliedTagList = JsonConvert.DeserializeObject<string[]>(tagSelect);
int arId = 0;
if (ModelState.IsValid)
{
Article article = new Article();
article.Title = stringTitle;
while (editorContent.EndsWith("<br>"))
editorContent = editorContent.Substring(0, editorContent.Length - 4);
article.Content = editorContent.Trim('\r', '\n', ' ');
article.UserId = User.Identity.GetUserId<int>();
article.CreateDate = DateTime.Now;
article.isActive = true;
article.View = 0;
db.Articles.Add(article);
db.SaveChanges();
arId = article.Id;
if (appliedTagList != null)
{
foreach (var item in appliedTagList)
{
AppliedTagArticle appliedTag = new AppliedTagArticle();
appliedTag.ArticleId = article.Id;
appliedTag.TagId = Int32.Parse(item);
//appliedTag.TaggingUser = WebSecurity.CurrentUserId;
appliedTag.AppliedDate = DateTime.Now;
db.AppliedTagArticles.Add(appliedTag);
db.SaveChanges();
}
}
}
return Json(arId, JsonRequestBehavior.AllowGet);
}
public ActionResult EditArticle(string articleId, string editorContent, string tagSelect, string stringTitle)
{
int id = Int32.Parse(articleId);
var appliedTagList = JsonConvert.DeserializeObject<string[]>(tagSelect);
if (ModelState.IsValid)
{
Article article = (from qt in db.Articles
where qt.Id == id && qt.isActive == true
select qt).FirstOrDefault();
article.Title = stringTitle;
while (editorContent.EndsWith("<br>"))
editorContent = editorContent.Substring(0, editorContent.Length - 4);
article.Content = editorContent.Trim('\r', '\n', ' ');
article.CreateDate = DateTime.Now;
article.isActive = true;
//asking. = 0;
db.Entry(article).State = EntityState.Modified;
db.SaveChanges();
// Delete applied tags in question
var appliedTags = (from apTag in db.AppliedTagArticles
where apTag.ArticleId == id
select apTag).ToList();
foreach (var item in appliedTags)
{
var delTag = db.AppliedTagArticles.Where(a => a.ArticleId == id
&& a.TagId == item.TagId).Single();
db.AppliedTagArticles.Remove(delTag);
}
db.SaveChanges();
//Save Applied tags
if (appliedTagList != null)
{
foreach (var item in appliedTagList)
{
AppliedTagArticle appliedTag = new AppliedTagArticle();
appliedTag.ArticleId = article.Id;
appliedTag.TagId = Int32.Parse(item);
//appliedTag.TaggingUser = WebSecurity.CurrentUserId;
appliedTag.AppliedDate = DateTime.Now;
db.AppliedTagArticles.Add(appliedTag);
db.SaveChanges();
}
}
}
return Json(id, JsonRequestBehavior.AllowGet);
}