public async Task <int> SaveAsync(List <EquityApi.BalanceSheet.Response> responses)
        {
            foreach (var response in responses)
            {
                List <BalanceSheetEntity> entities = response.BalanceSheetEntityList;
                if (ValidateEntities(entities) != 0)
                {
                    GeneralInfo generalInfo = response.GeneralInfo;
                    _logger.LogInformation("IngestionTask ==> Symbol: {0}", generalInfo.Symbol);

                    IngestionTask ingestionTask = IngestionTask.Create(string.Format("Balance Sheet {0}", generalInfo.ExchangeId), string.Format("Symbol: {0}", generalInfo.Symbol));
                    _ingestionContext.IngestionTasks.Add(ingestionTask);

                    TGeneralInfo tGeneralInfo = _mapper.Map <TGeneralInfo>(generalInfo);
                    tGeneralInfo.Id = Guid.NewGuid();
                    tGeneralInfo.IngestionTaskId = ingestionTask.IngestionTaskId;
                    _ingestionContext.TGeneralInfo.Add(tGeneralInfo);

                    foreach (var entity in entities)
                    {
                        TBalanceSheet item = _mapper.Map <TBalanceSheet>(entity);
                        item.Id = Guid.NewGuid();
                        item.IngestionTaskId = ingestionTask.IngestionTaskId;
                        _ingestionContext.TBalanceSheets.Add(item);
                    }
                }
            }
            return(await _ingestionContext.SaveChangesAsync());
        }
Beispiel #2
0
        public async Task <IActionResult> CompanyFinancialsRequest(Guid id, string exchangeId)
        {
            Authentication authentication = new Authentication(_ingestionContext, _logger);
            TokenEntity    tokenEntity    = await authentication.GetAccessTokenByClientConfigId(id);

            if (tokenEntity != null)
            {
                string endPoint = _configuration.GetValue <string>("MorningStar:EquityApi:CompanyFinancialAvailabilityList");
                EquityApi.CompanyFinancials.Request request =
                    EquityApi.CompanyFinancials.Request.Create(tokenEntity.Token, exchangeId, "exchangeId", exchangeId);
                string requestUrl = endPoint.SetQueryParams(request);

                IngestionTask ingestionTask = IngestionTask.Create(endPoint, JsonConvert.SerializeObject(request));
                _ingestionContext.IngestionTasks.Add(ingestionTask);

                EquityApi.CompanyFinancials.Response response = await RestClient.GetDynamicResponseAsync <EquityApi.CompanyFinancials.Response>(requestUrl);

                PersistenceService persistence = new PersistenceService(_ingestionContext, _mapper, _logger);
                int result = await persistence.SaveAsync(ingestionTask.IngestionTaskId, response);

                if (result > 0)
                {
                    List <ChangeTable> changes = _ingestionContext.ChangeTables.FromSqlRaw("EXECUTE MergeCompanyFinancials @TaskId={0}", ingestionTask.IngestionTaskId).ToList();
                    _logger.LogInformation("MergeCompanyFinancials: {0}", JsonConvert.SerializeObject(changes));
                }
                return(Ok(result));
            }
            return(NotFound(id));
        }
        public async Task <int> SaveAsync(List <EquityApi.ProfitabilityRatios.Response> responses, bool isTTM = false)
        {
            foreach (var response in responses)
            {
                List <ProfitabilityEntity> entities = response.ProfitabilityEntityList;
                if (ValidateEntities(entities) != 0)
                {
                    GeneralInfo generalInfo = response.GeneralInfo;
                    _logger.LogInformation("IngestionTask ==> Symbol: {0}", generalInfo.Symbol);

                    IngestionTask ingestionTask = IngestionTask.Create(string.Format("ProfitabilityRatios {0}", generalInfo.ExchangeId), string.Format("Symbol: {0}", generalInfo.Symbol));
                    _ingestionContext.IngestionTasks.Add(ingestionTask);

                    TGeneralInfo tGeneralInfo = _mapper.Map <TGeneralInfo>(generalInfo);
                    tGeneralInfo.Id = Guid.NewGuid();
                    tGeneralInfo.IngestionTaskId = ingestionTask.IngestionTaskId;
                    _ingestionContext.TGeneralInfo.Add(tGeneralInfo);

                    foreach (var entity in entities)
                    {
                        if (isTTM)
                        {
                            TProfitabilityRatioTTM item = _mapper.Map <TProfitabilityRatioTTM>(entity);
                            item.Id = Guid.NewGuid();
                            item.IngestionTaskId = ingestionTask.IngestionTaskId;
                            _ingestionContext.TProfitabilityRatioTTMs.Add(item);
                        }
                        else
                        {
                            TProfitabilityRatio item = _mapper.Map <TProfitabilityRatio>(entity);
                            item.Id = Guid.NewGuid();
                            item.IngestionTaskId = ingestionTask.IngestionTaskId;
                            _ingestionContext.TProfitabilityRatios.Add(item);
                        }
                    }
                }
            }
            return(await _ingestionContext.SaveChangesAsync());
        }