public static WordsStorageModel GetWordModelFromAiCiBa(AiCiBaE2C_Model _aimodel)
{
WordsStorageModel result = new WordsStorageModel();
result.Word = _aimodel.word_name;
result.word_pl = ListHelper.GetListFromArray(_aimodel.exchange.word_pl);
result.word_past = ListHelper.GetListFromArray(_aimodel.exchange.word_past);
result.word_done = ListHelper.GetListFromArray(_aimodel.exchange.word_done);
result.word_ing = ListHelper.GetListFromArray(_aimodel.exchange.word_ing);
result.word_third = ListHelper.GetListFromArray(_aimodel.exchange.word_third);
result.word_er = ListHelper.GetListFromArray(_aimodel.exchange.word_er);
result.word_est = ListHelper.GetListFromArray(_aimodel.exchange.word_est);
result.ph_en = _aimodel.symbols[0].ph_en;
result.ph_am = _aimodel.symbols[0].ph_am;
result.ph_other = _aimodel.symbols[0].ph_other;
result.ph_en_mp3 = _aimodel.symbols[0].ph_en_mp3;
result.ph_am_mp3 = _aimodel.symbols[0].ph_am_mp3;
result.ph_tts_mp3 = _aimodel.symbols[0].ph_tts_mp3;
foreach (var definition in _aimodel.symbols[0].parts.ToList())
{
result.Definitions.Add(new DefinitionStroage()
{
part = definition.part,
means = definition.means.ToList()
});
}
return(result);
}
public static WordsStorageModel QueryEntry(string _word, int _dictionarysource_id)
{
WordsStorageModel result = SQLManager.QueryEntry(_word, _dictionarysource_id);
result.Definitions = SQLManager.QueryDefinitions(result.ID);
return(result);
}
public static WordsStorageModel QueryWord(string _word, int _dictionarysource_id)
{
WordsStorageModel result = QueryEntry(_word, _dictionarysource_id);
foreach (var _partofspeech in SQLManager.QueryPartOfSpeech(result.ID))
{
switch (_partofspeech.Part)
{
case "word_pl":
result.word_pl.Add(_partofspeech.Word);
break;
case "word_past":
result.word_past.Add(_partofspeech.Word);
break;
case "word_done":
result.word_done.Add(_partofspeech.Word);
break;
case "word_ing":
result.word_ing.Add(_partofspeech.Word);
break;
case "word_third":
result.word_third.Add(_partofspeech.Word);
break;
case "word_er":
result.word_er.Add(_partofspeech.Word);
break;
case "word_est":
result.word_est.Add(_partofspeech.Word);
break;
}
}
result.Definitions = SQLManager.QueryDefinitions(result.ID);
foreach (var _definition in result.Definitions)
{
_definition.Means = SQLManager.QueryMeans(_definition.ID);
foreach (var _mean in _definition.Means)
{
_definition.means.Add(_mean.Meaning);
}
}
return(result);
}
public static WordsStorageModel Add(WordsStorageModel _entry)
{
if (!SQLManager.IfWordExist(_entry.Word))
{
Word _word = new Word()
{
Spelling = _entry.Word
};
SQLManager.Add(_word);
}
if (!SQLManager.IfEntryExist(_entry.Word, _entry.DictionarySource_ID))
{
SQLManager.Add(_entry);
int _entry_id = SQLManager.FindEntryID(_entry.Word, _entry.DictionarySource_ID);
foreach (var item in _entry.word_pl)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_pl",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var item in _entry.word_past)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_past",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var item in _entry.word_done)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_done",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var item in _entry.word_ing)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_ing",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var item in _entry.word_third)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_third",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var item in _entry.word_er)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_er",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var item in _entry.word_est)
{
PartOfSpeechStorage partofspeech = new PartOfSpeechStorage()
{
Entry_ID = _entry_id,
Part = "word_est",
Word = item
};
SQLManager.Add(partofspeech);
}
foreach (var _definition in _entry.Definitions)
{
_definition.ID = Guid.NewGuid();
_definition.Entry_ID = _entry_id;
SQLManager.Add(_definition);
foreach (var _mean in _definition.means)
{
var newMean = new MeanStorage()
{
Definition_ID = _definition.ID,
Meaning = _mean
};
_definition.Means.Add(newMean);
SQLManager.Add(newMean);
}
}
}
return(_entry);
}
