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;
}
