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