//-------------------------------------------------------------------------------
internal static void dbAutoComplSearch(string connectStringDB, string autocomplitWord)
{
var findWorldDict = new Dictionary <string, int>();
var keyForRemove = new List <string>();
dataSetSimpleText ds = new dataSetSimpleText();
dataSetSimpleText.NameDataTable tblName = ds.Name;
dataSetSimpleTextTableAdapters.NameTableAdapter daName;
daName = new dataSetSimpleTextTableAdapters.NameTableAdapter();
Console.WriteLine(daName.ClearBeforeFill);
tblName.Clear();
daName.Fill(tblName);
foreach (dataSetSimpleText.NameRow rowName in tblName)
{
if (findWorldDict.ContainsKey(rowName.word) || !rowName.word.StartsWith(autocomplitWord))
{
continue;
}
findWorldDict.Add(rowName.word, rowName.wordCount);
}
findWorldDict = findWorldDict.
OrderByDescending(pair => pair.Value).
ToDictionary(pair => pair.Key, pair => pair.Value);
// Место для сортировки по ключу при равных значениях Value.
printDisplayFiveValue(findWorldDict, 5);
}
internal static void dbInitialMethod(string connectStringDB, Dictionary <string, int> frequency)
{
dataSetSimpleText ds = new dataSetSimpleText();
dataSetSimpleText.NameDataTable tblName = ds.Name;
dataSetSimpleTextTableAdapters.NameTableAdapter daName;
daName = new dataSetSimpleTextTableAdapters.NameTableAdapter();
Console.WriteLine(daName.ClearBeforeFill);
var dataCount = daName.ScalarQuery();
if (dataCount != 0)
{
dbDeleteMethod(connectStringDB);
}
// Console.WriteLine(daName.Fill(tblName));
Console.WriteLine("Load data...");
foreach (var e in frequency)
{
daName.Insert(e.Key, e.Value);
}
Console.WriteLine("End Load data...");
}
//-------------------------------------------------------------------------------
internal static void dbUpdateMethod(string connectStringDB, Dictionary <string, int> frequency)
{
dataSetSimpleText ds = new dataSetSimpleText();
dataSetSimpleText.NameDataTable tblName = ds.Name;
dataSetSimpleTextTableAdapters.NameTableAdapter daName;
daName = new dataSetSimpleTextTableAdapters.NameTableAdapter();
Console.WriteLine(daName.ClearBeforeFill);
foreach (var e in frequency)
{
tblName.AddNameRow(e.Key, e.Value);
}
Console.WriteLine("Update data ...");
daName.Update(tblName);
Console.WriteLine("End Update data ");
}
