public static void Initialize(PortfoliosContext context) { context.Database.Migrate(); //context.Database.EnsureCreated(); FillData(context); }
private static void FillData(PortfoliosContext context) { User defaultUser = context.Users.Include(u => u.Portfolios).Where(u => u.UserName == "sgastia").SingleOrDefault(); if (defaultUser == null) { defaultUser = new Common.Entities.Users.User() { UserName = "******", Email = "*****@*****.**", Portfolios = new List <Portfolio>(), }; context.Users.Add(defaultUser); context.SaveChanges(); } //https://www.cnbc.com/berkshire-hathaway-portfolio/ string name = "Warren Buffet"; if (defaultUser.Portfolios.Where(p => p.Name == name).Any() == false) { context.CreatePortfolio(defaultUser, name, true, new Tuple <string, AssetClass>[] { new Tuple <string, AssetClass>("AAL", AssetClass.Stock), new Tuple <string, AssetClass>("AAPL", AssetClass.Stock), new Tuple <string, AssetClass>("AMZN", AssetClass.Stock), new Tuple <string, AssetClass>("AXP", AssetClass.Stock), new Tuple <string, AssetClass>("AXTA", AssetClass.Stock), new Tuple <string, AssetClass>("BAC", AssetClass.Stock), new Tuple <string, AssetClass>("BIIB", AssetClass.Stock), new Tuple <string, AssetClass>("BK", AssetClass.Stock), new Tuple <string, AssetClass>("CHTR", AssetClass.Stock), new Tuple <string, AssetClass>("COST", AssetClass.Stock), new Tuple <string, AssetClass>("DAL", AssetClass.Stock), new Tuple <string, AssetClass>("DVA", AssetClass.Stock), new Tuple <string, AssetClass>("GL", AssetClass.Stock), new Tuple <string, AssetClass>("GM", AssetClass.Stock), new Tuple <string, AssetClass>("GS", AssetClass.Stock), new Tuple <string, AssetClass>("JNJ", AssetClass.Stock), new Tuple <string, AssetClass>("JPM", AssetClass.Stock), new Tuple <string, AssetClass>("KHC", AssetClass.Stock), new Tuple <string, AssetClass>("KO", AssetClass.Stock), new Tuple <string, AssetClass>("KR", AssetClass.Stock), new Tuple <string, AssetClass>("LBTYA", AssetClass.Stock), new Tuple <string, AssetClass>("LBTYK", AssetClass.Stock), new Tuple <string, AssetClass>("LILA", AssetClass.Stock), new Tuple <string, AssetClass>("LILAK", AssetClass.Stock), new Tuple <string, AssetClass>("LSXMA", AssetClass.Stock), new Tuple <string, AssetClass>("LSXMK", AssetClass.Stock), new Tuple <string, AssetClass>("LUV", AssetClass.Stock), new Tuple <string, AssetClass>("MA", AssetClass.Stock), new Tuple <string, AssetClass>("MCO", AssetClass.Stock), new Tuple <string, AssetClass>("MDLZ", AssetClass.Stock), new Tuple <string, AssetClass>("MTB", AssetClass.Stock), new Tuple <string, AssetClass>("OXY", AssetClass.Stock), new Tuple <string, AssetClass>("PG", AssetClass.Stock), new Tuple <string, AssetClass>("PNC", AssetClass.Stock), new Tuple <string, AssetClass>("PSX", AssetClass.Stock), new Tuple <string, AssetClass>("RH", AssetClass.Stock), new Tuple <string, AssetClass>("QSR", AssetClass.Stock), new Tuple <string, AssetClass>("SIRI", AssetClass.Stock), new Tuple <string, AssetClass>("SPY", AssetClass.ETF), new Tuple <string, AssetClass>("STNE", AssetClass.Stock), new Tuple <string, AssetClass>("STOR", AssetClass.Stock), new Tuple <string, AssetClass>("SU", AssetClass.Stock), new Tuple <string, AssetClass>("SYF", AssetClass.Stock), new Tuple <string, AssetClass>("TEVA", AssetClass.Stock), new Tuple <string, AssetClass>("TRV", AssetClass.Stock), new Tuple <string, AssetClass>("UAL", AssetClass.Stock), new Tuple <string, AssetClass>("UPS", AssetClass.Stock), new Tuple <string, AssetClass>("USB", AssetClass.Stock), new Tuple <string, AssetClass>("V", AssetClass.Stock), new Tuple <string, AssetClass>("VOO", AssetClass.ETF), new Tuple <string, AssetClass>("VRSN", AssetClass.Stock), new Tuple <string, AssetClass>("WFC", AssetClass.Stock), }); } name = "ETF"; if (defaultUser.Portfolios.Where(p => p.Name == name).Any() == false) { context.CreatePortfolio(defaultUser, name, true, new Tuple <string, AssetClass>[] { new Tuple <string, AssetClass>("TQQQ", AssetClass.ETF), new Tuple <string, AssetClass>("SPXL", AssetClass.ETF), new Tuple <string, AssetClass>("TNA", AssetClass.ETF), new Tuple <string, AssetClass>("MIDU", AssetClass.ETF), new Tuple <string, AssetClass>("VNQ", AssetClass.ETF), new Tuple <string, AssetClass>("GEX", AssetClass.ETF), }); } name = "Big Technologies"; if (defaultUser.Portfolios.Where(p => p.Name == name).Any() == false) { context.CreatePortfolio(defaultUser, name, true, new Tuple <string, AssetClass>[] { new Tuple <string, AssetClass>("AAPL", AssetClass.Stock), new Tuple <string, AssetClass>("AMZN", AssetClass.Stock), new Tuple <string, AssetClass>("CSCO", AssetClass.Stock), new Tuple <string, AssetClass>("GOOGL", AssetClass.Stock), new Tuple <string, AssetClass>("IBM", AssetClass.Stock), new Tuple <string, AssetClass>("MSFT", AssetClass.Stock), new Tuple <string, AssetClass>("ORCL", AssetClass.Stock), new Tuple <string, AssetClass>("AMD", AssetClass.Stock), new Tuple <string, AssetClass>("CRM", AssetClass.Stock), new Tuple <string, AssetClass>("FSLR", AssetClass.Stock), new Tuple <string, AssetClass>("INTC", AssetClass.Stock), new Tuple <string, AssetClass>("MELI", AssetClass.Stock), new Tuple <string, AssetClass>("GLOB", AssetClass.Stock), //new Tuple<string, AssetClass>("", AssetClass.Stock), //new Tuple<string, AssetClass>("", AssetClass.Stock), //new Tuple<string, AssetClass>("", AssetClass.Stock), }); } }