public void InitTables()
{
db.CreateTable<Language>();
LanguageManager langManager = new LanguageManager(db);
langManager.InitDefaultData();
db.CreateTable<TranslateProvider>();
db.CreateTable<Direction>();
DirectionManager managerDirection = new DirectionManager(db);
managerDirection.InitDefaultData();
db.CreateTable<TranslateProvider>();
TranslateProviderManager managerProvider = new TranslateProviderManager(db);
managerProvider.InitDefaultData();
db.CreateTable<Favorites>();
db.CreateTable<SourceExpression>();
//SourceExpressionManager managerSourceExpression = new SourceExpressionManager(db);
//managerSourceExpression.InitDefaultData();
db.CreateTable<TranslatedExpression>();
db.CreateTable<DefinitionTypes>();
DefinitionTypesManager managerTypes = new DefinitionTypesManager(db);
managerTypes.InitDefaultData();
db.CreateTable<SourceDefinition>();
db.CreateTable<Chat>();
db.CreateTable<ChatHistory>();
}
private void writeTranslatedExpression(int sourceItemID, TranslateResultView resultView)
{
DefinitionTypesManager defTypesManager = new DefinitionTypesManager(db);
List<DefinitionTypes> defTypesList = defTypesManager.GetItems();
Repository<SourceDefinition> reposSourceDefinition = new Repository<SourceDefinition>();
Repository<TranslatedExpression> reposTranslatedExpression = new Repository<TranslatedExpression>();
foreach (var curDefinition in resultView.Definitions)
{
SourceDefinition sourceDefinitionItem = new SourceDefinition();
sourceDefinitionItem.SourceExpressionID = sourceItemID;
sourceDefinitionItem.TranscriptionText = curDefinition.Transcription;
sourceDefinitionItem.DefinitionTypeID = (int)curDefinition.Pos;
reposSourceDefinition.Save(sourceDefinitionItem);
int sourceDefId = getSourceDefinitionItemId(sourceItemID, curDefinition);
foreach (var curVariant in curDefinition.TranslateVariants)
{
TranslatedExpression translatedItem = new TranslatedExpression();
translatedItem.TranslatedText = curVariant.Text;
translatedItem.SourceDefinitionID = sourceDefId;
translatedItem.DefinitionTypeID = (int)curVariant.Pos;
translatedItem.LanguageFromID = direction.LanguageFrom.ID;
translatedItem.LanguageToID = direction.LanguageTo.ID;
//translatedItem.DirectionID = direction.GetCurrentDirectionId();
reposTranslatedExpression.Save(translatedItem);
fillTranslateResultIdsForNewItem(translatedItem.SourceDefinitionID, translatedItem.DefinitionTypeID, curVariant);
}
}
}
