public bool IsDuplicate()
{
int len1 = unifFirstString.Length;
int len2 = unifSecondString.Length;
double avLen = (len1 + len2) / 2.0;
int levenDist = LevenshteinDistanceExtensions.LevenshteinDistance(unifSecondString, unifFirstString);
double dicecoef = DiceCoefficientExtensions.DiceCoefficient(unifFirstString, unifSecondString);
Tuple <string, double> subs = LongestCommonSubsequenceExtensions.LongestCommonSubsequence(unifFirstString, unifSecondString);
string metFirst = DoubleMetaphoneExtensions.ToDoubleMetaphone(unifFirstString);
string metSecond = DoubleMetaphoneExtensions.ToDoubleMetaphone(unifSecondString);
int metLevDist = LevenshteinDistanceExtensions.LevenshteinDistance(metFirst, metSecond);
if (levenDist / avLen < 0.2 && dicecoef > 0.8)
{
return(true);
}
else if (dicecoef > 0.9)
{
return(true);
}
else if (subs.Item2 > 0.75)
{
return(true);
}
else if (metLevDist == 0)
{
return(true);
}
else
{
return(false);
}
}
public static double Compare(this string input, string comparedTo, FuzzyLogicType fuzzyLogicType)
{
double logicResult = 0;
try
{
switch (fuzzyLogicType)
{
case FuzzyLogicType.DiceCoefficient:
logicResult = DiceCoefficientExtensions.DiceCoefficient(input, comparedTo);
break;
case FuzzyLogicType.LevenshteinDistance:
logicResult = LevenshteinDistanceExtensions.LevenshteinDistance(input, comparedTo, true);
break;
case FuzzyLogicType.LongestCommonSubsequence:
var lcResult = LongestCommonSubsequenceExtensions.LongestCommonSubsequence(input, comparedTo, true);
logicResult = lcResult.Item2;
break;
case FuzzyLogicType.SimpleCompare:
logicResult = SimpleCompare.Compare(input, comparedTo);
break;
default:
break;
}
}
catch (Exception e)
{
return(logicResult);
}
return(logicResult);
}
private void button2_Click(object sender, EventArgs e)
{
//Full-text Date search_________________________________________________________________________________
int searchOutput = 0;
string query = textBox1.Text.Trim();
for (int i = 0; i < errorModels.Count; i++)
{
if (query == "" || query == " ")
{
MessageBox.Show("Вы не ввели текст в строку поиска по дате!");
break;
}
if (radioButton2.Checked)
{
if (errorModels[i].error.Contains(query) && errorModels[i].error.Length == query.Length)
{
//stringBuilder.Append(errorModels[i].date + '\r' + '\n');
DataGridViewRow row = dataGridView1.Rows[i];
var date = dataGridView1.Rows[searchOutput].Cells["date"].Value;
var error = dataGridView1.Rows[searchOutput].Cells["error"].Value;
var sourceError = dataGridView1.Rows[searchOutput].Cells["sourceError"].Value;
var stackTrace = dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value;
dataGridView1.Rows[searchOutput].Cells["date"].Value = row.Cells["date"].Value;
dataGridView1.Rows[searchOutput].Cells["error"].Value = row.Cells["error"].Value;
dataGridView1.Rows[searchOutput].Cells["sourceError"].Value = row.Cells["sourceError"].Value;
dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value = row.Cells["stackTrace"].Value;
row.Cells["date"].Value = date;
row.Cells["error"].Value = error;
row.Cells["sourceError"].Value = sourceError;
row.Cells["stackTrace"].Value = stackTrace;
var papaparsedData = completeErrors[searchOutput];
completeErrors[searchOutput] = completeErrors[i];
completeErrors[i] = papaparsedData;
searchOutput++;
}
else if (StringExtensions.FuzzyEquals(query, errorModels[i].error, 0.4) || errorModels[i].error.Contains(query))//StringExtensions.FuzzyEquals(query, errorModels[i].date, 0.3) || StringExtensions.FuzzyEquals(query, errorModels[i].error, 0.4)
{
DataGridViewRow row = dataGridView1.Rows[i];
var date = dataGridView1.Rows[searchOutput].Cells["date"].Value;
var error = dataGridView1.Rows[searchOutput].Cells["error"].Value;
var sourceError = dataGridView1.Rows[searchOutput].Cells["sourceError"].Value;
var stackTrace = dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value;
dataGridView1.Rows[searchOutput].Cells["date"].Value = row.Cells["date"].Value;
dataGridView1.Rows[searchOutput].Cells["error"].Value = row.Cells["error"].Value;
dataGridView1.Rows[searchOutput].Cells["sourceError"].Value = row.Cells["sourceError"].Value;
dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value = row.Cells["stackTrace"].Value;
row.Cells["date"].Value = date;
row.Cells["error"].Value = error;
row.Cells["sourceError"].Value = sourceError;
row.Cells["stackTrace"].Value = stackTrace;
var papaparsedData = completeErrors[searchOutput];
completeErrors[searchOutput] = completeErrors[i];
completeErrors[i] = papaparsedData;
searchOutput++;
}
}
if (radioButton3.Checked)
{
if (errorModels[i].sourceError.Contains(query))
{
DataGridViewRow row = dataGridView1.Rows[i];
var date = dataGridView1.Rows[searchOutput].Cells["date"].Value;
var error = dataGridView1.Rows[searchOutput].Cells["error"].Value;
var sourceError = dataGridView1.Rows[searchOutput].Cells["sourceError"].Value;
var stackTrace = dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value;
dataGridView1.Rows[searchOutput].Cells["date"].Value = row.Cells["date"].Value;
dataGridView1.Rows[searchOutput].Cells["error"].Value = row.Cells["error"].Value;
dataGridView1.Rows[searchOutput].Cells["sourceError"].Value = row.Cells["sourceError"].Value;
dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value = row.Cells["stackTrace"].Value;
row.Cells["date"].Value = date;
row.Cells["error"].Value = error;
row.Cells["sourceError"].Value = sourceError;
row.Cells["stackTrace"].Value = stackTrace;
var papaparsedData = completeErrors[searchOutput];
completeErrors[searchOutput] = completeErrors[i];
completeErrors[i] = papaparsedData;
searchOutput++;
}
else if (LongestCommonSubsequenceExtensions.LongestCommonSubsequence(query, errorModels[i].sourceError, true).Item2 > 0.005)//improved the accuracy of word recognition in fuzzyString Search
{
DataGridViewRow row = dataGridView1.Rows[i];
var date = dataGridView1.Rows[searchOutput].Cells["date"].Value;
var error = dataGridView1.Rows[searchOutput].Cells["error"].Value;
var sourceError = dataGridView1.Rows[searchOutput].Cells["sourceError"].Value;
var stackTrace = dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value;
dataGridView1.Rows[searchOutput].Cells["date"].Value = row.Cells["date"].Value;
dataGridView1.Rows[searchOutput].Cells["error"].Value = row.Cells["error"].Value;
dataGridView1.Rows[searchOutput].Cells["sourceError"].Value = row.Cells["sourceError"].Value;
dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value = row.Cells["stackTrace"].Value;
row.Cells["date"].Value = date;
row.Cells["error"].Value = error;
row.Cells["sourceError"].Value = sourceError;
row.Cells["stackTrace"].Value = stackTrace;
var papaparsedData = completeErrors[searchOutput];
completeErrors[searchOutput] = completeErrors[i];
completeErrors[i] = papaparsedData;
searchOutput++;
}
}
if (radioButton1.Checked)
{
if (query.Length <= 2)
{
query = $":{query}";
}
if (query.Length != 19 && query.Length < 19)
{
if (errorModels[i].date.Contains(query) && query.Length >= 2)
{
//stringBuilder.Append(errorModels[i].date + '\r' + '\n');
DataGridViewRow row = dataGridView1.Rows[i];
var date = dataGridView1.Rows[searchOutput].Cells["date"].Value;
var error = dataGridView1.Rows[searchOutput].Cells["error"].Value;
var sourceError = dataGridView1.Rows[searchOutput].Cells["sourceError"].Value;
var stackTrace = dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value;
dataGridView1.Rows[searchOutput].Cells["date"].Value = row.Cells["date"].Value;
dataGridView1.Rows[searchOutput].Cells["error"].Value = row.Cells["error"].Value;
dataGridView1.Rows[searchOutput].Cells["sourceError"].Value = row.Cells["sourceError"].Value;
dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value = row.Cells["stackTrace"].Value;
row.Cells["date"].Value = date;
row.Cells["error"].Value = error;
row.Cells["sourceError"].Value = sourceError;
row.Cells["stackTrace"].Value = stackTrace;
var papaparsedData = completeErrors[searchOutput];
completeErrors[searchOutput] = completeErrors[i];
completeErrors[i] = papaparsedData;
searchOutput++;
}
}
else if (errorModels[i].date.Contains(query) && errorModels[i].date.Length == query.Length)
{
//stringBuilder.Append(errorModels[i].date + '\r' + '\n');
DataGridViewRow row = dataGridView1.Rows[i];
var date = dataGridView1.Rows[searchOutput].Cells["date"].Value;
var error = dataGridView1.Rows[searchOutput].Cells["error"].Value;
var sourceError = dataGridView1.Rows[searchOutput].Cells["sourceError"].Value;
var stackTrace = dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value;
dataGridView1.Rows[searchOutput].Cells["date"].Value = row.Cells["date"].Value;
dataGridView1.Rows[searchOutput].Cells["error"].Value = row.Cells["error"].Value;
dataGridView1.Rows[searchOutput].Cells["sourceError"].Value = row.Cells["sourceError"].Value;
dataGridView1.Rows[searchOutput].Cells["stackTrace"].Value = row.Cells["stackTrace"].Value;
row.Cells["date"].Value = date;
row.Cells["error"].Value = error;
row.Cells["sourceError"].Value = sourceError;
row.Cells["stackTrace"].Value = stackTrace;
var papaparsedData = completeErrors[searchOutput];
completeErrors[searchOutput] = completeErrors[i];
completeErrors[i] = papaparsedData;
searchOutput++;
}
}
dataGridView1.FirstDisplayedScrollingRowIndex = 0;
}
}
