Загрузка данных
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();
}
}
}