Esempio n. 1
0
        // GET: Episode
        public ActionResult Calendar()
        {
            var query = @"SELECT 
                e.[Id] AS [Id],s.[Name] AS [SeriesName], e.[Title] AS [Title], e.[Season] AS [Season], e.[EpisodeNumber] AS [EpisodeNumber], 
                e.[FileName] AS [FileName], e.[Summary] AS [Summary], e.[FirstAired] AS [FirstAired], DATENAME(dw,e.[FirstAired]) As [DayOfWeek], e.[DownloadStatus] AS [DownloadStatus], 
                e.[SeriesId] AS [SeriesId] FROM [dbo].[TvEpisodes] AS e	INNER JOIN [dbo].[TvSeries] s ON s.Id = e.SeriesId
                WHERE (DATEDIFF(day, SysDateTime(), e.[FirstAired])) BETWEEN 0 AND 6 AND N'WANT' = e.[DownloadStatus] ORDER BY e.[FirstAired] ASC";

            var thisWeeksEpisodes = _context.QuerySql <TvEpisode>(query).GroupBy(e => e.FirstAired).ToDictionary(e => e.Key, o => o.ToList());

            var model = new CalendarViewModel()
            {
                Episodes = thisWeeksEpisodes
            };

            return(View(model));
        }
Esempio n. 2
0
 public List <int> GetSeasons(int seriesId)
 {
     return(_context.QuerySql <int>($"select Distinct(Season) from TvEpisodes where seriesId = {seriesId} and Season > 0").ToList());
 }
Esempio n. 3
0
        public IEnumerable <Activity> GetRecentActivity()
        {
            var recentActivity = _context.QuerySql <Activity>("[dbo].[GetRecentActivity]");

            return(recentActivity);
        }