private async Task AddRecipesAsync()
        {
            var list = await GetAllRecepiesFromHttpRequest();

            SQLiteAsyncConnection conn = new SQLiteAsyncConnection(dbName);
            await conn.InsertAllAsync(list);
        }

 public async Task<AlbumItem> LoadAlbumViaName(int artistId, string albumName)
 {
     var connection = new SQLiteAsyncConnection(DbPath);
     var query = connection.Table<AlbumItem>().Where(x => x.Name.Equals(albumName)).Where(x => x.ArtistId == artistId);
     var result = await query.ToListAsync();
     return result.FirstOrDefault();
 }

        private void ConnData()
        {
            //Creates database if it doesn't exists
            var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");

            conn = new SQLite.SQLiteAsyncConnection(dbPath);
        }

        private static Task CreateDatabase (SQLiteAsyncConnection connection, CancellationToken cancellationToken)
        {
            return Task.Factory.StartNew(() =>
            {
                //Create the tables
                var createTask = connection.CreateTablesAsync (tableTypes);
                createTask.Wait();

                //Count number of assignments
                var countTask = connection.Table<Assignment>().CountAsync();
                countTask.Wait();

                //If no assignments exist, insert our initial data
                if (countTask.Result == 0)
                {
                    var insertTask = connection.InsertAllAsync(TestData.All);

                    //Wait for inserts
                    insertTask.Wait();

                    //Mark database created
                    initialized = true;
                }
            });
        }

        /// <summary>
        /// For Displaying search result from database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private async void acbDrugSearch_TextChanged(object sender, RoutedEventArgs e)
        {

            var folder = ApplicationData.Current.LocalFolder.GetFolderAsync("DataFolder");

            SQLiteAsyncConnection conn = new SQLiteAsyncConnection(Path.Combine(ApplicationData.Current.LocalFolder.Path, "DataFile.sqlite"), true);
           

            string pillname = acbDrugSearch.Text;
            if (!string.IsNullOrEmpty(pillname) && !string.IsNullOrWhiteSpace(pillname) && pillname.Length > 3)
            {

                var query = conn.Table<drugs>().Where(x => x.drugname.Contains(pillname));
                var result = await query.ToListAsync();
                if (result == null)
                {
                    MessageBox.Show("Pill not found.");
                }
                else
                {
                    List<string> drugnamelist = new List<string>();
                    foreach (var item in result)
                    {
                        dataReadName =item.drugname;
                        dataReadMilligram = item.strenght;
                        dataReadNameMilligram = dataReadName + dataReadMilligram;
                        drugnamelist.Add(dataReadNameMilligram);
                    }
                    lstDrugSearch.ItemsSource = drugnamelist;
                }


            }
        }

        private async void Create()
        {
            Connection = new SQLiteAsyncConnection(dbpath);

            // create all tables
            Connection.CreateTableAsync<SQLite.Task>();
        }

        private async void btnOK_Click(object sender, RoutedEventArgs e)
        {
            SQLiteAsyncConnection conn = new SQLiteAsyncConnection(Path.Combine(ApplicationData.Current.LocalFolder.Path, "people.db"), true);

            Person person = new Person
            {
                DoctorName = watermarkTextBox.Text,
                Date = datepick.ValueString,
                Time = timepick.ValueString
             };

            await conn.InsertAsync(person);

            //My_Medi.ViewModels.MainViewModel veiw = new ViewModels.MainViewModel();

            //veiw.LoadData();
            DataContext = App.ViewModel;
            App.ViewModel.Items.Clear();
            App.ViewModel.LoadData();            
            

            NavigationService.GoBack();
            
            


        }

        private void AppBarToggleButton_Checked(object sender, RoutedEventArgs e)
        {

            AppBarToggleButton favButton = sender as AppBarToggleButton;
            //if ((bool)favButton.IsChecked)
            //{
            //    var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
            //    var con = new SQLiteAsyncConnection(path);
            //    //await con.InsertAllAsync(results);

            //    await con.QueryAsync<Result>(string.Format("insert into Result (name,name) values('{0}','{1}')", results[0].name, tblock.Text));
            //}
            //else
            //{

            //}
            if ((bool)favButton.IsChecked)
            {
                var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
                var con = new SQLiteAsyncConnection(path);
                con.QueryAsync<Favourite>(string.Format("insert into Favourite (placeName,userName) values('{0}','{1}')", results[0].name, tblock.Text));
            }
            else if (!(bool)favButton.IsChecked)
            {
                var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB";
                var con = new SQLiteAsyncConnection(path);
                con.QueryAsync<Favourite>(string.Format("delete from Favourite where placeName = '{0}' and username='{1}'", results[0].name, tblock.Text));
            }


        }

        public async Task DeleteCounterAsync(Counter counter)
        {
            var connection = new SQLiteAsyncConnection(_dbPath);
            await connection.DeleteAsync(counter);

            OnCountersChanged();
        }

        private async void btnOK_Click(object sender, RoutedEventArgs e)
        {

            SQLiteAsyncConnection conn = new SQLiteAsyncConnection(Path.Combine(ApplicationData.Current.LocalFolder.Path, "people.db"), true);
            //string[] per = new string[10];
 
            var per=App.ViewModel.Items[index];
            per.LineFive = watermarkTextBox.Text;
            per.Linesix = watermarkTextBox1.Text;
            per.Lineseven = watermarkTextBox2.Text;
            per.Lineeight = watermarkTextBox3.Text;
            Person person = new Person()

            {
                ID=per.Lineone,
                DoctorName=per.Linetwo,
                Date=per.Linethree,
                Time=per.LineFour,
                Temperature=per.LineFive,
                Bp=per.Linesix,
                symptoms=per.Lineseven,
                description=per.Lineeight

            };
           
            await conn.UpdateAsync(person);


            NavigationService.GoBack();
            
        }

 public async static Task<int> CounterSubscribed()
 {
     SQLiteAsyncConnection sqlConnection = new SQLiteAsyncConnection(DbHelper.DB_PATH);
     int counters = await sqlConnection.Table<Counter>().CountAsync();
     AppStore.AddValue(Constants.CountersSubscribed, counters.ToString());
     return counters;
 }

 private async void Button_Click_3(object sender, RoutedEventArgs e)
 {
     SQLiteAsyncConnection conn = new SQLiteAsyncConnection(ApplicationData.Current.LocalFolder.Path + "\\people.db");
     var query = conn.Table<Person>();//.Where(x => x.Name == "张三");
     var result = await query.ToListAsync();
     listbox.ItemsSource = result;
 }

 async Task<MusicLibraryViewModel.ArtistItem> LoadViaArtistName(string artistName)
     {
         var connection = new SQLiteAsyncConnection(_dbPath);
         var query = connection.Table<MusicLibraryViewModel.ArtistItem>().Where(x => x.Name.Equals(artistName));
         var result = await query.ToListAsync();
         return result.FirstOrDefault();
     }

 public async Task<string> GetFirstTrackPathByAlbumId(int albumId)
 {
     var connection = new SQLiteAsyncConnection(DbPath);
     var query = connection.Table<TrackItem>().Where(x => x.AlbumId == albumId);
     var result = await query.FirstOrDefaultAsync();
     return result != null ? result.Path : null;
 }

        /// <summary>
        /// Invoked when this page is about to be displayed in a Frame.
        /// </summary>
        /// <param name="e">Event data that describes how this page was reached.
        /// This parameter is typically used to configure the page.</param>
        protected async override void OnNavigatedTo(NavigationEventArgs e)
        {

            bool dbExist = await CheckDbAsync("Tips.db3");
            if (!dbExist)
            {
                await CreateDatabaseAsync();
            }

         
            SQLiteAsyncConnection conn = new SQLiteAsyncConnection("Tips.db3");
            var query = conn.Table<Tips>();
            tips = await query.ToListAsync();

            string title1res = tips[tips.Count - 1].title1;
            string title2res = tips[tips.Count - 1].title2;
            string title3res = tips[tips.Count - 1].title3;
            
            string desc1res = tips[tips.Count - 1].desc1;
            string desc2res = tips[tips.Count - 1].desc2;
            string desc3res = tips[tips.Count - 1].desc3;


            Tips l = new Tips { title1 = title1res, title2 = title2res, title3 = title3res, desc1 = desc1res, desc2 = desc2res, desc3 = desc3res };
            t.Add(l);
            TipsList.ItemsSource = t;
        }

 public Task Update(MapModel map)
 {
     SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString);
     _dataSources.Remove(_dataSources.First(source => source.ID.Equals(map.ID)));
     _dataSources.Add(map);
     return connection.UpdateAsync(map);
 }

 public async Task<TrackItem> LoadTrack(int trackId)
 {
     var connection = new SQLiteAsyncConnection(DbPath);
     var query = connection.Table<TrackItem>().Where(x => x.Id.Equals(trackId));
     var result = await query.ToListAsync();
     return result.FirstOrDefault();
 }

        private async void LoadChartContents()
        {
              bool dbExist = await CheckDbAsync("ouzen.db3");
            if (!dbExist)
            {
                await CreateDatabaseAsync();
            }

            // Get personnes
            SQLiteAsyncConnection conn = new SQLiteAsyncConnection("ouzen.db3");
            var query = conn.Table<ouzen>();
            ouzen = await query.ToListAsync();


            for (int i = 0; i < ouzen.Count; i++) Debug.WriteLine(ouzen[i].date1);

            //    items.Add(new ouzen { Name =q , Value = _random.Next(35, 150) });

            ((LineSeries)this.LineChart.Series[0]).ItemsSource = ouzen;
            ((LineSeries)this.LineChart.Series[0]).DependentRangeAxis =
              new LinearAxis
              {
                  Minimum = 35,
                  Maximum = 150,
                  Orientation = AxisOrientation.Y,
                  Interval = 5,
                  ShowGridLines = true
              };
            ((LineSeries)this.LineChart.Series[0]).Refresh();
        }

        private async void enterbtn_Click(object sender, RoutedEventArgs e)
        {
            var path = ApplicationData.Current.LocalFolder.Path + "/mydb.db";
            var con = new SQLiteAsyncConnection(path);
            person loginPerson = (await con.QueryAsync<person>("select isConfirmed from person where name='" + Dashboard.userName + "'"))[0];

            if (loginPerson.isConfirmed == 1)
            {
                List<person> all = new List<person>();
                all = await con.QueryAsync<person>("select name,email,country,gender,phone from person where name='" + searchboxtxt.Text + "' AND isConfirmed= 1  ");
               // var mm1 = new MessageDialog("no matches found").ShowAsync();
                String res = "";
                foreach (person a in all)
                {
                    res += "\n\n" + a.name + "\n\n" + a.email + "\n\n" + a.country + "\n\n" + a.gender + "\n\n" + a.phone;
                }
                restxtblock.Text = res;
            }
            else
            {
                var md1 = new MessageDialog("No permission to search for users").ShowAsync();
        
            }

            
        }

        private async void Button_Click_2(object sender, RoutedEventArgs e)
        {
            if (baza.Equals("eFiszki"))
            {
                baza = "AppData";
            }
            var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite";
            var db = new SQLiteAsyncConnection(path);

            List<UserDefaultDataBase> listadostepnychindekow = await db.QueryAsync<UserDefaultDataBase>("Select Id From UserDefaultDataBase");
          
            if (listadostepnychindekow.Count < 1)
            {
                MessageDialog dialog = new MessageDialog(egzamin1zamalokomunikat.Text);
                await dialog.ShowAsync();
            }
            else
            {
                if (toggledynamicsave.IsOn)
                {
                    dynamicsave = true;
                    //this.Frame.Navigate(typeof(NaukaSlowek));
                }
                else
                {
                    dynamicsave = false;
                    //this.Frame.Navigate(typeof(naukaslowek2));
                }

                if (toggleentertocheck.IsOn)
                {
                    pressenter = true;
                }
                else
                {
                    pressenter = false;
                }

                if (togglestatistic.IsOn)
                {
                    statistic = true;
                }
                else
                {
                    statistic = false;
                }
                if (togglesmartrandom.IsOn)
                {
                    smartrandom = true;
                }
                else
                {
                    smartrandom = false;
                }

                this.Frame.Navigate(typeof(naukaslowek2));

                
            }
        }