private void AddPicksForWeek(FakeGameRepository gameRepository, int weekId) { int minGameId = gameRepository.Get().Where(x => x.WeekId == weekId).Min(x => x.Id); int maxGameId = gameRepository.Get().Where(x => x.WeekId == weekId).Max(x => x.Id); int maxTeaserTeamId = 50; for (int i = 1; i <= maxTeaserTeamId; i++) { for (int j = 1; j <= 4; j++) { Pick p = new Pick(); p.Id = (list.Count == 0) ? 1 : list.Max(x => x.Id) + 1; int gameId = (p.Id % (maxGameId - minGameId + 1)) + minGameId; Game g = gameRepository.Get().Where(x => x.Id == gameId).Single(); p.GameId = g.Id; p.TeaserTeamId = i; p.ProTeamId = ((j % 2) == 0) ? g.HomeTeamId : g.AwayTeamId; list.Add(p); } } }
private void AddRows() { string[] h = { "Id", "HomeTeamId", "AwayTeamId", "Date", "Line", "HomeScore", "AwayScore", "WeekId" }; IGameRepository repo = new FakeGameRepository(); var list = repo.Get(); foreach (Game i in list) { Database.Insert(table, h, new string[] { i.Id.ToString(), i.HomeTeamId.ToString() , i.AwayTeamId.ToString() , i.Date.ToString() , i.Line.ToString() , i.HomeScore.ToString() , i.AwayScore.ToString() , i.WeekId.ToString() }); } }
// IGameRepository gameRepository public FakePickRepository() { FakeGameRepository gameRepository = new FakeGameRepository(); AddPicksForWeek(gameRepository, 1); AddPicksForWeek(gameRepository, 2); }