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