private void AddStrongToolTip(StrongCode code) { if (code.IsNotNull()) { var strongToolTip = new DevExpress.Utils.SuperToolTip() { AllowHtmlText = DevExpress.Utils.DefaultBoolean.True }; strongToolTip.Items.Add(new DevExpress.Utils.ToolTipTitleItem() { AllowHtmlText = DevExpress.Utils.DefaultBoolean.True, Text = code.ShortDefinition }); strongToolTip.Items.Add(new DevExpress.Utils.ToolTipSeparatorItem()); strongToolTip.Items.Add(new DevExpress.Utils.ToolTipItem() { AllowHtmlText = DevExpress.Utils.DefaultBoolean.True, Text = code.Definition }); lblStrong.SuperTip = strongToolTip; } }
private async Task _Import(string zipFilePath, UnitOfWork uow) { if (File.Exists(zipFilePath)) { var controller = new TranslatorController(); var fileName = ExtractAndGetFirstArchiveItemFilePath(zipFilePath); try { using (var conn = new SqliteConnection($"DataSource=\"{fileName}\"")) { SQLitePCL.Batteries.Init(); conn.Open(); var command = conn.CreateCommand(); var sql = @"SELECT topic, lexeme, transliteration, pronunciation, short_definition, definition FROM dictionary WHERE CAST(substr(topic,2) as INTEGER) > 4031 AND topic like ""G%"""; command.CommandText = sql; //@"SELECT topic, lexeme, transliteration, pronunciation, short_definition, definition FROM dictionary"; using (var reader = command.ExecuteReader()) { while (reader.Read()) { var topic = reader.GetString(0); var lexeme = reader.GetString(1); var transliteration = reader.GetString(2); var pronunciacion = reader.GetString(3); var shortDefinition = reader.GetString(4); var definition = reader.GetString(5); var lang = topic.StartsWith("H") ? Language.Hebrew : Language.Greek; var _code = topic.Substring(1); var code = Convert.ToInt32(_code); var short_definition_translation = await GetTranslation(controller, shortDefinition); var definition_translation = await GetTranslation(controller, definition); var item = new XPQuery <StrongCode>(uow).Where(x => x.Lang == lang && x.Code == code).FirstOrDefault(); if (item.IsNull()) { item = new StrongCode(uow) { Code = code, Definition = definition_translation, Lang = lang, Pronunciation = pronunciacion, ShortDefinition = short_definition_translation, SourceWord = lexeme, Transliteration = transliteration }; } else { item.Definition = definition_translation; item.Pronunciation = pronunciacion; item.ShortDefinition = short_definition_translation; item.SourceWord = lexeme; item.Transliteration = transliteration; } item.Save(); } } conn.Close(); } } finally { try { File.Delete(fileName); } catch { } } } }