KomMethods 1.0.0

using shoes.model;
using System;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Media;

namespace shoes
{
    public partial class Products : Page
    {
        private int _roleId;       
        private int? _userId;

        private SolidColorBrush _discBg = (SolidColorBrush)new BrushConverter().ConvertFrom("#2E8B57");

        public Products(int roleId, int? userId)
        {
            InitializeComponent();

            _roleId = roleId;
            _userId = userId;

            SetupByRole();
            LoadProducts();
        }

        private void SetupByRole()
        {
            
            if (_roleId == 0 || _roleId == 3)
            {
                PanelTools.Visibility = Visibility.Collapsed;
                PanelSimple.Visibility = Visibility.Visible;

                GridProducts.IsReadOnly = true;
                GridProducts.CanUserSortColumns = false;
                return;
            }

            
            PanelTools.Visibility = Visibility.Visible;
            PanelSimple.Visibility = Visibility.Collapsed;

            GridProducts.CanUserSortColumns = true;

            
            if (_roleId == 2)
                GridProducts.IsReadOnly = true;

            
            if (_roleId == 1)
                GridProducts.IsReadOnly = false;

            
            BtnOrders.Visibility = (_roleId == 1 || _roleId == 2) ? Visibility.Visible : Visibility.Collapsed;

            
            BtnAdd.Visibility = BtnDelete.Visibility = BtnSave.Visibility =
                (_roleId == 1) ? Visibility.Visible : Visibility.Collapsed;

            
            CbCategory.Items.Clear();
            CbCategory.Items.Add("Все");
            foreach (var c in MainWindow.bd.Category.OrderBy(x => x.Name).ToList())
                CbCategory.Items.Add(c);
            CbCategory.SelectedIndex = 0;

            CbSort.Items.Clear();
            CbSort.Items.Add("Без сортировки");
            CbSort.Items.Add("Цена ↑");
            CbSort.Items.Add("Цена ↓");
            CbSort.Items.Add("Скидка ↓");
            CbSort.Items.Add("Артикул A→Z");
            CbSort.Items.Add("Артикул Z→A");
            CbSort.SelectedIndex = 0;
        }

        private void LoadProducts()
        {
            var q = MainWindow.bd.Product.AsQueryable();

            if (_roleId == 0 || _roleId == 3)
            {
                GridProducts.ItemsSource = q.ToList();
                return;
            }

            // Поиск
            string s = (TbSearch.Text ?? "").Trim();
            if (s.Length > 0)
                q = q.Where(x => x.Article.Contains(s) || x.DescriptionText.Contains(s));

            // Фильтр категории
            if (CbCategory.SelectedItem != null && !(CbCategory.SelectedItem is string))
            {
                var cat = CbCategory.SelectedItem as Category;
                if (cat != null)
                    q = q.Where(x => x.CategoryId == cat.CategoryId);
            }


            string sort = CbSort.SelectedItem as string;

            if (sort == "Цена ↑") q = q.OrderBy(x => x.Cost);
            else if (sort == "Цена ↓") q = q.OrderByDescending(x => x.Cost);
            else if (sort == "Скидка ↓") q = q.OrderByDescending(x => x.DiscountPercent);
            else if (sort == "Артикул A→Z") q = q.OrderBy(x => x.Article);
            else if (sort == "Артикул Z→A") q = q.OrderByDescending(x => x.Article);

            GridProducts.ItemsSource = q.ToList();
        }

        private void AnyFilterChanged(object sender, EventArgs e)
        {
            LoadProducts();
        }

        private void GridProducts_LoadingRow(object sender, DataGridRowEventArgs e)
        {
            var p = e.Row.Item as Product;
            if (p == null) return;

            
            if (e.Row.GetIndex() % 2 == 0) e.Row.Background = Brushes.White;
            else e.Row.Background = (SolidColorBrush)new BrushConverter().ConvertFrom("#F7F7F7");
            e.Row.Foreground = Brushes.Black;

            
            if (p.DiscountPercent >= 15)
            {
                e.Row.Background = _discBg;     
                e.Row.Foreground = Brushes.White;
            }
        }


        private void Orders_Click(object sender, RoutedEventArgs e)
        {
            if (!(_roleId == 1 || _roleId == 2))
            {
                MessageBox.Show("Доступно только менеджеру/администратору.");
                return;
            }

            NavigationService.Navigate(new OrdersPage(_roleId, _userId));
        }

        private void Logout_Click(object sender, RoutedEventArgs e)
        {
            NavigationService.Navigate(new Login());
        }

        private void Add_Click(object sender, RoutedEventArgs e)
        {
            if (_roleId != 1) return;

            var pt = MainWindow.bd.ProductType.FirstOrDefault();
            var c = MainWindow.bd.Category.FirstOrDefault();
            var m = MainWindow.bd.Maker.FirstOrDefault();
            var pr = MainWindow.bd.Provider.FirstOrDefault();

            if (pt == null || c == null || m == null || pr == null)
            {
                MessageBox.Show("Не заполнены справочники (Category/Maker/Provider/ProductType).");
                return;
            }

            var p = new Product();
            p.Article = "NEW_" + DateTime.Now.Ticks;
            p.ProductTypeId = pt.ProductTypeId;
            p.CategoryId = c.CategoryId;
            p.MakerId = m.MakerId;
            p.ProviderId = pr.ProviderId;
            p.Unit = "шт.";
            p.Cost = 0;
            p.DiscountPercent = 0;
            p.QuantityStock = 0;
            p.DescriptionText = "";
            p.PhotoFile = null;

            MainWindow.bd.Product.Add(p);
            MainWindow.bd.SaveChanges();
            LoadProducts();
        }

        private void Delete_Click(object sender, RoutedEventArgs e)
        {
            if (_roleId != 1) return;

            var p = GridProducts.SelectedItem as Product;
            if (p == null) return;

            if (MessageBox.Show("Удалить выбранный товар?", "Подтверждение",
                MessageBoxButton.YesNo) != MessageBoxResult.Yes) return;

            try
            {
                MainWindow.bd.Product.Remove(p);
                MainWindow.bd.SaveChanges();
                LoadProducts();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Не удалось удалить (возможно, товар используется в заказах).\n" + ex.Message);
            }
        }

        private void Save_Click(object sender, RoutedEventArgs e)
        {
            if (_roleId != 1) return;

            try
            {
                MainWindow.bd.SaveChanges();
                LoadProducts();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Ошибка сохранения:\n" + ex.Message);
            }
        }
    }
}