private void AnimeFunction(int animeId)
        {
            while (true)
            {
                var animeObject = PageScraper.GetAnimeInfo(animeId);
                if (DatabaseControl.AnimeExists(animeId, false))
                {
                    DatabaseControl.InsertGenre(animeId, animeObject.Genre);
                    DatabaseControl.InsertAnime(animeObject);
                    if (animeObject.SequelID != 0)
                    {
                        if (DatabaseControl.AnimeExists((int)animeObject.SequelID, false))
                        {
                            animeId = animeObject.SequelID.Value;
                            continue;
                        }
                        if (animeObject.PrequelID != 0)
                        {
                            if (DatabaseControl.AnimeExists((int)animeObject.PrequelID, false))
                            {
                                animeId = animeObject.PrequelID.Value;
                                continue;
                            }
                        }
                    }
                }
                else
                {
                    var oldAnime    = DatabaseControl.GetAnimeById(animeId);
                    var updateAnime = new UpdateAnime
                    {
                        Aired    = animeObject.Aired == oldAnime.Aired ? null : animeObject.Aired,
                        Episodes = animeObject.Episodes == oldAnime.Episodes ? null : animeObject.Episodes,
                        Status   = animeObject.Status == oldAnime.Status ? null : animeObject.Status,
                        Duration = animeObject.Duration == oldAnime.Duration ? null : animeObject.Duration,
                        Rating   = animeObject.Rating == oldAnime.Rating ? null : animeObject.Rating,
                        Prequel  = animeObject.Prequel == oldAnime.Prequel ? null : animeObject.Prequel,
                        Sequel   = animeObject.Sequel == oldAnime.Sequel ? null : animeObject.Sequel,
                        ID       = animeId
                    };

                    if (updateAnime.Status != null || updateAnime.Aired != null || updateAnime.Duration != null ||
                        updateAnime.Rating != null || updateAnime.Prequel != null || updateAnime.Sequel != null ||
                        updateAnime.Episodes != null)
                    {
                        txtResults.Text += "\nAnimeID: " + animeId + "\n";
                        UpdateTxtResults(oldAnime, updateAnime);
                        DatabaseControl.UpdateAnime(updateAnime);
                    }
                }
                break;
            }
        }
        private void RunAnime(IList <string> animeList)
        {
            var urlChecker = new UrlChecker();
            var AnimeList  = urlChecker.Check(animeList);

            foreach (var anime in AnimeList)
            {
                if (DatabaseControl.AnimeExists(anime.ID, false))
                {
                    DatabaseControl.InsertGenre(anime.ID, anime.Genre);
                    DatabaseControl.InsertAnime(anime);
                }
                else
                {
                    var oldAnime    = DatabaseControl.GetAnimeById(anime.ID);
                    var updateAnime = new UpdateAnime
                    {
                        Aired    = anime.Aired == oldAnime.Aired ? null : anime.Aired,
                        Episodes = anime.Episodes == oldAnime.Episodes ? null : anime.Episodes,
                        Status   = anime.Status == oldAnime.Status ? null : anime.Status,
                        Duration = anime.Duration == oldAnime.Duration ? null : anime.Duration,
                        Rating   = anime.Rating == oldAnime.Rating ? null : anime.Rating,
                        Prequel  = anime.Prequel == oldAnime.Prequel ? null : anime.Prequel,
                        Sequel   = anime.Sequel == oldAnime.Sequel ? null : anime.Sequel,
                        ID       = anime.ID
                    };
                    if (updateAnime.Status != null || updateAnime.Aired != null || updateAnime.Duration != null ||
                        updateAnime.Rating != null || updateAnime.Prequel != null || updateAnime.Sequel != null ||
                        updateAnime.Episodes != null)
                    {
                        txtResults.Text += "\nAnimeID: " + anime.ID + "\n";
                        UpdateTxtResults(oldAnime, updateAnime);
                        DatabaseControl.UpdateAnime(updateAnime);
                    }
                }
            }
        }
 public static void UpdateAnime(UpdateAnime anime) => Connection.Execute("UpdateAnime", anime, commandType: CommandType.StoredProcedure);