private void LoadCurrentRaceInfo(DateTime date, string trackCode, int raceNumber) { _currentRaceInfo = null; string sql = string.Format( @"SELECT RACE_ID, DISTANCE, ABOUT_DISTANCE_FLAG, SURFACE, TRACK_CODE, TRACK_CONDITION FROM RACE_DESCRIPTION WHERE DATE_OF_THE_RACE = '{0}' AND TRACK_CODE = '{1}' AND RACE_NUMBER = {2}", Utilities.GetDateInYYYYMMDD(date), trackCode, raceNumber); using (var dbr = new DbReader()) { if (dbr.Open(sql)) { while (dbr.MoveToNextRow()) { _currentRaceInfo = new RaceInfo(); _currentRaceInfo.AboutFlag = dbr.GetValue<string>("ABOUT_DISTANCE_FLAG"); _currentRaceInfo.Distance = dbr.GetValue<double>("DISTANCE"); _currentRaceInfo.RaceId = dbr.GetValue<int>("RACE_ID"); _currentRaceInfo.Surface = dbr.GetValue<string>("SURFACE"); _currentRaceInfo.TrackCondition = dbr.GetValue<string>("TRACK_CONDITION"); _currentRaceInfo.TrackCode = trackCode; } } } }
private void SetCurrentRaceInfo(RaceInfo ri) { _winners = null; _currentRaceInfo = ri; LoadWinners(); }
public void Clear() { _timeComparisonCtrl.Clear(); _currentRaceInfo = null; _labelHorseName.Text = ""; }