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='******'", results[0].name, tblock.Text)); } }
public async Task <List <Movie> > GetFavorites() { try { await CreateTable(); var db = new SQLite.SQLiteAsyncConnection(_dbPath); // var db = new SQLiteAsyncConnection(_dbPath); List <Movie> results = await db.QueryAsync <Movie>("Select * FROM Movie"); string logResult = ""; foreach (Movie result in results) { logResult += result.id + "-" + result.title + ","; } Log.Debug("GetFavorites", "Returned " + logResult); return(results); } catch (SQLiteException ex) { Log.Debug("Get Favorites", "Exception " + ex.Message); return(new List <Movie>()); } }
protected override async void OnNavigatedTo(NavigationEventArgs e) { tblock.Text = !string.IsNullOrEmpty((App.Current as App).NavigateText) ? (App.Current as App).NavigateText : string.Empty; var path = ApplicationData.Current.LocalFolder.Path + "/mydb.db"; var con = new SQLiteAsyncConnection(path); //con.QueryAsync<person>("select name from person where name= ") + ""; //con.UpdateAsync("update person set password='******' where password='******' "); //person p1 = new person(); //List<person> allpersons1 = new List<person>(); //allpersons1 = await con.QueryAsync<person>("select name from person where name=" + "\'" + tblock.Text + "\'"); //if (allpersons1.Count == 1) //{ // p1 = allpersons1[0]; //} //await con.QueryAsync<person>("alter TABLE person add column isConfirmed integer "); if (isAdmin) { users.Visibility = Visibility.Visible; List<person> notConfirmedUsers = await con.QueryAsync<person>("select name from person where isConfirmed = 0"); users.ItemsSource = notConfirmedUsers; } else { users.Visibility = Visibility.Collapsed; } }
async Task<ObservableCollection<MusicLibraryViewModel.ArtistItem>> Load() { var connection = new SQLiteAsyncConnection(_dbPath); return new ObservableCollection<MusicLibraryViewModel.ArtistItem>( await connection.QueryAsync<MusicLibraryViewModel.ArtistItem>( "select * from ArtistItem")); }
public async Task<ObservableCollection<MapModel>> Load() { SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString); _dataSources = new ObservableCollection<MapModel>(await connection.QueryAsync<MapModel>("SELECT * FROM Maps")); return _dataSources; }
private void button_Click(object sender, RoutedEventArgs e) { if (File.Exists("Data.sql")) { // File.Create("data1.db"); acre.Text = "Exist Exist"; } else if (File.Exists("data1.db")) { if (File.Exists("data.db")) {acre.Text = "Exist";} } SQLiteAsyncConnection conn = new SQLiteAsyncConnection(DB_PATH, true); var query = conn.QueryAsync<chemicalnames2>("select * from chemicalnames2"); /* if (File.Exists("data1.db")) { acre.Text = "data1 Exist"; } else acre.Text = "data Exist";* / string[] array = new string[100]; //string arr = dbconn.Query<Task>("select Title from Task ").FirstOrDefault().ToString(); array[0] = "string"; int i; for (i = 1; i < 100; i++) { array[i] = dbconn.Query<chemicalnames2>("select chemicalname from chemicalnames2 where srno='" + i + "'").FirstOrDefault().ToString(); } items = new ObservableCollection<string>(); foreach (string str in array) items.Add(str); areapicker.ItemsSource = items; if (File.Exists("data.db")) { // Create the database connection using(var db = new SQLiteConnection("data.db")) { // If the table does not exist, create it db.CreateTable<chemicalnames2>(); acre.Text = "true"; // Retrieve a list of data from the database // List data = db.Table<chemicalnames2>().ToList<chemicalnames2>().ToString(); } }*/ // var tp = dbconn.Query<chemicalnames2>("select chemicalname from chemicalnames2 where srno='" + area.Text + "'").FirstOrDefault().ToString(); //acre.Text = tp.ToString(); }
async Task<ObservableCollection<MusicLibraryViewModel.AlbumItem>> LoadAlbumsFromId(int artistId) { var connection = new SQLiteAsyncConnection(_dbPath); return new ObservableCollection<MusicLibraryViewModel.AlbumItem>( await connection.QueryAsync<MusicLibraryViewModel.AlbumItem>( string.Format("select * from AlbumItem where ArtistId = {0}", artistId))); }
private async void checkUser() { if (!string.IsNullOrWhiteSpace(LoginModel.BadgeId) && !string.IsNullOrWhiteSpace(LoginModel.Password)) { SQLiteAsyncConnection connection = new SQLiteAsyncConnection("Test.db"); var result = await connection.QueryAsync<Employee>("SELECT * from Employee where BadgeId=\"" + LoginModel.BadgeId + "\""); //var result = await connection.ExecuteAsync("SELECT count("+""+"\"BadgeId\""+")"+ " from Employee"); System.Diagnostics.Debug.WriteLine("validating user"); #region if (result.Count != 0 && result[0].Password == LoginModel.Password && result[0].BadgeId == LoginModel.BadgeId) { System.Diagnostics.Debug.WriteLine("user validated"); Container.BadgeId = result[0].BadgeId; Container.Designation = result[0].Designation; Container.Manager = result[0].Manager; Container.Skill = result[0].Skill; Container.EName = result[0].EName; Container.Level = result[0].Level; if (result[0].Level != "1") { Container.Enable = Visibility.Visible; } else { Container.Enable = Visibility.Collapsed; } ((Frame)Window.Current.Content).Navigate(typeof(Profile)); } #endregion else { //set the message for user //LoginModel.UserFeedBack = "Username or Password is Invalid!"; //UserFeedBack = Visibility.Visible; //LoginModel.BadgeId = null; //LoginModel.Password = null; var errmsg = new MessageDialog("Invalid username or password"); await errmsg.ShowAsync(); ((Frame)Window.Current.Content).Navigate(typeof(MainPage)); } } else { var errmsg = new MessageDialog("Please enter the Details"); await errmsg.ShowAsync(); } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { bool dbExist = await CheckDbAsync("moneybook.db"); if (!dbExist) { await CreateDatabaseAsync(); //await CreateTaiKhoanItems(); } // Get Items SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db"); var query = conn.Table<taikhoan>(); taikhoans = await query.ToListAsync(); var queryk = await conn.QueryAsync<ghichep>("SELECT * from ghichep order by ngay"); List<ghichep> n = new List<ghichep>(); foreach (ghichep g in queryk.ToList()) { n.Add(g); } //var qGhiChep = conn.Table<ghichep>(); //ghicheps = await qGhiChep.ToListAsync(); // Show Tiems taikhoanList.ItemsSource = taikhoans; var result = from item in n group item by DateTime.Parse(item.Ngay).ToString("dd-MM-yyyy") into grp orderby grp.Key select grp; cvsGhiChepList.Source = result; ghichepListpv.DataContext = n; double sotienbandau = 0; var Sotienquery = await conn.QueryAsync<taikhoan>("SELECT sotienbandau from taikhoan"); foreach (var g in Sotienquery.ToList()) { sotienbandau += double.Parse(g.Sotienbandau); } tongsodutaikhoan.Text = "Tổng: " + sotienbandau.ToString("#,##0") +" đ"; }
protected override async void OnNavigatedTo(NavigationEventArgs e) { this.navigationHelper.OnNavigatedTo(e); SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db"); var query = await conn.QueryAsync<taikhoan>("SELECT tentaikhoan from taikhoan"); List<string> n = new List<string>(); foreach (var g in query.ToList()) { n.Add(g.Tentaikhoan); } tutaikhoan.ItemsSource = n; }
protected async override void OnNavigatedTo(NavigationEventArgs e) { part = e.Parameter as string; label.Text = part; // Get users SQLiteAsyncConnection connection = new SQLiteAsyncConnection("institutionFinder.db"); users = await connection.QueryAsync<Courses>("Select * FROM Courses"); // Show users viewcourses.ItemsSource = users; }
private async void Button_Click_3(object sender, RoutedEventArgs e) { string result = ""; var path = ApplicationData.Current.LocalFolder.Path + @"\Users.db"; var db = new SQLiteAsyncConnection(path); List<User> all = await db.QueryAsync<User>("Select* from Users"); var count = all.Any() ? all.Count : 0; foreach (var item in all) { result += "email" + item.email.ToString() + "\nFstname" + item.name+"\n"; } MessageDialog msg = new MessageDialog(result.ToString()); await msg.ShowAsync(); }
protected override async void OnNavigatedTo(NavigationEventArgs e) { SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db"); var taikhoanID = (int)e.Parameter; var query = await conn.QueryAsync<taikhoan>("SELECT * from taikhoan WHERE Id = " + taikhoanID); foreach (var g in query.ToList()) { id = g.Id; tentaikhoan.Text = g.Tentaikhoan; loaitaikhoan.SelectedItem = loaitaikhoan.Items.Cast<ComboBoxItem>().Where(cmbi => (string)cmbi.Tag == g.Loaitaikhoan).First(); loaitiente.SelectedItem = loaitiente.Items.Cast<ComboBoxItem>().Where(cmbi => (string)cmbi.Tag == g.Loaitiente).First(); sotienbandau.Text = g.Sotienbandau; ghichu.Text = g.Ghichu; } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { part = e.Parameter as string; navigated.Text = part; // Get users SQLiteAsyncConnection connection = new SQLiteAsyncConnection("institutionFinder.db"); users = await connection.QueryAsync<Campuses>("Select * FROM Campuses WHERE City ='" + part + "'"); // Show users UserList.ItemsSource = users; }
public static async Task<OCSettings> getSettings() { String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite"; SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path); var count = await conn.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCSettings'"); if (count > 0) { String Query = "SELECT * from OCSettings LIMIT 1;"; List<OCSettings> settings = await conn.QueryAsync<OCSettings>(Query); return settings.First<OCSettings>(); } else { createSettingsTable(); return await getSettings(); } }
public async void losuj() { if (baza == "eFiszki") { baza = "AppData"; } var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite"; var db = new SQLiteAsyncConnection(path); PobierzDaneBazy = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase"); if (PobierzDaneBazy.Count == 0) { MessageDialog dialog = new MessageDialog("Error"); await dialog.ShowAsync(); this.Frame.Navigate(typeof(gamesszubienica1)); } else { Random rnd = new Random(); indeks = rnd.Next(PobierzDaneBazy.Count); slowkoen = PobierzDaneBazy[indeks].SlowkoEn; tablica_zamknieta = slowkoen.ToCharArray(); foreach (char element in tablica_zamknieta) { if (element.ToString() == " ") { slowko_zamkniete = slowko_zamkniete + " " + " "; } else { slowko_zamkniete = slowko_zamkniete + "_" + " "; } } foreach (char element in tablica_zamknieta) { slowko_otwarte = slowko_otwarte + element + " "; } wylosowaneslowko.Text = slowko_zamkniete; } }
private async void loginbtn_Click(object sender, RoutedEventArgs e) { (App.Current as App).NavigateText = unametxt.Text; var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB"; var con = new SQLiteAsyncConnection(path); person p1 = new person(); List<person> allpersons = new List<person>(); allpersons = await con.QueryAsync<person>("select name,password from person where name=" + "\'" + unametxt.Text + "\'" + "and password="******"\'" + pwdtxt.Password + "\'"); if (allpersons.Count == 1) { p1 = allpersons[0]; Frame.Navigate(typeof(MainPage)); } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { // Show users aps = e.Parameter as string; SQLiteAsyncConnection connection = new SQLiteAsyncConnection("institutionFinder.db"); var users = await connection.QueryAsync<Courses>("Select courses FROM Courses where Id = " + 21 + ""); // Get users course = users.SingleOrDefault(); qCourses.Text = "You Qualify for " + course.courses; }
async protected override void OnNavigatedTo(NavigationEventArgs e) { activeCharacter = e.Parameter as Character; // load all transaction items var sqlite = new SQLiteAsyncConnection(activeCharacter.CharID + ".sqlite"); List<Transaction> items = await sqlite.QueryAsync<Transaction>("SELECT * FROM 'Transaction' GROUP BY TypeID ORDER BY TypeName"); this.Itemlist.ItemsSource = items; this.Categories.AddItems(items); this.Categories.ItemSelect += this.LoadData; SolidColorBrush line_sales = new SolidColorBrush(Color.FromArgb(255, 116, 195, 101)); Style point_sales = new Style(); point_sales.TargetType = typeof(DataPoint); point_sales.Setters.Add(new Setter(BackgroundProperty, line_sales)); (LineChart.Series[0] as LineSeries).Background = line_sales; (LineChart.Series[0] as LineSeries).DataPointStyle = point_sales; SolidColorBrush line_salesAvg = new SolidColorBrush(Color.FromArgb(255, 34, 139, 34)); Style point_salesAvg = new Style(); point_salesAvg.TargetType = typeof(DataPoint); point_salesAvg.Setters.Add(new Setter(BackgroundProperty, line_salesAvg)); point_salesAvg.Setters.Add(new Setter(WidthProperty, 0)); point_salesAvg.Setters.Add(new Setter(HeightProperty, 0)); (LineChart.Series[1] as LineSeries).Background = line_salesAvg; (LineChart.Series[1] as LineSeries).DataPointStyle = point_salesAvg; SolidColorBrush line_buys = new SolidColorBrush(Color.FromArgb(255, 196, 2, 51)); Style point_buys = new Style(); point_buys.TargetType = typeof(DataPoint); point_buys.Setters.Add(new Setter(BackgroundProperty, line_buys)); (LineChart.Series[2] as LineSeries).Background = line_buys; (LineChart.Series[2] as LineSeries).DataPointStyle = point_buys; SolidColorBrush line_buysAvg = new SolidColorBrush(Color.FromArgb(255, 237, 28, 36)); Style point_buysAvg = new Style(); point_buysAvg.TargetType = typeof(DataPoint); point_buysAvg.Setters.Add(new Setter(BackgroundProperty, line_buysAvg)); point_buysAvg.Setters.Add(new Setter(WidthProperty, 0)); point_buysAvg.Setters.Add(new Setter(HeightProperty, 0)); (LineChart.Series[3] as LineSeries).Background = line_buysAvg; (LineChart.Series[3] as LineSeries).DataPointStyle = point_buysAvg; }
public async Task <bool> IsFavorite(string movieid) { try { await CreateTable(); var db = new SQLite.SQLiteAsyncConnection(_dbPath); List <Movie> results = await db.QueryAsync <Movie>("Select _id FROM Movie WHERE _id = " + movieid); Log.Debug("IsFavorite", "movieid '" + movieid + "' returned " + results.Count + "results"); return(results.Count > 0); } catch (SQLiteException ex) { Log.Debug("IsFavorite", "Exception " + ex.Message); return(false); } }
protected override async void OnNavigatedTo(NavigationEventArgs e) { this.navigationHelper.OnNavigatedTo(e); SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db"); var taikhoanItem = (taikhoan)e.Parameter; id = taikhoanItem.Id; var qGhiChep = conn.Table<ghichep>().Where(t => t.Tutaikhoan.Contains(taikhoanItem.Tentaikhoan)); ghicheps = await qGhiChep.ToListAsync(); ghichepListItems.ItemsSource = ghicheps; double sotienbandau = 0; var Sotienquery = await conn.QueryAsync<taikhoan>("SELECT sotienbandau from taikhoan where Id = " + id); foreach (var g in Sotienquery.ToList()) { sotienbandau = double.Parse(g.Sotienbandau); } tonggiatritaikhoan.Text = "Số dư: " + sotienbandau.ToString("#,##0")+ " đ"; }
protected override async void OnNavigatedTo(NavigationEventArgs e) { SQLiteAsyncConnection conn = new SQLiteAsyncConnection("moneybook.db"); var query = await conn.QueryAsync<taikhoan>("SELECT tentaikhoan from taikhoan"); List<string> n = new List<string>(); foreach (var g in query.ToList()) { n.Add(g.Tentaikhoan); } tutaikhoan.ItemsSource = n; var ghichepItem = (ghichep)e.Parameter; id = ghichepItem.Id; loai.SelectedItem = loai.Items.Cast<ComboBoxItem>().Where(cmbi => (string)cmbi.Tag == ghichepItem.Loai).First(); sotien.Text = ghichepItem.Sotien; mucdichchi.Text = ghichepItem.Mucdichchi; ngay.Date = DateTime.Parse(ghichepItem.Ngay); gio.Time = TimeSpan.Parse(ghichepItem.Gio); ghichu.Text = ghichepItem.Ghichu; tutaikhoan.SelectedValue = ghichepItem.Tutaikhoan; }
protected async override void OnNavigatedTo(NavigationEventArgs e) { RootObject r1 = new RootObject(); gv2.ItemsSource = results; tblock.Text = (App.Current as App).NavigateText; var path = ApplicationData.Current.LocalFolder.Path + "/myDb1.DB"; var con = new SQLiteAsyncConnection(path); List<Favourite> favs = await con.QueryAsync<Favourite>(string.Format("select id from Favourite where userName = '******' and placeName = '{1}'", tblock.Text, results[0].name)) as List<Favourite>; if (favs.Count > 0 && favs.First().id > 0) { aptb.IsChecked = true; } //con.CreateTableAsync<Favourite>(); }
private async void zacznij() { // StandardLearningStart.IsEnabled = false; gamesnextbutton.IsEnabled = true; gamespreviousbutton.IsEnabled = true; var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite"; var db = new SQLiteAsyncConnection(path); PobierzDaneBazy = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase"); if (PobierzDaneBazy.Count == 0) { MessageDialog dialog = new MessageDialog("Error"); await dialog.ShowAsync(); this.Frame.Navigate(typeof(GamesStandardLeaning1)); } else { gamespreviousbutton.IsEnabled = false; StandatdLearningslowkoPL.Text = PobierzDaneBazy[licznik].SlowkoPl; StandatdLearningslowkoEN.Text = PobierzDaneBazy[licznik].SlowkoEn; } }
private async void loginbtn_Click(object sender, RoutedEventArgs e) { if (unametxt.Text == "trilok" && pwdtxt.Password == "trilok") { (App.Current as App).NavigateText = unametxt.Text; Dashboard.isAdmin = true; this.Frame.Navigate(typeof(Dashboard)); Dashboard.userName = "******"; } else { var path = ApplicationData.Current.LocalFolder.Path + "/mydb.db"; var con = new SQLiteAsyncConnection(path); person p1 = new person(); Dashboard.isAdmin = false; List<person> allpersons = new List<person>(); allpersons = await con.QueryAsync<person>("select name,password from person where name=" + "\'" + unametxt.Text + "\'" + "and password="******"\'" + pwdtxt.Password + "\'"); if (allpersons.Count == 1) { (App.Current as App).NavigateText = unametxt.Text; p1 = allpersons[0]; //username = unametxt.Text; Frame.Navigate(typeof(Dashboard)); Dashboard.userName = p1.name; } else { var m = new MessageDialog("invalid login").ShowAsync(); } } }
private async void Button_Click_1(object sender, RoutedEventArgs e) { string baza = comboboxusunzbazy.SelectedValue.ToString(); string slowko = comboboxslowkodousuniecia.SelectedValue.ToString(); string[] tablica = slowko.Split(new[] {'.'}); if (baza.Equals("eFiszki")) { baza = "AppData"; } var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + baza + ".sqlite"; var db = new SQLiteAsyncConnection(path); var maxid = 0; List<UserDefaultDataBase> result = await db.QueryAsync<UserDefaultDataBase>("Select max(id) as Id From UserDefaultDataBase"); foreach (var item in result) { maxid = item.Id; } int indeksdousuniecia = Convert.ToInt32(tablica[0]); var all = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase"); var del = await db.FindAsync<UserDefaultDataBase>(u => u.Id == indeksdousuniecia); await db.DeleteAsync(del); //Debug.WriteLine("maksymalny indeks: " + maxid + ", indeks do usuniecia:" + indeksdousuniecia); //if (maxid != indeksdousuniecia) //{ // List<UserDefaultDataBase> updateid = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase Where Id = ?", new object[] { maxid }); // var update = updateid.First(); // update.Id += 100; // update.SlowkoEn = "toz to dziala"; // await db.UpdateAsync(update); // Debug.WriteLine("Update indeksu:" + maxid + " na " + indeksdousuniecia); // //foreach (var i in updateid) // //{ // // Debug.WriteLine(i.Id); // //} // //await db.QueryAsync<UserDefaultDataBase>("Update UserDefaultDataBase set id= ? where id=?", new object[] {maxid, indeksdousuniecia }); // //foreach (var i in updateid) // //{ // // var update = updateid.First(); // // update.Id = indeksdousuniecia; // // await db.UpdateAsync(update); // //} //} comboboxslowkodousuniecia.Items.Clear(); setcomboslowko(); }
public async void setcomboslowko() { comboboxslowkodousuniecia.IsEnabled = true; buttonusunslowko.IsEnabled = false; comboboxslowkodousuniecia.Items.Clear(); String Result = ""; string wybranabaza = comboboxusunzbazy.SelectedValue.ToString(); if (wybranabaza.Equals("eFiszki")) { wybranabaza = "AppData"; } var path = Windows.Storage.ApplicationData.Current.LocalFolder.Path + @"\" + wybranabaza + ".sqlite"; var db = new SQLiteAsyncConnection(path); List<UserDefaultDataBase> allUsers = await db.QueryAsync<UserDefaultDataBase>("Select * From UserDefaultDataBase"); var count = allUsers.Any() ? allUsers.Count : 0; foreach (var item in allUsers) { Result = item.Id + ". " + item.SlowkoPl + " - " + item.SlowkoEn; comboboxslowkodousuniecia.Items.Add(Result); } }
private async void generateHierarchy() { list.Clear(); PeerList.Clear(); SQLiteAsyncConnection connection = new SQLiteAsyncConnection("Test.db"); var result = await connection.QueryAsync<Employee>("WITH CTE AS( SELECT EName,Skill,Designation,ManagerId AS ManagerId FROM Employee WHERE BadgeId =\"" + BadgeId+ "\" UNION ALL SELECT E.EName,E.Skill,E.Designation, E.ManagerId FROM Employee E INNER JOIN CTE ON E.BadgeId = CTE.ManagerId) SELECT * FROM CTE"); var result2 = await connection.QueryAsync<Employee>("SELECT EName,Designation,Skill FROM Employee WHERE Manager =\"" + Manager + "\""); foreach (var person in result) { if (person.EName!=EName) { list.Add(person); //Some.Add(person); } } list= new ObservableCollection<Employee>(list.Reverse()); ListViewItem l = new ListViewItem(); foreach (var peer in result2) { if (peer.EName!=EName) { PeerList.Add(peer); } } }
public static async Task<ObservableCollection<OCDirection>> getFavourites() { //TODO Math. String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite"; SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path); var count = await conn.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCDirection'"); if (count > 0) { String Query = "SELECT Id, * from OCDirection;"; List<OCDirection> stops = await conn.QueryAsync<OCDirection>(Query); ObservableCollection<OCDirection> directionsCollection = new ObservableCollection<OCDirection>(stops); return directionsCollection; } else { createFavouritesTable(); return await getFavourites(); } }
public Task <List <Product> > GetProductsByCategoryIdAsync(int ID) { return(_database.QueryAsync <Product>( $"SELECT * FROM[Product] WHERE [CategoryID] = { ID}")); }
public static async Task<List<OCSchedule>> getScheduleForDayAndStop(String day, String stop, int route) { String path = ApplicationData.Current.LocalFolder.Path + "/OCTranspo.sqlite"; SQLiteAsyncConnection conn = new SQLiteAsyncConnection(path); var count = await conn.ExecuteScalarAsync<int>("SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='OCStop'"); if (count > 0) { int date = getTodaysDate(); String Query = "SELECT * from OCSchedule where start_date <= " + date + " AND end_date >= " + date + " AND stop_code = '" + stop + "' AND route_short_name='" + route + "' AND " + day.ToLower() + " = '1' ORDER BY arrival_time"; List<OCSchedule> schedule = await conn.QueryAsync<OCSchedule>(Query); return schedule; } else { OCTranspoStopsData.initDB(); return await getScheduleForDayAndStop(day, stop, route); } }
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(); } }
public async Task<ObservableCollection<MapLocationModel>> LoadLocations(Guid mapId) { SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString); _locations = new ObservableCollection<MapLocationModel>(await connection.QueryAsync<MapLocationModel>("SELECT * FROM MapLocations WHERE MapId = ?", mapId)); return _locations; }