public SeriesResult <UserShowWatch> UserShowWatchDelete(UserShowWatch record) { try { connection.Open(); cmd = CreateSqlCommandForSP("UserShowWatchDelete"); cmd.Parameters.AddWithValue("UserShowWatchID", record.ID); cmd.ExecuteNonQuery(); return(new SeriesResult <UserShowWatch> { Result = SQLResult.Success, Data = record }); } catch (Exception e) { ErrorMethods.LogError(e.Message); return(new SeriesResult <UserShowWatch> { Result = SQLResult.ErrorHasOccured, Message = e.Message }); } finally { connection.Close(); } }
public SeriesResult <UserShowWatch> UserShowWatchAdd(UserShowWatch record) { try { connection.Open(); cmd = CreateSqlCommandForSP("UserShowWatchAdd"); cmd.Parameters.AddWithValue("UserShowID", record.UserShowID); cmd.Parameters.AddWithValue("SeasonNo", record.SeasonNo); cmd.Parameters.AddWithValue("EpisodeNo", record.EpisodeNo); cmd.Parameters.Add("ID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); record.ID = int.Parse(cmd.Parameters["ID"].Value.ToString()); return(new SeriesResult <UserShowWatch> { Result = SQLResult.Success, Data = record }); } catch (Exception e) { ErrorMethods.LogError(e.Message); return(new SeriesResult <UserShowWatch> { Result = SQLResult.ErrorHasOccured, Message = e.Message }); } finally { connection.Close(); } }
private async Task GetWatchedEpisodes() { SeriesResult <UserShowWatch> result = await AppGlobal.Db.UserShowWatchListAsync(MyViewModel.MyShow); MyViewModel.MyShow.EpisodesWatched = result.ListData; foreach (Episode episode in MyViewModel.MyShow.Episodes) { UserShowWatch watch = MyViewModel.MyShow.EpisodesWatched.SingleOrDefault(x => x.SeasonNo == episode.AiredSeason && x.EpisodeNo == episode.AiredEpisodeNumber); if (watch != null) { episode.Watched = true; } } }
private async Task <bool> EpisodeWatchedToggle(int episodeNumber) { try { UserShowWatch record = MyViewModel.MyShow .EpisodesWatched .SingleOrDefault(x => x.SeasonNo == MyViewModel.ViewingSeason && x.EpisodeNo == episodeNumber); if (record == null) { UserShowWatch newRecord = new UserShowWatch { UserShowID = MyViewModel.MyShow.UserShowID, SeasonNo = MyViewModel.ViewingSeason, EpisodeNo = episodeNumber }; SeriesResult <UserShowWatch> result = await AppGlobal.Db.UserShowWatchAddAsync(newRecord); MyViewModel.MyShow.EpisodesWatched.Add(result.Data); } else { SeriesResult <UserShowWatch> result = await AppGlobal.Db.UserShowWatchDeleteAsync(record); MyViewModel.MyShow.EpisodesWatched.Remove(record); } return(true); } catch (Exception ex) { ErrorMethods.LogError(ex.Message); } return(false); }
public async Task <SeriesResult <UserShowWatch> > UserShowWatchDeleteAsync(UserShowWatch record) { return(await Task.Run(() => UserShowWatchDelete(record))); }