public async Task <IActionResult> TakeMovies() { // Log.Information("Hello from movies"); var movies = await _movieRepository.GetActuallMovies(); return(Json(movies)); }
public async Task <List <IconDto> > GetAllActuallYTAsync() { var stations = new List <string>() { "zet", "rmf", "eska", "rmfmaxx", "zloteprzeboje", "vox", "chillizet" }; var songs = await _radioSongsRepository.GetActualByRadioAsync(stations); var movies = await _tvMovieRepository.GetActuallMovies(); songs = songs.Count > 0 ? songs.OrderByDescending(x => x.countValue).Take(50).ToList() : songs; movies = movies.Count > 0 ? movies.OrderByDescending(x => x.countValue).Take(10).ToList() : movies; songs.AddRange(movies); return(songs); }
public async Task <AdminUpdatesDto> GetAdminUpdates() { var date12 = DateTime.Now.AddHours(-12); var actuallSongs = await _liveContext.Songs.Include(s => s.YouTube).Where(s => s.PlayAt >= date12).ToListAsync(); //var actuallSongs = await _liveContext.Songs.Include(x => x.YouTube).ToListAsync(); var songsCount = actuallSongs.Count; DateTime?lastUpdateSong = null; DateTime?lastPlayedSong = null; DateTime?songsFirstPlayed = null; var songsErrors = actuallSongs.Where(x => x.YouTube.VideoID.Contains("Error") || x.YouTube.VideoID == x.Name || x.YouTube.VideoID.Contains("!!ID!!")); var stations = songsErrors.Select(x => x.Station).ToHashSet(); string songErrorInfo = songsErrors.ToList().Count.ToString(); string songsHours = ""; string moviesHous = ""; foreach (var st in stations) { songErrorInfo += "." + st; } if (songsCount > 0) { var newestSong = actuallSongs.Where(x => x.Added.HasValue).Select(x => x.Added.Value).ToList(); var lastPlayed = actuallSongs.Select(x => x.PlayAt).ToList(); if (newestSong.Count > 0) { lastUpdateSong = newestSong.Max(); } if (lastPlayed.Count > 0) { lastPlayedSong = lastPlayed.Max(); songsFirstPlayed = lastPlayed.Min(); if (lastPlayedSong.HasValue && songsFirstPlayed.HasValue) { songsHours = Math.Round(((lastPlayedSong.Value - songsFirstPlayed.Value).TotalHours + 1), 2).ToString(); } } } /* var actuallTvMovies = await _liveContext.TVMovies.Include(x => x.YouTube) * .Where(x => x.PlayAt >= DateTime.Now.AddHours(-0.5)) * .ToListAsync(); */ var showingTvMovies = await _tvMovieRepository.GetActuallMovies(); var allFutureTvMovies = await _tvMovieRepository.GetAllFutureMovies(); //var actuallTvMovies = await _liveContext.TVMovies.Include(x => x.YouTube).ToListAsync(); var moviesCount = allFutureTvMovies.Count; DateTime?lastUpdateMovie = null; var moviesErrors = allFutureTvMovies.Where(x => x.id.Contains("Error")); var moviesRating = allFutureTvMovies.Where(x => x.countValue == 0).ToList().Count; string firsPlayedMovie = ""; string lastPlayedMovie = ""; if (moviesCount > 0) { var plays = allFutureTvMovies.Select(x => x.playAt); firsPlayedMovie = plays.Min().ToString("dd.MM.yyyy HH:mm"); lastPlayedMovie = plays.Max().ToString("dd.MM.yyyy HH:mm"); lastUpdateMovie = plays.Max(); moviesHous = Math.Round((plays.Max() - plays.Min()).TotalHours, 2).ToString(); } // var showingMovies = actuallTvMovies.Where(x => x.PlayAt <= DateTime.Now.AddHours(24)).ToList(); var showingMovies = showingTvMovies.ToList(); var showingMoviesCount = showingMovies.Count; var showingMoviesCountErrors = showingMovies.Where(x => x.id.Contains("Error")).ToList().Count; var showingMoviesRating = showingMovies.Where(x => x.countValue == 0).ToList().Count; var actuallBooks = await _liveContext.Bestsellers.ToListAsync(); var Bonito = actuallBooks.Where(x => x.Store == "Bonito").ToList().Count; var Aros = actuallBooks.Where(x => x.Store == "Aros").ToList().Count; var Czytam = actuallBooks.Where(x => x.Store == "Czytam").ToList().Count; var Empik = actuallBooks.Where(x => x.Store == "Empik").ToList().Count; var Gandalf = actuallBooks.Where(x => x.Store == "Gandalf").ToList().Count; var Livro = actuallBooks.Where(x => x.Store == "Livro").ToList().Count; var Profit24 = actuallBooks.Where(x => x.Store == "Profit24").ToList().Count; var bestsellersErrors = actuallBooks.Where(x => x.Title.Contains('�') || x.Author.Contains('�')).ToList().Count; var booksCount = actuallBooks.Count; DateTime?lastUpdateBook = null; if (booksCount > 0) { var newest = actuallBooks.Where(x => x.Added.HasValue).OrderByDescending(x => x.Added.Value).FirstOrDefault(); lastUpdateBook = newest.Added; } var udpateInfo = new AdminUpdatesDto(); udpateInfo.SongsLastPlayed = lastPlayedSong.HasValue? lastPlayedSong.Value.ToString("dd.MM.yyyy HH:mm") : ""; udpateInfo.songsFirstPlayed = songsFirstPlayed.HasValue? songsFirstPlayed.Value.ToString("dd.MM.yyyy HH:mm") : ""; udpateInfo.SongsCount = songsCount; udpateInfo.SongsUpdate = lastUpdateSong.HasValue? lastUpdateSong.Value.ToString("dd.MM.yyyy HH:mm") : ""; udpateInfo.TvMoviesCount = moviesCount; udpateInfo.TvMoviesUpdate = lastUpdateMovie.HasValue? lastUpdateMovie.Value.ToString("dd.MM.yyyy HH:mm") : ""; udpateInfo.BestsellersCount = booksCount; udpateInfo.BestsellersUpdate = lastUpdateBook.HasValue? lastUpdateBook.Value.ToString("dd.MM.yyyy HH:mm") : ""; udpateInfo.songsErrors = songErrorInfo; udpateInfo.moviesErrors = moviesErrors.ToList().Count; udpateInfo.showingMoviesCount = showingMoviesCount; udpateInfo.showingMoviesCountErrors = showingMoviesCountErrors; udpateInfo.moviesFirstPlayed = firsPlayedMovie; udpateInfo.moviesLastPlayed = lastPlayedMovie; udpateInfo.songsHours = songsHours; udpateInfo.moviesHours = moviesHous; udpateInfo.moviesRuning = InfoCaches.duringMovieUpdate? "Yes" : "No"; udpateInfo.songsRuning = InfoCaches.duringSongsUpdate? "Yes" : "No"; udpateInfo.booksRuning = InfoCaches._booksUpdatingRunning? "Yes" : "No"; udpateInfo.Bonito = Bonito.ToString(); udpateInfo.Aros = Aros.ToString(); udpateInfo.Czytam = Czytam.ToString(); udpateInfo.Empik = Empik.ToString(); udpateInfo.Gandalf = Gandalf.ToString(); udpateInfo.Livro = Livro.ToString(); udpateInfo.Profit24 = Profit24.ToString(); udpateInfo.mRating = moviesRating.ToString(); udpateInfo.shRating = showingMoviesRating.ToString(); udpateInfo.bestsellersErrors = bestsellersErrors.ToString(); return(udpateInfo); }