public int DeleteShow(string id, int userId)
 {
     try
     {
         UserShow shw = db.UserShow.Where(x => x.ShowId == id && x.UserId == userId).FirstOrDefault();
         db.UserShow.Remove(shw);
         db.SaveChanges();
         return(1);
     }
     catch
     {
         throw;
     }
 }
 public int AddShow(Show show, int userId)
 {
     try
     {
         var showExist = db.UserShow.Any(x => x.ShowId == show.ShowId && x.UserId == userId);
         if (showExist)
         {
             return(3);
         }
         var userShow = new UserShow();
         userShow.UserId        = userId;
         userShow.ShowId        = show.ShowId;
         userShow.CreatedDate   = DateTime.UtcNow;
         userShow.CreatedBy     = userId;
         userShow.NextEpisodeId = show.NextEpisodeId;
         db.UserShow.Add(userShow);
         db.SaveChanges();
         return(1);
     }
     catch (Exception ex)
     {
         throw;
     }
 }