private void ReloadSingleQuoteLogEntity() { Cursor.Current = Cursors.WaitCursor; gridControl.FocusedView.CloseEditor(); // Get the specific entity that was modified foreach (var quote in _context.QuoteLog.Where(q => q.QuoteNumber == _quoteNumber)) { // Reload the entity from the database _context.Entry(quote).Reload(); } Cursor.Current = Cursors.Default; //gridControl.FocusedView.CloseEditor(); //System.Windows.Forms.Cursor.Current = Cursors.WaitCursor; ////_context.QuoteLog.Load(); ////_context.QuoteLog.Local.ToBindingList(); //var x = (from u in _context.QuoteLog // //where u.QuoteNumber.StartsWith("52") // select u).ToList(); //gridControl.DataSource = null; //gridControl.DataSource = _context.QuoteLog.Local.ToBindingList(); //BindLookupColumns(); //// Modified quote //// Create a list of the Entities (rows) in the Entity Set (table) //foreach (var quote in _context.QuoteLog.Where(q => q.QuoteNumber == "526-07")) //{ // // Reload the entity from the database // _context.Entry(quote).Reload(); //} // New quote //_context.QuoteLog.Load(); //System.Windows.Forms.Cursor.Current = Cursors.Default; }
public BindingList <QuoteCSM> RefreshNorthAmericanCsmData(string quoteNumber) { // Create a list of the Entities (rows) in the Entity Set (table) var csmList = _context.QuoteCSMs.Local.ToList(); foreach (var csm in csmList) { // Records that no longer exist in the database will be removed from the current state _context.Entry(csm).Reload(); } // Look up CSM Mnemonics for this quote and check them in the grid _context.QuoteCSMs.Where(o => o.QuoteNumber == _quoteNumber).Load(); return(_context.QuoteCSMs.Local.ToBindingList()); }