public void Run() { using (VilkaEntities context = new VilkaEntities()) { IQueryable <EventSiteData> liveEventSiteDatas = context.EventSiteDatas.Where((d) => d.Event.PrematchEnd <= DateTime.Now); Console.WriteLine(liveEventSiteDatas.Count() + "Event Datas found."); context.EventSiteDatas.RemoveRange(liveEventSiteDatas); IQueryable <Outcome> liveOutcomes = context.Outcomes.Where((d) => d.BetOffer.Event.PrematchEnd <= DateTime.Now); Console.WriteLine(liveOutcomes.Count() + "Outcomes found."); context.Outcomes.RemoveRange(liveOutcomes); IQueryable <BetOffer> liveBetOffers = context.BetOffers.Where((d) => d.Event.PrematchEnd <= DateTime.Now); Console.WriteLine(liveBetOffers.Count() + "Bet Offers found."); context.BetOffers.RemoveRange(liveBetOffers); IQueryable <Event> liveEvents = context.Events.Where((d) => d.PrematchEnd <= DateTime.Now); Console.WriteLine(liveEvents.Count() + "Events found."); context.Events.RemoveRange(liveEvents); Console.WriteLine("Removing live Events..."); Console.WriteLine(context.SaveChanges() + " rows affected."); Console.WriteLine(); } }
private void AnswerLeagueCompareRequest(CompareLeague l, bool answer) { using (VilkaEntities context = new VilkaEntities()) { if (answer == true) { League league = context.Leagues.Where((i) => i.Name == l.First || i.Name == l.Second).FirstOrDefault(); if (league == null) { League newLeague = new League(); newLeague.Name = l.First; newLeague.SportID = l.SportID; newLeague.RegionID = l.RegionID; league = context.Leagues.Add(newLeague); context.SaveChanges(); } Tuple <string, Region, Sport> keyFirst = new Tuple <string, Region, Sport>(l.First, l.Region, l.Sport); Tuple <string, Region, Sport> keySecond = new Tuple <string, Region, Sport>(l.Second, l.Region, l.Sport); if (!Dicts.LeagueDict.ContainsKey(keyFirst)) { Dicts.LeagueDict.Add(keyFirst, league); } if (!Dicts.LeagueDict.ContainsKey(keySecond)) { Dicts.LeagueDict.Add(keySecond, league); } } context.CompareLeagues.Remove(context.CompareLeagues.Where((i) => i.ID == l.ID).FirstOrDefault()); context.SaveChanges(); } }
public static BetTarget DBCopy(this BetTarget betTarget, VilkaEntities context) { if (betTarget == null) { return(null); } return(context.BetTargets.Where((b) => b.ID == betTarget.ID).FirstOrDefault()); }
public static Sport DBCopy(this Sport sport, VilkaEntities context) { if (sport == null) { return(null); } return(context.Sports.Where((s) => s.ID == sport.ID).FirstOrDefault()); }
public static OutcomeType DBCopy(this OutcomeType ot, VilkaEntities context) { if (ot == null) { return(null); } return(context.OutcomeTypes.Where((o) => o.ID == ot.ID).FirstOrDefault()); }
public static Event DBCopy(this Event ev, VilkaEntities context) { if (ev == null) { return(null); } return(context.Events.Where((e) => e.ID == ev.ID).FirstOrDefault()); }
public static BetType DBCopy(this BetType betType, VilkaEntities context) { if (betType == null) { return(null); } return(context.BetTypes.Where((b) => b.ID == betType.ID).FirstOrDefault()); }
public void ComperatorGetNextLeague(Action <string, string, string, string, Action <bool> > callback) { using (VilkaEntities context = new VilkaEntities()) { if (context.CompareLeagues.Count() == 0) { callback("Nothing Found", "Nothing Found", "Nothing Found", "Nothing Found", (a) => { }); } CompareLeague l = context.CompareLeagues.First(); callback(l.First, l.Second, l.Region.Name, l.Sport.Name, (a) => AnswerLeagueCompareRequest(l, a)); } }
public void EnsureBetTargets() { if (ID == 0) { throw new Exception("Better ID should be initialized before BetTargets."); } using (VilkaEntities context = new VilkaEntities()) { List <BetTargetMapping> mappings = context.BetTargetMappings.Where((mapping) => mapping.SiteID == ID).ToList(); foreach (BetTargetMapping mapping in mappings) { BetTargetMappings.Add(mapping.Name, mapping.BetTarget); } } }
public void EnsureOutcomeTypes() { if (ID == 0) { throw new Exception("Better ID should be initialized before OutcomeTypes."); } using (VilkaEntities context = new VilkaEntities()) { List <OutcomeTypeMapping> mappings = context.OutcomeTypeMappings.Where((mapping) => mapping.SiteID == ID).ToList(); foreach (OutcomeTypeMapping mapping in mappings) { OutcomeTypeMappings.Add(mapping.Name, mapping.OutcomeType); } } }
public void EnsureSports() { if (ID == 0) { throw new Exception("ID should be initialized before SportMappings."); } using (VilkaEntities context = new VilkaEntities()) { List <SportMapping> mappings = context.SportMappings.Where((mapping) => mapping.SiteID == ID).ToList(); foreach (SportMapping mapping in mappings) { SportMappings.Add(mapping.Name, mapping.Sport); } } }
public void EnsureID() { using (VilkaEntities context = new VilkaEntities()) { Site better = context.Sites.Where((site) => site.Name == Name).FirstOrDefault(); if (better == null) { better = new Site(); better.Name = Name; context.Sites.Add(better); context.SaveChanges(); } ID = better.ID; } }
public static Event FindEvent(Event ev) { using (VilkaEntities context = new VilkaEntities()) { foreach (Event item in context.Events) { if (!item.IsLive()) { if (Comparator.CompareEvents(item, ev)) { return(item); } } } return(null); } }