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 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 void InitEntriesList(ObservableCollection <EntryModel> EntriesModel) { EntriesModel.Clear(); EntryDAL entryDAL = new EntryDAL(); List <EntryModel> entries = entryDAL.GetEntries(); foreach (var item in entries) { EntriesModel.Add(item); } }
public List <EntryModel> GetEntries(int CompanyId) { List <EntryModel> result = new List <EntryModel>(); try { result = EntryDAL.GetEntriesByCompanyId(CompanyId); } catch (Exception e) { } return(result); }
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 List <EntryModel> GetEntries(int CompanyId) { List <EntryModel> result = new List <EntryModel>(); try { EntryDAL entryDAL = new EntryDAL(); result = entryDAL.GetEntriesByCompanyId(CompanyId); } catch (Exception e) { throw new Exception(e.Message); } return(result); }
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 { } }