ConcertAfisha/TableData.xaml.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing.Drawing2D;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace MusicSmth
{
    /// <summary>
    /// Логика взаимодействия для TableData.xaml
    /// </summary>
    public partial class TableData : Page
    {
        int id;
        public TableData(int UsId)
        {
            InitializeComponent();
            Music DB = new Music();
            List<string> s = new List<string>() { "Без фильтров", "По дате", "По цене" };
            ConcertData.ItemsSource = DB.Concerts.ToList();
            List<Cities> cit = DB.Cities.ToList();
            CityFilter.Items.Add("Все города");
            foreach(Cities i in cit)
            {
                CityFilter.Items.Add(i.City);
            }
            Sort.ItemsSource = s;
            Sort.SelectedItem = "Без фильтров";
            CityFilter.SelectedIndex = 0;
            id = UsId;
        }

        public void FindCity(object sender,  RoutedEventArgs e)
        {
            TextBlock city = (TextBlock)sender;
            int index = Convert.ToInt32(city.Uid);
            Music DB = new Music();
            string c = DB.Cities.Where(x=>x.ID_City == index).Select(x=>x.City).First();
            city.Text = c;
        }
        

        private void CountTracked(object sender, RoutedEventArgs e)
        {
            TextBlock count = (TextBlock)sender;
            int index = Convert.ToInt32(count.Uid);
            Music DB = new Music();
            int tracked = DB.Tracked_Concerts.Where(x=>x.ID_Concert == index).Count();
            count.Text = "Количество отметок " + tracked.ToString();
        }

        private void DateTill(object sender, RoutedEventArgs e)
        {
            TextBlock id = (TextBlock)sender;
            int index = Convert.ToInt32(id.Uid);
            Music DB = new Music();
            DateTime date = (DateTime)DB.Concerts.Where(x=>x.ID_Concert==index).Select(x=>x.Date).First();
            DateTime today = DateTime.Now;
            TimeSpan diff = date.Subtract(today);
            id.Text = "Дней до концерта "+diff.Days.ToString();
        }

        public void Back(object sender, EventArgs e)
        {
            MainFrame.mframe.Navigate(new AdminPage(id));
        }
        public void Add(object sender, EventArgs e)
        {
            MainFrame.mframe.Navigate(new AddConcert(id));
        }
        public void Edit(object sender, EventArgs e)
        {
            Button but = (Button)sender;
            int index = Convert.ToInt32(but.Uid);
            MainFrame.mframe.Navigate(new AddConcert(index, id));
        }
        public void Delete(object sender, EventArgs e)
        {
            Music DB = new Music();
            Button butt = (Button)sender;
            int index = Convert.ToInt32(butt.Uid);
            Concerts concert = DB.Concerts.Where(x=>x.ID_Concert == index).FirstOrDefault();
            switch (MessageBox.Show("Отменить концерт?", "concert", MessageBoxButton.YesNo, MessageBoxImage.Question))
            {
                case MessageBoxResult.Yes:
                    DB.Concerts.Remove(concert);
                    MessageBox.Show("Концерта больше нет");
                    DB.SaveChanges();
                    MainFrame.mframe.Navigate(new TableData(id));
                    break;
                case MessageBoxResult.No:
                    MessageBox.Show("Ну нет так нет");
                    break;
            }
        }

        public void Filter()
        {
            Music DB = new Music();
            List<Concerts> ConcFilter = new List<Concerts>();
            if (CityFilter.SelectedIndex != 0)
            {
                List<Places> pl = DB.Places.ToList();
                int index = Convert.ToInt32(pl.Where(x => x.ID_City == CityFilter.SelectedIndex).Select(x => x.ID_Place).FirstOrDefault());
                ConcFilter = DB.Concerts.Where(x => x.ID_Place == index).ToList();
            }
            else
            {
                ConcFilter = DB.Concerts.ToList();
            }
            if(InThisYear.IsChecked == true)
            {
                int year = DateTime.Now.Year;
                DateTime end = new DateTime(year, 12, 31);
                ConcFilter = ConcFilter.Where(x => x.Date <= end).ToList();
            }
            if (!string.IsNullOrWhiteSpace(Search.Text)) 
            {
                ConcFilter = ConcFilter.Where(x => x.Name.ToLower().Contains(Search.Text.ToLower())).ToList();
            }

            if(Sort.SelectedItem.ToString()=="По дате" && Up.IsChecked == true)
            {
                ConcFilter = ConcFilter.OrderBy(x => x.Date).ToList();
            }
            if(Sort.SelectedItem.ToString() == "По дате" && Down.IsChecked == true)
            {
                ConcFilter = ConcFilter.OrderByDescending(x => x.Date).ToList();
            }
            if(Sort.SelectedItem.ToString()=="По цене" && Up.IsChecked==true)
            {
                ConcFilter = ConcFilter.OrderBy(x=>(x.Lowest_Price + x.Highest_Price) / 2).ToList();
            }
            if (Sort.SelectedItem.ToString() == "По цене" && Down.IsChecked == true)
            {
                ConcFilter = ConcFilter.OrderByDescending(x => (x.Lowest_Price + x.Highest_Price) / 2).ToList();
            }
            ConcertData.ItemsSource = ConcFilter;
        }

        private void CityChanged(object sender, SelectionChangedEventArgs e)
        {
            Filter();
        }

        private void CheckedChanged(object sender, RoutedEventArgs e)
        {
            Filter();
        }

        private void SearchChange(object sender, TextChangedEventArgs e)
        {
            Filter();
        }

        private void SortChanged(object sender, SelectionChangedEventArgs e)
        {
            Filter();
        }

        private void Up_Checked(object sender, RoutedEventArgs e)
        {
            Filter();
        }

        private void Down_Checked(object sender, RoutedEventArgs e)
        {
            Filter();
        }
    }
}