/// <summary> /// save stock to db /// </summary> /// <param name="userObj"></param> /// <param name="stockCode"></param> public void SaveStocksToUser(user userObj, string stockCode) { userstock stock = new userstock(); stock.user = userObj; stock.stockcode = stockCode; _context.userstocks.InsertOnSubmit(stock); _context.SubmitChanges(); }
public IEnumerable <userstock> GetStocksOfUser(user userObj) { List <userstock> ustocks = new List <userstock>(); userstock ustock = new userstock(); ustock.user_id = 1; ustock.id = 1; ustock.stockcode = "appl"; ustocks.Add(ustock); userstock ustock1 = new userstock(); ustock1.user_id = 1; ustock1.id = 2; ustock1.stockcode = "goog"; ustocks.Add(ustock1); userstock ustock2 = new userstock(); ustock2.user_id = 2; ustock2.id = 3; ustock2.stockcode = "goog"; ustocks.Add(ustock2); return(ustocks.Where(x => x.user_id == userObj.id)); }