protected override void OnData() { base.OnData(); PPRD pprd = null; bool isRun = false; PPsElementJson ppse; int TopPP = 0; int RunPP = 0; string info = ""; var pps = Db.SQL <PP>("select r from PP r where r.ObjectNo <> ? order by r.Ad", 584); foreach (var pp in pps) { TopPP++; isRun = false; info = ""; pprd = Db.SQL <PPRD>("select r from PPRD r where r.PP = ? and r.Dnm = ?", pp, H.DnmRun).FirstOrDefault(); if (pprd != null) { isRun = true; RunPP++; info = pprd.CurRuns; } ppse = new PPsElementJson { PPoNo = (long)pp.GetObjectNo(), Ad = pp.Ad, RnkBaz = $"{pp.RnkBaz:#}", IsRun = isRun, CurRuns = info }; PPs.Add(ppse); } DD dd = Db.SQL <DD>("select r from DD r where r.Dnm = ?", H.DnmRun).FirstOrDefault(); HashSet <ulong> ppHS = new HashSet <ulong>(); // Toplam Oynamıs Uniqe Oyuncu var macs = Db.SQL <MAC>("select r from MAC r"); foreach (var mac in macs) { ppHS.Add(mac.HPP1oNo); // Oynuyor ppHS.Add(mac.GPP1oNo); // Oynuyor if (mac.SoD == "D") { ppHS.Add(mac.HPP2oNo); // Oynuyor ppHS.Add(mac.GPP2oNo); // Oynuyor } } Hdr = $"Oyuncular ► Toplam {TopPP:n0} ♦ Oynamış {ppHS.Count:n0} ► Son Dönem ► Kayıtlı {RunPP:n0} ♦ Oynamış {dd.OOC:n0}"; }
public void ConvertPastPerformances(Entry entry, XElement xePastPerformances) { try { DataTable dtPPs = RaceDAL.GetPastPerformances(xePastPerformances); PPs pps = new PPs(); pps.PP = new PP[dtPPs.Rows.Count]; for (int p = 0; p < dtPPs.Rows.Count; p++) { PP pp = new PP(); pp.RaceDate = DateTime.ParseExact(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("RaceDate")].ToString(), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture); pp.CourseCode = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("TrackCode")].ToString(); pp.RaceNumber = int.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("RaceNumber")].ToString()); pp.Breed = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Breed")].ToString(); pp.Country = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Country")].ToString(); pp.Going = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Going")].ToString(); pp.Surface = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Surface")].ToString(); double divider = 100; if (dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Surface")].ToString() == "Y") { divider = 220; } else if (dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Surface")].ToString() == "M") { divider = 201.168; } pp.DistanceFurlongs = Math.Abs(Math.Round((1 / divider) * double.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Distance")].ToString()), 1)); //pp.DistanceYards = pps_thishorse[p].DistanceYards; pp.Purse = int.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Purse")].ToString()); pp.ClaimPrice = int.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("ClaimPrice")].ToString());; pp.Odds = double.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Odds")].ToString()); pp.OfficialFinish = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("OfficialPosition")].ToString(); pp.OfficialPositionText = pp.OfficialFinish + "/" + dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("NumberOfRunners")].ToString(); pp.DistanceBeaten = double.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("DistanceBeaten")].ToString()) / 100; pp.Weight = int.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Weight")].ToString()); pp.JockeyName = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Jockey")].ToString(); pp.TrainerName = ""; pp.Medication = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Medication")].ToString(); pp.Equipment = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Equipment")].ToString(); pp.WinName = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("WinHorse")].ToString(); pp.PlaceName = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("PlaceHorse")].ToString(); pp.ShowName = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("ShowHorse")].ToString(); pp.Finish123 = pp.WinName + ";" + pp.PlaceName + ";" + pp.ShowName; pp.AgeSexRestrictions = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("AgeRestr")].ToString(); PP_Trackmaster pp_trackmaster = new PP_Trackmaster(); pp_trackmaster.TripComment = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("Comment")].ToString(); pp_trackmaster.LongTripComment = dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("LongComment")].ToString(); pp_trackmaster.SpeedFig = int.Parse(dtPPs.Rows[p].ItemArray[dtPPs.Columns.IndexOf("SpeedFig")].ToString()); pp.PP_Trackmaster = pp_trackmaster; pp.PP_Latekick = new PP_Latekick(); pps.PP[p] = pp; } entry.PPs = pps; } catch (Exception e3) { } }
public void ConvertPastPerformances(List <Latekick.BOL.Brisnet.Bris_PastPerformance> ppsBRIS) { foreach (Latekick.BOL.Latekick.Race race in LK.Race) { var draws_thisrace = (from d in ppsBRIS where d.RaceNumber_This_Day == int.Parse(race.RaceNumber) orderby d.Draw_This_Day select d.Draw_This_Day).Distinct(); race.RaceInfo.NumberOfHorses = draws_thisrace.Count(); foreach (int draw in draws_thisrace) { List <Latekick.BOL.Brisnet.Bris_PastPerformance> pps_thishorse = (from p in ppsBRIS where p.RaceNumber_This_Day == int.Parse(race.RaceNumber) && p.Draw_This_Day == draw select p).ToList(); PPs pps = new PPs(); pps.PP = new PP[pps_thishorse.Count()]; for (int p = 0; p < pps_thishorse.Count(); p++) { PP pp = new PP(); pp.RaceDate = pps_thishorse[p].RaceDate; pp.CourseCode = pps_thishorse[p].Track; pp.RaceNumber = pps_thishorse[p].RaceNumber; pp.Surface = pps_thishorse[p].Surface.ToUpper(); pp.Going = pps_thishorse[p].Going; pp.DistanceFurlongs = Math.Abs(Math.Round((double)pps_thishorse[p].DistanceYards / 220, 1)); pp.DistanceYards = pps_thishorse[p].DistanceYards; pp.Purse = pps_thishorse[p].Purse; pp.ClaimPrice = pps_thishorse[p].ClaimingPrice; pp.Odds = Math.Round(pps_thishorse[p].Odds, 1); pp.OfficialFinish = pps_thishorse[p].Pos_Finish; pp.OfficialPositionText = pps_thishorse[p].Pos_Finish + "/" + pps_thishorse[p].FieldSize; pp.Weight = pps_thishorse[p].Weight; pp.JockeyName = pps_thishorse[p].Jockey; pp.TrainerName = pps_thishorse[p].Trainer; pp.Medication = ParseMedicationCode(pps_thishorse[p].Medication); pp.Equipment = pps_thishorse[p].Equipment; pp.WinName = pps_thishorse[p].WinName; pp.PlaceName = pps_thishorse[p].PlaceName; pp.ShowName = pps_thishorse[p].ShowName; pp.Finish123 = pps_thishorse[p].WinName + ";" + pps_thishorse[p].PlaceName + ";" + pps_thishorse[p].ShowName; pp.AgeSexRestrictions = ParseAgeSexCode(pps_thishorse[p].Restrictions); pp.DistanceBeaten = pps_thishorse[p].BL_Finish; PP_Brisnet pp_brisnet = new PP_Brisnet(); pp_brisnet.SpeedFig = pps_thishorse[p].SpeedFig_BRIS; pp_brisnet.TripComment = pps_thishorse[p].TripComment; pp.PP_Brisnet = pp_brisnet; pp.PP_Latekick = new PP_Latekick(); pps.PP[p] = pp; } var latekickhorse = (from h in race.Entry where h.Draw == draw select h).First(); latekickhorse.PPs = pps; } } }