public void AddMatchCouponURL(MatchCouponURL entity)
{
Add <MatchCouponURL>(entity);
}
protected async Task <IEnumerable <Model.GenericMatchCoupon> > PersistCoupons(IEnumerable <Model.GenericMatchCoupon> coupons, DateTime couponDate, string tournament)
{
var ret = new List <Model.GenericMatchCoupon>();
var matches =
this.fixtureRepository
.GetMatchesForTournament(couponDate, tournament);
var sources =
coupons.Select(c => c.Source)
.Distinct()
.ToDictionary(s => s, s => this.bookmakerRepository.GetExternalSource(s));
var bestOddsBookmaker =
coupons.Select(c => c.Source)
.Distinct()
.ToDictionary(s => s + " Best Available", s => this.bookmakerRepository.FindByName(s + " Best Available"));
foreach (var coupon in coupons)
{
var retCoupon = Mapper.Map <Model.GenericMatchCoupon, Model.GenericMatchCoupon>(coupon);
var teamPlayerA = this.fixtureRepository.GetTeamOrPlayerFromNameAndMaybeFirstName(coupon.TeamOrPlayerA, coupon.FirstNameA);
var teamPlayerB = this.fixtureRepository.GetTeamOrPlayerFromNameAndMaybeFirstName(coupon.TeamOrPlayerB, coupon.FirstNameB);
var persistedMatch = this.fixtureRepository.GetMatchFromTeamSelections(teamPlayerA, teamPlayerB, couponDate);
if (persistedMatch == null)
{
continue; //won't get added to the return list but needs some reporting to the client
}
retCoupon.MatchId = persistedMatch.Id;
var matchCouponURLs = this.bookmakerRepository
.GetMatchCouponURLs(persistedMatch.Id)
.Where(m => m.ExternalSource.Source == coupon.Source)
.ToList();
if (matchCouponURLs.Count == 0)
{
var newMatchCouponURL = new MatchCouponURL()
{
MatchID = persistedMatch.Id,
ExternalSource = sources[coupon.Source],
MatchCouponURLString = coupon.MatchURL == null ? string.Empty : coupon.MatchURL.ToString()
};
this.bookmakerRepository.AddMatchCouponURL(newMatchCouponURL);
}
else
{
matchCouponURLs.First(u => u.ExternalSource.Source == coupon.Source).MatchCouponURLString = coupon.MatchURL == null ? string.Empty : coupon.MatchURL.ToString();
}
var outcomeProbs = this.predicitonRepository
.GetMatchOutcomeProbabilities(persistedMatch.Id)
.ToList();
if (outcomeProbs.Count == 0)
{
continue; //need a better way to deal with this, some message passing back to the caller
}
foreach (var outcome in coupon.HeadlineOdds.Keys)
{
var probForOutcome = outcomeProbs.First(p => p.MatchOutcomeID == (int)outcome);
var outcomeOdds = this.bookmakerRepository
.GetMatchOutcomeOdds(probForOutcome.Id)
.ToList();
var bestAvailableBookmaker = string.Format("{0} Best Available", coupon.Source);
Func <MatchOutcomeOdd, Model.Outcome, bool> predicate =
(o, oc) => o.ExternalSource.Source == coupon.Source &&
o.Bookmaker.BookmakerName == bestAvailableBookmaker &&
o.TimeStamp == outcomeOdds.Where(o2 => o.ExternalSource == o2.ExternalSource && o.Bookmaker == o2.Bookmaker)
.Select(x => x.TimeStamp)
.DefaultIfEmpty(DateTime.MinValue)
.Max() &&
o.Odd == (decimal)coupon.HeadlineOdds[oc];
var persisistedOdd = outcomeOdds.FirstOrDefault(x => predicate(x, outcome));
if (persisistedOdd == null)
{
var matchOutcomeOdd = new MatchOutcomeOdd()
{
MatchOutcomeProbabilitiesInMatchID = probForOutcome.Id,
Bookmaker = bestOddsBookmaker[bestAvailableBookmaker],
ExternalSource = sources[coupon.Source],
Odd = (decimal)coupon.HeadlineOdds[outcome],
TimeStamp = coupon.LastChecked
};
this.bookmakerRepository.AddMatchOutcomeOdd(matchOutcomeOdd);
retCoupon.HeadlineOdds.Add(outcome, coupon.HeadlineOdds[outcome]);
}
else
{
if (!retCoupon.HeadlineOdds.ContainsKey(outcome))
{
retCoupon.HeadlineOdds.Add(outcome, (double)persisistedOdd.Odd);//dubious
}
}
}
foreach (var outcome in coupon.ActualOdds.Keys)
{
var probForOutcome = outcomeProbs.First(p => p.MatchOutcomeID == (int)outcome);
var outcomeOdds = this.bookmakerRepository
.GetMatchOutcomeOdds(probForOutcome.Id)
.ToList();
var newActualOdds = new List <Model.GenericOdd>();
foreach (var odd in coupon.ActualOdds[outcome])
{
Func <MatchOutcomeOdd, Model.Outcome, bool> predicate =
(o, oc) => o.ExternalSource.Source == coupon.Source &&
(o.Bookmaker == null || o.Bookmaker.BookmakerName == odd.BookmakerName) &&
o.TimeStamp == outcomeOdds.Where(o2 => o.ExternalSource == o2.ExternalSource && (o.Bookmaker == null || o.Bookmaker == o2.Bookmaker))
.Select(x => x.TimeStamp)
.DefaultIfEmpty(DateTime.MinValue)
.Max() &&
o.Odd == (decimal)odd.DecimalOdds;
var persisistedOdd = outcomeOdds.FirstOrDefault(x => predicate(x, outcome));
if (persisistedOdd == null)
{
var matchOutcomeOdd = new MatchOutcomeOdd()
{
MatchOutcomeProbabilitiesInMatchID = probForOutcome.Id,
Bookmaker = this.bookmakerRepository.FindByName(odd.BookmakerName),
ExternalSource = sources[coupon.Source],
Odd = (decimal)odd.DecimalOdds,
TimeStamp = odd.TimeStamp,
ClickThroughURL = odd.ClickThroughURL == null ? null : odd.ClickThroughURL.ToString()
};
this.bookmakerRepository.AddMatchOutcomeOdd(matchOutcomeOdd);
if (!retCoupon.ActualOdds.ContainsKey(outcome))
{
retCoupon.ActualOdds.Add(outcome, new List <Model.GenericOdd>());
}
newActualOdds.Add(odd);
}
else
{
if (!retCoupon.ActualOdds.ContainsKey(outcome))
{
retCoupon.ActualOdds.Add(outcome, new List <Model.GenericOdd>());
}
var equivalentOdd = Mapper.Map <Model.GenericOdd, Model.GenericOdd>(odd);
equivalentOdd.MatchId = persistedMatch.Id;
equivalentOdd.TimeStamp = persisistedOdd.TimeStamp;
equivalentOdd.OddsBeforeCommission = (double)persisistedOdd.Odd;
newActualOdds.Add(equivalentOdd);
}
}
retCoupon.ActualOdds[outcome] = newActualOdds;
}
ret.Add(retCoupon);
}
await Task.Run(() => this.fixtureRepository.SaveChanges());
return(ret);
}
