public static int ActualizarAnimePorId(Animes animes) { int resultado = 0; using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { SqlCommand sqlCommand = new SqlCommand(null, sqlConnection); sqlCommand.CommandText = "Update Animes SET nombre_anime = @nombre_anime, categoria = @categoria, duracion = @duracion where id_anime = @id_anime"; sqlCommand.Parameters.AddWithValue("@nombre_anime", animes.nombre_anime); sqlCommand.Parameters.AddWithValue("@categoria", animes.categoria); sqlCommand.Parameters.AddWithValue("@duracion", animes.duracion); try { sqlConnection.Open(); resultado = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(resultado); }
public bool cadastrar(Animes anime) { var cadastrarAnime = new CadastrarAnime(_context); cadastrarAnime.cadastrar(anime); return(true); }
public static int AgregarAnimes(Animes animes) { int filasAfectadas = 0; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand sqlCommand = new SqlCommand(null, connection); sqlCommand.CommandText = "Insert into Animes (id_anime, nombre_anime, categoria, genero, duracion, capitulo, calidad) values (@id_anime, @nombre_anime, @categoria, @genero, @duracion, @capitulo, @calidad )"; sqlCommand.Parameters.AddWithValue("@id_anime", animes.id_anime); sqlCommand.Parameters.AddWithValue("@nombre_anime", animes.nombre_anime); sqlCommand.Parameters.AddWithValue("@categoria", animes.categoria); sqlCommand.Parameters.AddWithValue("@genero", animes.genero); sqlCommand.Parameters.AddWithValue("@duracion", animes.duracion); sqlCommand.Parameters.AddWithValue("@capitulo", animes.capitulo); sqlCommand.Parameters.AddWithValue("@calidad", animes.calidad); try { connection.Open(); filasAfectadas = sqlCommand.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(filasAfectadas); }
public ActionResult AssistindoAnime(int?id) // Faz o dropdown de temporadas { Usuario user = Session["usuarioLogado"] as Usuario; //Pega o usuário na Session Animes a = AnimeDAO.BuscarPorIDInclude(id); if (a != null) // Primeiro acesso nunca vai ser null { ViewBag.Temporada = new SelectList(a.Temporadas.ToList(), "IDTemporada", "Estacao"); //DropDown TempData["SaveInfo"] = a; //Salva as informações para quando alterar } else //Vai entrar aqui quando o cara mudar de temporada na view { a = TempData["SaveInfo"] as Animes; //Vai pegar o anime salvo ViewBag.Temporada = new SelectList(a.Temporadas.ToList().OrderByDescending(e => e.Estacao), "IDTemporada", "Estacao"); //Dropdown ViewBag.NameTemp = TempData["SaveChan"]; //Pega o valor salvo lá na EpisodiosTemporada } List <Episodio> eps = TempData["EpisodiosTemp"] as List <Episodio>; //Lista de episodios dql temp if (eps != null) //se os eps forem nulos, não crie viewbag { ViewBag.Episodios = new SelectList(eps.ToList(), "IDEpisodio", "NumEpisodio"); //Cria Viewbag dos eps } return(View(a)); //Retorna o anime }
static void Main(string[] args) { var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json"); var configuration = builder.Build(); var genres = new Genres(configuration); var types = new Types(configuration); var animes = new Animes(configuration); var animeGenres = new AnimeGenres(configuration); var animeStaging = new AnimeStaging(configuration); var stopWatch = new System.Diagnostics.Stopwatch(); stopWatch.Start(); try { var anime = animeStaging.Read(); animes.Save(anime); animeGenres.Save(anime); } catch (Exception e) { Console.WriteLine(e); } Console.WriteLine($"Run time: {stopWatch.ElapsedMilliseconds} ms"); }
public ActionResult AssistindoAnime(Animes a, int?Episodios) //Adiciona o "assistindo" para aquele usuário { Usuario user = Session["usuarioLogado"] as Usuario; //Pega o usuário na Session Temporada t = TempData["SaveTemp"] as Temporada; AssistindoAnime an = new AssistindoAnime(); a = AnimeDAO.BuscarPorIDInclude(a.IDAnime); an = AssistindoAnimeDAO.BuscarExANS(user, a); if (an != null) //Se não for nulo, ele já marcou como "estou assistindo", ou seja, apenas atualiza esse { an = AssistindoAnimeDAO.BuscarAnimeSendoAssistido(an); // Essa busca tem todos os includes an.TemporadaAtual = t; an.UltimoEP = EpisodioDAO.BuscarEPporID(Episodios); AssistindoAnimeDAO.AtualizarASN(an); } else { an = new AssistindoAnime(); an.Anime = a; an.Usuario = user; an.UltimoEP = EpisodioDAO.BuscarEPporID(Episodios); an.TemporadaAtual = t; AssistindoAnimeDAO.AdicionarAssistido(an); } return(RedirectToAction("AnimesAssistindo", "Biblioteca")); }
public ActionResult Index() { List <Animes> Animes = contextEF.Anime.ToList(); var vm = new ListeViewModels(); using (var context = new MangaEntities()) { var result1 = context.Anime.Where(f => f.Motif == "En Cours").OrderBy(x => x.Nom); foreach (var f in result1) { var dto = new Animes { Nom = f.Nom, Image = f.Image }; vm.ListAnimes.Add(dto); } } return(View(vm)); }
public ActionResult Search(string search) { List <Animes> Animes = contextEF.Anime.ToList(); var result1 = contextEF.Anime.Where(f => f.Nom.ToLower().Contains(search.ToLower())).OrderBy(x => x.Nom); var vm = new ListeViewModels(); using (var context = new MangaEntities()) { foreach (var f in result1) { var dto = new Animes { Nom = f.Nom, Image = f.Image, Genres = f.Genres, Synopsis = f.Synopsis }; vm.ListAnimes.Add(dto); } } return(View(vm)); }
public ShikimoriClient(ILogger logger, ClientSettings settings) { Client = new ApiClient(logger, settings); Achievements = new Achievements(Client); Animes = new Animes(Client); Bans = new Bans(Client); Calendars = new Calendars(Client); Characters = new Characters(Client); Clubs = new Clubs(Client); Comments = new Comments(Client); Constants = new Constants(Client); Dialogs = new Dialogs(Client); Favorites = new Favorites(Client); Forums = new Forums(Client); Friends = new Friends(Client); Genres = new Genres(Client); Mangas = new Mangas(Client); Messages = new Messages(Client); People = new People(Client); Publishers = new Publishers(Client); Ranobe = new Ranobe(Client); Stats = new Stats(Client); Studios = new Studios(Client); Styles = new Styles(Client); TopicIgnores = new TopicIgnores(Client); Topics = new Topics(Client); UserImages = new UserImages(Client); UserRates = new UserRates(Client); Users = new Users(Client); Videos = new Videos(Client); }
public ActionResult Index() { List <Animes> Animes = contextEF.Anime.ToList(); var result = contextEF.Anime.Where(f => f.Id < 3).OrderBy(x => x.Nom); var vm = new ListeViewModels(); using (var context = new MangaEntities()) { foreach (var f in result) { var dto = new Animes { Nom = f.Nom, Image = f.Image, Genres = f.Genres, Synopsis = f.Synopsis }; vm.ListAnimes.Add(dto); } } return(View(vm)); }
public ActionResult AdicionarAssistidos(int?id) //Adiciona o anime completo como "assistido" { Usuario user = Session["usuarioLogado"] as Usuario; Animes a = AnimeDAO.BuscarAnimesPorId(id); //Pega o anime inteiro a partir de sua ID if (user.AnimesAssistidos == null) //Isso aqui é só pra iniciar a lista, se não fizer isso vem excessão de nullpointer { user.AnimesAssistidos = new List <Assistidos>(); } Assistidos aux = new Assistidos { Anime = a // Recebe o anime e coloca ele como 'Assistido" }; List <AssistindoAnime> asn = AssistindoAnimeDAO.AnimesSendoAssistidos(user); foreach (AssistindoAnime item in asn) { if (item.Anime.NomeAnime.Equals(a.NomeAnime)) { AssistindoAnimeDAO.RemoverAnimeAsN(item); break; } } if (BibliotecaDAO.AdicionarAnimeBiblioteca(user, id, aux) == true) // Se retornar false, o anime já está cadastrado { return(RedirectToAction("Perfil", "Home")); // Redireciona para o perfil como "sucesso" } TempData["MsgErro"] = "O anime " + a.NomeAnime + " já está adicionado a 'Assistidos' !! "; return(RedirectToAction("BibliotecaAnimes", "Biblioteca"));//Retorna para a Biblioteca para ele adicionar outro }
public bool WatchingAndAiringContains(string name) { return(Animes .Where(a => a.Details.AiringNow || a.Details.Aired == AnimeSeason.Current || a.Details.Ended == AnimeSeason.Current) .Select(a => { var container = new List <double> { new StringDistance <Anime>(a, name, a.Name).Distance }; if (a.Details.TitleAndEnglish.Any()) { container.Add(a.Details .TitleAndEnglish .Select(s => new StringDistance <string>(s, name, s).Distance) .Min()); } if (a.Details.SynonymsSplit.Any()) { container.Add(a.Details .SynonymsSplit .Select(s => new StringDistance <string>(s, name, s).Distance) .Min()); } return container.Min(); }) .Any(ap => ap <= 1)); }
public ActionResult AdicionarAnime(int?Categorias, Animes a, HttpPostedFileBase AnimeImagem) { ViewBag.Categorias = new SelectList(CategoriaDAO.RetornarCategoria(), "IDCategoria", "DescCategoria"); if (AnimeDAO.BuscarPorNome(a) == null) { a.Categoria = CategoriaDAO.BuscarCategoriaPorID(Categorias); if (AnimeImagem == null) { a.Imagem = "SemImagem.jpeg"; } else { string c = System.IO.Path.Combine(Server.MapPath("~/Imagem/"), AnimeImagem.FileName); AnimeImagem.SaveAs(c); a.Imagem = AnimeImagem.FileName; } if (AnimeDAO.AdicionarAnime(a)) { TempData["AdtempAnime"] = "Cadastrado com sucesso"; return(RedirectToAction("Index", "Admin")); } return(View(a)); } ModelState.AddModelError("", "Esse anime já está cadastrado!"); return(View()); }
public ActionResult AlterarAnime(int?id) // Get Alterar Anime { ViewBag.Categorias = new SelectList(CategoriaDAO.RetornarCategoria(), "IDCategoria", "DescCategoria"); Animes a = AnimeDAO.BuscarPorID(id); return(View(AnimeDAO.BuscarPorNomeInclude(a))); }
static async Task Main(string[] args) { var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json"); var configuration = builder.Build(); System.Net.ServicePointManager.DefaultConnectionLimit = Int32.MaxValue; var genres = new Genres(configuration); var types = new Types(configuration); var animes = new Animes(configuration); var animeGenres = new AnimeGenres(configuration); var animeStaging = new AnimeStaging(configuration); var stopWatch = new System.Diagnostics.Stopwatch(); stopWatch.Start(); try { var saves = animeStaging.Read().Select(async(animeAsync) => { var anime = await animeAsync; await animes.Save(anime); await animeGenres.Save(anime.Id, anime.GenreIds); }); await Task.WhenAll(saves); } catch (Exception e) { Console.WriteLine(e); } Console.WriteLine($"Run time: {stopWatch.ElapsedMilliseconds} ms"); }
public IEnumerable <Animes> GetActionTraductor() { try { List <Animes> animesList = new List <Animes>(); using (MySqlConnection con = new MySqlConnection(connectionString)) { string sqlQuery = "SELECT * FROM animes where generos LIKE '%Action%'"; MySqlCommand cmd = new MySqlCommand(sqlQuery, con); con.Open(); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Animes anime = new Animes(); anime.titulo = rdr["titulo"].ToString(); anime.valoración = rdr["valoracion"].ToString(); anime.ranking = rdr["ranking"].ToString(); anime.generos = rdr["generos"].ToString(); anime.url = rdr["url"].ToString(); anime.image = rdr["image"].ToString(); anime.descripcion = rdr["descripcion"].ToString(); anime.edad = rdr["edad"].ToString(); animesList.Add(anime); } con.Close(); } return(animesList); } catch (Exception ex) { throw ex; } }
public ActionResult ButtonPressed(string magicButton) { List <Animes> Anime = contextEF.Anime.ToList(); var result = contextEF.Anime.Where(f => f.Nom.StartsWith(magicButton)).OrderBy(x => x.Nom); if (magicButton == "0") { result = contextEF.Anime.Where(f => f.Id < 3).OrderBy(x => x.Nom); } var vm = new ListeViewModels(); using (var context = new MangaEntities()) { foreach (var f in result) { var dto = new Animes { Nom = f.Nom, Image = f.Image, Genres = f.Genres, Synopsis = f.Synopsis }; vm.ListAnimes.Add(dto); } } return(View(vm)); }
private async Task OnResetFilter() { var checkeds = FilterData.Genres.Where(p => p.IsChecked); FilterData.SortDirections[0].IsChecked = true; FilterData.Orders[0].IsChecked = true; foreach (var item in checkeds) { item.IsChecked = false; } MessagingCenter.Send(this, "CloseFilterView"); switch (_catalogueMode) { case CatalogueModeEnum.Season: Loading = true; _animesWithSpecifiedFilters = null; Animes.ReplaceRange(_originalCollection); Loading = false; break; case CatalogueModeEnum.Global: ResetSearchConfig(_settingsPreferences.ShowNSFW, AnimeSearchSortable.Score, SortDirection.Descending); await ResetAndLoadGlobalAsync(); break; } }
public Anime ClosestAnime(string name) { return(Animes .Select(a => new StringDistance <Anime>(a, name, a.Name)) .Where(ap => ap.Distance <= 10) .OrderBy(ap => ap.Distance) .FirstOrDefault()?.Item); }
public static Animes BuscarPorNomeInclude(Animes a)//Busca q inclui todos os includes { return(ctx.Animes. Include("Temporadas"). Include("Temporadas.Episodios"). Include("Categoria"). SingleOrDefault(x => x.NomeAnime.Equals(a.NomeAnime))); }
public ActionResult DeleteConfirmed(int id) { Animes animes = db.Animes.Find(id); db.Animes.Remove(animes); db.SaveChanges(); return(RedirectToAction("Index")); }
private async Task <bool> LoadGlobalCatalogueAsync() { await App.DelayRequest(4); try { AnimeSearchResult anime = null; if (string.IsNullOrWhiteSpace(SearchQuery)) { anime = await App.Jikan.SearchAnime(_animeSearchConfig, _pageCount ++); } else if (SearchQuery?.Length > 0) { ResetSearchConfig(_settingsPreferences.ShowNSFW, AnimeSearchSortable.Title, SortDirection.Descending); anime = await App.Jikan.SearchAnime(SearchQuery, _pageCount ++, _animeSearchConfig); } Console.WriteLine($"Page count {_pageCount}"); if (anime?.Results != null) { anime.RequestCached = true; IList <FavoritedAnime> animes = await anime.Results.ConvertAnimeSearchEntryToAnimeSubEntry() .ConvertCatalogueAnimesToFavoritedAsync(_settingsPreferences.ShowNSFW); var toAddAnimes = new List <FavoritedAnime>(); var equalityComparer = new FavoriteAnimeEqualityComparer(); foreach (var item in animes) { if (!Animes.Contains(item, equalityComparer)) { toAddAnimes.Add(item); } } _originalCollection.AddRange(toAddAnimes); Animes.AddRange(toAddAnimes); return(false); } } catch (JikanRequestException ex) { ex.SaveExceptionData(); } catch (OperationCanceledException ex) { } catch (Exception ex) { ex.SaveExceptionData(); } return(true); }
private void RemoveAnime(AnimeModel animeToRemove) { // Removes the selection from the SQLite database SQLiteDataAccess.DeleteAnime(animeToRemove); // Removes the selection from the bindable collection Animes.Remove(animeToRemove); NotifyOfPropertyChange(() => TotalAnimes); }
public void Remove(string name) { var anime = Animes.First(a => a.Name.ToLower().Equals(name.ToLower())); if (anime != null) { Remove(anime); } }
public async Task LoadAsync(bool refresh = false) { if (IsBusy) { return; } IsBusy = true; if (IsMultiSeason) { FeaturedVideo = await _animeService.GetLatestEpisodeAsync(); var seasons = await _seasonService.ListAsync(new DataServices.ListRequest { Skip = refresh ? 0 : Seasons.Count }); Seasons.Clear(); Seasons.AddRange(seasons); foreach (var season in Seasons) { var episodes = await _animeService.ListEpisodeBySeasonAsync(new ListEpisodeBySeasonRequest { SeasonId = season.Id, Take = 5 }); season.Episodes.AddRange(episodes); } } else { List <Anime> animes = null; if (DataSource.ToLower() == "tvspecials") { FeaturedVideo = await _animeService.GetLatestTvSpecialAsync(); animes = await _animeService.ListTvSpecialsAsync(new DataServices.ListRequest { Skip = refresh ? 0 : Animes.Count }); } else if (DataSource.ToLower() == "movies") { FeaturedVideo = await _animeService.GetLatestMovieAsync(); animes = await _animeService.ListMoviesAsync(new DataServices.ListRequest { Skip = refresh ? 0 : Animes.Count }); } if (animes != null) { Animes.Clear(); Animes.AddRange(animes); } } IsBusy = false; }
public static bool AdicionarAnime(Animes Animes) { if (BuscarPorNome(Animes) == null) { ctx.Animes.Add(Animes); ctx.SaveChanges(); return(true); } return(false); }
public ActionResult Edit([Bind(Include = "ID,Title,Genre,Season,Episode")] Animes animes) { if (ModelState.IsValid) { db.Entry(animes).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(animes)); }
public ActionResult PesquisarAnime()// Get Pesquisar Anime { Animes a = TempData["PesqAnime"] as Animes; ViewBag.Msg = TempData["Msgs"]; if (a != null) { return(View(a)); } return(RedirectToAction("Admin", "Index")); }
public ActionResult Create([Bind(Include = "ID,Title,Genre,Season,Episode")] Animes animes) { if (ModelState.IsValid) { db.Animes.Add(animes); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(animes)); }
private async Task ResetAndLoadGlobalAsync() { _originalCollection.Clear(); Animes.Clear(); _pageCount = 1; ClearTextQuery(); RemainingAnimeCount = 0; Loading = true; await LoadGlobalCatalogueAsync(); Loading = false; }