public IActionResult AllRated()
{
int?user_id = HttpContext.Session.GetInt32("id");
if (user_id == null)
{
return(RedirectToAction("Index"));
}
List <DisplayRating> displayRatings = new List <DisplayRating>();
List <Release> allReleases = _context.Releases.ToList();
List <Rating> myRatings = _context.Ratings.Where(r => r.user_id == user_id).OrderByDescending(r => r.id).ToList();
foreach (Rating r in myRatings)
{
Release thisRelease = allReleases.SingleOrDefault(x => x.id == r.release_id);
DisplayRating newDisplay = new DisplayRating()
{
title = thisRelease.title,
release_id_string = thisRelease.id_string,
artist = thisRelease.artist,
artist_id_string = thisRelease.artist_id_string,
rating = r.rating
};
displayRatings.Add(newDisplay);
}
return(View(displayRatings));
}
public List <DisplayRating> CreateList(int num, int user_id, string period)
{
List <DisplayRating> list = new List <DisplayRating>();
List <Rating> allRatings = _context.Ratings.Where(r => r.user_id == user_id).OrderByDescending(r => r.rating).ToList();
List <Release> releases = _context.Releases.ToList();
if (period != null)
{
allRatings = allRatings.Where(r => {
Release ratedRelease = releases.SingleOrDefault(re => re.id == r.release_id);
if (ratedRelease.date.Substring(0, 3) == period.Substring(0, 3))
{
return(true);
}
return(false);
}).ToList();
}
for (int i = 0; i < allRatings.Count && i < num; i++)
{
try
{
Release thisRelease = releases.Single(r => r.id == allRatings[i].release_id);
DisplayRating newDisplay = new DisplayRating()
{
title = thisRelease.title,
release_id_string = thisRelease.id_string,
artist = thisRelease.artist,
rating = allRatings[i].rating,
release_date = thisRelease.date,
image = thisRelease.image
};
list.Add(newDisplay);
}
catch {}
}
return(list);
}
public List <DisplayRating> RecentRatings()
{
int user_id = (int)HttpContext.Session.GetInt32("id");
List <Rating> mostRecent = _context.Ratings.Where(r => r.user_id != user_id).ToList();
List <DisplayRating> recentDisplay = new List <DisplayRating>();
for (int i = mostRecent.Count - 1; i >= 0 && i > mostRecent.Count - 6; i--)
{
Release thisRelease = _context.Releases.SingleOrDefault(r => r.id == mostRecent[i].release_id);
User thisRater = _context.Users.SingleOrDefault(u => u.id == mostRecent[i].user_id);
DisplayRating newDisplay = new DisplayRating()
{
title = thisRelease.title,
release_id_string = thisRelease.id_string,
artist = thisRelease.artist,
artist_id_string = thisRelease.artist_id_string,
rating = mostRecent[i].rating,
rater = thisRater.username,
image = thisRelease.image
};
recentDisplay.Add(newDisplay);
}
return(recentDisplay);
}
