Загрузка данных


using SportShop.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Security.Cryptography;
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 SportShop
{
    /// <summary>
    /// Логика взаимодействия для MainWindow.xaml
    /// </summary>
    public partial class Catalog : Window
    {
        public Catalog(int mode)
        {
            InitializeComponent();

            switch (mode)
            {
                case 0:
                    btnAdd.Visibility = spSort.Visibility = btnDelete.Visibility = btnOrder.Visibility = Visibility.Collapsed;
                    App.currentUser = null;
                    textName.Text = "Гость";
                    break;
                case 1:
                    break;
                case 2:
                    btnAdd.Visibility = btnDelete.Visibility = Visibility.Collapsed;
                    break;
                case 3:
                    btnAdd.Visibility = spSort.Visibility =  btnDelete.Visibility = btnOrder.Visibility = Visibility.Collapsed;
                    break;
                default:
                    break;
            }

            if (App.currentUser != null)
            {
                textName.Text = App.currentUser.FullName.ToString();
            }
            List<Provider> allprovider = App.DBCon.Provider.ToList();

            var provider = new Provider { Id = 0, Name = "Все поставщики" };
            allprovider.Insert(0, provider);
            cbProvider.ItemsSource = allprovider;
            cbProvider.DisplayMemberPath = "Name";
            cbProvider.SelectedValuePath = "Id";
            cbProvider.SelectedIndex = 0;


            ShowProduct();
        }

        private void ShowProduct()
        {
            List<Product> products = App.DBCon.Product.ToList();

            string search = tbSearch.Text.Trim().ToLower();
            if (search.Length > 0)
            {
                products = products
                    .Where(p => 
                    p.Category.Name.ToLower().Contains(search) ||
                    p.ProductName.Name.ToLower().Contains(search) ||
                    p.Description.ToLower().Contains(search) ||
                    p.Manufacturer.Name.ToLower().Contains(search) ||
                    p.Provider.Name.ToLower().Contains(search) ||
                    p.Measure.Name.ToLower().Contains(search))
                    .ToList();
            }

            if (cbProvider.SelectedIndex > 0)
            {
                products = products.Where(p => p.ProviderId == (int)cbProvider.SelectedValue).ToList();
            }



            // отображение товаров
            lbCard.ItemsSource = products;
        }

        private void btnBack_Click(object sender, RoutedEventArgs e)
        {
            this.Close();
        }
        private void rbUp_Click(object sender, RoutedEventArgs e)
        {

        }

        private void rbDown_Click(object sender, RoutedEventArgs e)
        {

        }

        private void tbSearch_TextChanged(object sender, TextChangedEventArgs e)
        {
            ShowProduct();
        }

        private void cbProvider_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            ShowProduct();
        }
    }
}