public async Task <int> AddDLC(DLCAddModel dLC) { var validator = DataValidatorHelper.Validate(dLC); if (validator.IsValid) { var dlcDb = await _gamedbAccess.GetDLCBySteamAppIdAsync(dLC.SteamAppId); if (dlcDb == null) { var dlcTitle = await _gamedbAccess.GetDLCTitleBySteamAppId(dLC.SteamAppId); if (dlcTitle != null) { dLC.Title = dlcTitle; } return(await _gamedbAccess.AddDLCAsync(dLC)); } return(dlcDb.DLCId); } Console.WriteLine($"Invalid Data from {nameof(DLCAddModel)}"); validator.Errors.ForEach(e => Console.WriteLine(e)); throw new Exception("Some data are invalid"); }
public async Task <int> AddDLCAsync(DLCAddModel dLC) { string query = $@"INSERT INTO DLC (SteamAppId, Title) OUTPUT INSERTED.DLCId VALUES (@SteamAppId, @Title)"; return(await SaveDataAsync(query, dLC)); }