public ActionResult Index(int?page, string searchString)
{
IndexViewModel invm = new IndexViewModel();
List <ivm> indexview = new List <ivm>();
var TrackArtists = db.TrackLists.Select(x => x.Artist).Distinct().OrderBy(x => x).ToList();
if (!String.IsNullOrEmpty(searchString))
{
TrackArtists = db.TrackLists.Where(s => s.Artist.Contains(searchString) ||
s.Album.Contains(searchString) ||
s.Title.Contains(searchString) ||
s.Genre.Contains(searchString)).Select(x => x.Artist).Distinct().ToList();
}
var pageNumber = page ?? 1; // if no page was specified in the querystring, default to the first page (1)
var onePageOfProducts = TrackArtists.ToPagedList(pageNumber, 24); // will only contain 25 products max because of the pageSize
foreach (var item in onePageOfProducts)
{
var track = db.TrackLists.FirstOrDefault(x => x.Artist == item).Location;
track = @"\\51-DBA\radio\music\" + track.Substring(7);
TagLib.File file = TagLib.File.Create(track);
ivm tl = new ivm();
tl.artist = item;
if (file.Tag.Pictures.Length >= 1)
{
tl.Art = Convert.ToBase64String(file.Tag.Pictures[0].Data.Data);
}
invm.indexview.Add(tl);
}
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
invm.PlayList = invm.PlayList.ToList();
invm.indexview = invm.indexview.ToList();
invm.StreamPlayer = invm.StreamPlayer.ToList();
ViewBag.OnePageOfProducts = onePageOfProducts;
return(View(invm));
}
public ActionResult NullValues()
{
IndexViewModel invm = new IndexViewModel();
var nullValues = db.TrackLists.Where(x => x.Artist == null || x.Album == null || x.Title == null || x.TrackNumber == null || x.Genre == null);
foreach (var item in nullValues)
{
ivm t = new ivm();
t.artist = item.Artist;
t.album = item.Album;
t.title = item.Title;
t.tracknumber = item.TrackNumber;
t.genre = item.Genre;
t.ID = item.ID;
invm.indexview.Add(t);
}
invm.tracknumber = nullValues.Count();
return(View(invm));
}
public ActionResult Catalog(string artist, string shuffled)
{
//string[] files = Directory.GetFiles(@"//51-DBA\radio/Music/", "*.*", SearchOption.AllDirectories);
IndexViewModel invm = new IndexViewModel();
List <ivm> ivm = new List <ivm>();
List <player> steam = new List <player>();
if (artist == "random")
{
var TrackArtists = db.TrackLists.ToArray();
Shuffle(TrackArtists);
artist = TrackArtists.FirstOrDefault().Artist;
}
var albums = db.TrackLists.Where(x => x.Artist == artist).GroupBy(x => x.Album).ToList();
invm.artist = artist;
foreach (var item in albums)
{
ivm tl = new ivm();
tl.album = item.Key;
tl.artist = db.TrackLists.FirstOrDefault(x => x.Artist == artist).Artist;
tl.tracknumber = db.TrackLists.Where(x => x.Album == item.Key).Count();
var track = db.TrackLists.FirstOrDefault(x => x.Album == tl.album && x.Artist == artist).Location;
track = @"\\51-DBA\radio\music\" + track.Substring(7);
TagLib.File file = TagLib.File.Create(track);
if (file.Tag.Pictures.Length >= 1)
{
tl.Art = Convert.ToBase64String(file.Tag.Pictures[0].Data.Data);
}
invm.indexview.Add(tl);
}
if (db.TrackLists.Any(x => x.Title.Contains(artist)))
{
ivm tl = new ivm();
tl.artist = artist;
tl.album = "As Featured Artist";
var track = db.TrackLists.FirstOrDefault(x => x.Title.Contains(artist)).Location;
track = @"\\51-DBA\radio\music\" + track.Substring(7);
TagLib.File file = TagLib.File.Create(track);
if (file.Tag.Pictures.Length >= 1)
{
tl.Art = Convert.ToBase64String(file.Tag.Pictures[0].Data.Data);
}
invm.indexview.Add(tl);
}
var artists = db.TrackLists.Where(x => x.Artist == artist).OrderBy(x => x.Album).ToArray();
if (shuffled != null)
{
Shuffle(artists);
}
foreach (var item in artists)
{
player tl = new player();
tl.artist = item.Artist;
tl.album = item.Album;
tl.tracknumber = item.TrackNumber;
tl.title = item.Title;
tl.duration = item.Duration.Substring(0, item.Duration.Length - 8);
tl.genre = item.Genre;
tl.location = item.Location;
tl.ID = item.ID;
invm.StreamPlayer.Add(tl);
}
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
invm.PlayList = invm.PlayList.ToList();
invm.indexview = invm.indexview.ToList();
invm.StreamPlayer = invm.StreamPlayer.ToList();
return(View(invm));
}
public ActionResult History()
{
IndexViewModel invm = new IndexViewModel();
var SongList = db.PlayCounts.OrderByDescending(x => x.SongPlayCount).ToList();
var lastSevenDays = DateTime.Now.AddDays(-7);
var hours = 0;
var minutes = 0;
var seconds = 0;
var played = db.Histories.Where(x => x.IsComplete == 1).OrderBy(x => x.Timestamp);
var unplayed = db.SkippedSongs.OrderBy(x => x.Timestamp);
var CompleteAlbums = db.CompleteAlbumListens.Take(5);
var top5played = db.PlayedSongs.OrderByDescending(x => x.SongPlayCount).Take(5).ToList();
var genre = db.PlayedSongs.Where(x => x.Genre != null).GroupBy(x => x.Genre).OrderByDescending(x => x.Count()).Take(5);
foreach (var item in top5played)
{
ivm i = new ivm();
i.artist = item.Artist;
i.title = item.Title;
i.album = item.Album;
i.PlayCount = item.SongPlayCount;
invm.indexview.Add(i);
}
foreach (var item in genre)
{
topGenres gc = new topGenres();
gc.Genre = item.Key;
gc.PlayCount = item.Sum(x => x.SongPlayCount);
invm.Genres.Add(gc);
}
invm.Genres = invm.Genres.ToList();
foreach (var item in db.MostPlayedArtists.Take(5))
{
MostPlayed mp = new MostPlayed();
mp.Artist = item.Artist;
mp.Plays = item.Plays;
invm.mostplayed.Add(mp);
}
foreach (var item in SongList)
{
var song = db.TrackLists.FirstOrDefault(x => x.ID == item.TrackListID);
for (var i = 0; i < item.SongPlayCount; i++)
{
string[] duration = song.Duration.Split(':', '.');
hours = hours + Convert.ToInt32(duration[0]);
minutes = minutes + Convert.ToInt32(duration[1]);
seconds = seconds + Convert.ToInt32(duration[2]);
}
}
for (var i = seconds; i >= 60; i = i - 60)
{
seconds = seconds - 60;
minutes = minutes + 1;
}
for (var i = minutes; i >= 60; i = i - 60)
{
minutes = minutes - 60;
hours = hours + 1;
}
var timeframe = hours.ToString("00") + ":" + minutes.ToString("00") + ":" + seconds.ToString("00");
invm.duration = timeframe;
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
foreach (var item in SongList)
{
genrecharts gc = new genrecharts();
var songs = db.TrackLists.FirstOrDefault(x => x.ID == item.TrackListID);
var playcount = 0;
if (songs.Genre == null)
{
gc.Genre = "Other";
}
else
{
gc.Genre = songs.Genre;
}
for (var i = 0; i < item.SongPlayCount; i++)
{
playcount++;
}
gc.PlayCount = playcount;
invm.Charts.Add(gc);
}
foreach (var item in invm.Charts.GroupBy(x => x.Genre).Take(10))
{
genrechart gc = new genrechart();
gc.name = item.Key;
gc.y = item.Sum(x => x.PlayCount);
invm.Chart.Add(gc);
}
foreach (var item in played.Where(x => x.Timestamp >= lastSevenDays))
{
historychart hc = new historychart();
hc.Date = item.Timestamp.Value.ToShortDateString();
invm.PlayHistorys.Add(hc);
}
foreach (var item in invm.PlayHistorys.GroupBy(x => x.Date))
{
historycharts hc = new historycharts();
hc.Date = item.Key;
hc.Count = item.Count();
invm.PlayHistory.Add(hc);
}
foreach (var item in unplayed.Where(x => x.Timestamp >= lastSevenDays))
{
unplayedchart hc = new unplayedchart();
hc.Date = item.Timestamp.Value.ToShortDateString();
invm.Unplayedhistories.Add(hc);
}
foreach (var item in invm.Unplayedhistories.GroupBy(x => x.Date))
{
unplayedcharts hc = new unplayedcharts();
hc.Date = item.Key;
hc.Count = item.Count();
invm.Unplayedhistory.Add(hc);
}
foreach (var item in CompleteAlbums)
{
FinishedAlbums fa = new FinishedAlbums();
fa.Artist = item.Artist;
fa.Album = item.Album;
fa.Plays = item.Plays;
invm.finishedalbums.Add(fa);
}
foreach (var item in db.LongestSongs.Take(5))
{
LongestSongPlayed lsp = new LongestSongPlayed();
lsp.Artist = item.Artist;
lsp.Album = item.Album;
lsp.Title = item.Title;
lsp.Duration = item.Duration.Remove(8);
invm.longestsongplayed.Add(lsp);
}
foreach (var item in db.MostUnfinishedSongs.Take(5))
{
MostSkipped ms = new MostSkipped();
ms.Artist = item.Artist;
ms.Title = item.Title;
ms.Skips = item.Skips;
ms.Album = item.Album;
invm.mostskipped.Add(ms);
}
foreach (var item in db.CompleteAlbumListensByArtists.Take(5))
{
AlbumsByArtist aba = new AlbumsByArtist();
aba.Artist = item.Artist;
aba.Plays = item.Plays;
invm.albumbyartist.Add(aba);
}
foreach (var item in db.CompleteAlbumListensByGenres.Take(5))
{
AlbumsByGenre abg = new AlbumsByGenre();
abg.Genre = item.Genre;
abg.Plays = item.Plays;
invm.albumbygenre.Add(abg);
}
var DoNotCount = db.TrackLists.Where(x => x.Location.Contains(".flac"));
invm.NumberOfSongs = db.TrackLists.Except(DoNotCount).Count();
invm.Chart = invm.Chart.ToList();
invm.PlayList = invm.PlayList.ToList();
invm.PlayHistory = invm.PlayHistory.ToList();
invm.Unplayedhistory = invm.Unplayedhistory.ToList();
invm.indexview = invm.indexview.ToList();
invm.finishedalbums = invm.finishedalbums.ToList();
return(View(invm));
}
public ActionResult Agg()
{
IndexViewModel invm = new IndexViewModel();
var SongList = db.PlayCounts.OrderByDescending(x => x.SongPlayCount).ToList();
var thismonth = DateTime.Now.Month;
var played = db.Histories.Where(x => x.IsComplete == 1 && x.Timestamp.Value.Month == thismonth);
if (SongList == null)
{
}
else
{
foreach (var item in SongList)
{
ivm indexview = new ivm();
var song = db.TrackLists.FirstOrDefault(x => x.ID == item.TrackListID);
indexview.artist = song.Artist;
indexview.album = song.Album;
indexview.genre = song.Genre;
indexview.title = song.Title;
indexview.PlayCount = item.SongPlayCount;
if (db.Histories.Any(x => x.TrackListID == item.TrackListID && x.IsComplete == 1))
{
indexview.LastPlayed = db.Histories.OrderByDescending(x => x.Timestamp).FirstOrDefault(x => x.TrackListID == item.TrackListID && x.IsComplete == 1).Timestamp.ToString();
}
else
{
indexview.LastPlayed = "Unknown";
}
invm.indexview.Add(indexview);
}
}
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
foreach (var item in SongList)
{
player tl = new player();
var songs = db.TrackLists.FirstOrDefault(x => x.ID == item.TrackListID);
tl.artist = songs.Artist;
tl.album = songs.Album;
tl.tracknumber = songs.TrackNumber;
tl.title = songs.Title;
tl.duration = songs.Duration.Substring(0, songs.Duration.Length - 8);
tl.genre = songs.Genre;
tl.location = songs.Location;
tl.ID = songs.ID;
invm.StreamPlayer.Add(tl);
}
invm.PlayList = invm.PlayList.ToList();
invm.StreamPlayer = invm.StreamPlayer.Take(25).ToList();
invm.indexview = invm.indexview.Take(25).ToList();
return(View(invm));
}
public ActionResult Album(string artist, string album, string shuffled)
{
IndexViewModel invm = new IndexViewModel();
List <ivm> ivm = new List <ivm>();
List <player> steam = new List <player>();
if (album == "random")
{
var TrackArtists = db.TrackLists.ToArray();
Shuffle(TrackArtists);
artist = TrackArtists.FirstOrDefault().Artist;
album = TrackArtists.FirstOrDefault().Album;
}
if (album == "As Featured Artist")
{
var songs = db.TrackLists.Where(x => x.Title.Contains(artist)).ToArray();
var track = db.TrackLists.FirstOrDefault(x => x.Title.Contains(artist)).Location;
track = @"\\51-DBA\radio\music\" + track.Substring(7);
TagLib.File file = TagLib.File.Create(track);
if (shuffled != null)
{
Shuffle(songs);
}
var hours = 0;
var minutes = 0;
var seconds = 0;
foreach (var item in songs)
{
string[] duration = item.Duration.Split(':', '.');
hours = hours + Convert.ToInt32(duration[0]);
minutes = minutes + Convert.ToInt32(duration[1]);
seconds = seconds + Convert.ToInt32(duration[2]);
}
for (var i = seconds; i >= 60; i = i - 60)
{
seconds = seconds - 60;
minutes = minutes + 1;
}
for (var i = minutes; i >= 60; i = i - 60)
{
minutes = minutes - 60;
hours = hours + 1;
}
var timeframe = hours.ToString("00") + ":" + minutes.ToString("00") + ":" + seconds.ToString("00");
invm.duration = timeframe;
invm.Playlist = songs.Count().ToString();
invm.artist = artist;
invm.album = album;
if (file.Tag.Pictures.Length >= 1)
{
invm.Art = Convert.ToBase64String(file.Tag.Pictures[0].Data.Data);
}
var trackNumber = 1;
foreach (var item in songs)
{
ivm tl = new ivm();
tl.artist = item.Artist;
tl.album = item.Album;
tl.tracknumber = trackNumber;
tl.title = item.Title;
tl.duration = item.Duration.Substring(0, item.Duration.Length - 8);
tl.genre = item.Genre;
tl.location = item.Location;
tl.ID = item.ID;
invm.indexview.Add(tl);
trackNumber++;
}
foreach (var item in songs)
{
player tl = new player();
tl.artist = item.Artist;
tl.album = item.Album;
tl.tracknumber = item.TrackNumber;
tl.title = item.Title;
tl.duration = item.Duration.Substring(0, item.Duration.Length - 8);
tl.genre = item.Genre;
tl.location = item.Location;
tl.ID = item.ID;
invm.StreamPlayer.Add(tl);
}
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
}
else
{
var songs = db.TrackLists.Where(x => x.Album == album && x.Artist == artist).OrderBy(x => x.TrackNumber).ToArray();
var track = db.TrackLists.FirstOrDefault(x => x.Album == album && x.Artist == artist).Location;
track = @"\\51-DBA\radio\music\" + track.Substring(7);
TagLib.File file = TagLib.File.Create(track);
if (shuffled != null)
{
Shuffle(songs);
}
var hours = 0;
var minutes = 0;
var seconds = 0;
foreach (var item in songs)
{
string[] duration = item.Duration.Split(':', '.');
hours = hours + Convert.ToInt32(duration[0]);
minutes = minutes + Convert.ToInt32(duration[1]);
seconds = seconds + Convert.ToInt32(duration[2]);
}
for (var i = seconds; i >= 60; i = i - 60)
{
seconds = seconds - 60;
minutes = minutes + 1;
}
for (var i = minutes; i >= 60; i = i - 60)
{
minutes = minutes - 60;
hours = hours + 1;
}
var timeframe = hours.ToString("00") + ":" + minutes.ToString("00") + ":" + seconds.ToString("00");
invm.duration = timeframe;
invm.Playlist = songs.Count().ToString();
invm.artist = artist;
invm.album = album;
if (file.Tag.Pictures.Length >= 1)
{
invm.Art = Convert.ToBase64String(file.Tag.Pictures[0].Data.Data);
}
foreach (var item in songs)
{
ivm tl = new ivm();
tl.artist = item.Artist;
tl.album = item.Album;
tl.tracknumber = item.TrackNumber;
tl.title = item.Title;
tl.duration = item.Duration.Substring(0, item.Duration.Length - 8);
tl.genre = item.Genre;
tl.location = item.Location;
tl.ID = item.ID;
invm.indexview.Add(tl);
}
foreach (var item in songs)
{
player tl = new player();
tl.artist = item.Artist;
tl.album = item.Album;
tl.tracknumber = item.TrackNumber;
tl.title = item.Title;
tl.duration = item.Duration.Substring(0, item.Duration.Length - 8);
tl.genre = item.Genre;
tl.location = item.Location;
tl.ID = item.ID;
invm.StreamPlayer.Add(tl);
}
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
}
invm.PlayList = invm.PlayList.ToList();
invm.indexview = invm.indexview.ToList();
invm.StreamPlayer = invm.StreamPlayer.ToList();
return(View(invm));
}
public ActionResult SubGenre(string genre, string genre2)
{
IndexViewModel invm = new IndexViewModel();
var sidebar = db.PlaylistNames.Select(x => x.PlaylistName1).Distinct().ToList();
List <string> songs = new List <string>();
foreach (var item in sidebar)
{
playlist pl = new playlist();
pl.Playlist = item;
invm.PlayList.Add(pl);
}
invm.PlayList = invm.PlayList.ToList();
if (genre == "metal")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("metal") || x.Genre.Contains("stoner rock") || x.Genre.Contains("doom") || x.Genre.Contains("visual kei") || x.Genre.Contains("nintendocore") || x.Genre.Contains("grindcore") || x.Genre.Contains("industrial")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "elec")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("elec")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "comedy")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("comedy")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "rock")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("rock")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "punk")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("punk") || x.Genre.Contains("hardcore")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "folk")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("folk")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "indie")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("indie")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "hip hop")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("hip hop") || x.Genre.Contains("rap") || x.Genre.Contains("hip-hop")).Select(x => x.Genre).Distinct().ToList();
}
else if (genre == "country")
{
songs = db.TrackLists.Where(x => x.Genre.Contains("country")).Select(x => x.Genre).Distinct().ToList();
}
else
{
songs = db.TrackLists.Where(x => !x.Genre.Contains("hardcore") && !x.Genre.Contains("grindcore") && !x.Genre.Contains("industrial") && !x.Genre.Contains("nintendocore") && !x.Genre.Contains("country") && !x.Genre.Contains("visual kei") && !x.Genre.Contains("hip-hop") && !x.Genre.Contains("doom") && !x.Genre.Contains("comedy") && !x.Genre.Contains("stoner rock") && !x.Genre.Contains("metal") && !x.Genre.Contains("elec") && !x.Genre.Contains("rock") && !x.Genre.Contains("punk") && !x.Genre.Contains("folk") && !x.Genre.Contains("indie") && !x.Genre.Contains("hip hop") && !x.Genre.Contains("rap")).Select(x => x.Genre).Distinct().ToList();
}
foreach (var item in songs)
{
ivm tl = new ivm();
player pl = new player();
tl.genre = item;
invm.indexview.Add(tl);
}
invm.indexview = invm.indexview.ToList();
return(View(invm));
}
