public ActionResult Index() { var Context = new ProjectDBEntities(); IndexDisplayViewModel model = new IndexDisplayViewModel(); if (User.Identity.IsAuthenticated) { var Tracks = from t in Context.Tracks join ts in Context.UserTrackShares on t.TrackID equals ts.TrackID where ts.SharingType.SharingTypeDetail == "Public" || ts.SharingType.SharingTypeDetail == "Users Only" select t; foreach (var item in Tracks) { var LikesCount = item.UserTrackShares.Select(x => x.UserTrackShareLikes.Count()).ToList(); item.LikesCount = LikesCount[0]; } model.Tracks = Tracks.ToList(); } else { var Tracks = from t in Context.Tracks join ts in Context.UserTrackShares on t.TrackID equals ts.TrackID where ts.SharingType.SharingTypeDetail == "Public" select t; foreach (var item in Tracks) { var LikesCount = item.UserTrackShares.Select(x => x.UserTrackShareLikes.Count()).ToList(); item.LikesCount = LikesCount[0]; } model.Tracks = Tracks.ToList(); } model.Albums = Context.Albums .Where(x => x.IsActive == true && x.Tracks.Count > 0 && x.AlbumTitle != "Default") .OrderByDescending(x => x.AlbumGeneres.Count) .ToList(); return(View(model)); }
public ActionResult Index() { var Context = new ProjectDBEntities(); IndexDisplayViewModel model = new IndexDisplayViewModel(); if (User.Identity.IsAuthenticated) { var Tracks = from t in Context.Tracks join ts in Context.UserTrackShares on t.TrackID equals ts.TrackID where ts.SharingType.SharingTypeDetail == "Public" || ts.SharingType.SharingTypeDetail == "Users Only" select t; foreach (var item in Tracks) { var LikesCount = item.UserTrackShares.Select(x => x.UserTrackShareLikes.Count()).ToList(); item.LikesCount = LikesCount[0]; } model.Tracks = Tracks.ToList(); } else { var Tracks = from t in Context.Tracks join ts in Context.UserTrackShares on t.TrackID equals ts.TrackID where ts.SharingType.SharingTypeDetail == "Public" select t; foreach (var item in Tracks) { var LikesCount = item.UserTrackShares.Select(x => x.UserTrackShareLikes.Count()).ToList(); item.LikesCount = LikesCount[0]; } model.Tracks = Tracks.ToList(); } model.Albums = Context.Albums .Where(x => x.IsActive == true && x.Tracks.Count > 0 && x.AlbumTitle != "Default") .OrderByDescending(x => x.AlbumGeneres.Count) .ToList(); return View(model); }