public void WordBookLoader()
{
DatabaseConnector.Alphabet_Surf_db_DataReader_wordbook();
this.wordbook_grid.ItemsSource = DatabaseConnector.WordBook;
this.SearchedDataGrid = CollectionViewSource.GetDefaultView(DatabaseConnector.WordBook);
}
public static void Alphabet_Surf_db_Initializar()
{
SQLiteConnection.CreateFile("Alphabet_Surf_DB.sqlite");
DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector.Open();
SQLiteCommand command_alphabet_picture = new SQLiteCommand("create table alphabet_picture (alphabet varchar(5), upperOrLower varchar(10), pic_path_1 varchar(100), pic_path_2 varchar(1000), description varchar(2000))", DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector);
command_alphabet_picture.ExecuteNonQuery();
SQLiteCommand command_wordbook = new SQLiteCommand("create table wordbook (word varchar(5), short_description varchar(2000), long_description varchar(4000))", DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector);
command_wordbook.ExecuteNonQuery();
DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector.Close();
}
