public EditSavedOrder() { InitializeComponent(); lblboxLimitPrice.Visibility = Visibility.Hidden; txtboxLimitPrice.Visibility = Visibility.Hidden; lblboxStopPrice.Visibility = Visibility.Hidden; txtboxStopPrice.Visibility = Visibility.Hidden; this.Loaded += EditSavedOrder_Loaded; List <string> sideList = new List <string>(); sideList.Add("Sell"); sideList.Add("Buy"); cbxSide.ItemsSource = sideList; SymbolDataRetriveService.UpdateSymbols(); EquityEntities db = new EquityEntities(); var SymList = db.Symbol_Properties.Select(s => s.Symbol).ToList(); cbxSymbol.ItemsSource = SymList; }
void CreateOrder_Loaded(object sender, RoutedEventArgs e) { lblVisibilityPrices.Visibility = Visibility.Hidden; db = new EquityEntities(); SavedPortfolio = new ObservableCollection <Portfolio>(db.Portfolios.Where(t => t.UserID == Session.CurrentUser.UserID).ToList()); foreach (var item in SavedPortfolio) { PName.Add(item.PortfolioName); } Portfoliobox.ItemsSource = PName; var y = db.User_Role.Where(t2 => t2.RoleID == 1).Select(s => s.UserID).ToList(); var x = db.Users.Where(t => y.Contains(t.UserID)).Select(s2 => s2.UserName).ToList(); //var x = (from u in db.Users join r in db.User_Role on u.UserID equals r.UserID where r.RoleID == 1 select new { u.UserName }).ToList(); TraderBox.ItemsSource = x; SymbolDataRetriveService.UpdateSymbols(); SymList = db.Symbol_Properties.Select(s => s.Symbol).ToList(); cbxSymbolList.ItemsSource = SymList; cbxSymbolList.SelectedItem = SymList[0]; }
private void cbxSymbolList_SelectionChanged(object sender, SelectionChangedEventArgs e) { lblSecurityName.Content = db.Symbol_Properties.Where(t => t.Symbol.Equals(cbxSymbolList.SelectedItem.ToString())).Select(s => s.Name).ToList()[0]; lblMarketPrice.Content = SymbolDataRetriveService.GetMarketPrice(cbxSymbolList.SelectedValue.ToString()); }