public void ConvertRaces(XDocument xdTrackmaster)
{
DataTable dtRaces = DAL.Trackmaster.RaceCardDAL.GetRaces(xdTrackmaster);
LK.Course = new Course();
LK.Course.CourseCode = dtRaces.Rows[0].ItemArray[dtRaces.Columns.IndexOf("Track")].ToString().ToUpper();
LK.RaceDate = DateTime.ParseExact(dtRaces.Rows[0].ItemArray[dtRaces.Columns.IndexOf("RaceDate")].ToString(), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
LK.Race = new Race[dtRaces.Rows.Count];
int cnt = 0;
foreach (DataRow drRace in dtRaces.Rows)
{
Latekick.BOL.Latekick.Race latekickrace = new Latekick.BOL.Latekick.Race();
latekickrace.RaceDate = LK.RaceDate;
latekickrace.RaceInfo = new RaceInfo();
latekickrace.RaceInfo.Surface = dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("Surface")].ToString().ToUpper();
if (dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("DistUnit")].ToString().ToUpper() == "Y")
{
latekickrace.RaceInfo.DistanceFurlongs = Math.Round(Double.Parse(dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("Distance")].ToString()) / 220, 1);
latekickrace.RaceInfo.DistanceYards = Double.Parse(dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("Distance")].ToString());
}
else if (dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("DistUnit")].ToString().ToUpper() == "F")
{
latekickrace.RaceInfo.DistanceFurlongs = Double.Parse(dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("Distance")].ToString()) / 100;
latekickrace.RaceInfo.DistanceYards = latekickrace.RaceInfo.DistanceFurlongs * 220;
}
latekickrace.RaceNumber = dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("RaceNr")].ToString();
latekickrace.RaceInfo.PostTime = dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("PostTime")].ToString();
latekickrace.RaceInfo.RaceNumber = Int32.Parse(dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("RaceNr")].ToString());
latekickrace.RaceInfo.AgeSexRestrictions = dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("AgeRestr")].ToString();
latekickrace.RaceInfo.RaceDescription = dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("RaceText")].ToString();
latekickrace.RaceInfo.RaceType = dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("StkOrClm")].ToString();
latekickrace.RaceInfo.Purse = Int32.Parse(dtRaces.Rows[cnt].ItemArray[dtRaces.Columns.IndexOf("Purse")].ToString());
latekickrace.RaceInfo.CD_Profile = new CD_Profile();
LK.Race[cnt] = latekickrace;
cnt++;
}
LK.NumberOfRaces = cnt.ToString();
}
public void ConvertRaces(List <Latekick.BOL.Brisnet.Bris_Race> races)
{
LK.Course = new Course();
LK.Course.CourseCode = races[0].Track.Trim();
LK.RaceDate = races[0].RaceDate;
LK.Race = new Race[races.Count];
int cnt = 0;
for (int r = 0; r < races.Count; r++)
{
Latekick.BOL.Brisnet.Bris_Race brisrace = races[r];
Latekick.BOL.Latekick.Race latekickrace = new Latekick.BOL.Latekick.Race();
latekickrace.RaceDate = LK.RaceDate;
latekickrace.RaceInfo = new RaceInfo();
latekickrace.RaceInfo.Surface = brisrace.Surface.ToUpper();
latekickrace.RaceInfo.DistanceFurlongs = Math.Round((double)brisrace.DistanceYards / 220, 1);
latekickrace.RaceInfo.DistanceYards = brisrace.DistanceYards;
latekickrace.RaceNumber = brisrace.RaceNumber.ToString();
string pt2 = brisrace.PostTimes.ToString();
string pt = pt2.Replace("\"", "");
latekickrace.RaceInfo.PostTime = pt.Substring(pt.IndexOf("("), pt.IndexOf(")") - pt.IndexOf("(") + 1).Replace("(", "").Replace(")", "");
latekickrace.RaceInfo.RaceNumber = brisrace.RaceNumber;
latekickrace.RaceInfo.AgeSexRestrictions = ParseAgeSexCode(brisrace.Restrictions);
latekickrace.RaceInfo.RaceDescription = brisrace.Conditions;
latekickrace.RaceInfo.RaceType = ParseRaceType(brisrace.RaceType);
latekickrace.RaceInfo.Purse = brisrace.Purse;
latekickrace.RaceInfo.CD_Profile = new CD_Profile();
LK.Race[r] = latekickrace;
cnt++;
}
LK.NumberOfRaces = cnt.ToString();
}
public void ConvertHorses(Latekick.BOL.Latekick.Race race, XElement xeHorses)
{
DataTable dtEntries = RaceDAL.GetEntries(xeHorses);
race.RaceInfo.NumberOfHorses = dtEntries.Rows.Count;
race.Entry = new Entry[race.RaceInfo.NumberOfHorses];
int e = 0;
#region entry + stats
foreach (DataRow dr in dtEntries.Rows)
{
Latekick.BOL.Latekick.Entry entry = new Latekick.BOL.Latekick.Entry();
entry.HorseName = dr.ItemArray[dtEntries.Columns.IndexOf("HorseName")].ToString();
try { entry.Draw = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Draw")].ToString()); }
catch { }
entry.SaddleClothNo = dr.ItemArray[dtEntries.Columns.IndexOf("SaddleClothNo")].ToString();
entry.JockeyName = dr.ItemArray[dtEntries.Columns.IndexOf("JockeyName")].ToString();
entry.TrainerName = dr.ItemArray[dtEntries.Columns.IndexOf("TrainerName")].ToString();
entry.OwnerName = dr.ItemArray[dtEntries.Columns.IndexOf("OwnerName")].ToString();
try { entry.Weight = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Weight")].ToString()); }
catch { }
//entry.ApprenticeAllowance = -1;
entry.Equipment = dr.ItemArray[dtEntries.Columns.IndexOf("Equipment")].ToString();
entry.Medication = dr.ItemArray[dtEntries.Columns.IndexOf("Medication")].ToString();
entry.Sire = dr.ItemArray[dtEntries.Columns.IndexOf("Sire")].ToString();
entry.Dam = dr.ItemArray[dtEntries.Columns.IndexOf("Dam")].ToString();
entry.DamSire = dr.ItemArray[dtEntries.Columns.IndexOf("DamSire")].ToString();
entry.Gender = dr.ItemArray[dtEntries.Columns.IndexOf("Gender")].ToString();
//entry.Age = race.RaceDate.Year - (brisentry.YearOfBirth + (brisentry.YearOfBirth > 90 ? 1900 : 2000));
try { entry.ML = double.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("ML")].ToString()); }
catch { }
entry.ProjectedRatings = new ProjectedRatings();
entry.RunningStyle = new RunningStyle();
entry.Stats = new Stats();
try { entry.Stats.LifeTime_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Lifetime_Runs")].ToString()); }
catch { }
try { entry.Stats.LifeTime_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Lifetime_Win")].ToString()); }
catch { }
try { entry.Stats.LifeTime_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Lifetime_Place")].ToString()); }
catch { }
try { entry.Stats.LifeTime_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Lifetime_Show")].ToString()); }
catch { }
try { entry.Stats.ThisYear_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_ThisYear_Runs")].ToString()); }
catch { }
try { entry.Stats.ThisYear_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_ThisYear_Win")].ToString()); }
catch { }
try { entry.Stats.ThisYear_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_ThisYear_Place")].ToString()); }
catch { }
try { entry.Stats.ThisYear_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_ThisYear_Show")].ToString()); }
catch { }
try { entry.Stats.LastYear_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_LastYear_Runs")].ToString()); }
catch { }
try { entry.Stats.LastYear_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_LastYear_Win")].ToString()); }
catch { }
try { entry.Stats.LastYear_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_LastYear_Place")].ToString()); }
catch { }
try { entry.Stats.LastYear_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_LastYear_Show")].ToString()); }
catch { }
try { entry.Stats.Course_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Course_Runs")].ToString()); }
catch { }
try { entry.Stats.Course_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Course_Win")].ToString()); }
catch { }
try { entry.Stats.Course_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Course_Place")].ToString()); }
catch { }
try { entry.Stats.Course_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Course_Show")].ToString()); }
catch { }
try { entry.Stats.Dirt_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Dirt_Runs")].ToString()); }
catch { }
try { entry.Stats.Dirt_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Dirt_Win")].ToString()); }
catch { }
try { entry.Stats.Dirt_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Dirt_Place")].ToString()); }
catch { }
try { entry.Stats.Dirt_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Dirt_Show")].ToString()); }
catch { }
try { entry.Stats.Turf_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Turf_Runs")].ToString()); }
catch { }
try { entry.Stats.Turf_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Turf_Win")].ToString()); }
catch { }
try { entry.Stats.Turf_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Turf_Place")].ToString()); }
catch { }
try { entry.Stats.Turf_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Turf_Show")].ToString()); }
catch { }
try { entry.Stats.AW_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_AW_Runs")].ToString()); }
catch { }
try { entry.Stats.AW_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_AW_Win")].ToString()); }
catch { }
try { entry.Stats.AW_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_AW_Place")].ToString()); }
catch { }
try { entry.Stats.AW_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_AW_Show")].ToString()); }
catch { }
try { entry.Stats.Wet_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Mud_Runs")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Soft_Runs")].ToString()); }
catch { }
try { entry.Stats.Wet_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Mud_Win")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Soft_Win")].ToString()); }
catch { }
try { entry.Stats.Wet_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Mud_Place")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Soft_Place")].ToString()); }
catch { }
try { entry.Stats.Wet_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Mud_Show")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Soft_Show")].ToString()); }
catch { }
try { entry.Stats.Distance_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceDirt_Runs")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceTurf_Runs")].ToString()); }
catch { }
try { entry.Stats.Distance_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceDirt_Win")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceTurf_Win")].ToString()); }
catch { }
try { entry.Stats.Distance_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceDirt_Place")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceTurf_Place")].ToString()); }
catch { }
try { entry.Stats.Distance_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceDirt_Show")].ToString()) + int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_DistanceTurf_Show")].ToString()); }
catch { }
try { entry.Stats.Jockey_30d_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Jockey_30d_Runs")].ToString()); }
catch { }
try { entry.Stats.Jockey_30d_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Jockey_30d_Win")].ToString()); }
catch { }
try { entry.Stats.Jockey_30d_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Jockey_30d_Place")].ToString()); }
catch { }
try { entry.Stats.Jockey_30d_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Jockey_30d_Show")].ToString()); }
catch { }
try { entry.Stats.Trainer_30d_Runs = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Trainer_30d_Runs")].ToString()); }
catch { }
try { entry.Stats.Trainer_30d_Win = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Trainer_30d_Win")].ToString()); }
catch { }
try { entry.Stats.Trainer_30d_Place = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Trainer_30d_Place")].ToString()); }
catch { }
try { entry.Stats.Trainer_30d_Show = int.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Trainer_30d_Show")].ToString()); }
catch { }
entry.Earnings = new Earnings();
try { entry.Earnings.EarningsLifeTime = (int)double.Parse(dr.ItemArray[dtEntries.Columns.IndexOf("Stats_Lifetime_Earnings")].ToString()); }
catch { }
race.Entry[e] = entry;
e++;
}
#endregion
}