public ActionResult Create(NewArticle newArticle)
{
DataBaseTegs dataBaseTeg = new DataBaseTegs();
DataBaseArticles dataBaseArticles = new DataBaseArticles();
DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs();
newArticle.Article.Category_Id = newArticle.CategoryId;
newArticle.Article.DateTime = DateTime.Now;
int id_article = dataBaseArticles.Insert(newArticle.Article);
string[] tegs = newArticle.Tegs.Split(new char[] { '#' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string teg in tegs)
{
int id_teg = dataBaseTeg.Insert("#" + teg);
dataBaseArticles_Tegs.Insert(id_article, id_teg);
}
DataBaseCategories dataBaseCategory = new DataBaseCategories();
NewArticle newArticle1 = new NewArticle
{
Categories = new SelectList(dataBaseCategory.Select(), "Category_Id", "Name")
};
return(RedirectToAction("Index", "Home"));
}
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));
}
public ActionResult Delete(int?id)
{
if (id != null)
{
DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs();
DataBaseArticles dataBaseArticle = new DataBaseArticles();
dataBaseArticles_Tegs.DeleteArticle(id);
dataBaseArticle.Delete(id);
ModelState.AddModelError("", "Статья успешно удалена");
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Search(SearchModel model)
{
DataBaseArticles dataBaseArticle = new DataBaseArticles();
var articles = dataBaseArticle.Select(model);
var finalArticles = new List <Article>();
if (model.Tegs == null)
{
return(View(GetArticles(articles)));
}
else
{
return(View(GetArticles(articles, model.Tegs)));
}
}
public ActionResult Category(int?id_category, int?id_page)
{
DataBaseArticles dataBaseArticle = new DataBaseArticles();
DataBaseCategories dataBaseCategory = new DataBaseCategories();
var articles = dataBaseArticle.SelectTop10Category(Convert.ToInt32(id_page), Convert.ToInt32(id_category));
var category = dataBaseCategory.Select(id_category);
List <OneArticle> fullArticles = new List <OneArticle>();
bool check = false;
try
{
if (articles[articles.Count - 1] == null)
{
articles.RemoveAt(articles.Count - 1);
check = true;
}
}
catch (NullReferenceException)
{
return(RedirectToAction("Index", "Home"));
}
foreach (var a in articles)
{
OneArticle oneArticle = new OneArticle
{
Article = a,
Category = dataBaseCategory.Select(a.Category_Id)
};
fullArticles.Add(oneArticle);
}
ViewBag.index = ++id_page;
ViewBag.end = 0;
if (check)
{
ViewBag.end = 1;
}
return(View(fullArticles));
}
public ActionResult Index(int id = 1)
{
DataBaseArticles dataBaseArticles = new DataBaseArticles();
DataBaseCategories dataBaseCategory = new DataBaseCategories();
var articles = dataBaseArticles.SelectTop10(id);
SearchModel searchModel = new SearchModel();
bool check = false;
try
{
if (articles.Last() == null)
{
articles.RemoveAt(articles.Count - 1);
check = true;
}
}
catch (ArgumentNullException)
{
return(RedirectToAction("Index", "Home"));
}
foreach (var a in articles)
{
OneArticle oneArticle = new OneArticle
{
Article = a,
Category = dataBaseCategory.Select(a.Category_Id)
};
searchModel.OneArticles.Add(oneArticle);
}
searchModel.Categories = new SelectList(dataBaseCategory.Select(), "Category_Id", "Name");
ViewBag.index = ++id;
ViewBag.end = 0;
if (check)
{
ViewBag.end = 1;
}
return(View(searchModel));
}
public ActionResult Delete(int?id_category)
{
if (id_category == null)
{
return(RedirectToAction("Index", "Home"));
}
DataBaseCategories dataBaseCategory = new DataBaseCategories();
int id_withoutCategory = dataBaseCategory.SelectWithoutCategory();
DataBaseArticles dataBaseArticle = new DataBaseArticles();
dataBaseArticle.UpdateCategory(id_withoutCategory, id_category);
dataBaseCategory.Delete(id_category);
return(RedirectToAction("Categories"));
}
public static void CreateTables()
{
DataBaseUsers user = new DataBaseUsers();
user.CreateTables();
DataBaseCategories category = new DataBaseCategories();
category.CreateTable();
DataBaseTegs teg = new DataBaseTegs();
teg.CreateTable();
DataBaseArticles article = new DataBaseArticles();
article.CreateTable();
DataBaseArticles_Tegs articles_Tegs = new DataBaseArticles_Tegs();
articles_Tegs.CreateTable();
}
public ActionResult Edit(OneArticle oneArticle)
{
oneArticle.Article.DateTime = DateTime.Now;
DataBaseArticles dataBaseArticles = new DataBaseArticles();
dataBaseArticles.Update(oneArticle.Article);
DataBaseTegs dataBaseTeg = new DataBaseTegs();
DataBaseArticles_Tegs dataBaseArticles_Tegs = new DataBaseArticles_Tegs();
string[] tegs = oneArticle.Teg.Split(new char[] { '#' }, StringSplitOptions.RemoveEmptyEntries);
dataBaseArticles_Tegs.DeleteArticle(oneArticle.Article.Article_Id);
foreach (string teg in tegs)
{
int id_teg = dataBaseTeg.Insert("#" + teg);
dataBaseArticles_Tegs.Insert(oneArticle.Article.Article_Id, id_teg);
}
ModelState.AddModelError("", "Статья успешно изменена");
return(Edit(oneArticle.Article.Article_Id));
}
