private static ExcelRule ReadExcelRule(IExcelDataReader reader)
{
var text = reader.GetString(0);
var wholeWordsOnly = reader.GetString(1);
var category = reader.GetString(2);
var excelRule = new ExcelRule(text, wholeWordsOnly, category);
return(excelRule);
}
private static List <Condition> CreateTbConditions(ExcelRule condition)
{
List <Condition>?conditions = new();
if (condition.WholeWordsOnly == false)
{
conditions.Add(new Condition("subject", "contains", condition.Text));
}
else
{
conditions.Add(new Condition("subject", "contains", $" {condition.Text} "));
conditions.Add(new Condition("subject", "contains", $" {condition.Text},"));
conditions.Add(new Condition("subject", "contains", $" {condition.Text}."));
conditions.Add(new Condition("subject", "contains", $" {condition.Text}?"));
conditions.Add(new Condition("subject", "contains", $" {condition.Text}!"));
conditions.Add(new Condition("subject", "contains", $" {condition.Text}-"));
conditions.Add(new Condition("subject", "contains", $" {condition.Text}:"));
}
return(conditions);
}
bool IsServerType(ExcelRule rule)
{
return(rule == ExcelRule.Server || rule == ExcelRule.Common);
}
bool IsClientType(ExcelRule rule)
{
return(rule == ExcelRule.Client || rule == ExcelRule.Common);
}