/// <summary>
/// Case 2 : Complex Filter
/// </summary>
public static void Case2()
{
ICSVReader reader = new CSVReader();
SingleFilter filter1 = new SingleFilter()
{
Operator = Operators.GREATERTHAN, PropertyName = "EmployeeID", PropertyValue = 1
};
SingleFilter filter2 = new SingleFilter()
{
Operator = Operators.CONTAINS, PropertyName = "EmployeeFirstName", PropertyValue = "Su"
};
List <IFilter> filterList = new List <IFilter>();
filterList.Add(filter1);
filterList.Add(filter2);
IFilter filter = new ComplexFilter()
{
Combiner = Combiners.AND,
Filter = filterList
};
List <string> reqColumns = new List <string>()
{
"EmployeeFirstName", "EmployeeLastName", "EmployeeDOB", "EmployeeID"
};
var data = reader.GetNextData(5, 0, filter, reqColumns);
if (data.Count > 0)
{
DisplayRecords(data);
}
else
{
Console.WriteLine("No Result Found for this filter search");
}
data = reader.GetNextData(10, 6, filter, reqColumns);
if (data.Count > 0)
{
DisplayRecords(data);
}
else
{
Console.WriteLine("No Result Found for this filter search");
}
}
/// <summary>
/// Case 1 : Single Filter
/// </summary>
public static void Case1()
{
ICSVReader reader = new CSVReader();
IFilter filter = new SingleFilter()
{
Operator = Operators.GREATERTHAN, PropertyName = "EmployeeID", PropertyValue = 1
};
List <string> reqColumns = new List <string>()
{
"EmployeeFirstName", "EmployeeLastName", "EmployeeDOB", "EmployeeID"
};
var data = reader.GetNextData(10, 0, filter, reqColumns);
if (data.Count > 0)
{
DisplayRecords(data);
}
else
{
Console.WriteLine("No Result Found for this filter search");
}
data = reader.GetNextData(10, 11, filter, reqColumns);
if (data.Count > 0)
{
DisplayRecords(data);
}
else
{
Console.WriteLine("No Result Found for this filter search");
}
}
private bool Check(List <GenericDetail> row, SingleFilter data)
{
return(true);
// return the single check
}