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); }