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;
}
}
}
