private static void LoadFromDb() { _pool = new Dictionary<long, FactorStatistic>(); var collection = new DataBaseCollection<FactorStatistic>(); collection.Load(@"select BIT_MASK, FACTOR_NAME, NUMBER_OF_STARTERS, NUMBER_OF_WINNERS, ROI, IV from FACTOR_NAME"); collection.ForEach(fs => _pool.Add(fs.BitMask, fs)); }
private void LoadAllRacesForTheDistance() { if (_skipLoading) return; try { Cursor = Cursors.WaitCursor; if (null == _currentRaceInfo) return; _gridShowAllRacesForTheDistance.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; DateTime fd = _periodSelector.FromDate; DateTime td = _periodSelector.ToDate; string fromDate = string.Format("{0}{1:00}{2:00}", fd.Year, fd.Month, fd.Day); string toDate = string.Format("{0}{1:00}{2:00}", td.Year, td.Month, td.Day); string surf = _currentRaceInfo.Surface; string trackCode = _currentRaceInfo.TrackCode; string aboutFlag = _currentRaceInfo.AboutFlag.Trim(); _tbDistance.Text = Utilities.ConvertYardsToMilesOrFurlongs((int) _currentRaceInfo.Distance); if (aboutFlag.Contains("A")) { _tbDistance.Text = new string('*', 1) + _tbDistance.Text; } _tbSurface.Text = surf; var collection = new DataBaseCollection<RaceResults>(); string sqlLoader = string.Format(_sqlLoadRacesForDistanceAndTrack, trackCode, _currentRaceInfo.Distance, surf, aboutFlag, fromDate, toDate); collection.Load(sqlLoader); RaceResults.InitializeGrid(_gridShowAllRacesForTheDistance, collection.Count); WinnerInfo thisRaceInfo = null; int rowIndex = 0; collection.ForEach(rr => rr.AddToGrid(_gridShowAllRacesForTheDistance, _currentRaceInfo.RaceId, rowIndex++)); _gridShowAllRacesForTheDistance.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; _tbNumberOfRaces.Text = collection.Count.ToString(); } finally { Cursor = Cursors.Default; } }