public void addVideo(Common.VideoViewModel vvm) { IEnumerable <VideoViewModel> videos = db.Query <VideoViewModel>(String.Format("SELECT * FROM VideoViewModel WHERE Name = '{0}' AND ID = {1}", vvm.Name, vvm.ID)); if (videos.Count() == 0) { db.Insert(vvm); } }
private void FavoriteButton_Clicked(object sender, EventArgs e) { ImageButton button = (ImageButton)sender; Common.VideoViewModel vvm = (Common.VideoViewModel)button.Source.BindingContext; vvm.Favorite = vvm.Favorite ^ true; if (vvm.Favorite) { button.Source = tool.LIKEURL; database.addVideo(vvm); } else { button.Source = tool.DISLIKEURL; database.removeVideo(vvm); } }
public void removeVideo(Common.VideoViewModel vvm) { db.Execute(String.Format("DELETE FROM VideoViewModel WHERE Name = '{0}' AND ID = {1}", vvm.Name, vvm.ID)); }