public async Task <int> AddSystemRequirementAsync(SystemRequirementAddModel systemRequirement) { string query = $@"INSERT INTO SystemRequirement (GameId, PlatformId, Minimum, Recommended) OUTPUT Inserted.SystemRequirementId VALUES(@GameId, @PlatformId, @Minimum, @Recommended)"; return(await SaveDataAsync(query, systemRequirement)); }
public async Task <int> AddSystemRequirement(SystemRequirementAddModel systemRequirement) { var validator = DataValidatorHelper.Validate(systemRequirement); if (validator.IsValid) { systemRequirement.PlatformId = await AddPlatform(systemRequirement.Platform); var srDb = await _gamedbAccess. GetSystemRequirementByGameIdAndPlatformIdAsync(systemRequirement.GameId, systemRequirement.PlatformId); if (srDb == null) { return(await _gamedbAccess.AddSystemRequirementAsync(systemRequirement)); } return(srDb.SystemRequirementId); } Console.WriteLine($"Invalid Data from {nameof(SystemRequirementAddModel)}"); validator.Errors.ForEach(e => Console.WriteLine(e)); throw new Exception("Some data are invalid"); }