public bool?HasBeenFiltered(IFilterRow row)
            {
                if (row == null)
                {
                    return(false);
                }
                IFilterValue upc = row.GetColumn(VariantBarcode);

                if (upc == null)
                {
                    return(false);
                }

                row.RecommendedAmazonUk = RecommendedAmazonUkRowIds.Contains(upc.Value);
                row.RecommendedAmazonUs = RecommendedAmazonUsRowIds.Contains(upc.Value);
                row.RecommendedeBayUs   = RecommendedeBayUsRowIds.Contains(upc.Value);
                row.Recommended         = RecommendedRowIds.Contains(upc.Value);

                return(row.Recommended);
            }
            public bool ApplyFilter(IFilterRow row)
            {
                bool result = false;



                IFilterValue recommendedAmazonUs = row.GetColumn(RecommendedAmazonUs);
                IFilterValue recommendedAmazonUk = row.GetColumn(RecommendedAmazonUk);
                IFilterValue recommendedeBayUs   = row.GetColumn(RecommendedeBayUs);
                IFilterValue recommended         = row.GetColumn(Recommended);
                IFilterValue upc = row.GetColumn(OriginalSearchTerm);

                if (upc == null || recommended == null)
                {
                    return(result);
                }

                double upcNumber = double.Parse(upc.Value, CultureInfo.InvariantCulture);

                if (String.IsNullOrEmpty(recommended.Value) == false)
                {
                    if (recommended.Value.Trim().ToLower() == "yes")
                    {
                        RecommendedRowIds.Add(upc.Value);
                        if (recommendedAmazonUk.Value.Trim().ToLower() == "yes")
                        {
                            RecommendedAmazonUkRowIds.Add(upc.Value);
                        }
                        if (recommendedAmazonUs.Value.Trim().ToLower() == "yes")
                        {
                            RecommendedAmazonUsRowIds.Add(upc.Value);
                        }
                        if (recommendedeBayUs.Value.Trim().ToLower() == "yes")
                        {
                            RecommendedeBayUsRowIds.Add(upc.Value);
                        }
                        result = true;
                    }
                }
                return(result);
            }
 public void RemoveExcludedRows(CsvFile products)
 {
     foreach (CsvRow row in products.Rows.Where(r => r.ExcludeMe))
     {
         IFilterValue value = row.GetColumn(Upc);
         if (RecommendedRowIds.Contains(value.Value) == true)
         {
             RecommendedRowIds.Remove(value.Value);
         }
         if (RecommendedAmazonUsRowIds.Contains(value.Value) == true)
         {
             RecommendedAmazonUsRowIds.Remove(value.Value);
         }
         if (RecommendedAmazonUkRowIds.Contains(value.Value) == true)
         {
             RecommendedAmazonUkRowIds.Remove(value.Value);
         }
         if (RecommendedeBayUsRowIds.Contains(value.Value) == true)
         {
             RecommendedeBayUsRowIds.Remove(value.Value);
         }
     }
 }