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 void OpenArticle_Click(object sender, RoutedEventArgs e)
{
OracleDbContext db = new OracleDbContext();
int UserId = CurrentUser.User.UserId;
var currentArticle = (ArticlesUser)((Button)sender).Tag;
var art = db.Articles.FirstOrDefault(x => x.ArticleId == currentArticle.ArticleId_ArticlesUser);
var currentPage = ((MainWindow)Application.Current.MainWindow).CurrentPage.Content;
if (currentPage == null || (currentPage != null && currentPage.GetType().Name == "UserPage"))
{
OneArticle one = new OneArticle();
one.Title.Text = art.Title;
one.Text.Text = art.Text;
if (art.Image != null)
{
one.Source.Source = Pima.ViewModel.Converter.ConvertByteArrayToImage(art.Image);
}
else
{
one.Source.Visibility = Visibility.Collapsed;
}
(currentPage as UserPages.UserPage).CurrentPage.Navigate(one);
}
}
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));
}
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);
}
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 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));
}
private void GridResult_PreviewMouseDown(object sender, MouseButtonEventArgs e)
{
if (ArticleButton.IsChecked == true)
{
var currentArticle = (Model.Article)((Grid)sender).Tag;
int? id = currentArticle.ArticleId;
OneArticle one = new OneArticle();
OneArticle.articleId = (int)id;
one.Title.Text = currentArticle.Title;
one.Text.Text = currentArticle.Text;
if (currentArticle.Image != null)
{
one.Source.Source = Pima.ViewModel.Converter.ConvertByteArrayToImage(currentArticle.Image);
}
else
{
one.Source.Visibility = Visibility.Collapsed;
}
CurrentPage.Navigate(one);
}
else if (NoteButton.IsChecked == true)
{
var currentArticle = (Model.Notes)((Grid)sender).Tag;
int? id = currentArticle.NotesId;
OneNote one = new OneNote();
OneNote.articleId = (int)id;
one.Name.Text = currentArticle.Name;
//one.Text.Text = currentArticle.Text;
if (currentArticle.Note != null)
{
one.Source.Source = Pima.ViewModel.Converter.ConvertByteArrayToImage(currentArticle.Note);
}
else
{
one.Source.Visibility = Visibility.Collapsed;
}
CurrentPage.Navigate(one);
}
else if (SongButton.IsChecked == true)
{
var currentSong = (Model.Songs)((Grid)sender).Tag;
int? id = currentSong.SongsId;
OneSong one = new OneSong();
OneSong.songID = (int)id;
one.Name.Text = currentSong.Name;
//one.Text.Text = currentArticle.Text;
if (currentSong.Image != null)
{
one.Source.Source = Pima.ViewModel.Converter.ConvertByteArrayToImage(currentSong.Image);
}
else
{
one.Source.Visibility = Visibility.Collapsed;
}
CurrentPage.Navigate(one);
}
else if (ChordButton.IsChecked == true)
{
var currentChord = (Model.Chords)((Grid)sender).Tag;
int? id = currentChord.ChordsId;
OneChord one = new OneChord();
OneChord.ChordId = (int)id;
one.Name.Text = currentChord.Name;
//one.Text.Text = currentArticle.Text;
if (currentChord.Chord != null)
{
one.Source.Source = Pima.ViewModel.Converter.ConvertByteArrayToImage(currentChord.Chord);
}
else
{
one.Source.Visibility = Visibility.Collapsed;
}
CurrentPage.Navigate(one);
}
}
public MainWindowViewModel()
{
//NewsArticles.Add(new Article() { Title = "Uno" });
//NewsArticles.Add(new Article() { SourceImg = "Dos" });
//NewsArticles.Add(new Article() { Byline = "Tres" });
#region Data binding first part
foreach (Article u in Data.articles)
{
if (u.articleID > Data.articles.Count - 10)
{
NewsArticles.Insert(0, u);
}
}
foreach (Article u in Data.articles)
{
if (u.articleID == Data.articles.Count - 1)
{
OneArticle.Insert(0, u);
}
}
foreach (Article u in Data.articles)
{
if (u.articleID == Data.articles.Count - 2)
{
OneArticle2.Insert(0, u);
}
}
foreach (Article u in Data.articles)
{
if (u.articleID == Data.articles.Count - 3)
{
OneArticle3.Insert(0, u);
}
}
foreach (Article u in Data.articles)
{
if (u.articleID == Data.articles.Count - 4)
{
OneArticle4.Insert(0, u);
}
}
foreach (Article u in Data.articles)
{
if (u.articleID == Data.articles.Count - 5)
{
OneArticle5.Insert(0, u);
}
}
foreach (Article u in Data.articles)
{
if (u.articleID == Data.articles.Count - 6)
{
OneArticle6.Insert(0, u);
}
}
#endregion
foreach (Article u in Data.articles)
{
if (SomeCategory.currentCategory == "News")
{
if (u.articleID < Data.articles.Count & u.category == "News")
{
NewsArticles_Category.Insert(0, u);
}
}
else if (SomeCategory.currentCategory == "Politics")
{
if (u.articleID < Data.articles.Count & u.category == "Politics")
{
//NewsArticles_Category.Clear();
NewsArticles_Category.Insert(0, u);
}
}
else if (SomeCategory.currentCategory == "Opinion")
{
if (u.articleID < Data.articles.Count & u.category == "Opinion")
{
//NewsArticles_Category.Clear();
NewsArticles_Category.Insert(0, u);
}
}
else if (SomeCategory.currentCategory == "Sports")
{
if (u.articleID < Data.articles.Count & u.category == "Sports")
{
//NewsArticles_Category.Clear();
NewsArticles_Category.Insert(0, u);
}
}
else if (SomeCategory.currentCategory == "Entertainment")
{
if (u.articleID < Data.articles.Count & u.category == "Entertainment")
{
//NewsArticles_Category.Clear();
NewsArticles_Category.Insert(0, u);
}
}
else if (SomeCategory.currentCategory == "Social")
{
if (u.articleID < Data.articles.Count & u.category == "Social")
{
//NewsArticles_Category.Clear();
NewsArticles_Category.Insert(0, u);
}
}
}
}