private void combo_lang_Loaded(object sender, RoutedEventArgs e)
{
string[] langs = Enum.GetNames(typeof(ProgramTech.Language));
List <string> itemSources = new List <string>();
foreach (string lang in langs)
{
if (DatabaseController.getInstance().checkTableExists(lang))
{
itemSources.Add(lang);
}
}
combo_lang.ItemsSource = itemSources;
combo_lang.SelectedIndex = 0;
}
public bool saveBulk(DataTable wordsTable, string language)
{
connection = DatabaseController.getInstance().getSqlConnection();
try
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
{
bulkCopy.DestinationTableName = language;
bulkCopy.WriteToServer(wordsTable);
}
} catch (SqlException ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
public bool saveList(List <Word> words, Language language, bool async = false)
{
DatabaseController.getInstance().addTable(language.ToString());
DataTable wordTable = toDataTable(words);
if (async)
{
using (var localDao = new WordDAO())
{
localDao.saveBulk(wordTable, language.ToString());
}
}
else
{
staticDao.saveBulk(wordTable, language.ToString());
}
return(true);
}
private void button_dictionary_Click(object sender, EventArgs e)
{
LangWindow langWind = new LangWindow();
langWind.ShowDialog();
string selectedLang = langWind.SelectedLang;
if (selectedLang.Equals(String.Empty))
{
return;
}
if (DatabaseController.getInstance().checkTableExists(selectedLang))
{
AgreeWindow agreeWindow = new AgreeWindow();
agreeWindow.ShowDialog();
if (!agreeWindow.Agreement)
{
return;
}
else
{
DatabaseController.getInstance().removeTable(selectedLang);
}
}
var senderButton = sender as Button;
switch (senderButton.Name)
{
case "button_file":
addDictionaryFromFile(selectedLang);
break;
case "button_url":
addDictionaryFromUrl(selectedLang);
break;
}
}
public bool downloadDictionary(Language language, string url)
{
if (DatabaseController.getInstance().checkTableExists(language.ToString()))
{
return(false);
}
List <Word> words = new List <Word>();
try
{
using (var client = new WebClient())
{
using (System.IO.StringReader reader = new System.IO.StringReader(client.DownloadString(new Uri(url))))
{
string line;
while ((line = reader.ReadLine()) != null)
{
if (Word.isVaild(line))
{
words.Add(new Word(line));
}
else
{
log.Info(String.Format("{0} was not added to database, because it is not forged only from letters", line));
}
}
}
}
} catch (WebException ex)
{
throw new Exceptions.WordControllerWebException(url, ex);
}
return(WordService.getInstance().saveList(words, language));
}
public WordDAO()
{
connection = DatabaseController.getInstance().getSqlConnection();
}