public void UpdatePastPerformances()
{
foreach (Latekick.BOL.Latekick.Race race in latekickCard.Race)
{
latekick.com.Latekick2 ws = new Latekick.BLL.latekick.com.Latekick2();
foreach (Latekick.BOL.Latekick.Entry entry in race.Entry)
{
DataTable dtHistoricalRatings = ws.GetHistoricalRatings(latekickCard.RaceDate, entry.HorseName);
for (int h = 0; h < Math.Min(entry.PPs == null ? 0 : entry.PPs.PP.Length, dtHistoricalRatings.Rows.Count); h++)
{
DateTime SQLracedate = DateTime.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("RaceDate")].ToString());
if (entry.PPs.PP[h].RaceDate == SQLracedate)
{
try { entry.PPs.PP[h].PP_Latekick.ClassRating_GMR = int.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("CLASS_GMR")].ToString()); }
catch { }
entry.PPs.PP[h].PP_Latekick.Finish123_GMR = dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("Finish123")].ToString() == null ? "" : dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("Finish123")].ToString();
entry.PPs.PP[h].PP_Latekick.RaceType = dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("RaceType")].ToString() == null ? "" : dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("RaceType")].ToString();
try { entry.PPs.PP[h].PP_Latekick.Early = double.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("FF")].ToString()); }
catch { }
try { entry.PPs.PP[h].PP_Latekick.Middle = double.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("MF")].ToString()); }
catch { }
try { entry.PPs.PP[h].PP_Latekick.Late = double.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("LF")].ToString()); }
catch { }
try { entry.PPs.PP[h].PP_Latekick.Latekick = double.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("GMR_COMPO")].ToString()); }
catch { }
try { entry.PPs.PP[h].PP_Latekick.LateSpeed = double.Parse(dtHistoricalRatings.Rows[h].ItemArray[dtHistoricalRatings.Columns.IndexOf("LateSpeed")].ToString()); }
catch { }
}
else if (latekickCard.RaceDate > SQLracedate)
{
}
}
}
}
}
public void UpdateProjectedRatings()
{
foreach (Latekick.BOL.Latekick.Race race in latekickCard.Race)
{
latekick.com.Latekick2 ws = new Latekick.BLL.latekick.com.Latekick2();
foreach (Latekick.BOL.Latekick.Entry entry in race.Entry)
{
DataTable dtProjectedRatings = ws.GetProjectedRatings(latekickCard.RaceDate, latekickCard.Course.CourseCode, int.Parse(race.RaceNumber), entry.HorseName);
if (dtProjectedRatings.Rows.Count > 0)
{
race.RaceInfo.CourseName = dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("course_name")].ToString();
race.RaceInfo.RaceTypeLong = dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("race_type_long")].ToString();
try
{
race.RaceInfo.ClassRating = int.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("class_gmr")].ToString());
}
catch { }
entry.ML = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("ML")].ToString());
entry.LK_Odds = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("LK_Odds")].ToString());
entry.RunningStyle.PaceRuns = 0;
entry.RunningStyle.PaceWins = 0;
entry.RunningStyle.OffPaceRuns = 0;
entry.RunningStyle.OffPaceWins = 0;
entry.ProjectedRatings.Early = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Early")].ToString());
entry.ProjectedRatings.Middle = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Middle")].ToString());
entry.ProjectedRatings.Late = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Late")].ToString());
entry.ProjectedRatings.Average = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("AverageSpeed")].ToString());
entry.ProjectedRatings.Recent = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("RecentSpeed")].ToString());
entry.ProjectedRatings.Quirin = double.Parse(dtProjectedRatings.Rows[0].ItemArray[dtProjectedRatings.Columns.IndexOf("Quirin")].ToString());
}
}
}
}
public void UpdateWorkouts()
{
foreach (Latekick.BOL.Latekick.Race race in latekickCard.Race)
{
latekick.com.Latekick2 ws = new Latekick.BLL.latekick.com.Latekick2();
foreach (Latekick.BOL.Latekick.Entry entry in race.Entry)
{
DataTable dtWorkouts = ws.GetWorkouts(latekickCard.RaceDate, entry.HorseName);
for (int h = 0; h < Math.Min(entry.Workouts.Workout.Length, dtWorkouts.Rows.Count); h++)
{
int workrating;
int.TryParse(dtWorkouts.Rows[h].ItemArray[dtWorkouts.Columns.IndexOf("GMR_Workout")].ToString(), out workrating);
entry.Workouts.Workout[h].WorkRating = workrating;
entry.Workouts.Workout[h].WorkFromGate = int.Parse(dtWorkouts.Rows[h].ItemArray[dtWorkouts.Columns.IndexOf("Gate")].ToString());
entry.Workouts.Workout[h].WorkMates = dtWorkouts.Rows[h].ItemArray[dtWorkouts.Columns.IndexOf("WorkMates")].ToString();
}
}
}
}
public void UpdateRaces()
{
latekick.com.Latekick2 ws = new Latekick.BLL.latekick.com.Latekick2();
foreach (Latekick.BOL.Latekick.Race race in latekickCard.Race)
{
DataTable dtRaceInfo = ws.GetRaceDetails(latekickCard.RaceDate, latekickCard.Course.CourseCode, int.Parse(race.RaceNumber));
if (dtRaceInfo.Rows.Count > 0)
{
race.RaceInfo.CourseName = dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("course_name")].ToString();
race.RaceInfo.RaceTypeLong = dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("race_type_long")].ToString();
try
{
race.RaceInfo.ClassRating = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("class_gmr")].ToString());
}
catch { }
}
try
{
race.RaceInfo.MaxEarly = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("maxearly")].ToString());
}
catch { }
try
{
race.RaceInfo.MaxMiddle = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("maxmiddle")].ToString());
}
catch { }
try
{
race.RaceInfo.MaxLate = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("maxlate")].ToString());
}
catch { }
try
{
race.RaceInfo.MaxAverage = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("maxaverage")].ToString());
}
catch { }
try
{
race.RaceInfo.MaxRecent = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("maxrecent")].ToString());
}
catch { }
try
{
race.RaceInfo.MaxPace = double.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("maxpace")].ToString());
}
catch { }
try
{
race.RaceInfo.CD_Profile.Runs_All = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("runs_all")].ToString());
}
catch { race.RaceInfo.CD_Profile.Runs_All = 0; }
try
{
race.RaceInfo.CD_Profile.PaceWins_All = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("pacewins_all")].ToString());
}
catch { race.RaceInfo.CD_Profile.PaceWins_All = 0; }
try
{
race.RaceInfo.CD_Profile.StalkWins_All = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("stalkwins_all")].ToString());
}
catch { race.RaceInfo.CD_Profile.StalkWins_All = 0; }
try
{
race.RaceInfo.CD_Profile.CloseWins_All = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("closewins_all")].ToString());
}
catch { race.RaceInfo.CD_Profile.CloseWins_All = 0; }
try
{
race.RaceInfo.CD_Profile.Runs_Recent = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("runs_recent")].ToString());
}
catch { race.RaceInfo.CD_Profile.Runs_Recent = 0; }
try
{
race.RaceInfo.CD_Profile.PaceWins_Recent = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("pacewins_recent")].ToString());
}
catch { race.RaceInfo.CD_Profile.PaceWins_Recent = 0; }
try
{
race.RaceInfo.CD_Profile.StalkWins_Recent = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("stalkwins_recent")].ToString());
}
catch { race.RaceInfo.CD_Profile.StalkWins_Recent = 0; }
try
{
race.RaceInfo.CD_Profile.CloseWins_Recent = int.Parse(dtRaceInfo.Rows[0].ItemArray[dtRaceInfo.Columns.IndexOf("closewins_recent")].ToString());
}
catch { race.RaceInfo.CD_Profile.CloseWins_Recent = 0; }
}
}
