public void Where_EvaluateARowNotFulfillTheCritery_CriteryIsOnStringTypeColumn_ReturnFalse()
        {
            Where where = CreateWhere();
            ITable table  = new Table("testTable");
            Column column = new Column("C1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.StringTypeKey));

            table.AddColumn(column);
            Row  row  = table.CreateRowDefinition();
            Cell cell = row.GetCell(column.columnName);

            cell.data = "aaa";
            where.AddCritery(column.columnName, cell.data + "b", Operator.equal);
            Assert.IsFalse(where.IsSelected(row));
        }
        public void Where_EvaluateARowNotFulfillTheCritery_CriteryIsOnDoubleTypeColumn_ReturnFalse()
        {
            Where where = CreateWhere();
            ITable table  = new Table("testTable");
            Column column = new Column("C1", DataTypesFactory.GetDataTypesFactory().GetDataType(TypesKeyConstants.DoubleTypeKey));

            table.AddColumn(column);
            Row  row  = table.CreateRowDefinition();
            Cell cell = row.GetCell(column.columnName);

            cell.data = "1.3";
            Assert.IsTrue(double.TryParse(cell.data, out double value));
            where.AddCritery(column.columnName, value + 1 + "", Operator.equal);
            Assert.IsFalse(where.IsSelected(row));
        }