public void addTransaction(ApplicationDbContext db, ApplicationUser user, Stock stock, StockTransaction model) { model.StockTicker = stock.Identifier; model.UserId = user.Id; db.StockTransactions.Add(model); db.SaveChanges(); }
public IEnumerable<string> getKnownIdentifiers(ApplicationDbContext db, ApplicationUser user) { var transactions = this.getTransactions(db, user); var ids = transactions.Select(x => x.StockTicker).Distinct().ToList(); var idPrice = ids.Select(x => Tuple.Create(x, transactions.Where(y => y.StockTicker.Equals(x)).Select(y => y.TotalPrice).Sum())); return idPrice.OrderBy(x => x.Item2).Select(x => x.Item1).Take(6); }
public async Task<Stock> getNote(ApplicationDbContext db, ApplicationUser user, Stock stock) { if (stock.Identifier == "F") { stock.Note = "Ford Motor Comp"; } if (stock.Identifier == "TWTR") { stock.Note = "Who needs 140 characters?"; } return stock; }
public async Task setNote(ApplicationDbContext db, ApplicationUser user, Stock stock) { var note = db.StockNotes.Where(x => (x.UserId.Equals(user.Id)) && (x.StockTicker.Equals(stock.Identifier))); if (note.Count() == 0) { var newNote = new StockNote(); newNote.Note = stock.Note; newNote.StockTicker = stock.Identifier; newNote.UserId = user.Id; db.StockNotes.Add(newNote); } else { var a = note.First(); db.StockNotes.Update(a); a.Note = stock.Note; } db.SaveChanges(); }
public Task setNote(ApplicationDbContext db, ApplicationUser user, Stock stock) { if (wasCalled) { throw new Exception("SetNote called twice"); } this.wasCalled = true; this.Note = stock.Note; this.Symbol = stock.Identifier; return new Task(() => { }); }
public Task<Stock> getNote(ApplicationDbContext db, ApplicationUser user, Stock stock) { stock.Note = this.Note; return new Task<Stock>(() => stock); }
public IEnumerable<StockTransaction> getTransactions(ApplicationDbContext db, ApplicationUser user, string identifier) { return this.transactions().FindAll(x => x.Key == identifier).Select(x => x.Value); }
public IEnumerable<string> getKnownIdentifiers(ApplicationDbContext db, ApplicationUser user) { return this.transactions().Select(x => x.Key).Distinct(); }
public void clear(ApplicationDbContext db, ApplicationUser user) { }
public void addTransaction(ApplicationDbContext db, ApplicationUser user, Stock stock, StockTransaction model) { }
public IEnumerable<StockTransaction> getTransactions(ApplicationDbContext db, ApplicationUser user, string tickerSymbol) { return db.StockTransactions.Where(x => x.StockTicker.Equals(tickerSymbol) && x.UserId.Equals(user.Id)); }
public IEnumerable<StockTransaction> getTransactions(ApplicationDbContext db, ApplicationUser user) { return db.StockTransactions.Where(x => x.UserId.Equals(user.Id)); }
public void clear(ApplicationDbContext db, ApplicationUser user) { var elemsToRemove = db.StockTransactions.Where(x => x.UserId.Equals(user.Id)); elemsToRemove.ToList().ForEach(x => db.StockTransactions.Remove(x)); db.SaveChanges(); }
public IEnumerable<StockTransaction> getTransactions(ApplicationDbContext db, ApplicationUser user) { var retVal = transactions(); retVal.ForEach(x => x.Value.StockTicker = x.Key); return retVal.Select(x => x.Value); }
public async Task<Stock> getNote(ApplicationDbContext db, ApplicationUser user, Stock stock) { string result = db.StockNotes.Where(x => (x.UserId.Equals(user.Id)) && (x.StockTicker == stock.Identifier)).Select(x => x.Note).FirstOrDefault(); stock.Note = result; return stock; }
public async Task setNote(ApplicationDbContext db, ApplicationUser user, Stock stock) { System.Diagnostics.Debug.WriteLine(stock.Identifier + ": " + stock.Note); }