public string UpdateArticle(VwArticle articleModel) { var success = ""; try { using (WebSiteContext db = new WebSiteContext()) { Article updateArticle = db.Articles.Where(a => a.Id.ToString() == articleModel.Id).FirstOrDefault(); updateArticle.Title = articleModel.Title; updateArticle.CategoryRef = articleModel.CategoryRef; updateArticle.SubCategoryRef = articleModel.SubCategoryRef; updateArticle.ImageName = articleModel.ImageName; updateArticle.LastUpdated = articleModel.LastUpdated; //DateTime.Now; updateArticle.ByLineRef = articleModel.ByLineRef; updateArticle.Content = articleModel.Content; updateArticle.Summary = articleModel.Summary; //db.ArticleTags.RemoveRange(db.ArticleTags.Where(t => t.articleId.ToString() == editArticle.Id)); ////article.ArticleTags = null; //foreach (DbArticleTagModel tagModel in editArticle.Tags) //{ // article.ArticleTags.Add(new ArticleTag() { articleId = article.Id, Id = tagModel.Id, TagName = tagModel.TagName }); //} db.SaveChanges(); success = "ok"; } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }
public ArticleModel GetSingleArticle(string articleId) { var articleModel = new ArticleModel(); try { using (WebSiteContext db = new WebSiteContext()) { VwArticle dbVwArticle = db.VwArticles.Where(a => a.Id.ToString() == articleId).FirstOrDefault(); if (dbVwArticle != null) { articleModel.Article = dbVwArticle; articleModel.Success = "ok"; } } } catch (Exception ex) { articleModel.Success = Helpers.ErrorDetails(ex); } return(articleModel); }
public string AddNewArticle(VwArticle articleModel) { string success; try { Article newArticle = new Article { //Id = Guid.NewGuid().ToString(), Id = articleModel.Id, Title = articleModel.Title, CategoryRef = articleModel.CategoryRef, SubCategoryRef = articleModel.SubCategoryRef, ImageName = articleModel.ImageName, Created = DateTime.Now, LastUpdated = DateTime.Now, Content = articleModel.Content, Summary = articleModel.Summary, ByLineRef = articleModel.ByLineRef }; //foreach (DbArticleTagModel tag in articleModel.Tags) // if (tag.TagName != null) // newArticle.ArticleTags.Add(new ArticleTag() { TagName = tag.TagName, TagCategoryRef = tag.TagCategoryRef }); using (WebSiteContext db = new WebSiteContext()) { db.Articles.Add(newArticle); db.SaveChanges(); success = "ok"; } } catch (Exception ex) { success = Helpers.ErrorDetails(ex); } return(success); }