Пример #1
0
        /// <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();
        }
Пример #2
0
        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));
        }