public async Task AddSuggestion(string videoId, string songId, Guid modeId, Guid userId)
{
var video = await m_videoService.GetVideo(videoId);
if (video == null)
{
await m_videoService.PostVideo(new CreateVideoRequest { VideoId = videoId });
video = await m_videoService.GetVideo(videoId);
}
var song = await m_songService.Get(songId);
if (song == null)
{
await m_songService.Post(new CreateSongRequest { SongId = songId });
song = await m_songService.Get(songId);
}
var suggestionRelation = await m_suggestionService.GetSuggestionRelation(new SuggestionRelationRequest { ModeId = modeId, SongId = song.SongId, UserId = userId });
if (suggestionRelation == null) // The user does not have this suggestion
{
suggestionRelation = await m_suggestionService.GetSuggestionRelation(new SuggestionRelationRequest { ModeId = modeId, SongId = song.SongId, UserId = PartifySystemUserId }); // Partify-System userId
if (suggestionRelation == null) // this is not suggested by the Partify-System user. (or anybody else)
{
// post to relation and userRelation for the User and Partify-System user
await m_suggestionService.PostSuggestion(new CreateSuggestionRequest { ModeId = modeId, Overruled = false, SpotifyId = song.Id, YoutubeId = video.Id });
var suggestion = await m_suggestionService.GetSuggestion(song.Id, video.Id, modeId);
await m_userSuggestionService.Post(new CreateUserSuggestionRequest { SuggestionId = suggestion.Id, UserId = userId });
await m_userSuggestionService.Post(new CreateUserSuggestionRequest { SuggestionId = suggestion.Id, UserId = PartifySystemUserId });
return;
}
// The suggestion is set by the Partify-System user and we only need to post it to the UserSuggestion table
var suggestionByPartifySystemUser = await m_suggestionService.GetSuggestion(song.Id, video.Id, modeId);
await m_userSuggestionService.Post(new CreateUserSuggestionRequest { SuggestionId = suggestionByPartifySystemUser.Id, UserId = userId });
return;
}
// the user have allready added a suggestion for him/herserlf, we should now change the prefered suggestion for that spesific user
await RemoveSuggestion(suggestionRelation.UserSuggestionId);
var existingSuggestion = await m_suggestionService.GetSuggestion(song.Id, video.Id, modeId);
if (existingSuggestion == null)
{
await m_suggestionService.PostSuggestion(new CreateSuggestionRequest { ModeId = modeId, Overruled = false, SpotifyId = song.Id, YoutubeId = video.Id });
existingSuggestion = await m_suggestionService.GetSuggestion(song.Id, video.Id, modeId);
}
await m_userSuggestionService.Post(new CreateUserSuggestionRequest { SuggestionId = existingSuggestion.Id, UserId = userId });
}