public List <string> GetAllFundSymbols()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Funds.AsNoTracking().Select(f => f.Symbol).ToList());
}
}
public List <TransactionTypeDIM> GetAllTransactionTypes()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.TransactionTypes.AsNoTracking().ToList());
}
}
public List <IssueTypesDIM> GetAllIssueTypes()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.IssueTypes.AsNoTracking().ToList());
}
}
public bool SecurityExists(string symbol, string assetClass)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Securities.Include(s => s.AssetClass).FirstOrDefault(s => s.Symbol == symbol && s.AssetClass.Name == assetClass) != null);
}
}
public List <Fund> GetAllFundsReference()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Funds.AsNoTracking().Where(f => f.IsInitialised).ToList());
}
}
public TransactionTypeDIM GetTransactionType(string typeName)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.TransactionTypes.AsNoTracking().Where(c => (c.TypeName) == typeName).FirstOrDefault());
}
}
public CustodiansDIM GetCustodian(string custodianName)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Custodians.AsNoTracking().Where(c => (c.Name) == custodianName).FirstOrDefault());
}
}
public List <SecurityPriceStore> GetAllSecurityPrices(DateTime asOfDate)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.SecurityPriceData.Where(s => s.Date <= asOfDate).ToList());
}
}
public AccountingPeriodsDIM GetPeriod(DateTime previousDate, int fundId)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Periods.AsNoTracking().Where(p => p.AccountingDate == previousDate && p.FundId == fundId).FirstOrDefault());
}
}
public bool SecurityExists(string symbol)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Securities.Where(s => s.Symbol == symbol).FirstOrDefault() != null);
}
}
public Dictionary <string, ApplicationSettings> GetAllSettings()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.AppSettings.ToDictionary(s => s.SettingName));
}
}
public Dictionary <string, int> SecurityMap()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Securities.AsNoTracking().ToDictionary(k => k.Symbol, v => v.SecurityId));
}
}
public Dictionary <string, int> AssetClassMap()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.AssetClasses.AsNoTracking().ToDictionary(k => k.Name, v => v.AssetClassId));
}
}
public bool FundExists(string fundSymbol)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Funds.FirstOrDefault(f => f.Symbol == fundSymbol) != null);
}
}
public AssetClassDIM GetAssetClass(string name)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.AssetClasses.AsNoTracking().Where(a => (a.Name) == name).FirstOrDefault());
}
}
public List <AccountingPeriodsDIM> GetAllFundPeriods(int fundId)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Periods.AsNoTracking().Where(p => p.FundId == fundId).OrderBy(p => p.AccountingDate).ToList());
}
}
public CurrenciesDIM GetCurrency(string symbol)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Currencies.AsNoTracking().Where(c => (c.Symbol) == symbol).FirstOrDefault());
}
}
public List <string> GetSecuritySymbolByAssetClass(string assetClass)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Securities.AsNoTracking().Where(s => s.AssetClass.Name == assetClass).OrderBy(s => s.Symbol).Select(s => s.Symbol).ToList());
}
}
public List <CustodiansDIM> GetAllCustodians()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Custodians.AsNoTracking().ToList());
}
}
public List <AssetClassDIM> GetAllAssetClasses()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.AssetClasses.AsNoTracking().ToList());
}
}
public SecuritiesDIM GetSecurityInfo(string symbol)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Securities.AsNoTracking().Where(s => s.Symbol == symbol).Include(s => s.Currency).Include(s => s.AssetClass).FirstOrDefault());
}
}
public List <NavFrequencyDIM> GetAllNavFrequencies()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.NavFrequencies.AsNoTracking().ToList());
}
}
public async Task <TransferAgencyBO> GetInvestorActionById(int id)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(await context.TransferAgent.FindAsync(id));
}
}
public FundInvestorBO GetFundInvestor(int fundId, int investorId)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.FundInvestor.Where(fi => fi.FundId == fundId && fi.InvestorId == investorId).FirstOrDefault());
}
}
public List <SecurityPriceStore> GetSecurityPrices(string symbol, string assetClass)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.SecurityPriceData.Where(spd => spd.Security.Symbol == symbol).Include(spd => spd.Security.AssetClass).OrderBy(spd => spd.Date).ToList());
}
}
public List <InvestorsDIM> GetAllInvestors()
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.Investors.OrderBy(i => i.FullName).ToList());
}
}
public List <FundInvestorBO> GetAllFundInvestors(int fundId)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.FundInvestor.Where(fi => fi.FundId == fundId).ToList());
}
}
public List <TransferAgencyBO> GetAllFundInvestorActions(int fundId)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.TransferAgent.Where(ta => ta.FundId == fundId).OrderBy(ta => ta.TransactionDate).ToList());
}
}
public InvestorHoldingsFACT GetMostRecentInvestorHolding(int investorId, int fundId)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
return(context.InvestorHoldings.Where(i => i.FundId == fundId && i.InvestorId == investorId).OrderBy(i => i.HoldingDate).LastOrDefault());
}
}
public async Task UpdateSecurityInfo(SecuritiesDIM security)
{
using (PortfolioAceDbContext context = _contextFactory.CreateDbContext())
{
context.Securities.Update(security);
await context.SaveChangesAsync();
}
}
