private void DictionaryForm_Load(object sender, EventArgs e)
{
InitDictionaryManagerPaths();
DM.Init();
InitPathsTextBox();
InitSourseListBox();
this.Height = 305;
}
private void addWordsFromTextButton_Click(object sender, EventArgs e)
{
InitDictionaryManagerPaths();
if (commonSourceTextBox.Text == "" || sourceTextBox.Text == "")
{
MessageBox.Show("Не заполнены поля источники");
return;
}
string textToAnalyze = FileSaver.ReadTextToAnalize();
if (textToAnalyze == "")
{
MessageBox.Show("Файл " + DM.fileToAnalizePath + " не найден");
return;
}
string pathToExcel = FileSaver.OpenExcelFile();
if (DM.PathToExcel == "")
{
MessageBox.Show("Файл " + DM.PathToExcel + " не найден");
return;
}
int news = 0;
int olds = 0;
string log = "";
WordsFormer allWords = new WordsFormer();
allWords.analyzeAll(textToAnalyze);
if (excelApp == null)
{
excelApp = new ExcelManager();
excelApp.Open(DM.PathToExcel);
}
List <string> existedWords = excelApp.GetColumn(DM.Columns.word);
List <string> lfreq = excelApp.GetColumn(DM.Columns.freq);
List <string> lLvl = excelApp.GetColumn(DM.Columns.level);
int oldUnder = 0;
List <string> oldUnderList = new List <string>();
List <int> oldUnderCntList = new List <int>();
List <int> newsCnt = new List <int>();
for (int i = 0; i < existedWords.Count; i++)
{
var f = Convert.ToInt32(lfreq[i]);
if (lLvl[i] == "0" && Convert.ToInt32(lfreq[i]) <= DictionaryManager.NumberOfRare)
{
oldUnderList.Add(existedWords[i]);
}
}
for (int j = 0; j < allWords.dict.Count; j++)
{
string word = allWords.dict[j].word;
int indexOfWordInDictionary = existedWords.IndexOf(word);
Text = j.ToString() + "/" + allWords.dict.Count.ToString();
if (indexOfWordInDictionary < 0)//add new
{
Translator tranlate = new Translator();
Translator.WordTranslation translatedWord;
translatedWord = tranlate.makeTranslations(word);
int lastRow = excelApp.lastRow;
excelApp.SetValue(DM.Columns.word, lastRow, translatedWord.word);
excelApp.SetValue(DM.Columns.freq, lastRow, allWords.dict[j].freq.ToString());
excelApp.SetValue(DM.Columns.level, lastRow, "0");
excelApp.SetValue(DM.Columns.date, lastRow, DateTime.Today.ToShortDateString());
excelApp.SetValue(DM.Columns.definition, lastRow, translatedWord.definition);
excelApp.SetValue(DM.Columns.init, lastRow, translatedWord.initial);
excelApp.SetValue(DM.Columns.trans1, lastRow, translatedWord.translation.Split('\t')[0]);
excelApp.SetValue(DM.Columns.trans2, lastRow, translatedWord.translation.Split('\t')[1]);
excelApp.SetValue(DM.Columns.trans3, lastRow, translatedWord.translation.Split('\t')[2]);
excelApp.SetValue(DM.Columns.src, lastRow, sourceTextBox.Text);
excelApp.SetValue(DM.Columns.comSrc, lastRow, commonSourceTextBox.Text);
DM.AddExamples(excelApp, allWords.dict[j].examples, lastRow);
news++;
}
else
{
indexOfWordInDictionary = indexOfWordInDictionary + 2;//first two rows isnot count. can refacotr
DM.IncreaseFrequency(excelApp, indexOfWordInDictionary, allWords.dict[j].freq);
DM.AddExamples(excelApp, allWords.dict[j].examples, indexOfWordInDictionary);
olds++;
if (oldUnderList.IndexOf(word) > -1)
{
oldUnder++;
}
log = log + word + "\taddFreq " + allWords.dict[j].freq.ToString() + "\tfrom " + allWords.dict[j].word + "\r";
}
}
Text = $"Новые {news}, знаю {olds}, всего {allWords.dict.Count}. Сложность {(news * 100 / allWords.dict.Count)}%. Редкие {oldUnder}";
FileSaver.Log(log);
FileSaver.Duplicate(sourceTextBox.Text);
excelApp.makeVisible();
}
