////Delete //public void deleteCategories(articles articles) //{ // var result = _db.articles.FirstOrDefault(e => e.Id == articles.Id); // result.isBlocked = false; // _db.SaveChanges(); //} public void FullDeleteArticle(articles article) { //var article = _db.articles.FirstOrDefault(e => e.Id == model.Id); var result = _db.articleCategories.Where(e => e.categoriesId == article.Id).ToList(); var deleteFavourite = _db.favourites.Where(e => e.articlesId == article.Id); var deleteImage = _db.images.Where(e => e.articlesId == article.Id); var deleteRating = _db.ratings.Where(e => e.articlesId == article.Id); var BlockArticlesRequests = _db.requestsArticles.Where(e => e.articlesId == article.Id); var deleteArticleTags = _db.articlesTags.Where(e => e.articlesId == article.Id); var deleteArticleCategories = _db.articleCategories.Where(e => e.articlesId == article.Id); var deleteArticle = _db.articles.Where(e => e.Id == article.Id); _db.favourites.RemoveRange(deleteFavourite); _db.images.RemoveRange(deleteImage); _db.ratings.RemoveRange(deleteRating); foreach (var artReq in BlockArticlesRequests) { artReq.articlesId = null; } _db.articlesTags.RemoveRange(deleteArticleTags); _db.articleCategories.RemoveRange(deleteArticleCategories); _db.articles.RemoveRange(deleteArticle); _db.SaveChanges(); }
//Create public void CreateArticles(ArticlesCustomClass article) { var newarticle = new articles(); newarticle.title = article.Title; newarticle.content = article.Content; newarticle.date = DateTime.Now; newarticle.isBlocked = true; if (LoginHelper.IsLoggedIn()) { newarticle.usersId = LoginHelper.CurrentUser().Id; } else { newarticle.usersId = 16; // რომ წავა დასასრულისკენ პროექტი, ეს იფ-ელსი წაიშლება და მარტო current user დარჩება } if (!ExistCustomArticle(article)) { _db.articles.Add(newarticle); //_db.SaveChanges(); foreach (var categoryId in article.CategoriesList) { _db.articleCategories.Add( new articleCategories() { categoriesId = categoryId, articlesId = newarticle.Id }); _db.SaveChanges(); } if (article.RequestsList != null) { foreach (var requestID in article.RequestsList) { _db.requestsArticles.Add( new requestsArticles() { requestsId = requestID, articlesId = newarticle.Id }); _db.SaveChanges(); } } var mapPath = HostingEnvironment.MapPath("~/images/"); foreach (var file in article.Images) { if (file != null) { file.SaveAs(mapPath + file.FileName); _db.images.Add(new images() { name = file.FileName, url = "~/images/" + file.FileName, articlesId = newarticle.Id, usersId = null, isMain = false }); _db.SaveChanges(); } else { continue; } } } }
public bool Exist(articles article) { return(_db.articles.FirstOrDefault(e => e.title == article.title) == null ? false : true); }