public static void AddComment(string textOfComment, int articleId, string UserMail)
{
Comment comment = new Comment()
{
Author = UserMail, Time = DateTime.Now, TextOfComment = textOfComment
};
Article articl = DbLogic.GetArticle(articleId);
if (articl != null)
{
if (articl.Comments == null)
{
articl.Comments = new List <Comment>()
{
comment
};
}
else
{
articl.Comments.Add(comment);
}
}
BlogContext db = DbLogic.GetDB();
db.Entry(articl).State = EntityState.Modified;
db.SaveChanges();
DbLogic.SetDb(db);
}
static public int EditArticle(Article article, string UserMail)
{
BlogContext db = DbLogic.GetDB();
Article changedArticle = db.Articles.Find(article.ArticleId);
article.Time = DateTime.Now;
article.UserMail = UserMail;
db.Articles.Remove(changedArticle);
db.Articles.Add(article);
db.SaveChanges();
DbLogic.SetDb(db);
return(article.ArticleId);
}
static public void EditCategory(Category category)
{
BlogContext db = DbLogic.GetDB();
Category changedCategory = db.Categories.Find(category.CategoryId);
foreach (var b in db.Articles)
{
if (changedCategory.CategoryName == b.Category)
{
b.Category = category.CategoryName;
}
}
db.Categories.Remove(changedCategory);
db.Categories.Add(category);
db.SaveChanges();
DbLogic.SetDb(db);
}
static public int AddArticle(AddArticleViewModel model, HttpPostedFileBase Photo, string UserMail)
{
byte[] imageDate = null;
if (Photo != null)
{
using (var binaryReader = new BinaryReader(Photo.InputStream))
{
imageDate = binaryReader.ReadBytes(Photo.ContentLength);
}
}
string tagsString = null;
if (model.TagsList != null)
{
foreach (var b in model.TagsList)
{
tagsString += b + " ";
}
}
Article article = new Article()
{
Name = model.Name, FullDescription = model.FullDescription, Tags = tagsString, ShortDescription = model.ShortDescription, Category = model.Category
};
article.Picture = new Picture()
{
Name = Convert.ToString(article.ArticleId), Image = imageDate, Id = article.ArticleId
};
article.Time = DateTime.Now;
article.UserMail = UserMail;
BlogContext blogContext = DbLogic.GetDB();
blogContext.Articles.Add(article);
blogContext.SaveChanges();
DbLogic.SetDb(blogContext);
return(article.ArticleId);
}
