private void UpdateTheList() { ObservableCollection <FootballPlayerViewModel> updatedlist = new ObservableCollection <FootballPlayerViewModel> (); using (SQLiteConnection connection = new SQLiteConnection(Path.Combine(App.folderPath, "FootballPlayerDB.db3"))) { var list = connection.Query <FootballPlayer> ("SELECT * FROM FootballPlayer ORDER BY ISFAVOURITE DESC,FIRSTNAME ASC"); foreach (var item in list) { var pvm = new FootballPlayerViewModel(); pvm.FirstName = item.FirstName; pvm.LastName = item.LastName; pvm.Date_of_Birth = item.Date_of_Birth; pvm.Country = item.Country; pvm.Description = item.Description; pvm.Isfavourite = item.Isfavourite; pvm.age = (DateTime.Now - DateTime.Parse(item.Date_of_Birth)).ToString(); updatedlist.Add(pvm); } } PlayerViewModelList = updatedlist; }
private void UpdateTheList() { ObservableCollection<FootballPlayerViewModel> updatedlist = new ObservableCollection<FootballPlayerViewModel> (); using (SQLiteConnection connection = new SQLiteConnection (Path.Combine (App.folderPath, "FootballPlayerDB.db3"))) { var list = connection.Query<FootballPlayer> ("SELECT * FROM FootballPlayer ORDER BY ISFAVOURITE DESC,FIRSTNAME ASC"); foreach (var item in list) { var pvm = new FootballPlayerViewModel (); pvm.FirstName = item.FirstName; pvm.LastName = item.LastName; pvm.Date_of_Birth = item.Date_of_Birth; pvm.Country = item.Country; pvm.Description = item.Description; pvm.Isfavourite = item.Isfavourite; pvm.age = (DateTime.Now - DateTime.Parse (item.Date_of_Birth)).ToString (); updatedlist.Add (pvm); } } PlayerViewModelList = updatedlist; }