public void RateAlbum(int albumId, int rating, int userId) { var album = this.context.Albums.FirstOrDefault(x => x.AlbumId == albumId); var user = this.context.Users.FirstOrDefault(x => x.UserId == userId); var ratedAlbum = new UserRatedAlbum() { User = user, UserId = userId, Album = album, AlbumId = album.AlbumId, Rating = rating }; foreach (var ratedInDb in this.context.UserRatedAlbums) { if (ratedInDb.AlbumId == ratedAlbum.AlbumId && ratedInDb.UserId == ratedAlbum.UserId) // exceptions!! { throw new Exception("You have already rated this album!"); } } album.TimesRated += 1; this.context.UserRatedAlbums.Add(ratedAlbum); this.context.SaveChanges(); //return user.Id ; }
public int RateAlbum(int albumId, int rating, int userId) { var album = this.context.Albums.FirstOrDefault(x => x.AlbumId == albumId); var user = this.context.Users.FirstOrDefault(x => x.UserId == userId); var ratedAlbum = new UserRatedAlbum() { User = user, UserId = userId, Album = album, AlbumId = album.AlbumId, Rating = rating }; foreach (var ratedInDb in this.context.UserRatedAlbums) { if (ratedInDb.AlbumId == ratedAlbum.AlbumId && ratedInDb.UserId == ratedAlbum.UserId) { return(0); } } album.TimesRated += 1; this.context.UserRatedAlbums.Add(ratedAlbum); this.context.SaveChanges(); return(user.UserId); }