public string GetFileName(PopularWordType popularWordType)
{
string fileName = string.Format(@"C:\Projects\StudyLanguages\Источники слов\{0}_{1}.xml",
popularWordType, _languageTo);
return(fileName);
}
public void ConvertPopularWords(PopularWordType popularWordType)
{
LoadLanguages();
var popularWordsQuery = new PopularWordsQuery();
List <SourceWithTranslation> words = popularWordsQuery.GetWordsByType(_userLanguages, popularWordType);
var fileName = GetFileName(popularWordType);
SaveConvertedWords(fileName, words);
Console.WriteLine(
"Переконвертировали популярные слова с типом {0}. Воспользовались дополнительными словарями {1} раз",
fileName, _translator.CountExtraCalls);
}
/// <summary>
/// Создает слова по типу популярности
/// </summary>
/// <param name="source">слово</param>
/// <param name="translation">перевод</param>
/// <param name="type">тип популярности</param>
/// <returns>созданные слова для группы, или ничего</returns>
public SourceWithTranslation GetOrCreate(PronunciationForUser source,
PronunciationForUser translation,
PopularWordType type)
{
var wordsQuery = new WordsQuery();
WordWithTranslation wordWithTranslation = wordsQuery.GetOrCreate(source, translation, null, WordType.Default,
null);
if (wordWithTranslation == null)
{
return(null);
}
var parsedType = (int)type;
SourceWithTranslation result = Adapter.ReadByContext(c => {
var wordsWithTranslationsQuery = (from w1 in c.Word
join wt in c.WordTranslation on w1.Id equals wt.WordId1
join pw in c.PopularWord on wt.Id equals pw.WordTranslationId
join w2 in c.Word on wt.WordId2 equals w2.Id
where pw.Type == parsedType && wt.Id == wordWithTranslation.Id
select new { wt, w1, w2 });
var firstRecord = wordsWithTranslationsQuery.AsEnumerable().FirstOrDefault();
if (firstRecord == null)
{
return(null);
}
SourceWithTranslation innerResult = ConverterEntities.ConvertToSourceWithTranslation(firstRecord.wt.Id,
firstRecord.wt.
Image,
wordWithTranslation
.Source.
LanguageId,
firstRecord.w1,
firstRecord.w2);
return(innerResult);
});
if (result == null)
{
result = Create(wordWithTranslation, parsedType);
}
return(result);
}
public PopularWordsCreator(LanguageShortName from, PopularWordType type)
{
_from = from;
_type = type;
}
/// <summary>
/// Возвращает слова по типу популярности
/// </summary>
/// <param name="userLanguages">язык</param>
/// <param name="type">тип популярных слов</param>
/// <returns>список слов по типу</returns>
public List <SourceWithTranslation> GetWordsByType(UserLanguages userLanguages, PopularWordType type)
{
long sourceLanguageId = userLanguages.From.Id;
long translationLanguageId = userLanguages.To.Id;
var parsedType = (int)type;
List <SourceWithTranslation> result = Adapter.ReadByContext(c => {
var wordsWithTranslationsQuery = (from w1 in c.Word
join wt in c.WordTranslation on w1.Id equals wt.WordId1
join pw in c.PopularWord on wt.Id equals pw.WordTranslationId
join w2 in c.Word on wt.WordId2 equals w2.Id
where pw.Type == parsedType &&
((w1.LanguageId == sourceLanguageId &&
w2.LanguageId == translationLanguageId)
||
(w1.LanguageId == translationLanguageId &&
w2.LanguageId == sourceLanguageId))
orderby pw.Id
select new { wt, w1, w2 });
List <SourceWithTranslation> innerResult =
wordsWithTranslationsQuery.AsEnumerable().Select(
e =>
ConverterEntities.ConvertToSourceWithTranslation(e.wt.Id, e.wt.Image, sourceLanguageId, e.w1,
e.w2)).
ToList();
return(innerResult);
});
return(result);
}
