public static LeagueResults_GetFixture_Result LeagueResult_GetFixture(int FixtureId) { using (ClubWorldDbContext db = new ClubWorldDbContext()) { return(db.LeagueResults_GetFixture(FixtureId).SingleOrDefault()); } }
public static void LeagueResult_AddResultPlayers(int ResultRef, int RegistrationRef) { using (ClubWorldDbContext db = new ClubWorldDbContext()) { db.LeagueResults_AddResultPlayers(ResultRef, RegistrationRef); } }
public static List <LeagueResult_TeamsForFixture_Result> LeagueResult_GetTeamsForFixture(int FixtureId) { using (ClubWorldDbContext db = new ClubWorldDbContext()) { return(db.LeagueResult_TeamsForFixture(FixtureId).ToList()); } }
public static int LeagueResult_AddResult(int FixtureRef, int HomeShots, int AwayShots) { ObjectParameter resultRef = new ObjectParameter("ResultId", typeof(Int32)); using (ClubWorldDbContext db = new ClubWorldDbContext()) { db.LeagueResults_AddResult(FixtureRef, HomeShots, AwayShots, resultRef); return((int)resultRef.Value); } }
public static List <LeagueFixtureType> LeagueResult_GetFixtureTypes() { using (ClubWorldDbContext db = new ClubWorldDbContext()) { return(( from ft in db.League_FixtureType select new LeagueFixtureType { FixturteTypeId = ft.FixtureTypeId, Description = ft.Name, RinksRequired = ft.RinksRequired }).ToList()); } }
public static void LeagueResult_InsertResultRecords(List <ResultRecord> resultList) { using (ClubWorldDbContext db = new ClubWorldDbContext()) { DbContextTransaction tran = db.Database.BeginTransaction(); foreach (ResultRecord res in resultList) { League_Result resEntity = new League_Result { FixtureRef = res.FixtureRef, ResultType = res.FixtureType, HomeShots = res.HomeShots, AwayShots = res.AwayShots }; db.League_Result.Add(resEntity); db.SaveChanges(); int resID = resEntity.ResultID; League_Fixtures fixEntity = db.League_Fixtures.SingleOrDefault(lf => lf.FixtureId == res.FixtureRef); fixEntity.FixtureTypeRef = res.FixtureType; foreach (Player p in res.HomeRink) { League_ResultPlayers lrp = new League_ResultPlayers { ResultRef = resEntity.ResultID, RegistrationRef = p.RegistrationId }; db.League_ResultPlayers.Add(lrp); } } db.SaveChanges(); tran.Commit(); } }
public List <Fixture> LeagueResults_FixturesForLeague(int LeagueId, int NoOfRecs = 10) { Repository <LeagueResults_FixturesForLeague_Result> repo = new Repository <LeagueResults_FixturesForLeague_Result>(db); using (ClubWorldDbContext db = new ClubWorldDbContext()) { return ((from fix in repo.(LeagueId) where fix.Completed == 0 select new Fixture { FixtureRef = fix.FixtureId, DiaryRef = fix.DiaryId, BookedDate = fix.BookedDate.ToString(@"ddd dd MMM yyyy"), HomeTeamName = fix.HomeName, HomeTeamRef = fix.HomeTeamRef, AwayTeamName = fix.AwayName, AwayTeamRef = fix.AwayTeamRef }).Take(NoOfRecs).ToList()); //return db.LeagueResults_FixturesForLeague(LeagueId).Take(NoOfRecs).ToList(); return ((from fix in db.LeagueResults_FixturesForLeague(LeagueId) where fix.Completed == 0 select new Fixture { FixtureRef = fix.FixtureId, DiaryRef = fix.DiaryId, BookedDate = fix.BookedDate.ToString(@"ddd dd MMM yyyy"), HomeTeamName = fix.HomeName, HomeTeamRef = fix.HomeTeamRef, AwayTeamName = fix.AwayName, AwayTeamRef = fix.AwayTeamRef }).Take(NoOfRecs).ToList()); } }
public void AssignDates(DateTime StartDate, List <String> SessionsRequested, List <string> DaysRequested, Boolean AllSessionsForDay) { IEnumerator <GetFreeRinks_Result> rinks = null; int?rinksRequired = _Repository.GetRinksPerGame(_fixtures.LeagueId); int p1 = ListToFlag(SessionsRequested); int p2 = ListToFlag(DaysRequested); int MaxRinksAvailable; List <GetFreeRinks_Result> r1; if (SessionsRequested.Count() > 1 & !AllSessionsForDay) { p1 = (int)Math.Pow(2, double.Parse(SessionsRequested[0]) - 1); r1 = _db.GetFreeRinks(StartDate, p1, p2, 0, rinksRequired).ToList(); p1 = (int)Math.Pow(2, double.Parse(SessionsRequested[1]) - 1); var r2 = _db.GetFreeRinks(StartDate, p1, p2, 1, rinksRequired).ToList(); rinks = r1.Union(r2).OrderBy(s => s.AvDate).GetEnumerator(); MaxRinksAvailable = r1.Sum(sr => sr.SpareRinks ?? default(int)) + r2.Sum(sr => sr.SpareRinks ?? default(int)); } else { r1 = _db.GetFreeRinks(StartDate, p1, p2, 2, rinksRequired).ToList(); MaxRinksAvailable = r1.Sum(sr => sr.SpareRinks ?? default(int)); rinks = r1.GetEnumerator(); } if (MaxRinksAvailable < _fixtures.TotalGames()) { return; } rinks.MoveNext(); int rinksLeft = rinks.Current.SpareRinks ?? default(int); int rinksLeftFlag = rinks.Current.RinkFlag ?? default(int); foreach (Games round in _fixtures.Series) { foreach (Game game in round.Round) { if (game.HomeTeam.Id * game.AwayTeam.Id > 0) // Zero equates to a bye { if (rinksLeft >= rinksRequired) { game.AssignedDate = rinks.Current.AvDate ?? DateTime.Now; int rinksUsedFlag = 0; int counter = 0; foreach (int r in FindFreeRinks(rinksLeftFlag)) { rinksUsedFlag |= r; rinksLeftFlag |= r; counter += 1; if (counter == rinksRequired) { rinksLeft -= counter; break; } } using (ClubWorldDbContext saveContext = new ClubWorldDbContext()) { saveContext.AddNewFixture(_fixtures.LeagueName, game.AssignedDate, 1, rinksUsedFlag, rinks.Current.SessionRef, _fixtures.LeagueId, game.HomeTeam.Id, game.AwayTeam.Id); } rinksUsedFlag = 0; } else { rinks.MoveNext(); rinksLeft = rinks.Current.SpareRinks ?? default(int); rinksLeftFlag = rinks.Current.RinkFlag ?? default(int); } } } rinks.MoveNext(); rinksLeft = rinks.Current.SpareRinks ?? default(int); rinksLeftFlag = rinks.Current.RinkFlag ?? default(int); } }
public Fixtures(ClubWorldDbContext context) : base(context) { }