public static void CompileObject(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtEntry = EntryDAL.GetEntryInfo(xe);
entry.SaddleClothNo = dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("SaddleClothNo")].ToString();
entry.Draw = int.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("Draw")].ToString());
entry.TrainerName = dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("TrainerName")].ToString();
entry.JockeyName = dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("JockeyName")].ToString();
entry.OwnerName = dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("OwnerName")].ToString();
entry.Equip = dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("Equipment")].ToString();
entry.Medication = dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("Medication")].ToString();
entry.WeightCarried = int.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("Weight")].ToString());
if (int.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("ApprenticeAllowance")].ToString()) == -999)
{
entry.ApprenticeAllowance = null;
}
else
{
entry.ApprenticeAllowance = int.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("ApprenticeAllowance")].ToString());
}
try
{
entry.ML = double.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("ML")].ToString());
}
catch { }
entry.TrueOdds = double.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("TrueOdds")].ToString());
try { entry.ThisHorse.EarningsLifeTime = int.Parse(dtEntry.Rows[0].ItemArray[dtEntry.Columns.IndexOf("EarningsLifeTime")].ToString()); }
catch { }
}
public static void LoadBrisStats(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtBrisStats = EntryDAL.GetBrisStats(xe);
entry.BrisStats = new Latekick.BOL.Base.Entry.BrisStat[dtBrisStats.Rows.Count];
for (int b = 0; b < entry.BrisStats.Length; b++)
{
entry.BrisStats[b] = new Latekick.BOL.Base.Entry.BrisStat();
entry.BrisStats[b].Category = dtBrisStats.Rows[b].ItemArray[dtBrisStats.Columns.IndexOf("BrisStatCategory")].ToString();
try
{
entry.BrisStats[b].Runs = int.Parse(dtBrisStats.Rows[b].ItemArray[dtBrisStats.Columns.IndexOf("Runs")].ToString());
}
catch { }
try
{
entry.BrisStats[b].WinRatio = double.Parse(dtBrisStats.Rows[b].ItemArray[dtBrisStats.Columns.IndexOf("WinPct")].ToString());
}
catch { }
try
{
entry.BrisStats[b].ITM = double.Parse(dtBrisStats.Rows[b].ItemArray[dtBrisStats.Columns.IndexOf("ITM")].ToString());
}
catch { }
try
{
entry.BrisStats[b].ROI = double.Parse(dtBrisStats.Rows[b].ItemArray[dtBrisStats.Columns.IndexOf("ROI")].ToString());
}
catch { }
}
}
public static void LoadEarnings(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtEarnings = HorseDAL.GetEarnings(xe);
try
{
entry.ThisHorse.EarningsLifeTime = int.Parse(dtEarnings.Rows[0].ItemArray[dtEarnings.Columns.IndexOf("EarningsLifeTime")].ToString());
}
catch { }
}
public static void LoadProjectedRatings(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtProjectedRatings = EntryDAL.GetProjectedRatings(xe);
entry.ProjRatings = new Latekick.BOL.Base.Entry.ProjectedRatings();
entry.ProjRatings.Early = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Early")].ToString());
entry.ProjRatings.Middle = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Middle")].ToString());
entry.ProjRatings.Late = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Late")].ToString());
entry.ProjRatings.Dash = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Dash")].ToString());
entry.ProjRatings.Golden = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Golden")].ToString());
entry.ProjRatings.Average = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Average")].ToString());
entry.ProjRatings.Recent = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Recent")].ToString());
entry.ProjRatings.Quirin = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Quirin")].ToString());
}
public static void LoadRunningStyle(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtRunningStyle = HorseDAL.GetRunningStyle(xe);
entry.ThisHorse.RunStyle = new Latekick.BOL.Base.Horse.RunningStyle();
try { entry.ThisHorse.RunStyle.RunStyle_BRIS = dtRunningStyle.Rows[0].ItemArray[dtRunningStyle.Columns.IndexOf("RunStyle_BRIS")].ToString().Trim(); }
catch { }
try { entry.ThisHorse.RunStyle.PaceRuns = int.Parse(dtRunningStyle.Rows[0].ItemArray[dtRunningStyle.Columns.IndexOf("paceRuns")].ToString()); }
catch { }
try { entry.ThisHorse.RunStyle.PaceWins = int.Parse(dtRunningStyle.Rows[0].ItemArray[dtRunningStyle.Columns.IndexOf("paceWins")].ToString()); }
catch { }
try { entry.ThisHorse.RunStyle.OffPaceRuns = int.Parse(dtRunningStyle.Rows[0].ItemArray[dtRunningStyle.Columns.IndexOf("offPaceRuns")].ToString()); }
catch { }
try { entry.ThisHorse.RunStyle.OffPaceWins = int.Parse(dtRunningStyle.Rows[0].ItemArray[dtRunningStyle.Columns.IndexOf("offPaceWins")].ToString()); }
catch { }
}
public static void LoadEntries(XElement xRace, BOL.Base.Race race)
{
try
{
DataTable dtRunners = RaceDAL.GetHorseNames(xRace);
race.NumberOfHorses = dtRunners.Rows.Count;
race.Entries = new Latekick.BOL.Base.Entry[race.NumberOfHorses];
race.HorseNames = new string[race.NumberOfHorses];
List <XElement> xEntries_Unsorted = xRace.Elements("Entry").ToList <XElement>();
IOrderedEnumerable <XElement> xEntries = xEntries_Unsorted.OrderBy(entry => entry.Element("SaddleClothNo").Value, new CustomComparer());
for (int i = 0; i < race.NumberOfHorses; i++)
{
Latekick.BOL.Base.Entry entry = EntryBL.CreateObject();
EntryBL.CompileObject(xEntries.ElementAt(i), entry);
Latekick.BOL.Base.Horse horse = HorseBL.CreateObject();
HorseBL.CompileObject(xEntries.ElementAt(i), horse);
entry.ThisHorse = horse;
EntryBL.LoadProjectedRatings(xEntries.ElementAt(i), entry);
EntryBL.LoadStats(xEntries.ElementAt(i), entry);
EntryBL.LoadBrisStats(xEntries.ElementAt(i), entry);
HorseBL.LoadWorkouts(xEntries.ElementAt(i), entry);
HorseBL.LoadPastPerformances(xEntries.ElementAt(i), entry);
HorseBL.LoadRunningStyle(xEntries.ElementAt(i), entry);
HorseBL.LoadEarnings(xEntries.ElementAt(i), entry);
race.Entries[i] = entry;
race.HorseNames[i] = entry.ThisHorse.Name;
}
}
catch (Exception e2)
{
}
}
public static void LoadWorkouts(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtWorkouts = HorseDAL.GetWorkouts(xe);
entry.ThisHorse.Workouts = new Latekick.BOL.Base.Workout[dtWorkouts.Rows.Count];
for (int i = 0; i < dtWorkouts.Rows.Count; i++)
{
entry.ThisHorse.Workouts[i] = new Latekick.BOL.Base.Workout();
entry.ThisHorse.Workouts[i].WorkDate = DateTime.Parse(dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkDate")].ToString());
entry.ThisHorse.Workouts[i].WorkCourse = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkTrack")].ToString();
entry.ThisHorse.Workouts[i].WorkDaysAgo = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkDaysAgo")].ToString();
entry.ThisHorse.Workouts[i].WorkDistance = Double.Parse(dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkDistance")].ToString());
entry.ThisHorse.Workouts[i].WorksSurface = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkSurface")].ToString();
entry.ThisHorse.Workouts[i].WorkGoing = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkGoing")].ToString();
entry.ThisHorse.Workouts[i].WorkMates = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkMates")].ToString();
entry.ThisHorse.Workouts[i].WorkTime = Double.Parse(dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkTime")].ToString());
entry.ThisHorse.Workouts[i].WorkRating = Double.Parse(dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkRating")].ToString());
entry.ThisHorse.Workouts[i].WorkDescription = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkDescription")].ToString();
entry.ThisHorse.Workouts[i].Gate = int.Parse(dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkFromGate")].ToString());
entry.ThisHorse.Workouts[i].WorkRank = dtWorkouts.Rows[i].ItemArray[dtWorkouts.Columns.IndexOf("WorkRank")].ToString();
}
}
public static void LoadStats(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtStats = EntryDAL.GetStats(xe);
entry.Horse_LifeTime_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_CurrentYear_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_LastYear_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_Dirt_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_AW_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_Turf_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_Track_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_Wet_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Horse_Distance_Stats = new Latekick.BOL.Base.Entry.WPSStats();
entry.Trainer_Meet = new Latekick.BOL.Base.Entry.WPSStats();
entry.Jockey_Meet = new Latekick.BOL.Base.Entry.WPSStats();
entry.Jockey_30Days = new Latekick.BOL.Base.Entry.WPSStats();
entry.Trainer_30Days = new Latekick.BOL.Base.Entry.WPSStats();
try
{
entry.Horse_LifeTime_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LifeTime_Runs")].ToString());
}
catch { }
try
{
entry.Horse_LifeTime_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LifeTime_Win")].ToString());
}
catch { }
try
{
entry.Horse_LifeTime_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LifeTime_Place")].ToString());
}
catch { }
try
{
entry.Horse_LifeTime_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LifeTime_Show")].ToString());
}
catch { }
try
{
entry.Horse_CurrentYear_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("ThisYear_Runs")].ToString());
}
catch { }
try
{
entry.Horse_CurrentYear_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("ThisYear_Win")].ToString());
}
catch { }
try
{
entry.Horse_CurrentYear_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("ThisYear_Place")].ToString());
}
catch { }
try
{
entry.Horse_CurrentYear_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("ThisYear_Show")].ToString());
}
catch { }
try
{
entry.Horse_LastYear_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LastYear_Runs")].ToString());
}
catch { }
try
{
entry.Horse_LastYear_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LastYear_Win")].ToString());
}
catch { }
try
{
entry.Horse_LastYear_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LastYear_Place")].ToString());
}
catch { }
try
{
entry.Horse_LastYear_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("LastYear_Show")].ToString());
}
catch { }
try
{
entry.Horse_Track_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Course_Runs")].ToString());
}
catch { }
try
{
entry.Horse_Track_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Course_Win")].ToString());
}
catch { }
try
{
entry.Horse_Track_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Course_Place")].ToString());
}
catch { }
try
{
entry.Horse_Track_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Course_Show")].ToString());
}
catch { }
try
{
entry.Horse_Dirt_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Dirt_Runs")].ToString());
}
catch { }
try
{
entry.Horse_Dirt_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Dirt_Win")].ToString());
}
catch { }
try
{
entry.Horse_Dirt_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Dirt_Place")].ToString());
}
catch { }
try
{
entry.Horse_Dirt_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Dirt_Show")].ToString());
}
catch { }
try
{
entry.Horse_Turf_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Turf_Runs")].ToString());
}
catch { }
try
{
entry.Horse_Turf_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Turf_Win")].ToString());
}
catch { }
try
{
entry.Horse_Turf_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Turf_Place")].ToString());
}
catch { }
try
{
entry.Horse_Turf_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Turf_Show")].ToString());
}
catch { }
try
{
entry.Horse_AW_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("AW_Runs")].ToString());
}
catch { }
try
{
entry.Horse_AW_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("AW_Win")].ToString());
}
catch { }
try
{
entry.Horse_AW_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("AW_Place")].ToString());
}
catch { }
try
{
entry.Horse_AW_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("AW_Show")].ToString());
}
catch { }
try
{
entry.Horse_Wet_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Wet_Runs")].ToString());
}
catch { }
try
{
entry.Horse_Wet_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Wet_Win")].ToString());
}
catch { }
try
{
entry.Horse_Wet_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Wet_Place")].ToString());
}
catch { }
try
{
entry.Horse_Wet_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Wet_Show")].ToString());
}
catch { }
try
{
entry.Horse_Distance_Stats.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Distance_Runs")].ToString());
}
catch { }
try
{
entry.Horse_Distance_Stats.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Distance_Win")].ToString());
}
catch { }
try
{
entry.Horse_Distance_Stats.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Distance_Place")].ToString());
}
catch { }
try
{
entry.Horse_Distance_Stats.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Distance_Show")].ToString());
}
catch { }
try
{
entry.Jockey_Meet.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_Runs_Meet")].ToString());
}
catch { }
try
{
entry.Jockey_Meet.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_Win_Meet")].ToString());
}
catch { }
try
{
entry.Jockey_Meet.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_Place_Meet")].ToString());
}
catch { }
try
{
entry.Jockey_Meet.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_Show_Meet")].ToString());
}
catch { }
try
{
entry.Trainer_Meet.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_Runs_Meet")].ToString());
}
catch { }
try
{
entry.Trainer_Meet.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_Win_Meet")].ToString());
}
catch { }
try
{
entry.Trainer_Meet.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_Place_Meet")].ToString());
}
catch { }
try
{
entry.Trainer_Meet.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_Show_Meet")].ToString());
}
catch { }
try
{
entry.Trainer_ThisYear = dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_ThisYear")].ToString();
}
catch { }
try
{
entry.Trainer_LastYear = dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_LastYear")].ToString();
}
catch { }
try
{
entry.Trainer_30Days.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_30d_Runs")].ToString());
}
catch { }
try
{
entry.Trainer_30Days.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_30d_Win")].ToString());
}
catch { }
try
{
entry.Trainer_30Days.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_30d_Place")].ToString());
}
catch { }
try
{
entry.Trainer_30Days.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Trainer_30d_Show")].ToString());
}
catch { }
try
{
entry.Jockey_30Days.Runs = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_30d_Runs")].ToString());
}
catch { }
try
{
entry.Jockey_30Days.Win = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_30d_Win")].ToString());
}
catch { }
try
{
entry.Jockey_30Days.Place = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_30d_Place")].ToString());
}
catch { }
try
{
entry.Jockey_30Days.Show = int.Parse(dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_30d_Show")].ToString());
}
catch { }
try
{
entry.Jockey_ThisYear = dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_ThisYear")].ToString();
}
catch {}
try
{
entry.Jockey_LastYear = dtStats.Rows[0].ItemArray[dtStats.Columns.IndexOf("Jockey_LastYear")].ToString();
}
catch { }
}
public static void LoadPastPerformances(XElement xe, Latekick.BOL.Base.Entry entry)
{
DataTable dtPPs = HorseDAL.GetPastPerformances(xe);
entry.ThisHorse.PastPerformances = new Latekick.BOL.Base.Performance[dtPPs.Rows.Count];
for (int i = 0; i < dtPPs.Rows.Count; i++)
{
entry.ThisHorse.PastPerformances[i] = new Latekick.BOL.Base.Performance();
entry.ThisHorse.PastPerformances[i].ThisRace = new Latekick.BOL.Base.Race();
try
{
entry.ThisHorse.PastPerformances[i].ThisRace.Purse = double.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Purse")].ToString());
}
catch { }
try
{
entry.ThisHorse.PastPerformances[i].ThisRace.ClaimingPrice = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("claim")].ToString());
}
catch { }
entry.ThisHorse.PastPerformances[i].ThisRace.RaceDate = DateTime.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("RaceDate")].ToString());
entry.ThisHorse.PastPerformances[i].ThisRace.CourseAbbreviation = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("CourseCode")].ToString();
entry.ThisHorse.PastPerformances[i].ThisRace.Going = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Going")].ToString().ToLower();
entry.ThisHorse.PastPerformances[i].ThisRace.Distance = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("DistanceFurlongs")].ToString();
entry.ThisHorse.PastPerformances[i].ThisRace.Surface = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Surface")].ToString();
entry.ThisHorse.PastPerformances[i].ThisRace.RaceClass = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("ClassRating_GMR")].ToString();
entry.ThisHorse.PastPerformances[i].ThisRace.RaceType = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("RaceType")].ToString();
entry.ThisHorse.PastPerformances[i].ThisRace.Finish123 = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Finish123")].ToString();
entry.ThisHorse.PastPerformances[i].ThisRace.Finish123_GMR = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Finish123_GMR")].ToString();
entry.ThisHorse.PastPerformances[i].OfficialPositionText = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("OfficialPositionText")].ToString();
try
{
entry.ThisHorse.PastPerformances[i].OfficialPosition = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("OfficialFinish")].ToString());
}
catch { }
try
{
entry.ThisHorse.PastPerformances[i].Odds = Double.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Odds")].ToString());
}
catch { }
entry.ThisHorse.PastPerformances[i].OddsText = entry.ThisHorse.PastPerformances[i].Odds.Value.ToString("#.#");
try
{
entry.ThisHorse.PastPerformances[i].Weight = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Weight")].ToString());
}
catch { }
try
{
entry.ThisHorse.PastPerformances[i].DistanceBeaten = double.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("DistanceBeaten")].ToString());
}
catch { }
System.Globalization.TextInfo ti = new System.Globalization.CultureInfo("en-US", false).TextInfo;
entry.ThisHorse.PastPerformances[i].JockeyName = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("JockeyName")].ToString();
entry.ThisHorse.PastPerformances[i].TrainerName = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("TrainerName")].ToString();
entry.ThisHorse.PastPerformances[i].PerformanceComment = dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("TripComment")].ToString();
entry.ThisHorse.PastPerformances[i].Early = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Early")].ToString());
entry.ThisHorse.PastPerformances[i].Middle = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Middle")].ToString());
entry.ThisHorse.PastPerformances[i].Late = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Late")].ToString());
entry.ThisHorse.PastPerformances[i].GMR = int.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("Latekick")].ToString());
entry.ThisHorse.PastPerformances[i].LateSpeed = Double.Parse(dtPPs.Rows[i].ItemArray[dtPPs.Columns.IndexOf("LateSpeed")].ToString());
}
}
