Ejemplo n.º 1
0
        public async Task AddSingleNews(FinWireData finwireData)
        {
            var finwireXmlNewsAdded = await _dbContext.FinwireXmlNews.AddAsync(new FinwireXmlNews
            {
                DateTime    = DateTime.Now,
                FileContent = finwireData.RoughXml,
                FileName    = finwireData.Guid,
            });

            if (!_dbContext.FinwireNews.Any(x => finwireData.Guid == x.Guid))
            {
                var newsEntity = finwireData.ToFinwireNews();
                newsEntity.FinautoPassed = _finwireFilterService.IsFilterPassed(finwireData);

                newsEntity.FinwireAgency =
                    _dbContext.FinwireAgencies.FirstOrDefault(x => x.Agency == finwireData.Agency)
                    ?? (await _dbContext.AddAsync(new FinwireAgency {
                    Agency = finwireData.Agency
                })).Entity;

                newsEntity.FinwireXmlNews = finwireXmlNewsAdded.Entity;

                var newsEntityAdded = (await _dbContext.AddAsync(newsEntity)).Entity;

                //todo make generic method in helper etc, find better solution using EF Core
                finwireData.SocialTags?.ForEach(async x =>
                                                await _dbContext.AddAsync(new FinwireNew2FirnwireSocialTag
                {
                    FinwireNew       = newsEntityAdded,
                    FinwireSocialTag = _dbContext.FinwireSocialTags.FirstOrDefault(y => y.Tag == x)
                                       ?? (await _dbContext.AddAsync(new FinwireSocialTag {
                        Tag = x
                    })).Entity
                })
                                                );

                finwireData.Companies?.ForEach(async x =>
                {
                    await _dbContext.AddAsync(new FinwireNew2FinwireCompany
                    {
                        FinwireNew     = newsEntityAdded,
                        FinwireCompany = _dbContext.FinwireCompanies.FirstOrDefault(y => y.Company == x)
                                         ?? (await _dbContext.AddAsync(new FinwireCompany {
                            Company = x, Slug = x.ToSlug()
                        })).Entity
                    });
                });
            }

            await _dbContext.SaveChangesAsync();
        }