try { var db = new SQLite.Database("FavDB1.test"); // creates the database file in the local app folder if (db.Ready) { var stmt = db.PrepareStatement("CREATE TABLE IF NOT EXISTS Shows (ShowID INTEGER, Showname TEXT,showlink TEXT,image TEXT,classification TEXT,summary TEXT,network TEXT,airtime TEXT,airday TEXT)"); if (stmt.Execute()) { Expression.Blend.TvShowsData.TvShowsDataSource.TvShowsDataItem itm = Item as Expression.Blend.TvShowsData.TvShowsDataSource.TvShowsDataItem; Windows.UI.Xaml.Media.ImageSource image1 = itm.Image as Windows.UI.Xaml.Media.ImageSource; string imagePath = ((Windows.UI.Xaml.Media.Imaging.BitmapImage)(image1)).UriSource.ToString(); int showID = GetShowID(imagePath); stmt = db.PrepareStatement("DELETE FROM Shows WHERE ShowID= " + showID.ToString()); if (stmt.Execute()) { //var fav = (from favShow in App.FavouriteShows // where favShow.showid == showID // select favShow).FirstOrDefault(); //App.FavouriteShows.Remove(fav); App.FillFavShowsList(true); if (App.FavouriteShows.Count != 0) App.ShowFavShowsCollection(App.FavouriteShows); else App.ShowGroupedCollection(); } } } } catch (ArgumentException ex) { }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)