public void SearchIn(string tagAddingSub)
{
conn.Open();
List <string> gram = new List <string>();
Dictionary <int, string> nameFile = new Dictionary <int, string>();
Dictionary <int, double> resCode = new Dictionary <int, double>();
Analysis search = new Analysis();
bool isDel = false;
string mainCode = "";
string childCode = "";
double maxRes = Double.MinValue;
using (command = new SQLiteCommand("select File.id from File join Submit on File.id_Submit = Submit.id where Submit.Tag = @tag", conn))
{
command.Parameters.Add(new SQLiteParameter("@Tag", tagAddingSub));
using (IDataReader r = command.ExecuteReader())
{
if (r.Read())
{
idMainFileForHist = r.GetInt32(0);
}
}
}
using (command = new SQLiteCommand(
"select Gram.Gram from Gram join KGrmams on KGrmams.id_Gram = Gram.id join Code on KGrmams.id_Code = Code.id join File on File.id_Code = Code.id where File.id = @id", conn))
{
command.Parameters.Add(new SQLiteParameter("@id", idMainFileForHist));
using (IDataReader r = command.ExecuteReader())
{
while (r.Read())
{
gram.Add(r.GetString(0));
}
}
}
for (int i = 0; i < gram.Count / 2; i++)
{
using (command = new SQLiteCommand(
"select DISTINCT File.Name, File.id from File join Code on File.id_Code = Code.id join KGrmams on KGrmams.id_Code = Code.id join Gram on KGrmams.id_Gram = Gram.id where Gram.Gram = @gram and File.id != @idFile", conn))
{
command.Parameters.Add(new SQLiteParameter("@gram", gram[i]));
command.Parameters.Add(new SQLiteParameter("@idFile", idMainFileForHist));
using (IDataReader r = command.ExecuteReader())
{
while (r.Read())
{
if (!nameFile.ContainsKey(r.GetInt32(1)) && isDel && nameFile.Count > 1)
{
nameFile.Remove(r.GetInt32(1));
}
else if (!isDel)
{
nameFile.Add(r.GetInt32(1), r.GetString(0));
}
}
}
}
isDel = true;
}
using (command = new SQLiteCommand(
"select Code.NormalizeCode from Code join File on File.id_Code = Code.id where File.id = @id", conn))
{
command.Parameters.Add(new SQLiteParameter("@id", idMainFileForHist));
using (IDataReader r = command.ExecuteReader())
{
if (r.Read())
{
mainCode += r.GetString(0);
}
}
}
search.SetCodeMainFromDB(mainCode);
foreach (int key in nameFile.Keys)
{
using (command = new SQLiteCommand(
"select Code.NormalizeCode from Code join File on File.id_Code = Code.id where File.id = @id", conn))
{
command.Parameters.Add(new SQLiteParameter("@id", key));
using (IDataReader r = command.ExecuteReader())
{
if (r.Read())
{
childCode += r.GetString(0);
}
}
}
search.SetCodeChildFromDB(childCode);
resCode.Add(key, ((search.ResultAlgorithm(0) + search.ResultAlgorithm(1) + search.ResultAlgorithm(2)) / 3));
}
foreach (int Key in resCode.Keys)
{
if (resCode[Key] > maxRes)
{
maxRes = resCode[Key];
idiDenticalFie = Key;
}
}
conn.Close();
}
public void SearchIn(string tagAddingSub)
{
conn.Open();
List <string> gram = new List <string>();
Dictionary <int, string> nameFile = new Dictionary <int, string>();
Dictionary <int, double> resCode = new Dictionary <int, double>();
Analysis search = new Analysis();
bool isDel = false;
string mainCode = "";
string childCode = "";
double maxRes = Double.MinValue;
using (command = new SqlCommand("select [file].id from [file] join [submit] on [file].id_submit = [submit].id where [submit].tag = @Tag", conn))
{
command.Parameters.Add(new SqlParameter("@Tag", tagAddingSub));
using (IDataReader r = command.ExecuteReader())
{
if (r.Read())
{
idMainFileForHist = r.GetInt32(0);
}
}
}
using (command = new SqlCommand(
"select [gram].gram from [gram] join [kgrmams] on [kgrmams].id_gram = [gram].id join [code] on [kgrmams].id_code = [code].id join [file] on [file].id_code = [code].id where [file].id = @id", conn))
{
command.Parameters.Add(new SqlParameter("@id", idMainFileForHist));
using (IDataReader r = command.ExecuteReader())
{
while (r.Read())
{
gram.Add(r.GetString(0));
}
}
}
for (int i = 0; i < gram.Count / 2; i++)
{
using (command = new SqlCommand(
"select DISTINCT [file].name, [file].id from [file] join [code] on [file].id_code = [code].id join [kgrmams] on [kgrmams].id_code = [code].id " +
"join [gram] on [kgrmams].id_gram = [gram].id where [gram].gram = @gram and [file].id != @idFile", conn))
{
command.Parameters.Add(new SqlParameter("@gram", gram[i]));
command.Parameters.Add(new SqlParameter("@idFile", idMainFileForHist));
using (IDataReader r = command.ExecuteReader())
{
while (r.Read())
{
if (!nameFile.ContainsKey(r.GetInt32(1)) && isDel && nameFile.Count > 1)
{
nameFile.Remove(r.GetInt32(1));
}
else if (!isDel)
{
nameFile.Add(r.GetInt32(1), r.GetString(0));
}
}
}
}
isDel = true;
}
using (command = new SqlCommand(
"select [code].normalizecode from [code] join [file] on [file].id_code = [code].id where [file].id = @id", conn))
{
command.Parameters.Add(new SqlParameter("@id", idMainFileForHist));
using (IDataReader r = command.ExecuteReader())
{
if (r.Read())
{
mainCode += r.GetString(0);
}
}
}
search.SetCodeMainFromDB(mainCode);
foreach (int key in nameFile.Keys)
{
using (command = new SqlCommand(
"select [code].normalizecode from [code] join [file] on [file].id_code = [code].id where [file].id = @id", conn))
{
command.Parameters.Add(new SqlParameter("@id", key));
using (IDataReader r = command.ExecuteReader())
{
if (r.Read())
{
childCode += r.GetString(0);
}
}
}
search.SetCodeChildFromDB(childCode);
resCode.Add(key, ((search.ResultAlgorithm(0) + search.ResultAlgorithm(1) + search.ResultAlgorithm(2)) / 3));
}
foreach (int Key in resCode.Keys)
{
if (resCode[Key] > maxRes)
{
maxRes = resCode[Key];
idiDenticalFie = Key;
}
}
conn.Close();
}