public void DeleteIndex(StockIndex stockIndex) { using (StockDataEntities context = new StockDataEntities()) { StockIndex existingIndex = context.StockIndexes .Where(i => String.Compare(i.IndexName, stockIndex.IndexName, true) == 0).SingleOrDefault(); if (existingIndex != null) { context.StockIndexes.Remove(existingIndex); context.SaveChanges(); } } }
private void lvIndexes_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (this.lvIndexes.SelectedItem != null) { StockIndex index = this.lvIndexes.SelectedItem as StockIndex; this._selectedIndex = index; this.txtName.Text = index.IndexName; this.txtDesc.Text = index.Description; this.cbCountry.SelectedValue = index.CountryCode; this.lvComponents.ItemsSource = this._symbolRepository.GetIndexComponents(index.IndexName); if (this.lvComponents.Items.Count > 0) this.tbComponents.Text = string.Format("Total {0} components", this.lvComponents.Items.Count); else this.tbComponents.Text = ""; } }
public void UpdateStockIndex(StockIndex stockIndex) { using (StockDataEntities context = new StockDataEntities()) { StockIndex existingIndex = context.StockIndexes .Where(i => String.Compare(i.IndexName, stockIndex.IndexName, true) == 0).SingleOrDefault(); if (existingIndex != null) { existingIndex.Description = stockIndex.Description; } else { context.StockIndexes.Add(stockIndex); } context.SaveChanges(); } }