Example #1
0
        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));
        }
Example #2
0
        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");
        }