public int?MakeRawArticleDraft(int articleId, string userId)
{
RawArticle rawArticle = dbContext.RawArticles.Find(articleId);
if (rawArticle == null)
{
return(null);
}
Article newArticle = mapper.Map <Article>(rawArticle);
newArticle.TempArticleId = rawArticle.Id;
newArticle.Id = 0;
newArticle.CreationDate = DateTime.UtcNow;
newArticle.CreatorId = userId;
newArticle.State = Data.Enums.ArticleState.Draft;
dbContext.Articles.Add(newArticle);
rawArticle.IsDeleted = true;
dbContext.SaveChanges();
ArticleSeoData articleToEditSeoData = new ArticleSeoData()
{
ArticleId = newArticle.Id, MetaDescription = rawArticle.Title, MetaKeyword = rawArticle.Title.Replace(" ", " ,"), MetaTitle = rawArticle.Title, SeoUrl = rawArticle.Title.Replace(" ", "-")
};
dbContext.ArticlesSeoData.Add(articleToEditSeoData);
dbContext.SaveChanges();
return(newArticle.Id);
}
public bool EditDraft(EditArticleViewModel model)
{
Article draftToEdit = dbContext.Articles.Find(model?.Id);
if (draftToEdit == null)
{
return(false);
}
if (model.ArticleImage != null)
{
string webRootPath = hostingEnvironment.WebRootPath;
string imageUrl = @$ "{webRootPath}/Images/{model?.ImageName}.jpg";
using (var fileStream = new FileStream(imageUrl, FileMode.Create))
{
model.ArticleImage.CopyTo(fileStream);
}
model.ImageUrl = $@"\Images\{model.ImageName}.jpg";
byte[] myBinaryImage = File.ReadAllBytes(imageUrl);
var resizzedImage = SkiaSharpImageManipulationProvider.ResizeStaticProportions(myBinaryImage, 460);
File.WriteAllBytes(imageUrl, resizzedImage.FileContents);
}
else
{
draftToEdit.ImageUrl = model.ImageUrl;
}
draftToEdit.Body = model.Body;
draftToEdit.CategoryId = model.CategoryId;
draftToEdit.ImageUrl = model.ImageUrl;
draftToEdit.EnableComments = model.EnableComments;
draftToEdit.H1Tag = model.H1Tag;
draftToEdit.LastModDate = DateTime.UtcNow;
draftToEdit.SourceName = model.SourceName;
draftToEdit.SourceURL = model.SourceURL;
draftToEdit.Title = model.Title;
draftToEdit.LastModDate = DateTime.UtcNow;
dbContext.SaveChanges();
ArticleSeoData articleSeoDataToEdit = dbContext.ArticlesSeoData.Where(x => x.ArticleId == draftToEdit.Id).FirstOrDefault();
articleSeoDataToEdit.MetaDescription = model.MetaDescription;
articleSeoDataToEdit.MetaKeyword = model.MetaKeyword;
articleSeoDataToEdit.MetaTitle = model.MetaTitle;
articleSeoDataToEdit.SeoUrl = model.SeoUrl;
dbContext.SaveChanges();
return(true);
}
private static void SeedArticlesSeoData(IApplicationBuilder app)
{
using var serviceScope = app?.ApplicationServices.GetRequiredService <IServiceScopeFactory>().CreateScope();
ApplicationDbContext context = serviceScope.ServiceProvider.GetService <ApplicationDbContext>();
var articles = context.Articles.ToArray();
if (context.ArticlesSeoData.ToArray().Length == 0)
{
foreach (var article in articles)
{
ArticleSeoData articleSeoDataTenp = new ArticleSeoData {
ArticleId = article.Id, MetaDescription = article.Title, MetaKeyword = article.Title, SeoUrl = article.SourceURL, MetaTitle = article.Title
};
context.ArticlesSeoData.Add(articleSeoDataTenp);
}
context.SaveChanges();
}
}
public EditArticleViewModel EditArticleGetModel(int draftId)
{
EditArticleViewModel model = new EditArticleViewModel();
Article articleToEdit = dbContext.Articles.Find(draftId);
if (articleToEdit == null)
{
return(null);
}
ArticleSeoData articleToEditSeoData = dbContext.ArticlesSeoData.Where(a => a.ArticleId == articleToEdit.Id).FirstOrDefault();
model = mapper.Map <EditArticleViewModel>(articleToEdit);
model.CategoryId = articleToEdit.CategoryId;
model.MetaDescription = articleToEditSeoData.MetaDescription;
model.MetaKeyword = articleToEditSeoData.MetaKeyword;
model.MetaTitle = articleToEditSeoData.MetaTitle;
model.SeoUrl = articleToEditSeoData.SeoUrl;
return(model);
}
public bool AddNewDraft(AddArticleViewModel model)
{
if (model == null)
{
return(false);
}
string webRootPath = hostingEnvironment.WebRootPath;
string imageUrl = @$ "{webRootPath}/Images/{model?.ImageName}.jpg";
Article article = mapper.Map <Article>(model);
if (model.ArticleImage != null)
{
using (var fileStream = new FileStream(imageUrl, FileMode.Create))
{
model.ArticleImage.CopyTo(fileStream);
}
byte[] myBinaryImage = File.ReadAllBytes(imageUrl);
var resizzedImage = SkiaSharpImageManipulationProvider.ResizeStaticProportions(myBinaryImage, 460);
File.WriteAllBytes(imageUrl, resizzedImage.FileContents);
article.ImageUrl = $@"\Images\{model.ImageName}.jpg";
}
article.CreationDate = DateTime.UtcNow;
article.LastModDate = DateTime.UtcNow;
article.State = ArticleState.Draft;
article.CategoryId = model.CategoryId;
dbContext.Articles.Add(article);
dbContext.SaveChanges();
ArticleSeoData seoData = mapper.Map <ArticleSeoData>(model);
seoData.ArticleId = dbContext.Articles.Where(x => x == article).FirstOrDefault().Id;
seoData.SeoUrl = article.Title.Replace(" ", "-");
dbContext.ArticlesSeoData.Add(seoData);
dbContext.SaveChanges();
return(true);
}
