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;
}
