private void Button_Click_1(object sender, RoutedEventArgs e) { string slowkopl = TextBoxDodajSlowkoPL.Text.ToLower(); string slowkoen = TextBoxDodajSlowkoEN.Text.ToLower(); string kontekst = TextBoxDodajKontekst.Text; if (kontekst.Length == 0) { kontekst = " "; } string podpowiedz = TextBoxDodajSlowkoPodpowiedz.Text; if (podpowiedz.Length == 0) { podpowiedz = " "; } string DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, aktualnabaza + ".sqlite"); var db = new SQLite.SQLiteConnection(DBPath); var newfisz = new UserDefaultDataBase { SlowkoPl = slowkopl, SlowkoEn = slowkoen, Kontekst = kontekst, Podpowiedz = podpowiedz, IloscOdpowiedzi = 0, IloscPoprawnychOdpowiedzi = 0, passa = 0, kategoria = 1 }; db.Insert(newfisz); TextBoxDodajSlowkoEN.Text = ""; TextBoxDodajSlowkoPL.Text = ""; TextBoxDodajKontekst.Text = ""; TextBoxDodajSlowkoPodpowiedz.Text = ""; DodajSlowkoEndButton.IsEnabled = true; }
/// <summary> /// Invoked when the application is launched normally by the end user. Other entry points /// will be used when the application is launched to open a specific file, to display /// search results, and so forth. /// </summary> /// <param name="args">Details about the launch request and process.</param> protected async override void OnLaunched(LaunchActivatedEventArgs args) { Frame rootFrame = Window.Current.Content as Frame; int sprawdz = 0; var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path; StorageFolder folder = Windows.Storage.ApplicationData.Current.LocalFolder; //var files = await folder.GetFilesAsync(); IReadOnlyList <StorageFile> fList = await folder.GetFilesAsync(); foreach (var f in fList) { //Debug.WriteLine(f.DisplayName); if (f.DisplayName.Equals("AppData")) { sprawdz = 1; } } ; Debug.WriteLine(Windows.Storage.ApplicationData.Current.LocalFolder.Path); if (sprawdz == 0) { this.DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "AppData.sqlite"); //inicjalizacja bazy using (var db = new SQLite.SQLiteConnection(this.DBPath)) { db.CreateTable <UserInformation>(); db.CreateTable <UserDefaultDataBase>(); var uzytkownik = new UserInformation { Id = 1, IloscDobrychOdpowiedzi = 0, IloscOgolnychOdpowiedzi = 0, passa = 0, NauczucielTest = 1, NauczycielPin = 0000, IloscLogowan = 0 }; var slowko1 = new UserDefaultDataBase { SlowkoPl = "Monitor", SlowkoEn = "Screen", Podpowiedz = "You watching move on yours PC's s...", Kontekst = "Monitor komputera", IloscOdpowiedzi = 0, passa = 0, IloscPoprawnychOdpowiedzi = 0, kategoria = 1 }; db.Insert(uzytkownik); db.Insert(slowko1); } } //this.DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "AppData.sqlite"); //Debug.WriteLine("App path: {0}", DBPath); ////inicjalizacja bazy //using (var db = new SQLite.SQLiteConnection(this.DBPath)) //{ // db.CreateTable<UserInformation>(); // db.CreateTable<UserDefaultDataBase>(); // var asd = new UserDefaultDataBase // { // SlowkoPl = "Monitor", // SlowkoEn = "Screen", // Podpowiedz = "You watching move on yours PC's s...", // Kontekst = "Monitor komputera", // IloscOdpowiedzi = 0, // passa = 0, // IloscPoprawnychOdpowiedzi = 0 // }; // db.Insert(asd); //} // Do not repeat app initialization when the Window already has content, // just ensure that the window is active if (rootFrame == null) { // Create a Frame to act as the navigation context and navigate to the first page rootFrame = new Frame(); if (args.PreviousExecutionState == ApplicationExecutionState.Terminated) { //TODO: Load state from previously suspended application } // Place the frame in the current Window Window.Current.Content = rootFrame; } if (rootFrame.Content == null) { // When the navigation stack isn't restored navigate to the first page, // configuring the new page by passing required information as a navigation // parameter if (!rootFrame.Navigate(typeof(MainPage), args.Arguments)) { throw new Exception("Failed to create initial page"); } } // Ensure the current window is active Window.Current.Activate(); }