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);
}
}