private void LoadSites() { DataSet data = db.Select("*", Site.Table, null, Site.Fields.SiteName.ToString()); Collection<SiteBinding> gridData = data.getBindableCollection<SiteBinding>(); dgSitesOrLots.ItemsSource = gridData; dataGridDisplayText = SiteBinding.getdisplayTextMap(); dataGridViewData = data; dataGridViewData.BuildPrimaryKeyIndex(Site.PrimaryKey); }
private void LoadLots() { DataSet data = db.Select("lots.*,clients.Name", "lots,clients", "clients.clientID = lots.assocID AND clients.ClientType = 1", "clients.Name ASC"); Collection<LotSelectorBinding> gridData = data.getBindableCollection<LotSelectorBinding>(); dgSitesOrLots.ItemsSource = gridData; dataGridDisplayText = LotSelectorBinding.getdisplayTextMap(); dataGridViewData = data; dataGridViewData.BuildPrimaryKeyIndex(Lot.PrimaryKey); }
private void threadLoadLotData() { try { DataSet data = db.Select("*", Lot.Table, Lot.Fields.assocID.ToString() + " = '" + mSite.GetSiteID() + "'",Lot.Fields.LotNumber.ToString()); Collection<LotBinding> gridData = data.getBindableCollection<LotBinding>(); DispatcherOperation dataOp = Dispatcher.BeginInvoke(DispatcherPriority.Normal, new Action<Collection<LotBinding>>(setLotData), gridData); DispatcherOperationStatus status = dataOp.Status; while (status != DispatcherOperationStatus.Completed) { status = dataOp.Wait(TimeSpan.FromMilliseconds(1000)); if (status == DispatcherOperationStatus.Aborted) { Console.WriteLine("Failed"); } } dataGridViewData = data; dataGridViewData.BuildPrimaryKeyIndex(Lot.PrimaryKey); } catch (Exception ex) { MessageBox.Show("Loading Lots - " + msgCodes.GetString("M2102") + ex.Message, "Error - 2102", MessageBoxButton.OK, MessageBoxImage.Error); } }