public IncomeController(IIncomeRepository repo, ILogger <IncomeController> logger, PIMS3Context ctx) { _repo = repo; _logger = logger; _ctx = ctx; _incomeProcessingBusLogicComponent = new IncomeProcessing(_ctx); }
public InvestorSvc(PIMS3Context ctx) { _ctx = ctx; }
public CommonSvc(PIMS3Context ctx) { _ctx = ctx; }
public AssetData(PIMS3Context ctx) { _ctx = ctx; }
public PositionController(PIMS3Context ctx) { _ctx = ctx; }
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); }
public ImportFileController(PIMS3Context dbCtx) { _dbCtx = dbCtx; }
public InvestorDataProcessing(PIMS3Context ctx) { _ctx = ctx; //_logger = logger; // to be implemented }
public ProfileDataProcessing(PIMS3Context ctx) { _ctx = ctx; }
public IncomeRepository(PIMS3Context ctx, ILogger <IncomeRepository> logger, ICommonSvc commonSvc) { _ctx = ctx; _logger = logger; _commonSvc = commonSvc; }
public PositionDataProcessing(PIMS3Context ctx) { _ctx = ctx; }
public InvestorController(PIMS3Context context, InvestorSvc investorSvc, IOptions <AppSettings> appSettings) { _context = context; _investorSvc = investorSvc; _appSettings = appSettings.Value; }
public IncomeProcessing(PIMS3Context ctx) { _ctx = ctx; }
public AssetClassesController(PIMS3Context context) { _context = context; }
public AccountDataProcessing(PIMS3Context ctx) { _ctx = ctx; }
public ImportFileProcessing(DataImportVm viewModel, PIMS3Context ctx, InvestorSvc investorSvc) { _viewModel = viewModel; _ctx = ctx; _investorSvc = investorSvc; }
public AccountTypesController(PIMS3Context context) { _context = context; }
public ProfileController(PIMS3Context dbCtx) { _dbCtx = dbCtx; }
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)); }