public async Task <int> AddVideoAsync(VideoAddModel video) { string query = $@"INSERT INTO Video (Title,Thumbnail, Highlight, WebmId, Mp4Id, GameId) OUTPUT INSERTED.VideoId VALUES (@Title,@Thumbnail, @Highlight, @WebmId, @Mp4Id, @GameId)"; return(await SaveDataAsync(query, video)); }
public async Task AddVideoAsync(VideoAddModel video) { var validator = DataValidatorHelper.Validate(video); if (validator.IsValid) { var videoDB = await _gamedbAccess.GetVideoByTitleAsync(video.Title, video.GameId); if (videoDB == null) { if (video.MP4 != null) { video.MP4Id = await _gamedbAccess.AddVideoContentAsync(video.MP4); } if (video.Webm != null) { video.WebmId = await _gamedbAccess.AddVideoContentAsync(video.Webm); } await _gamedbAccess.AddVideoAsync(video); } } else { Console.WriteLine($"Invalid Data from {nameof(VideoAddModel)}"); validator.Errors.ForEach(e => Console.WriteLine(e)); throw new Exception("Some data are invalid"); } }
private async void AddVideos(List <Movie> movies, int gameId, string title) { if (movies != null) { foreach (var video in movies) { var videoToAdd = new VideoAddModel() { GameId = gameId, Title = string.IsNullOrEmpty(video.Name)? title : video.Name, Thumbnail = video.Thumbnail }; if (video.MP4 != null) { videoToAdd.MP4 = new VideoContentAddModel { Max = video.MP4.Max, Quality = video.MP4.Quality, MediaType = "mp4" } } ; if (video.Webm != null) { videoToAdd.Webm = new VideoContentAddModel { Max = video.Webm.Max, Quality = video.Webm.Quality, MediaType = "webm" } } ; await _gameManager.AddVideoAsync(videoToAdd); } } }