Пример #1
0
 public IncomeController(IIncomeRepository repo, ILogger <IncomeController> logger, PIMS3Context ctx)
 {
     _repo   = repo;
     _logger = logger;
     _ctx    = ctx;
     _incomeProcessingBusLogicComponent = new IncomeProcessing(_ctx);
 }
Пример #2
0
 public InvestorSvc(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #3
0
 public CommonSvc(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #4
0
 public AssetData(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #5
0
 public PositionController(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #6
0
        public DataImportVm SaveRevenue(DataImportVm importVmToUpdate, PIMS3Context _ctx, string investorId)
        {
            //  Processing includes:
            //  1. persisting revenue,
            //  2. persisting revenue delinquencies, and
            //  3. updating Positions ("PymtDue") where applicable.

            ImportFileProcessing   busLayerComponent = new ImportFileProcessing(importVmToUpdate, _ctx, null);
            IEnumerable <Income>   revenueListingToSave;
            PositionDataProcessing positionDataAccessComponent = new PositionDataProcessing(_ctx);

            if (busLayerComponent.ValidateVm())
            {
                revenueListingToSave = busLayerComponent.ParseRevenueSpreadsheetForIncomeRecords(importVmToUpdate.ImportFilePath.Trim(), this, investorId);

                if (revenueListingToSave == null || revenueListingToSave.Count() == 0)
                {
                    if (!string.IsNullOrEmpty(importVmToUpdate.ExceptionTickers))
                    {
                        importVmToUpdate.MiscMessage = "Error saving revenue for " + importVmToUpdate.ExceptionTickers + ". Check position(s).";
                    }
                    else
                    {
                        importVmToUpdate.MiscMessage = BuildLogMessage("revenue");
                    }

                    return(importVmToUpdate);
                }
                else
                {
                    // Persist to 'Income'. Deferring use of using{}: ctx scope needed.
                    _ctx.AddRange(revenueListingToSave);
                    recordsSaved = _ctx.SaveChanges();
                }

                if (recordsSaved > 0)
                {
                    totalAmtSaved = 0M;
                    foreach (var record in revenueListingToSave)
                    {
                        totalAmtSaved += record.AmountRecvd;
                    }

                    // Returned values to UI.
                    importVmToUpdate.AmountSaved  = totalAmtSaved;
                    importVmToUpdate.RecordsSaved = recordsSaved;

                    // Update Positions.
                    positionDataAccessComponent.UpdatePositionPymtDueFlags(ExtractPositionIdsForPymtDueProcessing(revenueListingToSave), true);

                    /* === Month-end delinquent revenue processing === */

                    // If at month end/beginning, we'll query Positions for any now delinquent income receivables via "PymtDue" flag.
                    // Any unpaid income receivables, those not marked as received via 'Income due', will STILL have their 'PymtDue' flag set as
                    // True, and hence will now be considered a delinquent Position, resulting in persistence to 'DelinquentIncome' table.
                    // Delinquent position searches may ONLY be performed during month-end xLSX processing, as income receipts are still being
                    // accepted during the month via 'Income due'. During 'Income due' payments, flags are set accordingly: [PymtDue : True -> False].
                    // Any delinquent Positions will automatically be added to the 'Income due' collection that is broadcast via the UI schedule,
                    // for necessary action.
                    if (DateTime.Now.Day <= 3 && DateTime.Now.DayOfWeek.ToString() != "Saturday" && DateTime.Now.DayOfWeek.ToString() != "Sunday")
                    {
                        //PositionDataProcessing positionDataAccessComponent = new PositionDataProcessing(_ctx);
                        IQueryable <dynamic>     filteredPositionAssetJoinData = positionDataAccessComponent.GetCandidateDelinquentPositions(investorId);
                        IList <DelinquentIncome> pastDueListing = new List <DelinquentIncome>();
                        string delinquentMonth = DateTime.Now.AddMonths(-1).Month.ToString().Trim();
                        int    matchingPositionDelinquencyCount       = 0;
                        IList <DelinquentIncome> existingDelinqencies = positionDataAccessComponent.GetSavedDelinquentRecords(investorId, "");
                        int duplicateDelinquencyCount = 0;

                        foreach (dynamic joinData in filteredPositionAssetJoinData)
                        {
                            // 'DelinquentIncome' PKs: InvestorId, MonthDue, PositionId
                            // Do we have a match based on PositionId & InvestorId ? If so, Position is eligible for omitting setting 'PymtDue' to True.
                            matchingPositionDelinquencyCount = existingDelinqencies.Where(d => d.PositionId == joinData.PositionId &&
                                                                                          d.InvestorId == joinData.InvestorId).Count();

                            if (matchingPositionDelinquencyCount >= 1)
                            {
                                // Do we have a duplicate entry ?
                                duplicateDelinquencyCount = existingDelinqencies.Where(d => d.PositionId == joinData.PositionId &&
                                                                                       d.InvestorId == joinData.InvestorId &&
                                                                                       d.MonthDue == delinquentMonth).Count();
                            }

                            if (joinData.DividendFreq == "M")
                            {
                                if (matchingPositionDelinquencyCount > 0 && duplicateDelinquencyCount == 0)
                                {
                                    pastDueListing.Add(InitializeDelinquentIncome(joinData));
                                }
                                else
                                {
                                    continue;
                                }
                            }
                            else
                            {
                                string[] divMonths = joinData.DividendMonths.Split(',');
                                for (var i = 0; i < divMonths.Length; i++)
                                {
                                    if (divMonths[i].Trim() == delinquentMonth)
                                    {
                                        if (matchingPositionDelinquencyCount > 0 && duplicateDelinquencyCount == 0)
                                        {
                                            pastDueListing.Add(InitializeDelinquentIncome(joinData));
                                        }
                                        else
                                        {
                                            continue;
                                        }
                                    }
                                }
                            }
                            matchingPositionDelinquencyCount = 0;
                        }

                        // Persist to 'DelinquentIncome' as needed.
                        if (pastDueListing.Any())
                        {
                            bool pastDueSaved = positionDataAccessComponent.SaveDelinquencies(pastDueListing.ToList());
                            if (pastDueSaved)
                            {
                                importVmToUpdate.MiscMessage = "Found & stored " + pastDueListing.Count() + " Position(s) with delinquent revenue.";
                                Log.Information("Saved {0} delinquent position(s) to 'DelinquentIncome' via ImportFileDataProcessing.SaveRevenue()", pastDueListing.Count());
                            }
                        }

                        // Finally, update PymtDue flags on received XLSX positions.
                        positionDataAccessComponent.UpdatePositionPymtDueFlags(ExtractPositionIdsForPymtDueProcessing(revenueListingToSave), true);
                    }
                }
                _ctx.Dispose();
            }

            // Missing amount & record count reflects error condition.
            return(importVmToUpdate);
        }
Пример #7
0
 public ImportFileController(PIMS3Context dbCtx)
 {
     _dbCtx = dbCtx;
 }
Пример #8
0
 public InvestorDataProcessing(PIMS3Context ctx)
 {
     _ctx = ctx;
     //_logger = logger; // to be implemented
 }
Пример #9
0
 public ProfileDataProcessing(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #10
0
 public IncomeRepository(PIMS3Context ctx, ILogger <IncomeRepository> logger, ICommonSvc commonSvc)
 {
     _ctx       = ctx;
     _logger    = logger;
     _commonSvc = commonSvc;
 }
Пример #11
0
 public PositionDataProcessing(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #12
0
 public InvestorController(PIMS3Context context, InvestorSvc investorSvc, IOptions <AppSettings> appSettings)
 {
     _context     = context;
     _investorSvc = investorSvc;
     _appSettings = appSettings.Value;
 }
Пример #13
0
 public IncomeProcessing(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #14
0
 public AssetClassesController(PIMS3Context context)
 {
     _context = context;
 }
Пример #15
0
 public AccountDataProcessing(PIMS3Context ctx)
 {
     _ctx = ctx;
 }
Пример #16
0
 public ImportFileProcessing(DataImportVm viewModel, PIMS3Context ctx, InvestorSvc investorSvc)
 {
     _viewModel   = viewModel;
     _ctx         = ctx;
     _investorSvc = investorSvc;
 }
Пример #17
0
 public AccountTypesController(PIMS3Context context)
 {
     _context = context;
 }
Пример #18
0
 public ProfileController(PIMS3Context dbCtx)
 {
     _dbCtx = dbCtx;
 }
Пример #19
0
        public DataImportVm SaveAssets(DataImportVm importVmToSave, PIMS3Context _ctx, string id)
        {
            ImportFileProcessing busLogicComponent = new ImportFileProcessing(importVmToSave, _ctx, null);

            if (busLogicComponent.ValidateVm())
            {
                assetListingToSave = busLogicComponent.ParsePortfolioSpreadsheetForAssetRecords(importVmToSave.ImportFilePath.Trim(), this, id);

                if (assetListingToSave == null || assetListingToSave.Count() == 0)
                {
                    if (!string.IsNullOrEmpty(importVmToSave.ExceptionTickers))
                    {
                        importVmToSave.MiscMessage = "Error saving position(s) for " + importVmToSave.ExceptionTickers + ". Check position(s)";
                    }
                    else
                    {
                        importVmToSave.MiscMessage = BuildLogMessage("position(s)");
                    }

                    return(importVmToSave);
                }
                else
                {
                    List <Data.Entities.Profile>  profilesToSave  = new List <Data.Entities.Profile>();
                    List <Data.Entities.Asset>    assetsToSave    = new List <Data.Entities.Asset>();
                    List <Data.Entities.Position> positionsToSave = new List <Data.Entities.Position>();

                    for (int vmRecordIdx = 0; vmRecordIdx < assetListingToSave.Count(); vmRecordIdx++)
                    {
                        if (assetListingToSave.ElementAt(vmRecordIdx).Profile != null)
                        {
                            profilesToSave.Add(MapVmToEntities(assetListingToSave.ElementAt(vmRecordIdx).Profile) as Data.Entities.Profile);
                        }
                        else
                        {
                            profileDataAccessComponent = new ProfileDataProcessing(_ctx);
                        }

                        // "Asset" must first be initialized before referenced "Positions" can be added.
                        assetsToSave.Add(MapVmToEntities(assetListingToSave.ElementAt(vmRecordIdx)) as Data.Entities.Asset);

                        positionsToSave.Clear();
                        for (var position = 0; position < assetListingToSave.ElementAt(vmRecordIdx).Positions.Count(); position++)
                        {
                            positionsToSave.Add(MapVmToEntities(assetListingToSave.ElementAt(vmRecordIdx).Positions.ElementAt(position)) as Data.Entities.Position);
                            assetsToSave.ElementAt(vmRecordIdx).Positions.Add(positionsToSave.ElementAt(position));
                        }
                    }

                    // Persist to PIMS2Db.
                    try
                    {
                        // Omitting "using{}": DI handles disposing of ctx; *non-disposed ctx* needed for later
                        // call to profileDataAccessComponent.FetchDbProfileTicker().
                        if (profilesToSave.Count > 0)
                        {
                            _ctx.AddRange(profilesToSave);
                        }

                        _ctx.AddRange(assetsToSave);
                        recordsSaved = _ctx.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        Exception err = ex.InnerException;
                        Log.Error("Error persisting Profile(s)/Asset(s) to database within ImportFileDataProcessing.SaveAssets() due to {0}", err.Message);
                        return(null);
                    }
                }
            }

            return(HandleDbProcessingResults(importVmToSave, null, assetListingToSave));
        }