public static RatingListModel getLatestRatings()
{
var ratingList = new RatingListModel();
using (var db = new shamethethronesContext())
{
var ratings = db.Ratings.Take(50).OrderByDescending(e => e.id).ToList();
foreach(var rating in ratings)
{
var ratingModel = new RatingModel(rating);
ratingList.add(ratingModel);
}
}
return ratingList;
}
public RestroomWithRatingModel getRestroomWithRating(int restroomId)
{
using (var db = new shamethethronesContext())
{
Restroom restroomModel = db.Restrooms.Single(x => x.id == restroomId);
var ratings = db.Ratings.Where(x => x.restroomId == restroomId).OrderByDescending(x => x.id).Take(50).ToList();
var restroom = new RestroomModel(restroomModel);
var ratingsListModel = new RatingListModel(ratings);
var restroomWithRating = new RestroomWithRatingModel();
restroomWithRating.restroomModel = restroom;
restroomWithRating.ratingModels = ratingsListModel;
return restroomWithRating;
}
}