public int CreateEmptyArticle() { var article = new Article { DateCreate = DateTime.Now, DatePublish = DateTime.Now.AddHours(3), CategoryId = GetFirstArticleCategory(), TranslitUrl = Guid.NewGuid().ToString() }; _context.Articles.Add(article); _context.SaveChanges(); article.Title = string.Format("Нова стаття #: {0}", article.ArticleId); _context.SaveChanges(); return article.ArticleId; }
public bool SaveArticle(Article article) { var articleDb = GetArticle(article.ArticleId); if (string.IsNullOrEmpty(article.TranslitUrl)) { string tr = _context.Database.SqlQuery<string>(String.Format("Select dbo.ChangeToTranslit('{0}')", article.Title.Replace("'", "-"))).Single(); bool urlExist = _context.Articles.Where(w => w.ArticleId != article.ArticleId).Any(a => a.TranslitUrl == tr); if (urlExist) { tr = string.Format("{0}_{1}", tr, article.ArticleId.ToString().Substring(article.ArticleId.ToString().Length - 4)); } article.TranslitUrl = tr; } _context.Entry(articleDb).CurrentValues.SetValues(article); _context.SaveChanges(); return true; }