public void AddNewArticle(tblArticles article)
{
using (var context = this.CreateDbContext())
{
//article.tblUsers = context.Set<tblUsers>().Single(n => n.ID == article.UserID);
context.Set <tblArticles>().Add(article);
context.SaveChanges();
}
}
public ActionResult Edit(int id, tblArticles article)
{
try
{
using (Article db = new Article())
{
db.Entry(article).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void AttachTagToArticle(List <tblTags> tags, tblArticles article)
{
using (DbContext context = this.CreateDbContext())
{
//List<tblArticlesTags> articleTags = new List<tblArticlesTags>();
foreach (tblTags t in tags)
{
context.Set <tblArticlesTags>().Add(new tblArticlesTags( )
{
ArticleID = article.ID,
TagID = t.ID
});
}
context.SaveChanges();
}
}
public ActionResult Create(tblArticles article)
{
try
{
using (Article db = new Article())
{
db.tblArticles.Add(article);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, tblArticles article)
{
try
{
// TODO: Add delete logic here
using (Article db = new Article())
{
article = db.tblArticles.Where(x => x.Id == id).FirstOrDefault();
db.tblArticles.Remove(article);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult NewArticle(NewArticleModel newArticleModel)
{
if (newArticleModel.Tags.Length > 0)
{
ITagService tagService = new TagService();
List <string> tagList = tagService.ParseTags(newArticleModel.Tags);
List <tblTags> dbLinkedTags = tagService.FindOrAddTags(tagList);
tblArticles article = new tblArticles()
{
Content = newArticleModel.Content,
Header = newArticleModel.Header,
Date = DateTime.Now,
UserID = 1
};
this._articleManager.AddNewArticle(article);
tagService.AttachTagToArticle(dbLinkedTags, article);
}
return(Redirect(Url.Content("~/")));
}
public List <tblComments> AddCommentToArticleById(int ArticleID, tblComments comment)
{
List <tblComments> comments;
using (DbContext context = this.CreateDbContext())
{
tblUsers user = context.Set <tblUsers>().Single(n => n.ID == comment.UserID);
tblArticles article = context.Set <tblArticles>().Single(n => n.ID == ArticleID);
comment.tblArticles = article;
comment.tblUsers = user;
context.Set <tblComments>().Add(comment);
context.SaveChanges();
comments = context.Set <tblComments>()
.Where(n => n.ArticleID == ArticleID)
.Include(n => n.tblUsers)
.ToList();
}
return(comments);
}
public void AttachTagToArticle(List <tblTags> tags, tblArticles article)
{
_tagManager.AttachTagToArticle(tags, article);
}
