public ActionResult Edit(int?id) { if (id == null) { return(RedirectToAction("Index", "Home")); } DataBaseArticles dataBaseArticle = new DataBaseArticles(); DataBaseCategories dataBaseCategory = new DataBaseCategories(); DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs(); DataBaseTegs dataBaseTeg = new DataBaseTegs(); OneArticle oneArticle = new OneArticle(); oneArticle.Article = dataBaseArticle.Select(id); oneArticle.Categories = new SelectList(dataBaseCategory.Select(), "Category_Id", "Name"); oneArticle.Category = dataBaseCategory.Select(oneArticle.Article.Category_Id); var id_tegs = dataBaseArticles_Tegs.SelectTegs(oneArticle.Article.Article_Id); foreach (var id_teg in id_tegs) { var teg = dataBaseTeg.Select(id_teg.Tegs_Id); oneArticle.Teg += teg.Name; } return(View(oneArticle)); }
public ActionResult Tegs(int?id_teg) { if (id_teg == null) { return(RedirectToAction("Index", "Home")); } DataBaseTegs dataBaseTeg = new DataBaseTegs(); DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs(); DataBaseArticles dataBaseArticle = new DataBaseArticles(); DataBaseCategories dataBaseCategory = new DataBaseCategories(); var id_articles = dataBaseArticles_Tegs.SelectArticles(id_teg); List <OneArticle> fullArticles = new List <OneArticle>(); foreach (var id_article in id_articles) { OneArticle oneArticle = new OneArticle(); var id_tegs = dataBaseArticles_Tegs.SelectTegs(id_article.Articles_Id); foreach (var teg in id_tegs) { var tegs = dataBaseTeg.Select(teg.Tegs_Id); oneArticle.Tegs.Add(tegs); } oneArticle.Article = dataBaseArticle.Select(id_article.Articles_Id); oneArticle.Category = dataBaseCategory.Select(oneArticle.Article.Category_Id); fullArticles.Add(oneArticle); } return(View(fullArticles)); }
private List <OneArticle> GetArticles(List <Article> articles) { DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs(); DataBaseTegs dataBaseTegs = new DataBaseTegs(); DataBaseCategories dataBaseCategories = new DataBaseCategories(); List <OneArticle> oneArticles = new List <OneArticle>(); foreach (var a in articles) { OneArticle oneArticle = new OneArticle(); oneArticle.Article = a; oneArticle.Category = dataBaseCategories.Select(a.Category_Id); var id_teg = dataBaseArticles_Tegs.SelectTegs(a.Article_Id); foreach (var teg in id_teg) { oneArticle.Tegs.Add(dataBaseTegs.Select(teg.Tegs_Id)); } oneArticles.Add(oneArticle); } return(oneArticles); }
private List <OneArticle> GetArticles(List <Article> articles, string tegsModel) { DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs(); DataBaseTegs dataBaseTegs = new DataBaseTegs(); DataBaseCategories dataBaseCategories = new DataBaseCategories(); string[] tegs = tegsModel.Split(new char[] { '#' }, StringSplitOptions.RemoveEmptyEntries); List <OneArticle> oneArticles = new List <OneArticle>(); foreach (var a in articles) { bool check = false; OneArticle oneArticle = new OneArticle(); var id_teg = dataBaseArticles_Tegs.SelectTegs(a.Article_Id); List <Teg> listTegs = new List <Teg>(); foreach (var teg in id_teg) { var getTegs = dataBaseTegs.Select(teg.Tegs_Id); listTegs.Add(getTegs); if (tegs.Contains(getTegs.Name.Substring(1))) { check = true; } } if (check) { oneArticle.Article = a; oneArticle.Category = dataBaseCategories.Select(a.Category_Id); oneArticle.Tegs = listTegs; } oneArticles.Add(oneArticle); } try { oneArticles.Reverse(); } catch (Exception) {} return(oneArticles); }