C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Globalization;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using BF.SilverlightClient.DownloadServiceReference;
using BF.SilverlightClient.Library;
using BF.SilverlightClient.ViewModels;
using BF.SilverlightClient.Views.UploadAndDownload;
using BF.Web.Services;
using BF.SilverlightClient.Views.ScsSkuViews;
using IdeaBlade.Core;
using IdeaBlade.Linq;
using IdeaBlade.EntityModel;

namespace BF.SilverlightClient.Views.Reports
{
using FilterOperator = BF.SilverlightClient.DownloadServiceReference.FilterOperator;
    /// <summary>
    /// for both detailed and short views
    /// </summary>
    public partial class DetailedReportView : UserControl
    {
        void UpdateWipTooltips(ScsViewModelForCollection currentScs)
        {
            if (currentScs == null) return;
            var column = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "WIPb");
            var txtBlock = new TextBlock() { Text = "WIPb" };
            var tt = new ToolTip() { Style = (Style)Application.Current.Resources["toolTipStyle"]};

            if (Session.Person.SNET.Snet_Mgr_ExclusiveControl == false)
            {
                tt.Content = Tooltips.GetTooltip("TtWipB");
                @ToolTipService.SetToolTip(txtBlock, tt);
            }
            else
            {
                tt.Content = Tooltips.GetTooltip("TtWipBdep");
                if (ScsCollectionViewModel.Instance.CurrentSCS.IsDependentSupplier)
                    @ToolTipService.SetToolTip(txtBlock, tt);
                else
                {
                    tt.Content = "Work in Process B - already ordered before asking supplier";
                    @ToolTipService.SetToolTip(txtBlock,tt);
                }
            }

            if (Session.Person.SNET.Snet_Mgr_ExclusiveControl == false)
            {
                tt.Content = Tooltips.GetTooltip("TtWipA");
                @ToolTipService.SetToolTip(txtBlock,tt);
            }
            else
            {
                tt.Content = Tooltips.GetTooltip("TtWipAdep");
                @ToolTipService.SetToolTip(txtBlock, tt);
            }
            @column.Header = txtBlock;
        }
        private readonly UserPreferencesKey _userPreferencesKeyForSelectedFields;
        readonly private UserPreferencesKey _userPreferencesKeyForFiltering;
        public DetailedReportView(UserPreferencesKey userPreferencesKeyForSelectedFields, UserPreferencesKey userPreferencesKeyForFiltering)
        {
            _userPreferencesKeyForFiltering = userPreferencesKeyForFiltering;
            _userPreferencesKeyForSelectedFields = userPreferencesKeyForSelectedFields;
           
            Resources.Add("ScsCollection", ScsCollectionViewModel.Instance);
            InitializeComponent();
          
            ScsCollectionViewModel.Instance.CurrentScsChanged += UpdateWipTooltips;
            DetailedReportGrid.DataLoaded += (s, e) =>
                {
                    GlobalSubs.ReorderScsSkuFieldsAndSetVisibility(DetailedReportGrid, userPreferencesKeyForSelectedFields);
                    TitleTextBlock.Text = string.Format("{2} report for {0} {1}",
                        ScsCollectionViewModel.Instance.CurrentSCS.Model.VirtualSCS_ID !=null ? "(Virtual)" : "",
                        ScsCollectionViewModel.Instance.CurrentSCS.Model.VirtualSCS_ID !=null
                            ? ScsCollectionViewModel.Instance.CurrentSCS.Model.VirtualSCSname :
                            String.Format("{0} (ID: {1})", ScsCollectionViewModel.Instance.CurrentSCS.Model.Name, ScsCollectionViewModel.Instance.CurrentSCS.Model.SCS_ID) 
                            , userPreferencesKeyForSelectedFields == UserPreferencesKey.FieldsForDetailedReport ? "Detailed" : "Short"
                            );
                    TitleTextBlock2.Text = ScsCollectionViewModel.Instance.CurrentSCS.UsesForecastArrivalInBalance ? "Values in DueIn column ignored - DueIns by date merged with forecast" : "";
                    var req1FamColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "REQ1Fam");
                    req1FamColumn.IsVisible = req1FamColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                    var req2FamColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "REQ2Fam");
                    req2FamColumn.IsVisible = req2FamColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                    var fam1QColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "1FAMq");
                    fam1QColumn.IsVisible = fam1QColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                    var fam2QColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "2FAMq");
                    fam2QColumn.IsVisible = fam2QColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                };
            InitializePagerAndLoadData();
            ScsCollectionViewModel.Instance.CurrentScsChanged += OnCurrentScsChanged;
            Unloaded += (sender, args) => { ScsCollectionViewModel.Instance.CurrentScsChanged -= OnCurrentScsChanged; };
            pager.DataLoaded += PagerOnDataLoaded;
        }

        private void PagerOnDataLoaded(List<object> objects)
        {
            foreach (var record in objects.Cast<vScsSkuForDetailedReport>())
            {
                if (record.WasBalanced != false) continue;
                record.Allocation = null;
                record.AverageDailyDemand = null;
                record.AvgForecastInScso = null;
                record.BatchIncrementQty = null;
                record.REQtot = null;
                record.ActiveYN = null;
                record.BatchIncrementQty = null;
                record.UnconstrainedRelease = null;
                record.ConstrainedRelease = null;
                record.ConstrainedRelease_Add = null;
                record.ConstrainedRelease_Add2 = null;
                record.ConstrainedRelease_AfterSatisfyingDosObj = null;
                record.Cost = null;
                record.CustomField1SpecificToScs = null;
                record.CustomField2SpecificToScs = null;
                record.RequiredCapacityRCAP = null;
                record.LowestBatchQty = null;
                record.OnHandActual = null;
                record.OnHandVirtualDOS_Begin = null;
                record.OnHandVirtualDOSep = null;
                record.PurchaseOrder = null;
                record.TargetInventoryQuantity = null;
                record.SCS_ProcGroup_Name = null;
                record.SCS_ProcGroup2_Name = null;
                record.Short = null;
                record.SKU_NameUsedBySCS = "(not balanced) " + record.SKU_NameUsedBySCS; // because inactive or conflict
            }
        }

        private void OnCurrentScsChanged(ScsViewModelForCollection scsViewModelForCollection)
        {
            InitializePagerAndLoadData();
        }

        void InitializePagerAndLoadData()
        {
            if (ScsCollectionViewModel.Instance.CurrentSCS == null) return;

            var optionalFilterAndSortingConfig = // could get from userPreferences;  implemented by LINQ SQL
             SettingsManager.RetrieveObjectFromDatabase<FilterAndSortingConfigForDownloading>(_userPreferencesKeyForFiltering);
           
            IEntityQuery<vScsSkuForDetailedReport> query =
                 ApplicationManager.BFEntities.vScsSkuForDetailedReportsOfCurrentScs;
            if (includeInactiveCheckbox.IsChecked != true)
                query = query.Where(x => x.WasBalanced == true && x.ActiveYN == true);

            if (optionalFilterAndSortingConfig != null)
            {
                query = ApplyFilterForReportData(optionalFilterAndSortingConfig, query);
                var desc = optionalFilterAndSortingConfig.Description;
                FilterIsSetIndicator.Visibility = desc != null
                    ? Visibility.Visible
                    : Visibility.Collapsed;
                if (desc != null) FilterIsSetIndicator.SetValue(ToolTipService.ToolTipProperty, desc);
            }
            else
                FilterIsSetIndicator.Visibility = Visibility.Collapsed;

            ISortSelector sortSelector = new SortSelector(

                (optionalFilterAndSortingConfig != null && !String.IsNullOrEmpty(optionalFilterAndSortingConfig.ColumnNameForSorting)) ?
                    GetFieldNameForSorting(optionalFilterAndSortingConfig.ColumnNameForSorting) : "OnHandVirtualDOS_Begin",

                optionalFilterAndSortingConfig != null ?
                        (optionalFilterAndSortingConfig.SortingDirectionAscendingOrDescending ? ListSortDirection.Ascending : ListSortDirection.Descending)
                  : ListSortDirection.Ascending
                );
            sortSelector = sortSelector.ThenBy("SKU_NAME");
            sortSelector = sortSelector.ThenBy("BalanceSequence");
            pager.InitializeAndLoadData((EntityQuery)query, sortSelector, "SKU_NameUsedBySCS");
        }
        
        private IEntityQuery<vScsSkuForDetailedReport> ApplyFilterForReportData(FilterAndSortingConfigForDownloading filteringAndSortingConfig,
            IEntityQuery<vScsSkuForDetailedReport> dataRecs)
        {
            if (filteringAndSortingConfig != null)
            {
                foreach (var columnNameAndValue in filteringAndSortingConfig.ColumnsAndValuesForFiltering)
                {
                    if (columnNameAndValue.FilterOperator == FilterOperator.NoFilter) continue;
                    var val = columnNameAndValue.Value;


                    int intVal; int.TryParse(val, out intVal);
                    float floatVal; float.TryParse(val, out floatVal);
                    decimal decimalVal; decimal.TryParse(val, out decimalVal);

                    switch (columnNameAndValue.ColumnName)
                    {
                        case "SKU#":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.CompareTo(val) >= 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.Contains(val));
                                    break;
                            }
                            break;
                        case "SKU":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.Opt == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.Opt == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.Opt.CompareTo(val) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.Opt.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.Opt.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.Opt.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.Opt.Contains(val));
                                    break;
                            }
                            break;

                        case "1FAM":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.CompareTo(val) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.Contains(val));
                                    break;
                            }
                            break;
                        case "2FAM":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.CompareTo(val) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.Contains(val));
                                    break;
                            }
                            break;
                        case "REQtot":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot < lt);
                                    break;
                                //default: //throw new Exception("invalid filter operator");     
                            }
                            break;
                        case "REQsku":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease < lt);
                                    break;
                            }
                            break;
                        case "REQext":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj < lt);
                                    break;
                            }
                            break;
                        case "REQ1Fam":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add < lt);
                                    break;
                            }
                            break;
                        case "REQ2Fam":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 < lt);
                                    break;
                            }
                            break;
                        case "RCAP":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP < lt);
                                    break;
                            }
                            break;
                        case "1B":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty < lt);
                                    break;
                            }
                            break;
                        case "BI":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty < lt);
                                    break;
                            }
                            break;
                        case "EOD":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution < lt);
                                    break;
                            }
                            break;
                        case "OBJq":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity < lt);
                                    break;
                            }
                            break;
                        case "Short":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short < lt);
                                    break;
                            }
                            break;
                        case "REQbat":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease < lt);
                                    break;
                            }
                            break;
                        case "TOTb":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin < lt);
                                    break;
                            }
                            break;
                        case "TOT":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep < lt);
                                    break;
                            }
                            break;
                        case "DueIn":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder < lt);
                                    break;
                            }
                            break;
                        case "WIPb":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB < lt);
                                    break;
                            }
                            break;
                        case "WIPa":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA < lt);
                                    break;
                            }
                            break;
                        case "TBq":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual < lt);
                                    break;
                            }
                            break;
                        case "DueOut":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation < lt);
                                    break;
                            }
                            break;
                        case "NTBdos":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos < lt);
                                    break;
                            }
                            break;
                        case "ADF": //Day of Supply Rate/AverageDailyDemond
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand < lt);
                                    break;
                            }
                            break;
                        case "ADFw":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso < lt);
                                    break;
                            }
                            break;
                        case "Cost":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost < lt);
                                    break;
                            }
                            break;
                        case "Cust1":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs.CompareTo(gt) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs.CompareTo(lt) < 0);
                                    break;
                            }
                            break;
                        case "Cust2":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs.CompareTo(gt) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs.CompareTo(lt) < 0);
                                    break;
                            }
                            break;
                        case "SCS_ID":
                            break;
                        default:
                            throw new Exception("bad column name " + columnNameAndValue.ColumnName);
                    }
                }
                if (filteringAndSortingConfig.ScsIdsAndPgcIdsForFiltering != null)
                {
                foreach (var scsIdAndPgcId in filteringAndSortingConfig.ScsIdsAndPgcIdsForFiltering)
                {
                    if (scsIdAndPgcId.PgcIds != null && scsIdAndPgcId.PgcIds.Count != 0)
                    {
                        var pgcIds = scsIdAndPgcId.PgcIds.Select(x => (int?)x).ToList();
                        var scsId = (int?)scsIdAndPgcId.ScsId;
                        dataRecs = dataRecs.Where
                            (x =>
                            (x.SCS_ID == scsId && pgcIds.Contains(x.SCS_ProcGroup_ID)) ||
                            x.SCS_ID != scsId); // and all other items from different scs id
                    }
                    if (scsIdAndPgcId.Pgc2Ids != null && scsIdAndPgcId.Pgc2Ids.Count != 0)
                    {
                        var pgc2Ids = scsIdAndPgcId.Pgc2Ids.Select(x => (int?)x).ToList();
                        var scsId = (int?)scsIdAndPgcId.ScsId;
                        dataRecs = dataRecs.Where
                            (x =>
                            (x.SCS_ID == scsId && pgc2Ids.Contains(x.SCS_ProcGroup2_ID)) ||
                            x.SCS_ID != scsId); // and all other items from different scs id
                    }
                }
                }
            }
            return dataRecs;
        }

        string GetFieldNameForSorting(string fieldNameInGui)
        {
            switch (fieldNameInGui)
            {
            case "":
            case null:
                return null;
            case "SKU#":
                return "SKU_NameUsedBySCS";
            case "SKU":
                return "Opt";
            case "REQtot":
                return "REQtot"; // no such field, need to order by sum of fields
            case "REQsku":
                return "ConstrainedRelease";
            case "REQext":
                return "ConstrainedRelease_AfterSatisfyingDosObj";
            case "REQ1Fam":
                return "SCS_ProcGroup_Name";
            case "REQ2Fam":
                return "SCS_ProcGroup2_Name";
            case "RCAP":
                return "RequiredCapacityRCAP";
            case "1B":
                return "LowestBatchQty";
            case "BI":
                return "BatchIncrementQty";
            case "EOD":
                return "EndOfDistribution";
            case "OBJq":
                return "TargetInventoryQuantity";
            case "Short":
                return "Short";
            case "REQbat":
                return "UnconstrainedRelease";
            case "TOTb":
                return "OnHandVirtualDOS_Begin";
            case "TOT":
                return "OnHandVirtualDOSep";
            case "DueIn":
                return "PurchaseOrder";
            case "WIPb":
                return "WorkInProcessB";
            case "WIPa":
                return "WorkInProcessA";
            case "TBq":
                return "OnHandActual";
            case "DueOut":
                return "Allocation";
            case "NTBdos":
                return "NTBdos";
            case "ADF":
                return "AverageDailyDemand";
            case "ADFw":
                return "AvgForecastInScso";
            case "Cost":
                return "Cost";
                default:
                    throw new Exception(String.Format("invalid column name for sorting: '{0}'", fieldNameInGui));
            }
        }

       private void NameHyperlinkButtonClick(object sender, RoutedEventArgs e)
        {
            var button = (HyperlinkButton)sender;
            var viewRecord = (vScsSkuForDetailedReport)button.DataContext;
            var wnd = new ScsSkuCoverageOfForecastWindow(viewRecord.SCS_SKU_ID, ScsCollectionViewModel.Instance.CurrentSCS);
            wnd.ShowDialog();
        }
        private void SelectFieldsButtonClick(object sender, RoutedEventArgs e)
        {
            var wnd = new ScsSkuDragDropSelectFieldsWindow(_userPreferencesKeyForSelectedFields, 
                false, // for only 1 scs
                ReorderFieldsAndSetVisibility);
            wnd.ShowDialog();
       }
        private void ReorderFieldsAndSetVisibility()
        {
            GlobalSubs.ReorderScsSkuFieldsAndSetVisibility(DetailedReportGrid, _userPreferencesKeyForSelectedFields);
        }
        private void SortFilterDetailedFieldsButtonClick(object sender, RoutedEventArgs e)
        {
            var wnd = new FilterAndSortingConfigWindow(_userPreferencesKeyForFiltering, true);
            wnd.ShowDialog();
            wnd.Closed += (s2, e2) => InitializePagerAndLoadData();
        }

        private void IncludeInactiveCheckbox_OnChecked(object sender, RoutedEventArgs e)
        {
            InitializePagerAndLoadData();
        }

    }
}

​x
 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Globalization;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using BF.SilverlightClient.DownloadServiceReference;
using BF.SilverlightClient.Library;
using BF.SilverlightClient.ViewModels;
using BF.SilverlightClient.Views.UploadAndDownload;
using BF.Web.Services;
using BF.SilverlightClient.Views.ScsSkuViews;
using IdeaBlade.Core;
using IdeaBlade.Linq;
using IdeaBlade.EntityModel;
​
namespace BF.SilverlightClient.Views.Reports
{
using FilterOperator = BF.SilverlightClient.DownloadServiceReference.FilterOperator;
    /// <summary>
    /// for both detailed and short views
    /// </summary>
    public partial class DetailedReportView : UserControl
    {
        void UpdateWipTooltips(ScsViewModelForCollection currentScs)
        {
            if (currentScs == null) return;
            var column = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "WIPb");
            var txtBlock = new TextBlock() { Text = "WIPb" };
            var tt = new ToolTip() { Style = (Style)Application.Current.Resources["toolTipStyle"]};
​
            if (Session.Person.SNET.Snet_Mgr_ExclusiveControl == false)
            {
                tt.Content = Tooltips.GetTooltip("TtWipB");
                @ToolTipService.SetToolTip(txtBlock, tt);
            }
            else
            {
                tt.Content = Tooltips.GetTooltip("TtWipBdep");
                if (ScsCollectionViewModel.Instance.CurrentSCS.IsDependentSupplier)
                    @ToolTipService.SetToolTip(txtBlock, tt);
                else
                {
                    tt.Content = "Work in Process B - already ordered before asking supplier";
                    @ToolTipService.SetToolTip(txtBlock,tt);
                }
            }
​
            if (Session.Person.SNET.Snet_Mgr_ExclusiveControl == false)
            {
                tt.Content = Tooltips.GetTooltip("TtWipA");
                @ToolTipService.SetToolTip(txtBlock,tt);
            }
            else
            {
                tt.Content = Tooltips.GetTooltip("TtWipAdep");
                @ToolTipService.SetToolTip(txtBlock, tt);
            }
            @column.Header = txtBlock;
        }
        private readonly UserPreferencesKey _userPreferencesKeyForSelectedFields;
        readonly private UserPreferencesKey _userPreferencesKeyForFiltering;
        public DetailedReportView(UserPreferencesKey userPreferencesKeyForSelectedFields, UserPreferencesKey userPreferencesKeyForFiltering)
        {
            _userPreferencesKeyForFiltering = userPreferencesKeyForFiltering;
            _userPreferencesKeyForSelectedFields = userPreferencesKeyForSelectedFields;
           
            Resources.Add("ScsCollection", ScsCollectionViewModel.Instance);
            InitializeComponent();
          
            ScsCollectionViewModel.Instance.CurrentScsChanged += UpdateWipTooltips;
            DetailedReportGrid.DataLoaded += (s, e) =>
                {
                    GlobalSubs.ReorderScsSkuFieldsAndSetVisibility(DetailedReportGrid, userPreferencesKeyForSelectedFields);
                    TitleTextBlock.Text = string.Format("{2} report for {0} {1}",
                        ScsCollectionViewModel.Instance.CurrentSCS.Model.VirtualSCS_ID !=null ? "(Virtual)" : "",
                        ScsCollectionViewModel.Instance.CurrentSCS.Model.VirtualSCS_ID !=null
                            ? ScsCollectionViewModel.Instance.CurrentSCS.Model.VirtualSCSname :
                            String.Format("{0} (ID: {1})", ScsCollectionViewModel.Instance.CurrentSCS.Model.Name, ScsCollectionViewModel.Instance.CurrentSCS.Model.SCS_ID) 
                            , userPreferencesKeyForSelectedFields == UserPreferencesKey.FieldsForDetailedReport ? "Detailed" : "Short"
                            );
                    TitleTextBlock2.Text = ScsCollectionViewModel.Instance.CurrentSCS.UsesForecastArrivalInBalance ? "Values in DueIn column ignored - DueIns by date merged with forecast" : "";
                    var req1FamColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "REQ1Fam");
                    req1FamColumn.IsVisible = req1FamColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                    var req2FamColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "REQ2Fam");
                    req2FamColumn.IsVisible = req2FamColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                    var fam1QColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "1FAMq");
                    fam1QColumn.IsVisible = fam1QColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                    var fam2QColumn = GlobalSubs.FindGridViewColumnByUniqueName(DetailedReportGrid.Columns, "2FAMq");
                    fam2QColumn.IsVisible = fam2QColumn.IsVisible && ScsCollectionViewModel.Instance.PgcBalanceEnabledForAtLeast1Scs;
                };
            InitializePagerAndLoadData();
            ScsCollectionViewModel.Instance.CurrentScsChanged += OnCurrentScsChanged;
            Unloaded += (sender, args) => { ScsCollectionViewModel.Instance.CurrentScsChanged -= OnCurrentScsChanged; };
            pager.DataLoaded += PagerOnDataLoaded;
        }
​
        private void PagerOnDataLoaded(List<object> objects)
        {
            foreach (var record in objects.Cast<vScsSkuForDetailedReport>())
            {
                if (record.WasBalanced != false) continue;
                record.Allocation = null;
                record.AverageDailyDemand = null;
                record.AvgForecastInScso = null;
                record.BatchIncrementQty = null;
                record.REQtot = null;
                record.ActiveYN = null;
                record.BatchIncrementQty = null;
                record.UnconstrainedRelease = null;
                record.ConstrainedRelease = null;
                record.ConstrainedRelease_Add = null;
                record.ConstrainedRelease_Add2 = null;
                record.ConstrainedRelease_AfterSatisfyingDosObj = null;
                record.Cost = null;
                record.CustomField1SpecificToScs = null;
                record.CustomField2SpecificToScs = null;
                record.RequiredCapacityRCAP = null;
                record.LowestBatchQty = null;
                record.OnHandActual = null;
                record.OnHandVirtualDOS_Begin = null;
                record.OnHandVirtualDOSep = null;
                record.PurchaseOrder = null;
                record.TargetInventoryQuantity = null;
                record.SCS_ProcGroup_Name = null;
                record.SCS_ProcGroup2_Name = null;
                record.Short = null;
                record.SKU_NameUsedBySCS = "(not balanced) " + record.SKU_NameUsedBySCS; // because inactive or conflict
            }
        }
​
        private void OnCurrentScsChanged(ScsViewModelForCollection scsViewModelForCollection)
        {
            InitializePagerAndLoadData();
        }
​
        void InitializePagerAndLoadData()
        {
            if (ScsCollectionViewModel.Instance.CurrentSCS == null) return;
​
            var optionalFilterAndSortingConfig = // could get from userPreferences;  implemented by LINQ SQL
             SettingsManager.RetrieveObjectFromDatabase<FilterAndSortingConfigForDownloading>(_userPreferencesKeyForFiltering);
           
            IEntityQuery<vScsSkuForDetailedReport> query =
                 ApplicationManager.BFEntities.vScsSkuForDetailedReportsOfCurrentScs;
            if (includeInactiveCheckbox.IsChecked != true)
                query = query.Where(x => x.WasBalanced == true && x.ActiveYN == true);
​
            if (optionalFilterAndSortingConfig != null)
            {
                query = ApplyFilterForReportData(optionalFilterAndSortingConfig, query);
                var desc = optionalFilterAndSortingConfig.Description;
                FilterIsSetIndicator.Visibility = desc != null
                    ? Visibility.Visible
                    : Visibility.Collapsed;
                if (desc != null) FilterIsSetIndicator.SetValue(ToolTipService.ToolTipProperty, desc);
            }
            else
                FilterIsSetIndicator.Visibility = Visibility.Collapsed;
​
            ISortSelector sortSelector = new SortSelector(
​
                (optionalFilterAndSortingConfig != null && !String.IsNullOrEmpty(optionalFilterAndSortingConfig.ColumnNameForSorting)) ?
                    GetFieldNameForSorting(optionalFilterAndSortingConfig.ColumnNameForSorting) : "OnHandVirtualDOS_Begin",
​
                optionalFilterAndSortingConfig != null ?
                        (optionalFilterAndSortingConfig.SortingDirectionAscendingOrDescending ? ListSortDirection.Ascending : ListSortDirection.Descending)
                  : ListSortDirection.Ascending
                );
            sortSelector = sortSelector.ThenBy("SKU_NAME");
            sortSelector = sortSelector.ThenBy("BalanceSequence");
            pager.InitializeAndLoadData((EntityQuery)query, sortSelector, "SKU_NameUsedBySCS");
        }
        
        private IEntityQuery<vScsSkuForDetailedReport> ApplyFilterForReportData(FilterAndSortingConfigForDownloading filteringAndSortingConfig,
            IEntityQuery<vScsSkuForDetailedReport> dataRecs)
        {
            if (filteringAndSortingConfig != null)
            {
                foreach (var columnNameAndValue in filteringAndSortingConfig.ColumnsAndValuesForFiltering)
                {
                    if (columnNameAndValue.FilterOperator == FilterOperator.NoFilter) continue;
                    var val = columnNameAndValue.Value;
​
​
                    int intVal; int.TryParse(val, out intVal);
                    float floatVal; float.TryParse(val, out floatVal);
                    decimal decimalVal; decimal.TryParse(val, out decimalVal);
​
                    switch (columnNameAndValue.ColumnName)
                    {
                        case "SKU#":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.CompareTo(val) >= 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.SKU_NameUsedBySCS.Contains(val));
                                    break;
                            }
                            break;
                        case "SKU":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.Opt == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.Opt == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.Opt.CompareTo(val) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.Opt.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.Opt.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.Opt.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.Opt.Contains(val));
                                    break;
                            }
                            break;
​
                        case "1FAM":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.CompareTo(val) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup_Name.Contains(val));
                                    break;
                            }
                            break;
                        case "2FAM":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name == val);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name == val);
                                    break;
                                case FilterOperator.GreaterThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.CompareTo(val) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.CompareTo(val) < 0);
                                    break;
                                case FilterOperator.StartsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.StartsWith(val));
                                    break;
                                case FilterOperator.EndsWith:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.EndsWith(val));
                                    break;
                                case FilterOperator.Contains:
                                    dataRecs = dataRecs.Where(x => x.SCS_ProcGroup2_Name.Contains(val));
                                    break;
                            }
                            break;
                        case "REQtot":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.REQtot < lt);
                                    break;
                                //default: //throw new Exception("invalid filter operator");     
                            }
                            break;
                        case "REQsku":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease < lt);
                                    break;
                            }
                            break;
                        case "REQext":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_AfterSatisfyingDosObj < lt);
                                    break;
                            }
                            break;
                        case "REQ1Fam":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add < lt);
                                    break;
                            }
                            break;
                        case "REQ2Fam":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.ConstrainedRelease_Add2 < lt);
                                    break;
                            }
                            break;
                        case "RCAP":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.RequiredCapacityRCAP < lt);
                                    break;
                            }
                            break;
                        case "1B":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.LowestBatchQty < lt);
                                    break;
                            }
                            break;
                        case "BI":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.BatchIncrementQty < lt);
                                    break;
                            }
                            break;
                        case "EOD":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.EndOfDistribution < lt);
                                    break;
                            }
                            break;
                        case "OBJq":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.TargetInventoryQuantity < lt);
                                    break;
                            }
                            break;
                        case "Short":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Short < lt);
                                    break;
                            }
                            break;
                        case "REQbat":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.UnconstrainedRelease < lt);
                                    break;
                            }
                            break;
                        case "TOTb":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOS_Begin < lt);
                                    break;
                            }
                            break;
                        case "TOT":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandVirtualDOSep < lt);
                                    break;
                            }
                            break;
                        case "DueIn":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.PurchaseOrder < lt);
                                    break;
                            }
                            break;
                        case "WIPb":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessB < lt);
                                    break;
                            }
                            break;
                        case "WIPa":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.WorkInProcessA < lt);
                                    break;
                            }
                            break;
                        case "TBq":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.OnHandActual < lt);
                                    break;
                            }
                            break;
                        case "DueOut":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = intVal;
                                    dataRecs = dataRecs.Where(x => x.Allocation < lt);
                                    break;
                            }
                            break;
                        case "NTBdos":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.NTBdos < lt);
                                    break;
                            }
                            break;
                        case "ADF": //Day of Supply Rate/AverageDailyDemond
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AverageDailyDemand < lt);
                                    break;
                            }
                            break;
                        case "ADFw":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = floatVal;
                                    dataRecs = dataRecs.Where(x => x.AvgForecastInScso < lt);
                                    break;
                            }
                            break;
                        case "Cost":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost > gt);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = decimalVal;
                                    dataRecs = dataRecs.Where(x => x.Cost < lt);
                                    break;
                            }
                            break;
                        case "Cust1":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs.CompareTo(gt) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField1SpecificToScs.CompareTo(lt) < 0);
                                    break;
                            }
                            break;
                        case "Cust2":
                            switch (columnNameAndValue.FilterOperator)
                            {
                                case FilterOperator.IsEqualTo:
                                    var eq = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs == eq);
                                    break;
                                case FilterOperator.IsNotEqualTo:
                                    var ne = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs != ne);
                                    break;
                                case FilterOperator.GreaterThan:
                                    var gt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs.CompareTo(gt) > 0);
                                    break;
                                case FilterOperator.LessThan:
                                    var lt = val.ToString(CultureInfo.InvariantCulture);
                                    dataRecs = dataRecs.Where(x => x.CustomField2SpecificToScs.CompareTo(lt) < 0);
                                    break;
                            }
                            break;
                        case "SCS_ID":
                            break;
                        default:
                            throw new Exception("bad column name " + columnNameAndValue.ColumnName);
                    }
                }
                if (filteringAndSortingConfig.ScsIdsAndPgcIdsForFiltering != null)
                {
                foreach (var scsIdAndPgcId in filteringAndSortingConfig.ScsIdsAndPgcIdsForFiltering)
                {
                    if (scsIdAndPgcId.PgcIds != null && scsIdAndPgcId.PgcIds.Count != 0)
                    {
                        var pgcIds = scsIdAndPgcId.PgcIds.Select(x => (int?)x).ToList();
                        var scsId = (int?)scsIdAndPgcId.ScsId;
                        dataRecs = dataRecs.Where
                            (x =>
                            (x.SCS_ID == scsId && pgcIds.Contains(x.SCS_ProcGroup_ID)) ||
                            x.SCS_ID != scsId); // and all other items from different scs id
                    }
                    if (scsIdAndPgcId.Pgc2Ids != null && scsIdAndPgcId.Pgc2Ids.Count != 0)
                    {
                        var pgc2Ids = scsIdAndPgcId.Pgc2Ids.Select(x => (int?)x).ToList();
                        var scsId = (int?)scsIdAndPgcId.ScsId;
                        dataRecs = dataRecs.Where
                            (x =>
                            (x.SCS_ID == scsId && pgc2Ids.Contains(x.SCS_ProcGroup2_ID)) ||
                            x.SCS_ID != scsId); // and all other items from different scs id
                    }
                }
                }
            }
            return dataRecs;
        }
​
        string GetFieldNameForSorting(string fieldNameInGui)
        {
            switch (fieldNameInGui)
            {
            case "":
            case null:
                return null;
            case "SKU#":
                return "SKU_NameUsedBySCS";
            case "SKU":
                return "Opt";
            case "REQtot":
                return "REQtot"; // no such field, need to order by sum of fields
            case "REQsku":
                return "ConstrainedRelease";
            case "REQext":
                return "ConstrainedRelease_AfterSatisfyingDosObj";
            case "REQ1Fam":
                return "SCS_ProcGroup_Name";
            case "REQ2Fam":
                return "SCS_ProcGroup2_Name";
            case "RCAP":
                return "RequiredCapacityRCAP";
            case "1B":
                return "LowestBatchQty";
            case "BI":
                return "BatchIncrementQty";
            case "EOD":
                return "EndOfDistribution";
            case "OBJq":
                return "TargetInventoryQuantity";
            case "Short":
                return "Short";
            case "REQbat":
                return "UnconstrainedRelease";
            case "TOTb":
                return "OnHandVirtualDOS_Begin";
            case "TOT":
                return "OnHandVirtualDOSep";
            case "DueIn":
                return "PurchaseOrder";
            case "WIPb":
                return "WorkInProcessB";
            case "WIPa":
                return "WorkInProcessA";
            case "TBq":
                return "OnHandActual";
            case "DueOut":
                return "Allocation";
            case "NTBdos":
                return "NTBdos";
            case "ADF":
                return "AverageDailyDemand";
            case "ADFw":
                return "AvgForecastInScso";
            case "Cost":
                return "Cost";
                default:
                    throw new Exception(String.Format("invalid column name for sorting: '{0}'", fieldNameInGui));
            }
        }
​
       private void NameHyperlinkButtonClick(object sender, RoutedEventArgs e)
        {
            var button = (HyperlinkButton)sender;
            var viewRecord = (vScsSkuForDetailedReport)button.DataContext;
            var wnd = new ScsSkuCoverageOfForecastWindow(viewRecord.SCS_SKU_ID, ScsCollectionViewModel.Instance.CurrentSCS);
            wnd.ShowDialog();
        }
        private void SelectFieldsButtonClick(object sender, RoutedEventArgs e)
        {
            var wnd = new ScsSkuDragDropSelectFieldsWindow(_userPreferencesKeyForSelectedFields, 
                false, // for only 1 scs
                ReorderFieldsAndSetVisibility);
            wnd.ShowDialog();
       }
        private void ReorderFieldsAndSetVisibility()
        {
            GlobalSubs.ReorderScsSkuFieldsAndSetVisibility(DetailedReportGrid, _userPreferencesKeyForSelectedFields);
        }
        private void SortFilterDetailedFieldsButtonClick(object sender, RoutedEventArgs e)
        {
            var wnd = new FilterAndSortingConfigWindow(_userPreferencesKeyForFiltering, true);
            wnd.ShowDialog();
            wnd.Closed += (s2, e2) => InitializePagerAndLoadData();
        }
​
        private void IncludeInactiveCheckbox_OnChecked(object sender, RoutedEventArgs e)
        {
            InitializePagerAndLoadData();
        }
​
    }
}
​

View IL Code