public bool UnfollowStock(string email, int stockId) { using (StockViewerEntities db = new StockViewerEntities()) { StockAspNetUser stock = (from ts in db.StockAspNetUsers where ts.AspNetUser.Email.ToLower() == email.ToLower() && ts.Stock.Id == stockId select ts).FirstOrDefault(); if (stock != null) { db.Entry(stock).State = EntityState.Deleted; db.SaveChanges(); } return(true); } }
public bool FollowStock(string email, int stockId) { using (StockViewerEntities db = new StockViewerEntities()) { bool alreadyFollowed = db.StockAspNetUsers.Any( ts => ts.Stock.Id == stockId && ts.AspNetUser.Email.ToLower() == email.ToLower()); if (!alreadyFollowed) { AspNetUser user = db.AspNetUsers.FirstOrDefault(t => t.Email.ToLower() == email.ToLower()); Stock stock = db.Stocks.FirstOrDefault(s => s.Id == stockId); if (user != null && stock != null) { StockAspNetUser ts = new StockAspNetUser(); ts.AspNetUser = user; ts.Stock = stock; db.StockAspNetUsers.Add(ts); db.SaveChanges(); return(true); } } return(true); } }