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);
}
}
