public List<Quest401kTransactionDto> GetAllTransactions()
{
var context = new Invest.Dal.InvestContext();
var transactions = context.Quest401KTransactions.OrderBy(p => p.Ticker).OrderBy(p => p.Date).Take(500);
return MapModelToDto(transactions);
}
public bool AddNewTransactionFromMerger(int Id, double shares, DateTime mergerDate, int securityId, int mergerId)
{
var db = new InvestContext();
var security = db.Securities.FirstOrDefault(p => p.Id == securityId);
var model = db.BuyAndHoldTransactions.FirstOrDefault(p => p.Id == Id);
var w = new BuyAndHoldTransaction();
w.OriginalTransactionId = model.Id;
w.TransactionDate = model.TransactionDate;
w.TickerSymbol = security.TickerSymbol;
w.SecurityId = securityId;
w.OriginalTickerSymbol = model.OriginalTickerSymbol;
w.OriginalSecurityId = model.SecurityId;
w.Period = model.Period;
w.TransactionType = model.TransactionType;
w.AmountInvested = model.AmountInvested;
w.NumberShares = shares;
w.BuyPrice = model.AmountInvested / decimal.Parse(shares.ToString());
w.ValidFrom = mergerDate;
w.Notes = model.Notes;
w.MergerId = mergerId;
db.BuyAndHoldTransactions.Add(w);
db.SaveChanges();
return true;
}
public ActionResult BuyPriceDesc()
{
var context = new InvestContext();
var AmericanCenturyTransactions = GetAmericanCenturyLongTermTransactionsList(false);
return View(AmericanCenturyTransactions);
}
public ActionResult BuyPriceDesc(AmericanCenturyBuysViewModel AmericanCenturyTransaction)
{
var excludeShortTermTransactions = AmericanCenturyTransaction.ExcludeShortTermTransactions;
var context = new InvestContext();
var AmericanCenturyTransactions = GetAmericanCenturyLongTermTransactionsList(excludeShortTermTransactions);
return View(AmericanCenturyTransactions);
}
public TickerDto GetTickerBySymbol(string symbol)
{
var context = new InvestContext();
if (!string.IsNullOrWhiteSpace(symbol))
{
var ticker = context.Tickers.FirstOrDefault(p => p.Symbol == symbol);
return ticker != null ? ConvertToDto(ticker) : new TickerDto();
}
return new TickerDto();
}
public TransactionTypeDto GetTransactionType(int id)
{
var context = new InvestContext();
var transactionTypeDtos = new List<TransactionTypeDto>();
var transactionType = context.BuyAndHoldTransactionTypes.FirstOrDefault(p => p.Id == id);//.OrderBy(p => p.TransactionType1).ToList();
var Dto = MapToDto(transactionType);
return Dto;
}
public List<Quest401kTransactionDto> GetTickerTransactions(string ticker)
{
var context = new Invest.Dal.InvestContext();
context.Configuration.LazyLoadingEnabled = false;
var transactions = context.Quest401KTransactions.Include("SubTransactions").Where(p => p.Ticker == ticker).OrderBy(p => p.Ticker).OrderBy(p => p.Date).Take(500);
var w = transactions.ToList().First().SubTransactions;
return MapModelToDto(transactions);
}
public NavDto GetNav(int tickerId)
{
var context = new InvestContext();
//var tickerDto = new TickerDto();
var nav = context.Navs.OrderByDescending(p => p.Date).FirstOrDefault(p => p.TickerId == tickerId);
//foreach (var ticker in tickers)
//{
var navDto = ConvertToDto(nav);
// tickerDtos.Add(tickerDto);
//}
return navDto;
}
public List<TickerDto> GetTickers(string text)
{
var context = new InvestContext();
var tickerDtos = new List<TickerDto>();
//var tickers = context.Tickers.Where(r => r.Symbol.StartsWith(text)).OrderBy(p => p.Symbol).Select(r => new { r.Id, value = r.Symbol }).ToList();
var tickers = context.Tickers.Where(r => r.Symbol.StartsWith(text)).OrderBy(p => p.Symbol).ToList();
foreach (var ticker in tickers)
{
var tickerDto = ConvertToDto(ticker);
tickerDtos.Add(tickerDto);
}
return tickerDtos;
}
public TickerDto GetTickerById(int id)
{
var context = new InvestContext();
//var tickerDto = new TickerDto();
var ticker = context.Tickers.FirstOrDefault(p => p.Id == id);
//foreach (var ticker in tickers)
//{
var tickerDto = ConvertToDto(ticker);
// tickerDtos.Add(tickerDto);
//}
return tickerDto;
}
public List<StatementItemDto> GetStatements(int accountId)
{
var context = new InvestContext();
var statementItemDtos = new List<StatementItemDto>();
var statementItems = context.StatementItems.OrderBy(p => p.Ticker).ThenByDescending(p=>p.Date); ;//.Where(p => p.AccountId == accountId).OrderBy(p => p.Ticker1.Symbol);
foreach (var statementItem in statementItems)
{
var statementItemDto = ConvertToDto(statementItem);
statementItemDtos.Add(statementItemDto);
}
return statementItemDtos;
}
public List<TickerDto> GetAllTickers()
{
var context = new InvestContext();
var tickerDtos = new List<TickerDto>();
List<Invest.Domain.Models.Ticker> tickers = context.Tickers.OrderBy(p => p.Name).ToList();
foreach (var ticker in tickers)
{
var tickerDto = ConvertToDto(ticker);
tickerDtos.Add(tickerDto);
}
return tickerDtos;
}
public NavDto GetTicker(string tickerSymbol)
{
var context = new InvestContext();
//var tickerDto = new TickerDto();
var nav = context.Navs.OrderByDescending(p => p.Date).FirstOrDefault(p => p.Ticker == tickerSymbol);
//foreach (var ticker in tickers)
//{
var navDto = nav != null ? ConvertToDto(nav) : new NavDto();
// tickerDtos.Add(tickerDto);
//}
return navDto;
}
public List<AccountDto> GetAccounts()
{
var context = new InvestContext();
var accountDtos = new List<AccountDto>();
List<Invest.Domain.Models.Account> accountModels = context.Accounts.OrderBy(p => p.Name).ToList();
foreach (var account in accountModels)
{
var accountDto = ConvertToDto(account);
accountDtos.Add(accountDto);
}
return accountDtos;
}
public List<TransactionTypeDto> GetTransactionTypes()
{
var context = new InvestContext();
var transactionTypeDtos = new List<TransactionTypeDto>();
var transactionTypes = context.TransactionTypes.OrderBy(p => p.TransactionType1).ToList();
foreach (var transactionType in transactionTypes)
{
var transactionTypeDto = MapToDto(transactionType);
transactionTypeDtos.Add(transactionTypeDto);
}
return transactionTypeDtos;
}
public List<BuyAndHoldRawTransactionDto> GetBuyAndHoldRawTransactions2(string symbol)
{
var buyAndHoldTransactions = new List<BuyAndHoldRawTransactionDto>();
var db = new InvestContext();
List<BuyAndHoldRawTransaction> BuyAndHoldTransactionModels;
//return context.BuyAndHoldTransactions.Where(p => p.Symbol == ticker).Where(p => (p.TransactionId ?? 0) > 0).Where(p => (p.ValidTo ?? tomorrow) > DateTime.Today).OrderByDescending(p => p.TransactionDate).ToList();
if (symbol == "zzz")
{
BuyAndHoldTransactionModels = db.BuyAndHoldRawTransactions
.OrderByDescending(p => p.TransactionDate).Take(1000).ToList();
}
else
{
BuyAndHoldTransactionModels = db.BuyAndHoldRawTransactions.Where(p => p.TickerSymbol == symbol).Where(p => p.TransactionType != "Dividend Tx").Where(p => p.TransactionType != "VOID").Where(p => p.TransactionType != "").Where(p => p.TransactionType != null)
.OrderBy(p => p.TransactionDate).ToList();
}
foreach (var buyAndHoldTransactionModel in BuyAndHoldTransactionModels)
{
buyAndHoldTransactions.Add(new BuyAndHoldRawTransactionDto
{
Amount = buyAndHoldTransactionModel.Amount,
AmountInvested = buyAndHoldTransactionModel.AmountInvested,
//BhId = buyAndHoldTransactionModel.BhId,
BuyPrice = buyAndHoldTransactionModel.BuyPrice,
Company = buyAndHoldTransactionModel.Company,
DebitCredit = buyAndHoldTransactionModel.DebitCredit,
DividendAmount = buyAndHoldTransactionModel.DividendAmount,
Fees = buyAndHoldTransactionModel.Fees,
Id = buyAndHoldTransactionModel.Id,
Notes = buyAndHoldTransactionModel.Notes,
NumberShares = buyAndHoldTransactionModel.NumberShares,
Period = buyAndHoldTransactionModel.Period,
Price = buyAndHoldTransactionModel.Price,
Quantity = buyAndHoldTransactionModel.Quantity,
Split = buyAndHoldTransactionModel.Split,
TickerSymbol = buyAndHoldTransactionModel.TickerSymbol,
SuspectedType = buyAndHoldTransactionModel.SuspectedType,
TransactionDate = buyAndHoldTransactionModel.TransactionDate,
TransactionTypeId = buyAndHoldTransactionModel.TransactionTypeId,
TransactionType = buyAndHoldTransactionModel.TransactionType,
Xref = buyAndHoldTransactionModel.Xref,
XXX = buyAndHoldTransactionModel.XXX
});
}
return buyAndHoldTransactions;
}
public Security Update(SecurityDto dto)
{
Security model;
//using (var context = new InvestContext())
var context = new InvestContext();
//{
model = context.Securities.FirstOrDefault(p => p.Id == dto.Id);
model.Active = dto.Active;
model.CompanyName = dto.CompanyName;
model.Notes = dto.Notes;
model.TickerSymbol = dto.TickerSymbol;
context.SaveChanges();
//}
return model;
}
public HistoricalCompanyName Update(HistoricalCompanyNameDto dto)
{
HistoricalCompanyName model;
//using (var context = new InvestContext())
var context = new InvestContext();
//{
model = context.HistoricalCompanyNames.FirstOrDefault(p => p.Id == dto.Id);
model.ValidFrom = dto.ValidFrom;
model.CompanyName = dto.CompanyName;
//model. = dto.Notes;
//model.TickerSymbol = dto.TickerSymbol;
context.SaveChanges();
//}
return model;
}
public HistoricalTickerSymbol Update(HistoricalTickerSymbolDto dto)
{
HistoricalTickerSymbol model;
//using (var context = new InvestContext())
var context = new InvestContext();
//{
model = context.HistoricalTickerSymbols.FirstOrDefault(p => p.Id == dto.Id);
//model.Active = dto.Active;
//model.CompanyName = dto.CompanyName;
//model.Notes = dto.Notes;
model.TickerSymbol = dto.TickerSymbol;
context.SaveChanges();
//}
return model;
}
public List<AmericanCenturyBuyDto> GetTransactions()
{
var transactions = new List<AmericanCenturyBuyDto>();
var db = new InvestContext();
var transactionModels = db.AmericanCenturyBuys
.OrderByDescending(p => p.Date).ToList();
foreach (var buyModel in transactionModels)
{
var w = MapAmericanCenturyBuy(buyModel);
transactions.Add(w);
}
return transactions;
}
public List<AmericanCenturyTransactionDto> GetAmericanCenturyTransactions(bool excludeSoldTransactions)
{
var context = new InvestContext();
var transactions = new List<AmericanCenturyTransactionDto>();
//TODO ADD LOGIC to faCTO OUT SOLD TRANSACTIONS
var transactionModels = excludeSoldTransactions ? context.AmericanCenturyTransactions.OrderBy(p => p.AmericanCenturyBuy.Date).ToList()
: context.AmericanCenturyTransactions.OrderBy(p => p.AmericanCenturyBuy.Date).ToList();
foreach (var model in transactionModels)
{
var dto = MapAmericanCenturyTransaction(model);
transactions.Add(dto);
}
return transactions;
}
public BuyAndHoldTransaction CreateBuyAndHoldTransaction(BuyAndHoldTransactionDto dto)
{
var context = new InvestContext();
var model = new BuyAndHoldTransaction(); // db.BuyAndHoldTransactions.FirstOrDefault(p => p.Id == dto.Id);
model.RawTransactionId = dto.BuyAndHoldRawId;
model.OriginalTransactionId = dto.OriginalTransactionId;
model.TransactionDate = dto.TransactionDate;
model.SecurityId = dto.SecurityId.HasValue ? dto.SecurityId.Value : 0;
model.TickerSymbol = dto.TickerSymbol;
model.OriginalSecurityId = dto.OriginalSecurityId.HasValue ? (int?)dto.OriginalSecurityId.Value : null;
model.OriginalTickerSymbol = dto.OriginalTickerSymbol;
model.Period = dto.Period;
model.TransactionType = dto.TransactionType;
model.TransactionTypeId = dto.TransactionTypeId;
model.TransactionApplied = dto.TransactionApplied;
model.DividendAmount = dto.DividendAmount;
model.AmountInvested = dto.AmountInvested;
model.NumberShares = dto.NumberShares;
model.BuyPrice = dto.BuyPrice;
model.Split = dto.Split;
model.ValidFrom = dto.ValidFrom;
model.ValidTo = dto.ValidTo;
model.SellId = dto.SellId;
model.SellDate = dto.SellDate;
model.Notes = dto.Notes;
model.Url1 = dto.Url1;
model.Url2 = dto.Url2;
model.Url3 = dto.Url3;
model.NewMergerId = dto.MergerId;
model.NewSpinOffId = dto.SpinOffId;
context.BuyAndHoldTransactions.Add(model);
context.SaveChanges();
return model;
}
public List<AmericanCenturyTransactionDto> GetAmericanCenturyLongTermTransactions(bool excludeSoldTransactions)
{
var context = new InvestContext();
var transactions = new List<AmericanCenturyTransactionDto>();
//TODO ADD LOGIC to faCTO OUT SOLD TRANSACTIONS
var OneYearAgo = DateTime.Now.AddYears(-1);
var transactionModels = context.AmericanCenturyTransactions.Where(p => p.AmericanCenturyBuy.Date < OneYearAgo).OrderBy(p => p.AmericanCenturyBuy.Date).ToList();
if (excludeSoldTransactions)
{
transactionModels = transactionModels.Where(p => p.AmericanCenturySellId != null).ToList();
}
foreach (var model in transactionModels)
{
var dto = MapAmericanCenturyTransaction(model);
transactions.Add(dto);
}
return transactions;
}
public List<BuyAndHoldMerger> GetBuyAndHoldMergers()
{
var db = new InvestContext();
return db.BuyAndHoldMergers.ToList();
}
public IEnumerable<HistoricalTickerSymbol> GetByTickerSymbol(string symbol)
{
var context = new InvestContext();
return context.HistoricalTickerSymbols.Where(p => p.Security.TickerSymbol == symbol);
}
public IEnumerable<HistoricalTickerSymbol> GetBySecurityId(int id)
{
var context = new InvestContext();
return context.HistoricalTickerSymbols.Where(p => p.SecurityId == id);
}
public HistoricalTickerSymbol GetById(int id)
{
var context = new InvestContext();
return context.HistoricalTickerSymbols.FirstOrDefault(p => p.Id == id);
}
public IEnumerable<HistoricalTickerSymbol> GetAll()
{
var context = new InvestContext();
return context.HistoricalTickerSymbols.OrderBy(p => p.TickerSymbol);
}
public BuyAndHoldRawTransaction GetBuyAndHoldRawTransaction(int id)
{
var db = new InvestContext();
return db.BuyAndHoldRawTransactions.FirstOrDefault(p => p.Id == id);
}
public BuyAndHoldSplit GetBuyAndHoldSplit(int id)
{
var db = new InvestContext();
return db.BuyAndHoldSplits.FirstOrDefault(p => p.Id == id);
}
