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);
}
}
}
