prs/prs.desktop/Panels/Products/JobRequisitionReviewPage.xaml.cs

using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using System;
using System.Collections.Generic;
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 PRSDesktop
{
    /// <summary>
    /// Interaction logic for JobRequisitionReviewPage.xaml
    /// </summary>
    public partial class JobRequisitionReviewPage : Page
    {
        public List<JobRequiReviewDashboardFilterItem> filterItems = new List<JobRequiReviewDashboardFilterItem>();
        public JobRequisitionReviewPage()
        {
            InitializeComponent();
            Grid.Refresh(true, true);
        }

        private void Filter_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            var item = filterComboBox.SelectedItem as JobRequiReviewDashboardFilterItem;
            Grid.RefreshOnFilterChanged(item.SupplierID);
        }

        private void LoadFilters()
        {
            List<Guid> productIDs = new List<Guid>();
            CoreTable productsTable = new Client<JobRequisitionItem>().Query(new Filter<JobRequisitionItem>(x => x.Product).LinkValid(),
                new Columns<JobRequisitionItem>(x => x.Product.ID));
            foreach (CoreRow row1 in productsTable.Rows)
            {
                productIDs.Add(Guid.Parse(row1.Values[0].ToString()));
            }
            CoreTable table = new Client<SupplierProduct>().Query(
                new Filter<SupplierProduct>(x => x.Product).LinkValid()
                    .And(x => x.SupplierLink).LinkValid(),
                new Columns<SupplierProduct>(x => x.SupplierLink.ID, x => x.Product.ID, x => x.SupplierLink.Name, x => x.SupplierLink.Code));
            if (table.Rows.Any())
            {
                JobRequiReviewDashboardFilterItem firstItem = new JobRequiReviewDashboardFilterItem
                {
                    Text = "No Filter"
                };
                filterItems.Add(firstItem);
                foreach (CoreRow row in table.Rows)
                {
                    JobRequiReviewDashboardFilterItem filterItem = new JobRequiReviewDashboardFilterItem
                    {
                        SupplierID = Guid.Parse(row.Values[0].ToString()),
                        ProductID = Guid.Parse(row.Values[1].ToString()),
                    };
                    if (row.Values[3] != null)
                    {
                        filterItem.Text = row.Values[3].ToString();
                        if (row.Values[2] != null)
                        {
                            filterItem.Text = filterItem.Text + " " + row.Values[2].ToString();
                        }
                    }

                    var founditem = filterItems.Find(x => x.SupplierID == filterItem.SupplierID);
                    if (founditem == null)
                    {
                        if (productIDs.Contains(filterItem.ProductID))
                            filterItems.Add(filterItem);
                    }
                }
            }
            filterComboBox.ItemsSource = filterItems;
        }
    }
}