public PartialViewResult SaveLeague(ViewLeague viewLeague)
{
League league = new League();
if (ModelState.IsValid)
{
try
{
league.LeagueID = viewLeague.LeagueID;
league.LeagueName = viewLeague.LeagueName;
league.Description = viewLeague.LeagueDescription;
league.RegionID = viewLeague.RegionID;
viewLeague.LeagueID = BizMgr.SaveLeague(league);
BizMgr.SaveUserLeague(viewLeague.LeagueID, this.CurrentUser.SystemUserID);
}
catch (Exception ex)
{
LogController.LogError(ex, LogEntryType.NormalError, "", "", "", "League=" + viewLeague.LeagueID.ToString());
return PartialView("_League", viewLeague);
}
}
else
{
viewLeague.Regions = GetRegions(viewLeague.RegionID);
return PartialView("_League", viewLeague);
}
return PartialView("_League", GetLeague(viewLeague.LeagueID));
}
void buttonSave_Click(object sender, EventArgs e)
{
try
{
Page.Validate();
if (Page.IsValid)
{
League league = LeagueBL.GetBy(base.LeagueId, false);
if (league == null)
{
// insert
league = new League();
league.AssociationId = base.AssociationId;
league.Name = TextName.Text;
league.Description = TextDescription.Text;
league = LeagueBL.Insert(league);
}
else
{
// update
league.Name = TextName.Text;
// league.AssociationId = base.AssociationId;
league.Description = TextDescription.Text;
league = LeagueBL.Update(league);
}
if (league == null) { message.Text = "Save failed"; }
else { _redirectToListUrl(); }
}
}
catch (Exception ex)
{
message.Text = ex.Message;
}
}
public override void createTeams(MainForm.ProgressBarIncrement inc, League league)
{
if (league == League.College)
{
generateTopCollegeBasketballTeams(inc);
}
}
/// <summary>
/// Assigns a league a randomly-chosen theme from an existing finite list
/// </summary>
/// <returns>The theme.</returns>
public ColorTheme GetTheme(League league)
{
if(league.Id == null)
return null;
var remaining = AvailableLeagueColors.Except(UsedLeagueColors.Values).ToList();
if(remaining.Count == 0)
remaining.AddRange(AvailableLeagueColors);
var random = new Random().Next(0, remaining.Count - 1);
var color = remaining[random];
if(UsedLeagueColors.ContainsKey(league.Id))
{
color = UsedLeagueColors[league.Id];
}
else
{
UsedLeagueColors.Add(league.Id, color);
}
var theme = GetThemeFromColor(color);
if(Application.Current.Resources.ContainsKey($"{color}Medium"))
theme.Medium = (Color)Application.Current.Resources[$"{color}Medium"];
return theme;
}
public League Insert(League league)
{
league.Enabled = true;
league.ID = Guid.NewGuid();
league.Created = DateTime.Now;
league.Modified = DateTime.Now;
DataContextHelper.CurrentContext.Leagues.InsertOnSubmit(league);
DataContextHelper.CurrentContext.SubmitChanges();
return league;
}
public LeagueSeason Build()
{
if (league == null)
{
league = A.League.Build();
}
var leagueSeason = new LeagueSeason(league, A.Date, A.Date.AddMonths(9), A.Team.Repeat(18));
return leagueSeason;
}
public Match(int matchID, Team team1, Team team2, DateTime scheduledTime, int gameTime, int team1Score, int team2Score, List<GamePlayer> PlayerTeam1, List<GamePlayer> PlayerTeam2, League league)
{
_team1 = team1;
_team2 = team2;
_scheduledTime = scheduledTime;
_gameTime = gameTime;
_team1Score = team1Score;
_team2score = team2Score;
_playerTeam1 = PlayerTeam1;
_playerTeam2 = PlayerTeam2;
_matchID = matchID;
_league = league;
}
public void InsertLeagueErrorTest()
{
List<string> errors = new List<string>();
BLLeague.InsertLeague(null, ref errors);
Assert.AreEqual(1, errors.Count);
errors = new List<string>();
League league = new League();
BLLeague.InsertLeague(league, ref errors);
Assert.AreEqual(1, errors.Count);
}
public League Update(League league)
{
League value = DataContextHelper.CurrentContext.Leagues.FirstOrDefault<League>(n => n.ID.Equals(league.ID));
if (value != null)
{
value.Name = league.Name.Trim();
value.Website = league.Website.Trim();
value.Description = league.Description.Trim();
value.Enabled = league.Enabled;
value.Modified = DateTime.Now;
DataContextHelper.CurrentContext.SubmitChanges();
}
return value;
}
private static void AddTeamToLeague(Team team, League league)
{
if (league != null)
{
if (team.Leagues.Contains(league))
{
Console.WriteLine("Existing team in league: {0} belongs to {1}", team.TeamName, league.LeagueName);
}
else
{
team.Leagues.Add(league);
Console.WriteLine("Added team to league: {0} to league {1}", team.TeamName, league.LeagueName);
}
}
}
public void CreateChallenge(Athlete challenger, Athlete challengee, League league)
{
var time = TimeSpan.FromTicks(DateTime.Now.AddMinutes(60).Subtract(DateTime.Today).Ticks);
if(time.Ticks > TimeSpan.TicksPerDay)
time = time.Subtract(TimeSpan.FromTicks(TimeSpan.TicksPerDay));
SelectedTime = time;
SelectedDate = DateTime.Today;
var membership = league.Memberships.SingleOrDefault(m => m.AthleteId == challengee.Id);
Challenge = new Challenge {
BattleForRank = membership.CurrentRank,
ChallengerAthleteId = challenger.Id,
ChallengeeAthleteId = challengee.Id,
ProposedTime = SelectedDateTime,
LeagueId = league.Id,
};
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var l = new League();
if (!LeagueGuid.Equals(Guid.Empty))
{
l = _repo.Single<League>(LeagueGuid);
}
if (!string.IsNullOrEmpty(tbLeagueName.Text.Trim()))
l.LeagueName = tbLeagueName.Text.Trim();
else
throw new Exception("请输入分类名称");
l.LeagueOrgName = tbLeagueOrgName.Text.Trim();
l.LeagueSeason = tbLeagueSeason.Text.Trim();
l.LeagueTime = Convert.ToDateTime(tbLeagueTime.Text.Trim());
l.LeagueLogo = tbLeagueLogo.Text.Trim();
l.LeagueOrder = Convert.ToInt16(tbLeagueOrder.Text.Trim());
l.IsActive = cbIsActive.Checked;
if (LeagueGuid != Guid.Empty)
{
_repo.Update(l);
ClientScript.RegisterClientScriptBlock(typeof (string), "succeed",
"alert('更新成功');window.location.href = window.location.href", true);
}
else
{
_repo.Insert(l);
ClientScript.RegisterClientScriptBlock(typeof (string), "save",
"alert('添加成功');window.location.href = 'AdminLeague.aspx';", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterClientScriptBlock(typeof (string), "failed", $"alert('{ex.Message}')", true);
}
}
async public Task GetLeaderboard(bool forceRefresh = false)
{
using(new Busy(this))
{
await AzureService.Instance.LeagueManager.GetItemAsync(League.Id, forceRefresh);
_league = null;
League.LocalRefresh();
Memberships.Clear();
League.Memberships.ForEach(i => Memberships.Add(new MembershipViewModel { Membership = i }));
if(Memberships.Count == 0)
{
Memberships.Add(new MembershipViewModel
{
EmptyMessage = "This league has no members yet"
});
}
}
}
public static League GetLeagueDetail(int id, ref List<string> errors)
{
SqlConnection conn = new SqlConnection(connection_string);
League league = null;
try
{
string strSQL = "spGetLeagueDetail";
SqlDataAdapter mySA = new SqlDataAdapter(strSQL, conn);
mySA.SelectCommand.CommandType = CommandType.StoredProcedure;
mySA.SelectCommand.Parameters.Add(new SqlParameter("@league_id", SqlDbType.Int));
mySA.SelectCommand.Parameters["@league_id"].Value = id;
DataSet myDS = new DataSet();
mySA.Fill(myDS);
if (myDS.Tables[0].Rows.Count == 0)
return null;
league = new League();
league.id = id;
league.name = myDS.Tables[0].Rows[0]["name"].ToString();
}
catch (Exception e)
{
errors.Add("Error: " + e.ToString());
}
finally
{
conn.Dispose();
conn = null;
}
return league;
}
public static int InsertLeague(League league, ref List<string> errors)
{
if (league == null)
{
errors.Add("League cannot be null");
}
else
{
if (league.name == null)
{
errors.Add("League name cannot be null");
}
}
if (errors.Count > 0)
{
AsynchLog.LogNow(errors);
return 0;
}
return DALLeague.InsertLeague(league, ref errors);
}
public LeagueList()
{
Leagues = new ObservableCollection<League>();
var leagueA = new League("League A");
Leagues.Add(leagueA);
var leagueB = new League("League B");
Leagues.Add(leagueB);
var divisionA = new Division("Division A");
leagueB.Divisions.Add(divisionA);
var divisionB = new Division("Division B");
leagueB.Divisions.Add(divisionB);
var divisionC = new Division("Division C");
leagueB.Divisions.Add(divisionC);
var east = new Team("Team East");
divisionC.Teams.Add(east);
var west = new Team("Team West");
divisionC.Teams.Add(west);
var north = new Team("Team North");
divisionC.Teams.Add(north);
var south = new Team("Team South");
divisionC.Teams.Add(south);
var divisionD = new Division("Division D");
leagueB.Divisions.Add(divisionD);
var leagueC = new League("League C");
Leagues.Add(leagueC);
}
public void InsertGameTest()
{
List<string> errors = new List<string>();
Race race = new Race();
race.name = "Protoss";
race.code = 'P';
int raceID = DALRace.InsertRace(race, ref errors);
race.id = raceID;
Race race2 = new Race();
race2.name = "Terran";
race2.code = 'T';
raceID = DALRace.InsertRace(race2, ref errors);
race2.id = raceID;
Race race3 = new Race();
race3.name = "Zerg";
race3.code = 'Z';
raceID = DALRace.InsertRace(race3, ref errors);
race3.id = raceID;
League league = new League();
league.name = "Diamond";
int leagueID = DALLeague.InsertLeague(league, ref errors);
league.id = leagueID;
League league2 = new League();
league2.name = "Platinum";
leagueID = DALLeague.InsertLeague(league2, ref errors);
league2.id = leagueID;
League league3 = new League();
league3.name = "Master";
leagueID = DALLeague.InsertLeague(league3, ref errors);
league3.id = leagueID;
Map map = new Map();
map.name = "Shakuras Plateau";
map.spawns = 4;
map.size = "120x100";
int mapID = DALMap.InsertMap(map, ref errors);
map.id = mapID;
Map map2 = new Map();
map2.name = "Daybreak";
map2.spawns = 2;
map2.size = "100x100";
mapID = DALMap.InsertMap(map, ref errors);
map2.id = mapID;
Player player = new Player();
player.name = "Niter";
player.code = 777;
player.race = race3;
player.league = league2;
int playerID = DALPlayer.InsertPlayer(player, ref errors);
player.id = playerID;
Player player2 = new Player();
player2.name = "WolfBro";
player2.code = 123;
player2.race = race;
player2.league = league;
playerID = DALPlayer.InsertPlayer(player2, ref errors);
player2.id = playerID;
Player player3 = new Player();
player3.name = "Corone";
player3.code = 123;
player3.race = race2;
player3.league = league3;
playerID = DALPlayer.InsertPlayer(player3, ref errors);
player3.id = playerID;
Game game = new Game();
game.matchup = "ZVT";
game.length = "0:23:00";
game.player1 = player;
game.player1_race = player.race;
game.player2 = player2;
game.player2_race = player2.race;
game.winner = game.player1;
game.map = map;
int gameID = DALGame.InsertGame(game, ref errors);
game.id = gameID;
Assert.AreEqual(0, errors.Count);
Game verifyGame = DALGame.GetGameDetail(game.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(game.matchup, verifyGame.matchup);
Assert.AreEqual(game.length, verifyGame.length);
Assert.AreEqual(game.player1.id, verifyGame.player1.id);
Assert.AreEqual(game.player1_race.id, verifyGame.player1_race.id);
Assert.AreEqual(game.player2.id, verifyGame.player2.id);
Assert.AreEqual(game.player2_race.id, verifyGame.player2_race.id);
Game game2 = new Game();
game2.matchup = "TVP";
game2.length = "0:44:44";
game2.player1 = player2;
game2.player1_race = player2.race;
game2.player2 = player3;
game2.player2_race = player3.race;
game2.winner = game.player2;
game2.map = map2;
game2.id = game.id;
DALGame.UpdateGame(game2, ref errors);
verifyGame = DALGame.GetGameDetail(game2.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(game2.matchup, verifyGame.matchup);
Assert.AreEqual(game2.length, verifyGame.length);
Assert.AreEqual(game2.player1.id, verifyGame.player1.id);
Assert.AreEqual(game2.player1_race.id, verifyGame.player1_race.id);
Assert.AreEqual(game2.player2.id, verifyGame.player2.id);
Assert.AreEqual(game2.player2_race.id, verifyGame.player2_race.id);
List<Game> GameList = DALGame.GetGameList(ref errors);
DALGame.DeleteGame(game.id, ref errors);
DALPlayer.DeletePlayer(player.id, ref errors);
DALPlayer.DeletePlayer(player2.id, ref errors);
DALPlayer.DeletePlayer(player3.id, ref errors);
DALRace.DeleteRace(race.id, ref errors);
DALRace.DeleteRace(race2.id, ref errors);
DALRace.DeleteRace(race3.id, ref errors);
DALLeague.DeleteLeague(league.id, ref errors);
DALLeague.DeleteLeague(league2.id, ref errors);
DALLeague.DeleteLeague(league3.id, ref errors);
DALMap.DeleteMap(map.id, ref errors);
DALMap.DeleteMap(map2.id, ref errors);
Game verifyEmptyGame = DALGame.GetGameDetail(game.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(null, verifyEmptyGame);
}
public static void Delete(League league)
{
new LeagueDao().Delete(league);
}
public static League Update(League league)
{
return new LeagueDao().Update(league);
}
private void cbox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
League l = cbox.SelectedItem as League;
lbox.ItemsSource = l.Teams.Select(t => t.TName);
}
public Team(string teamId)
{
TeamId = teamId;
TeamsLeague = new League();
}
public static List <string> Generate(string conferenceName, string divisionName, string teamName, League league)
{
List <string> ret = new List <string>();
Team team = league.FindTeam(teamName);
GameList games = league.AllGames.FilterByTeams(new List <int> {
team.Id
});
TeamResult results = games.Results[team.Id];
ret.Add("Records:");
ret.Add($"Overall: {results.OverallRecord}");
ret.Add($"Conference: {results.ConferenceRecord}");
ret.Add($"Division: {results.DivisionRecord}");
ret.Add(string.Empty);
/*
* Cross-Conference win/loss
* Division chances
* Rankings
* PF/PA
*/
return(ret);
}
public Task TransferLeagueManager(League league, FantasyCriticUser newManager)
{
return(_fantasyCriticRepo.TransferLeagueManager(league, newManager));
}
public static void Main()
{
var xmlDoc = XElement.Load("../../leagues-and-teams.xml");
using (var context = new FootballEntities())
{
var counter = 1;
foreach (var league in xmlDoc.Elements())
{
Console.WriteLine("Processing league #{0} ...", counter++);
var leagueInXml = league.Element("league-name");
bool leagueExistsInQuery = leagueInXml != null;
if (leagueInXml != null)
{
var leagueInDb = context.Leagues.FirstOrDefault(l => l.LeagueName == leagueInXml.Value);
if (leagueInDb == null)
{
var newLeague = new League { LeagueName = league.Element("league-name").Value };
context.Leagues.Add(newLeague);
Console.WriteLine("Created league: {0}", newLeague.LeagueName);
context.SaveChanges();
}
else
{
Console.WriteLine("Existing league: {0}", leagueInDb.LeagueName);
}
}
var teamsInXml = league.Element("teams");
bool teamsExistsInQuery = teamsInXml != null;
if (teamsInXml != null && teamsInXml.Descendants().Any())
{
foreach (var team in teamsInXml.Descendants())
{
string teamNameInXml = team.Attribute("name").Value;
string teamCountryInXml = null;
if (team.Attribute("country") != null)
{
teamCountryInXml = team.Attribute("country").Value;
}
// check does team exists
var teamInDb = context.Teams.FirstOrDefault(t => t.TeamName == teamNameInXml);
if (teamInDb != null)
{
if ((teamInDb.Country != null) && teamInDb.Country.CountryName == (teamCountryInXml ?? ""))
{
// team exists
Console.WriteLine(
"Existing team: {0} ({1})",
teamNameInXml,
teamCountryInXml ?? "no country");
// Check and eventually add team to league if necessary
if (leagueExistsInQuery && teamsExistsInQuery)
{
var teamLeague =
teamInDb.Leagues.FirstOrDefault(l => l.LeagueName == leagueInXml.Value);
if (teamLeague != null)
{
Console.WriteLine("Existing team in league: {0} belongs to {1}",
teamNameInXml,
teamLeague.LeagueName);
}
else
{
teamInDb.Leagues.Add(teamLeague);
context.SaveChanges();
Console.WriteLine("Added team to league: {0} to league {1}",
teamNameInXml, leagueInXml.Value);
}
}
}
}
else
{
// not exisiting
var newTeam = new Team { TeamName = teamNameInXml };
if (teamCountryInXml != null)
{
// get country code
var teamCountryCode = context.Countries
.Where(c => c.CountryName == teamCountryInXml)
.Select(c => c.CountryCode).FirstOrDefault();
if (teamCountryCode != null)
{
newTeam.CountryCode = teamCountryCode;
}
}
context.Teams.Add(newTeam);
context.SaveChanges();
Console.WriteLine(
"Created team: {0} ({1})",
teamNameInXml,
teamCountryInXml ?? "no country");
// Just add new team to League
if (leagueExistsInQuery && teamsExistsInQuery)
{
var teamLeague =
context.Leagues.FirstOrDefault(l => l.LeagueName == leagueInXml.Value);
newTeam.Leagues.Add(teamLeague);
context.SaveChanges();
Console.WriteLine("Added team to league: {0} to league {1}",
teamNameInXml, leagueInXml.Value);
}
}
}
}
}
context.SaveChanges();
}
}
public void Delete(League league)
{
db.Leagues.Remove(league);
db.SaveChanges();
}
public void Add(League league)
{
db.Leagues.Add(league);
db.SaveChanges();
}
public Task CreateInviteLink(League league)
{
LeagueInviteLink link = new LeagueInviteLink(Guid.NewGuid(), league, Guid.NewGuid(), true);
return(_fantasyCriticRepo.SaveInviteLink(link));
}
public async Task <IReadOnlyList <FantasyCriticUserRemovable> > GetUsersWithRemoveStatus(League league)
{
var usersInLeague = await _fantasyCriticRepo.GetUsersInLeague(league.LeagueID);
List <LeagueYear> leagueYears = new List <LeagueYear>();
List <Publisher> allPublishers = new List <Publisher>();
foreach (var year in league.Years)
{
var leagueYear = await _fantasyCriticRepo.GetLeagueYear(league, year);
leagueYears.Add(leagueYear);
var publishersForYear = leagueYear.Publishers;
allPublishers.AddRange(publishersForYear);
}
List <FantasyCriticUserRemovable> usersWithStatus = new List <FantasyCriticUserRemovable>();
foreach (var user in usersInLeague)
{
bool userRemovable = !league.LeagueManager.Equals(user);
foreach (var leagueYear in leagueYears)
{
var publishersForYear = allPublishers.Where(x => x.LeagueYearKey.Year == leagueYear.Year);
if (!publishersForYear.Any(x => x.User.Equals(user)))
{
//User did not play in this year, safe to remove.
continue;
}
if (leagueYear.PlayStatus.PlayStarted)
{
userRemovable = false;
}
}
usersWithStatus.Add(new FantasyCriticUserRemovable(user, userRemovable));
}
return(usersWithStatus);
}
public Task <IReadOnlyList <FantasyCriticUser> > GetUsersInLeague(League league)
{
return(_fantasyCriticRepo.GetUsersInLeague(league.LeagueID));
}
public Task <IReadOnlyList <LeagueInvite> > GetOutstandingInvitees(League league)
{
return(_fantasyCriticRepo.GetOutstandingInvitees(league));
}
static void Main(string[] args)
{
League league = new League("Premier League", "2020/2021");
#region Liverpool
Trainer liverpoolTrainer = new Trainer("Jurgen", "Klop", 50, 15);
Team liverpool = new Team("Liverpool", liverpoolTrainer);
Player liverpoolGk = new Player("Alisson", "Beker", 28, Position.Gk);
Player liverpoolDef = new Player("Virgil", "Van Dyk", 26, Position.Def);
Player liverpoolMid = new Player("James", "Milner", 33, Position.Mid);
Player liverpoolFwd = new Player("Mo", "Salah", 28, Position.Fwd);
liverpool.Players.Add(liverpoolGk);
liverpool.Players.Add(liverpoolDef);
liverpool.Players.Add(liverpoolMid);
liverpool.Players.Add(liverpoolFwd);
league.Teams.Add(liverpool);
#endregion
#region Chelsea
Trainer chelseaTrainer = new Trainer("Tomas", "Tuhel", 48, 10);
Team chelsea = new Team("Chelsea", chelseaTrainer);
Player chelseaGk = new Player("Forlan", "Mendy", 20, Position.Gk);
Player chelseaDef = new Player("Zuma", "Kurt", 22, Position.Def);
Player chelseaMid = new Player("Jason", "Mount", 22, Position.Mid);
Player chelseaFwd = new Player("Olivie", "Giroud", 28, Position.Fwd);
chelsea.Players.Add(chelseaGk);
chelsea.Players.Add(chelseaDef);
chelsea.Players.Add(chelseaMid);
chelsea.Players.Add(chelseaFwd);
league.Teams.Add(chelsea);
#endregion
#region ManCity
Trainer cityTrainer = new Trainer("Pep", "Gvardiola", 55, 20);
Team city = new Team("Manchester City", cityTrainer);
Player cityGk = new Player("Ederson", "Moraes", 25, Position.Gk);
Player cityDef = new Player("John", "Stones", 22, Position.Def);
Player cityMid = new Player("Kevin", "De Bryne", 24, Position.Mid);
Player cityFwd = new Player("Kun", "Augero", 32, Position.Fwd);
city.Players.Add(cityGk);
city.Players.Add(cityDef);
city.Players.Add(cityMid);
city.Players.Add(cityFwd);
league.Teams.Add(city);
#endregion
#region ManUtd
Trainer manUtdTrainer = new Trainer("Ole", "Solsker", 55, 20);
Team manUtd = new Team("Manchester United", manUtdTrainer);
Player manUtdGk = new Player("David", "De Gea", 30, Position.Gk);
Player manUtdDef = new Player("Herry", "Magvier", 28, Position.Def);
Player manUtdMid = new Player("Bruno", "Fernandes", 24, Position.Mid);
Player manUtdFwd = new Player("Markus", "Rashvord", 22, Position.Fwd);
manUtd.Players.Add(manUtdGk);
manUtd.Players.Add(manUtdDef);
manUtd.Players.Add(manUtdMid);
manUtd.Players.Add(manUtdFwd);
league.Teams.Add(manUtd);
#endregion
#region Leicester
Trainer leicesterTrainer = new Trainer("Brandon", "Rodzers", 55, 20);
Team leicester = new Team("Leicester", leicesterTrainer);
Player leicesterGk = new Player("Bernd", "Leno", 25, Position.Gk);
Player leicesterDef = new Player("Hecrot", "Bellerin", 25, Position.Def);
Player leicesterMid = new Player("Saka", "Bulayo", 26, Position.Mid);
Player leicesterFwd = new Player("Pepe", "Nicolas", 33, Position.Fwd);
leicester.Players.Add(leicesterGk);
leicester.Players.Add(leicesterDef);
leicester.Players.Add(leicesterMid);
leicester.Players.Add(leicesterFwd);
//league.Teams.Add(leicester);
#endregion
#region Arsenal
Trainer arsenalTrainer = new Trainer("Brandon", "Rodzers", 55, 20);
Team arsenal = new Team("Arsenal", arsenalTrainer);
Player arsenalGk = new Player("Kasper", "Shmajhel", 30, Position.Gk);
Player arsenalDef = new Player("Jony", "Evans", 25, Position.Def);
Player arsenalMid = new Player("Juri", "Tilemans", 26, Position.Mid);
Player arsenalFwd = new Player("Jammy", "Vardy", 33, Position.Fwd);
arsenal.Players.Add(arsenalGk);
arsenal.Players.Add(arsenalDef);
arsenal.Players.Add(arsenalMid);
arsenal.Players.Add(arsenalFwd);
league.Teams.Add(arsenal);
#endregion
league.CreateMatches();
Console.Write(league.GetInfo());
Console.Write(league.GetMatches());
Console.WriteLine(league.GetTable());
Console.WriteLine("============Odds===============");
GenerateOdds(league);
Console.WriteLine("========Press a key to start simulation");
Console.ReadLine();
Console.WriteLine("===============Lets Play==================");
league.SimulateAllMatches();
Console.Write(league.GetMatches());
Console.WriteLine(league.GetTable());
}
public Task SetArchiveStatusForUser(League league, bool archive, FantasyCriticUser user)
{
return(_fantasyCriticRepo.SetArchiveStatusForUser(league, archive, user));
}
public async Task <bool> UserIsActiveInLeagueYear(League league, int year, FantasyCriticUser user)
{
var activePlayers = await GetActivePlayersForLeagueYear(league, year);
return(activePlayers.Any(x => x.Id == user.Id));
}
private static void SetNextMatchTeams(Team match1Team, Match nextMatch, Team match2Team, League team1League,
League team2League)
{
if (match2Team.IsFreeTicket)
{
// team 2 is a free ticket
nextMatch.HomeTeamId = match1Team.Id;
nextMatch.HomeTeam = match1Team;
nextMatch.GuestTeamId = match2Team.Id;
nextMatch.GuestTeam = match2Team;
SetResultForAbordedMatch(nextMatch);
}
else if (match1Team.IsFreeTicket)
{
// team 1 is a free ticket
nextMatch.HomeTeamId = match2Team.Id;
nextMatch.HomeTeam = match2Team;
nextMatch.GuestTeamId = match1Team.Id;
nextMatch.GuestTeam = match1Team;
SetResultForAbordedMatch(nextMatch);
}
else if (team1League.Number > team2League.Number)
{
// none of the teams is a free ticket, league number decides home team
nextMatch.HomeTeamId = match2Team.Id;
nextMatch.HomeTeam = match2Team;
nextMatch.GuestTeamId = match1Team.Id;
nextMatch.GuestTeam = match1Team;
}
else if (team1League.Number < team2League.Number)
{
// none of the teams is a free ticket, league number decides home team
nextMatch.HomeTeamId = match1Team.Id;
nextMatch.HomeTeam = match1Team;
nextMatch.GuestTeamId = match2Team.Id;
nextMatch.GuestTeam = match2Team;
}
else
{
var random = new Random();
if (random.Next(0, 999) < 500)
{
nextMatch.HomeTeamId = match1Team.Id;
nextMatch.HomeTeam = match1Team;
nextMatch.GuestTeamId = match2Team.Id;
nextMatch.GuestTeam = match2Team;
}
else
{
nextMatch.HomeTeamId = match2Team.Id;
nextMatch.HomeTeam = match2Team;
nextMatch.GuestTeamId = match1Team.Id;
nextMatch.GuestTeam = match1Team;
}
}
}
public static DataMatrix GenerateMatrix(string conferenceName, string divisionName, string teamName, League league)
{
return(null);
}
protected PlayerLeagueStats AddPlayerLeagueStats(Player player, Season season, League league, int totalPoints, int totalFouls, int gamesPlayed, int mvpAwards)
{
PlayerLeagueStats stats = new PlayerLeagueStats(player, season, league, totalPoints, totalFouls, gamesPlayed, mvpAwards);
//statsRepository.SaveOrUpdatePlayerLeagueStats(stats);
//FlushSessionAndEvict(stats);
return(stats);
}
protected override void Seed(RsbContext context)
{
var weeks = new List <Week>
{
new Week
{
Id = Guid.NewGuid(),
Name = "Week 1",
Order = 1,
StartDateTime = new DateTime(2016, 8, 24, 20, 0, 0),
EndDateTime = new DateTime(2016, 8, 24, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Week 2",
Order = 2,
StartDateTime = new DateTime(2016, 8, 24, 20, 0, 0),
EndDateTime = new DateTime(2016, 8, 31, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Week 3",
Order = 3,
StartDateTime = new DateTime(2016, 8, 31, 20, 0, 0),
EndDateTime = new DateTime(2016, 9, 7, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Week 4",
Order = 4,
StartDateTime = new DateTime(2016, 9, 7, 20, 0, 0),
EndDateTime = new DateTime(2016, 9, 14, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Week 5",
Order = 5,
StartDateTime = new DateTime(2016, 9, 14, 20, 0, 0),
EndDateTime = new DateTime(2016, 9, 21, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Week 6",
Order = 6,
StartDateTime = new DateTime(2016, 9, 21, 20, 0, 0),
EndDateTime = new DateTime(2016, 9, 28, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Week 7",
Order = 7,
StartDateTime = new DateTime(2016, 9, 28, 20, 0, 0),
EndDateTime = new DateTime(2016, 10, 5, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Quarter Final",
Order = 8,
StartDateTime = new DateTime(2016, 10, 5, 20, 0, 0),
EndDateTime = new DateTime(2016, 10, 12, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Semi Final",
Order = 9,
StartDateTime = new DateTime(2016, 10, 12, 20, 0, 0),
EndDateTime = new DateTime(2016, 10, 19, 19, 59, 59)
},
new Week
{
Id = Guid.NewGuid(),
Name = "Final",
Order = 10,
StartDateTime = new DateTime(2016, 10, 19, 20, 0, 0),
EndDateTime = new DateTime(2016, 10, 26, 19, 59, 59)
},
};
weeks.ForEach(s => context.Weeks.Add(s));
var bakers = new List <Baker>
{
new Baker
{
Id = Guid.NewGuid(),
Name = "Andrew",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Benjamina",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Candice",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Jane",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Kate",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Lee",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Louise",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Michael",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Rav",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Selasi",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Tom",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
},
new Baker
{
Id = Guid.NewGuid(),
Name = "Val",
Weeks = new List <Week> {
weeks.OrderBy(o => o.Order).First()
}
}
};
bakers.ForEach(s => context.Bakers.Add(s));
var user1 = new User
{
UserId = new Guid("09e010a5-eac6-42bc-bfdd-1edf3cb71b82"),
Name = "Andy Brown",
Predictions = new List <Prediction>()
};
var user2 = new User
{
UserId = new Guid("bf75a638-b322-4027-8b4c-bdb33b790e38"),
Name = "Louise Brown",
Predictions = new List <Prediction>()
};
var league1 = new League
{
Id = Guid.NewGuid(),
Code = "BOB111",
Name = "Test League 1",
Users = new List <User> {
user1
}
};
var league2 = new League
{
Id = Guid.NewGuid(),
Code = "BOB112",
Name = "Test League 2",
Users = new List <User> {
user1, user2
}
};
context.Users.Add(user1);
context.Leagues.Add(league1);
context.Leagues.Add(league2);
context.SaveChanges();
var week2Id = context.Weeks
.Single(o => o.Order == 2).Id;
var week2User1StarId = context.Bakers.Single(o => o.Name == "Candice").Id;
var week2User1ExitId = context.Bakers.Single(o => o.Name == "Andrew").Id;
var week2User2StarId = context.Bakers.Single(o => o.Name == "Benjamina").Id;
var week2User2ExitId = context.Bakers.Single(o => o.Name == "Selasi").Id;
user1.Predictions.Add(new Prediction {
ExitBakerId = week2User1ExitId,
StarBakerId = week2User1StarId,
WeekId = week2Id, PredictionId = Guid.NewGuid()
});
user2.Predictions.Add(new Prediction {
ExitBakerId = week2User2ExitId,
StarBakerId = week2User2StarId,
WeekId = week2Id, PredictionId = Guid.NewGuid()
});
var week3Id = context.Weeks
.Single(o => o.Order == 3).Id;
var week3User1StarId = context.Bakers.Single(o => o.Name == "Andrew").Id;
var week3User1ExitId = context.Bakers.Single(o => o.Name == "Candice").Id;
var week3User2StarId = context.Bakers.Single(o => o.Name == "Candice").Id;
var week3User2ExitId = context.Bakers.Single(o => o.Name == "Selasi").Id;
user1.Predictions.Add(new Prediction {
ExitBakerId = week3User1ExitId,
StarBakerId = week3User1StarId,
WeekId = week3Id, PredictionId = Guid.NewGuid()
});
user2.Predictions.Add(new Prediction {
ExitBakerId = week3User2ExitId,
StarBakerId = week3User2StarId,
WeekId = week3Id, PredictionId = Guid.NewGuid()
});
var week4Id = context.Weeks
.Single(o => o.Order == 4).Id;
var week4User1StarId = context.Bakers.Single(o => o.Name == "Andrew").Id;
var week4User1ExitId = context.Bakers.Single(o => o.Name == "Selasi").Id;
var week4User2StarId = context.Bakers.Single(o => o.Name == "Selasi").Id;
var week4User2ExitId = context.Bakers.Single(o => o.Name == "Kate").Id;
user1.Predictions.Add(new Prediction {
ExitBakerId = week4User1ExitId,
StarBakerId = week4User1StarId,
WeekId = week4Id, PredictionId = Guid.NewGuid()
});
user2.Predictions.Add(new Prediction {
ExitBakerId = week4User2ExitId,
StarBakerId = week4User2StarId,
WeekId = week4Id, PredictionId = Guid.NewGuid()
});
var week5Id = context.Weeks
.Single(o => o.Order == 5).Id;
var week5User1StarId = context.Bakers.Single(o => o.Name == "Lee").Id;
var week5User1ExitId = context.Bakers.Single(o => o.Name == "Val").Id;
var week5User2StarId = context.Bakers.Single(o => o.Name == "Kate").Id;
var week5User2ExitId = context.Bakers.Single(o => o.Name == "Selasi").Id;
user1.Predictions.Add(new Prediction {
ExitBakerId = week5User1ExitId,
StarBakerId = week5User1StarId,
WeekId = week5Id, PredictionId = Guid.NewGuid()
});
user2.Predictions.Add(new Prediction {
ExitBakerId = week5User2ExitId,
StarBakerId = week5User2StarId,
WeekId = week5Id, PredictionId = Guid.NewGuid()
});
// var week6Id = context.Weeks
// .Single(o => o.Order == 6).Id;
// var week6User1StarId = context.Bakers.Single(o => o.Name == "Ian Cumming").Id;
// var week6User1ExitId = context.Bakers.Single(o => o.Name == "Mat Riley").Id;
// var week6User2StarId = context.Bakers.Single(o => o.Name == "Flora Shedden").Id;
// var week6User2ExitId = context.Bakers.Single(o => o.Name == "Paul").Id;
// user1.Predictions.Add(new Prediction { ExitBakerId = week6User1ExitId,
// StarBakerId = week6User1StarId,
// WeekId = week6Id, PredictionId = Guid.NewGuid()});
// user2.Predictions.Add(new Prediction { ExitBakerId = week6User2ExitId,
// StarBakerId = week6User2StarId,
// WeekId = week6Id, PredictionId = Guid.NewGuid() });
//
//
//
//
// var week7Id = context.Weeks
// .Single(o => o.Order == 7).Id;
// var week7User1StarId = context.Bakers.Single(o => o.Name == "Flora Shedden").Id;
// var week7User1ExitId = context.Bakers.Single(o => o.Name == "Ian Cumming").Id;
// var week7User2StarId = context.Bakers.Single(o => o.Name == "Flora Shedden").Id;
// var week7User2ExitId = context.Bakers.Single(o => o.Name == "Paul").Id;
// user1.Predictions.Add(new Prediction { ExitBakerId = week7User1ExitId,
// StarBakerId = week7User1StarId,
// WeekId = week7Id, PredictionId = Guid.NewGuid()});
// user2.Predictions.Add(new Prediction { ExitBakerId = week7User2ExitId,
// StarBakerId = week7User2StarId,
// WeekId = week7Id, PredictionId = Guid.NewGuid() });
//
//
//
//
// var week8Id = context.Weeks
// .Single(o => o.Order == 8).Id;
// var week8User1StarId = context.Bakers.Single(o => o.Name == "Flora Shedden").Id;
// var week8User1ExitId = context.Bakers.Single(o => o.Name == "Tamal Ray").Id;
// var week8User2StarId = context.Bakers.Single(o => o.Name == "Ian Cumming").Id;
// var week8User2ExitId = context.Bakers.Single(o => o.Name == "Paul").Id;
// user1.Predictions.Add(new Prediction { ExitBakerId = week8User1ExitId,
// StarBakerId = week8User1StarId,
// WeekId = week8Id, PredictionId = Guid.NewGuid()});
// user2.Predictions.Add(new Prediction { ExitBakerId = week8User2ExitId,
// StarBakerId = week8User2StarId,
// WeekId = week8Id, PredictionId = Guid.NewGuid() });
//
// context.SaveChanges();
context.Weeks.Single(o => o.Order == 1).StarBaker = context.Bakers.Single(o => o.Name == "Andrew");
context.Weeks.Single(o => o.Order == 1).ExitBaker = context.Bakers.Single(o => o.Name == "Benjamina");
context.Weeks.Single(o => o.Order == 2).StarBaker = context.Bakers.Single(o => o.Name == "Andrew");
context.Weeks.Single(o => o.Order == 2).ExitBaker = context.Bakers.Single(o => o.Name == "Louise");
context.Weeks.Single(o => o.Order == 3).StarBaker = context.Bakers.Single(o => o.Name == "Kate");
context.Weeks.Single(o => o.Order == 3).ExitBaker = context.Bakers.Single(o => o.Name == "Selasi");
context.Weeks.Single(o => o.Order == 4).StarBaker = context.Bakers.Single(o => o.Name == "Lee");
context.Weeks.Single(o => o.Order == 4).ExitBaker = context.Bakers.Single(o => o.Name == "Val");
context.Weeks.Single(o => o.Order == 5).StarBaker = context.Bakers.Single(o => o.Name == "Jane");
context.Weeks.Single(o => o.Order == 5).ExitBaker = context.Bakers.Single(o => o.Name == "Lee");
//
// context.Weeks.Single(o => o.Order == 6).StarBaker = context.Bakers.Single(o => o.Name == "Mat Riley");
// context.Weeks.Single(o => o.Order == 6).ExitBaker = context.Bakers.Single(o => o.Name == "Alvin Magallanes");
//
// context.Weeks.Single(o => o.Order == 7).StarBaker = context.Bakers.Single(o => o.Name == "Tamal Ray");
// context.Weeks.Single(o => o.Order == 7).ExitBaker = context.Bakers.Single(o => o.Name == "Mat Riley");
//
// context.Weeks.Single(o => o.Order == 8).StarBaker = context.Bakers.Single(o => o.Name == "Nadiya Begum");
// context.Weeks.Single(o => o.Order == 8).ExitBaker = context.Bakers.Single(o => o.Name == "Paul");
// // Run Scoring
context.SaveChanges();
}
public void AddLeague(League league)
{
_volleyballContext.LeagueSet.Add(league);
}
public void SetUp()
{
db = new PeLImpl();
for (int i = 0; i < 4; i++)
{
db.RegisterUser("test" + i, "" + i, "email" + i, null);
}
db.EditUserById(db.getUserByName("test0").id, null, null, null, null, 1000, 10, false);
db.EditUserById(db.getUserByName("test1").id, null, null, null, null, 0, 15, false);
db.EditUserById(db.getUserByName("test2").id, null, null, null, null, 700, 20, false);
db.EditUserById(db.getUserByName("test3").id, null, null, null, null, 1500, 25, false);
var userList = new List <SystemUser>
{
db.getUserByName("test0"),
db.getUserByName("test1"),
db.getUserByName("test2"),
db.getUserByName("test3")
};
center = GameCenter.getGameCenter();
for (int i = 0; i < 10; i++)
{
db.EditUserById(db.getUserByName("test0").id, null, null, null, null, null, null, true);
db.EditUserById(db.getUserByName("test1").id, null, null, null, null, null, null, true);
db.EditUserById(db.getUserByName("test2").id, null, null, null, null, null, null, true);
db.EditUserById(db.getUserByName("test3").id, null, null, null, null, null, null, true);
}
//set users ranks.
int j = 10;
for (int i = 0; i < 4; i++)
{
db.EditUserById(db.getUserByName("test0").id, null, null, null, null, null, j, false);
j += 5;
}
//set the leagues
center.maintainLeagues(userList);
//get the league of user 3
League l = center.getUserLeague(userList[3]);
//setting the games
//pref order: mustpref(spectate,league)->game type , buy in policy, starting chips, minimal bet, minimum players, maximum players.
var gamesList = new List <TexasHoldemGame>
{
//regular games
new TexasHoldemGame(userList[0], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(9, null)))))), true),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
new TexasHoldemGame(userList[0], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(9, null)))))), false),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
new TexasHoldemGame(userList[1], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(2, null)))))), true),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
new TexasHoldemGame(userList[1], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(2, null)))))), false),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
new TexasHoldemGame(userList[2], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(2, null)))))), false),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
new TexasHoldemGame(userList[2], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(2, null)))))), false),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
//league games
new TexasHoldemGame(userList[3], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(2, null)))))), false, l.minRank, l.maxRank),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2])),
new TexasHoldemGame(userList[3], new MustPreferences(new GamePolicyDecPref(GameTypePolicy.No_Limit, 0,
new BuyInPolicyDecPref(100, new StartingAmountChipsCedPref(500,
new MinBetDecPref(20, new MinPlayersDecPref(2,
new MaxPlayersDecPref(2, null)))))), false, l.minRank, l.maxRank),
userIdDeltaRank => db.EditUserById(userIdDeltaRank[0], null, null, null, null, null, userIdDeltaRank[1], false),
userIdLeaderB => db.EditUserLeaderBoardsById(userIdLeaderB[0], userIdLeaderB[1], userIdLeaderB[2]))
};
for (int i = 0; i < gamesList.Count; i++)
{
gamesList[i].gameId = i;
center.TexasHoldemGames.Add(gamesList[i]);
}
sl = new SLImpl();
}
public void RemoveLeague(League league)
{
_volleyballContext.LeagueSet.Remove(league);
}
public void InsertPlayerTest()
{
List<string> errors = new List<string>();
Race race = new Race();
race.name = "Protoss";
race.code = 'P';
int raceID = DALRace.InsertRace(race, ref errors);
race.id = raceID;
Race race3 = new Race();
race3.name = "Zerg";
race3.code = 'Z';
raceID = DALRace.InsertRace(race3, ref errors);
race3.id = raceID;
League league = new League();
league.name = "Diamond";
int leagueID = DALLeague.InsertLeague(league, ref errors);
league.id = leagueID;
League league2 = new League();
league2.name = "Platinum";
leagueID = DALLeague.InsertLeague(league2, ref errors);
league2.id = leagueID;
Player player = new Player();
player.name = "Niter";
player.code = 777;
player.race = race3;
player.league = league2;
Player player2 = new Player();
player2.name = "WolfBro";
player2.code = 123;
player2.race = race;
player2.league = league;
int playerID = DALPlayer.InsertPlayer(player, ref errors);
player.id = playerID;
Assert.AreEqual(0, errors.Count);
Player verifyPlayer = DALPlayer.GetPlayerDetail(player.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(player.name, verifyPlayer.name);
Assert.AreEqual(player.code, verifyPlayer.code);
Assert.AreEqual(player.race.id, verifyPlayer.race.id);
Assert.AreEqual(player.league.id, verifyPlayer.league.id);
player2.id = player.id;
DALPlayer.UpdatePlayer(player2, ref errors);
verifyPlayer = DALPlayer.GetPlayerDetail(player2.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(player2.name, verifyPlayer.name);
Assert.AreEqual(player2.code, verifyPlayer.code);
Assert.AreEqual(player2.race.id, verifyPlayer.race.id);
Assert.AreEqual(player2.league.id, verifyPlayer.league.id);
DALPlayer.DeletePlayer(player.id, ref errors);
Player verifyEmptyPlayer = DALPlayer.GetPlayerDetail(player.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(null, verifyEmptyPlayer);
}
public Task <IReadOnlyList <FantasyCriticUser> > GetActivePlayersForLeagueYear(League league, int year)
{
return(_fantasyCriticRepo.GetActivePlayersForLeagueYear(league, year));
}
public static League Insert(League league)
{
return new LeagueDao().Insert(league);
}
public async Task <bool> UserIsInLeague(League league, FantasyCriticUser user)
{
var playersInLeague = await GetUsersInLeague(league);
return(playersInLeague.Any(x => x.Id == user.Id));
}
public async Task GenerateOffer()
{
var date = DateTime.Now;
var yesterday = date.AddDays(-1).ToString("yyyy-MM-dd");
var tommorow = date.AddDays(1).ToString("yyyy-MM-dd");
string url = $"https://sportdataprovider.volcanobet.me/api/public/prematch/SportEvents?SportId=1&from={yesterday}T23:00:00.000Z&to={tommorow}T06:00:00.000Z&timezone=-60&clientType=WebConsumer&v=1.1.496-rc6&lang=sr-Latn-EN";
string html;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.AutomaticDecompression = DecompressionMethods.GZip;
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader reader = new StreamReader(stream))
{
html = reader.ReadToEnd();
}
var offer = JsonConvert.DeserializeObject <OfferModel>(html);
var sport = await _context.Sport.Where(s => s.Name == offer.Sport.Name).FirstOrDefaultAsync();
if (sport == null)
{
sport = new Sport();
sport.Name = offer.Sport.Name;
_context.AddRange(sport);
_context.SaveChanges();
}
foreach (var location in offer.Locations)
{
foreach (var league in location.Leagues)
{
var leagueDatabase = await _context.League.Where(l => l.Name == $"{location.Name} - {league.Name}")
.SingleOrDefaultAsync();
if (leagueDatabase == null)
{
leagueDatabase = new League();
leagueDatabase.Name = $"{location.Name} - {league.Name}";
leagueDatabase.Sport = sport;
_context.League.AddRange(leagueDatabase);
_context.SaveChanges();
}
foreach (var eventDate in league.EventDateGroups)
{
foreach (var eventDateEvent in eventDate.Events)
{
var matchModel = new Match();
matchModel.Competition = league.Name;
matchModel.Id = eventDateEvent.Id;
var types = new Type();
matchModel.Sport = sport;
matchModel.Time = eventDateEvent.Fixture.StartDate.AddHours(1);
var firstTeam = await _context.Team
.Where(t => t.Name == eventDateEvent.Fixture.Participants[0].Name)
.FirstOrDefaultAsync();
var secondTeam = await _context.Team
.Where(t => t.Name == eventDateEvent.Fixture.Participants[1].Name)
.FirstOrDefaultAsync();
if (firstTeam == null)
{
firstTeam = new Team();
firstTeam.League = leagueDatabase;
firstTeam.Name = eventDateEvent.Fixture.Participants[0].Name;
_context.Team.AddRange(firstTeam);
matchModel.HomeTeam = firstTeam;
}
if (firstTeam != null)
{
matchModel.HomeTeam = firstTeam;
}
if (secondTeam == null)
{
secondTeam = new Team();
secondTeam.League = leagueDatabase;
secondTeam.Name = eventDateEvent.Fixture.Participants[1].Name;
_context.Team.AddRange(secondTeam);
matchModel.AwayTeam = secondTeam;
}
if (secondTeam != null)
{
matchModel.AwayTeam = secondTeam;
}
foreach (var market in eventDateEvent.Markets)
{
if (market.Name == "1x2")
{
foreach (var pick in market.Picks)
{
if (pick.Name == "1")
{
types._1 = pick.Odds;
}
if (pick.Name == "x")
{
types._X = pick.Odds;
}
if (pick.Name == "2")
{
types._2 = pick.Odds;
}
}
}
if (market.Name == "Double chance")
{
foreach (var pick in market.Picks)
{
if (pick.Name == "1x")
{
types._1X = pick.Odds;
}
if (pick.Name == "x2")
{
types._X2 = pick.Odds;
}
if (pick.Name == "12")
{
types._12 = pick.Odds;
}
}
}
}
var matchExist = await _context.Match
.Include(h => h.HomeTeam)
.Include(a => a.AwayTeam)
.Where(m => m.HomeTeam == matchModel.HomeTeam && m.AwayTeam == matchModel.AwayTeam &&
m.Time == matchModel.Time).FirstOrDefaultAsync();
if (matchExist == null && matchModel.HomeTeam != null && matchModel.AwayTeam != null)
{
matchModel.Type = types;
matchModel.TopMatch = false;
matchModel.Hide = false;
_context.Match.Add(matchModel);
_context.SaveChanges();
}
}
}
}
}
}
public LeagueEditViewModel(League league = null)
{
League = league ?? new League();
}
public int SaveLeague(League League)
{
return Ctx.LeagueManager.LeagueSave(League);
}
public League Create(League league)
{
Leagues.Add(league);
return(league);
}
public override void NotifyPropertiesChanged()
{
_league = null;
base.NotifyPropertiesChanged();
SetPropertyChanged("League");
SetPropertyChanged("Athlete");
SetPropertyChanged("HasChallenge");
SetPropertyChanged("IsMember");
SetPropertyChanged("IsLast");
SetPropertyChanged("IsMemberAndLeagueStarted");
SetPropertyChanged("IsNotMemberAndLeagueStarted");
SetPropertyChanged("IsFirstPlace");
SetPropertyChanged("EmptyMessage");
SetPropertyChanged("DateRange");
SetPropertyChanged("CreatedBy");
SetPropertyChanged("LeaderMembership");
SetPropertyChanged("HasLeaderOtherThanSelf");
SetPropertyChanged("CurrentMembership");
SetPropertyChanged("CanChallenge");
SetPropertyChanged("PraisePhrase");
SetPropertyChanged("GetBestChallengee");
}
public void init()
{
fbData = new FootballData();
competitions = fbData.GetCompetitionsList();
prem = fbData.GetLeaugeByCompetitionId(premierLeague2017Id, "Premier League");
}
private LeagueSeason CreateLeagueSeason(IEnumerable<Team> teams)
{
var nationalLeague = new NationalLeague(world, "Test");
var division = new League(nationalLeague, "Test", 1, DayOfWeek.Saturday, 1);
return new LeagueSeason(division, new DateTime(2012, 08, 01), new DateTime(2013, 05, 30), teams.ToArray());
}
public LeagueSeasonBuilder ForLeague(League league)
{
this.league = league;
return this;
}
private List <UpcomingMatch> MapUpcomingMatch(JToken content)
{
List <UpcomingMatch> upcomingGames = new List <UpcomingMatch>();
foreach (var item in content)
{
if (!item["opponents"].HasValues)
{
System.Diagnostics.Debug.WriteLine("Array is empty");
continue;
}
else if (item["opponents"].Count <object>() <= 1)
{
continue;
}
var league = new League
{
Id = (int)item["league"]["id"],
ImgUrl = (string)item["league"]["image_url"],
Name = (string)item["league"]["name"],
Slug = (string)item["videogame"]["slug"],
Url = (string)item["league"]["url"],
Videogame = new Videogame
{
Id = (int)item["videogame"]["id"],
Name = (string)item["videogame"]["name"],
Slug = (string)item["videogame"]["slug"],
}
};
var opponentOne = new Team
{
Id = (int)item["opponents"][0]["opponent"]["id"],
Acronym = (string)item["opponents"][0]["opponent"]["acronym"],
Name = (string)item["opponents"][0]["opponent"]["name"],
ImgUrl = (string)item["opponents"][0]["opponent"]["image_url"]
};
var opponentTwo = new Team
{
Id = (int)item["opponents"][1]["opponent"]["id"],
Acronym = (string)item["opponents"][1]["opponent"]["acronym"],
Name = (string)item["opponents"][1]["opponent"]["name"],
ImgUrl = (string)item["opponents"][1]["opponent"]["image_url"]
};
var series = new Series
{
Id = (int)item["serie"]["id"],
Name = (string)item["serie"]["name"],
Prizepool = (string)item["serie"]["prizepool"],
Season = (string)item["serie"]["season"],
Year = (int)item["serie"]["year"],
Description = (string)item["serie"]["description"],
FullName = (string)item["serie"]["full_name"],
Tier = (string)item["serie"]["tier"],
BeginDate = ((DateTime)item["serie"]["begin_at"]).ToLocalTime(),
};
var upcomingGame = new UpcomingMatch
{
ID = (int)item["id"],
StartDate = (string)item["begin_at"],
Draw = (bool)item["draw"],
MatchType = (string)item["match_type"],
Name = (string)item["name"],
NumberOfGames = (int)item["number_of_games"],
Tournament = (string)item["tournament"]["name"],
League = league,
OpponentOne = opponentOne,
OpponentTwo = opponentTwo,
Series = series
};
upcomingGames.Add(upcomingGame);
}
return(upcomingGames);
}
public async Task <IReadOnlyList <LeagueInviteLink> > GetActiveInviteLinks(League league)
{
IReadOnlyList <LeagueInviteLink> inviteLinks = await _fantasyCriticRepo.GetInviteLinks(league);
return(inviteLinks.Where(x => x.Active).ToList());
}
public void InsertStatisticTest()
{
List<string> errors = new List<string>();
Race race = new Race();
race.name = "Protoss";
race.code = 'P';
int raceID = DALRace.InsertRace(race, ref errors);
race.id = raceID;
Race race2 = new Race();
race2.name = "Terran";
race2.code = 'T';
raceID = DALRace.InsertRace(race2, ref errors);
race2.id = raceID;
Race race3 = new Race();
race3.name = "Zerg";
race3.code = 'Z';
raceID = DALRace.InsertRace(race3, ref errors);
race3.id = raceID;
League league = new League();
league.name = "Diamond";
int leagueID = DALLeague.InsertLeague(league, ref errors);
league.id = leagueID;
League league2 = new League();
league2.name = "Platinum";
leagueID = DALLeague.InsertLeague(league2, ref errors);
league2.id = leagueID;
League league3 = new League();
league3.name = "Master";
leagueID = DALLeague.InsertLeague(league3, ref errors);
league3.id = leagueID;
Map map = new Map();
map.name = "Shakuras Plateau";
map.spawns = 4;
map.size = "120x100";
int mapID = DALMap.InsertMap(map, ref errors);
map.id = mapID;
Map map2 = new Map();
map2.name = "Daybreak";
map2.spawns = 2;
map2.size = "100x100";
mapID = DALMap.InsertMap(map, ref errors);
map2.id = mapID;
Player player = new Player();
player.name = "Niter";
player.code = 777;
player.race = race3;
player.league = league2;
int playerID = DALPlayer.InsertPlayer(player, ref errors);
player.id = playerID;
Player player2 = new Player();
player2.name = "WolfBro";
player2.code = 123;
player2.race = race;
player2.league = league;
playerID = DALPlayer.InsertPlayer(player2, ref errors);
player2.id = playerID;
Player player3 = new Player();
player3.name = "Corone";
player3.code = 123;
player3.race = race2;
player3.league = league3;
playerID = DALPlayer.InsertPlayer(player3, ref errors);
player3.id = playerID;
Game game = new Game();
game.matchup = "ZVT";
game.length = "0:23:00";
game.player1 = player;
game.player1_race = player.race;
game.player2 = player2;
game.player2_race = player2.race;
game.winner = game.player1;
game.map = new Map();
game.map.id = 1;
int gameID = DALGame.InsertGame(game, ref errors);
game.id = gameID;
Statistic statistic = new Statistic();
statistic.player = game.player1;
statistic.game = game;
statistic.apm = 0;
statistic.resources = 0;
statistic.units = 0;
statistic.structures = 0;
var statisticID = DALStatistic.InsertStatistic(statistic, ref errors);
statistic.id = statisticID;
Assert.AreEqual(0, errors.Count);
Statistic verifyStatistic = DALStatistic.GetStatisticDetail(statistic.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(statistic.id, verifyStatistic.id);
Assert.AreEqual(statistic.player.id, verifyStatistic.player.id);
Assert.AreEqual(statistic.game.id, verifyStatistic.game.id);
Assert.AreEqual(statistic.apm, verifyStatistic.apm);
Assert.AreEqual(statistic.resources, verifyStatistic.resources);
Assert.AreEqual(statistic.units, verifyStatistic.units);
Assert.AreEqual(statistic.structures, verifyStatistic.structures);
Statistic statistic2 = new Statistic();
statistic2.player = game.player2;
statistic2.game = game;
statistic2.apm = 1;
statistic2.resources = 1;
statistic2.units = 1;
statistic2.structures = 1;
statistic2.id = statistic.id;
DALStatistic.UpdateStatistic(statistic2, ref errors);
verifyStatistic = DALStatistic.GetStatisticDetail(statistic2.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(statistic2.id, verifyStatistic.id);
Assert.AreEqual(statistic2.player.id, verifyStatistic.player.id);
Assert.AreEqual(statistic2.game.id, verifyStatistic.game.id);
Assert.AreEqual(statistic2.apm, verifyStatistic.apm);
Assert.AreEqual(statistic2.resources, verifyStatistic.resources);
Assert.AreEqual(statistic2.units, verifyStatistic.units);
Assert.AreEqual(statistic2.structures, verifyStatistic.structures);
DALStatistic.DeleteStatistic(statistic.id, ref errors);
Statistic verifyEmptyStatistic = DALStatistic.GetStatisticDetail(statistic.id, ref errors);
Assert.AreEqual(0, errors.Count);
Assert.AreEqual(null, verifyEmptyStatistic);
}
public IActionResult GetLiveMatches()
{
var client = new RestClient($"https://api.pandascore.co//lives?per_page=10&token=" + _token);
var request = new RestRequest(Method.GET);
IRestResponse response = client.Execute(request);
TextInfo myTI = new CultureInfo("sv-SE", false).TextInfo;
if (response.IsSuccessful)
{
var content = JsonConvert.DeserializeObject <JToken>(response.Content);
List <LiveGame> liveGames = new List <LiveGame>();
foreach (var item in content)
{
var match = item["match"];
var league = new League
{
Id = (int)match["league"]["id"],
ImgUrl = (string)match["league"]["image_url"],
Name = (string)match["league"]["name"],
Slug = (string)match["league"]["slug"],
Url = (string)""
};
var opponentOne = new Team
{
Id = (int)match["opponents"][0]["opponent"]["id"],
Acronym = (string)match["opponents"][0]["opponent"]["acronym"],
Name = (string)match["opponents"][0]["opponent"]["name"],
ImgUrl = (string)match["opponents"][0]["opponent"]["image_url"]
};
var opponentTwo = new Team
{
Id = (int)match["opponents"][1]["opponent"]["id"],
Acronym = (string)match["opponents"][1]["opponent"]["acronym"],
Name = (string)match["opponents"][1]["opponent"]["name"],
ImgUrl = (string)match["opponents"][1]["opponent"]["image_url"]
};
var live = new LiveGame
{
id = (int)item["event"]["id"],
startDate = (string)match["begin_at"],
isActive = (bool)match["live"]["supported"],
matchType = (string)match["match_type"],
streamUrl = (string)match["live_embed_url"],
linkUrl = (string)match["live_url"],
draw = (bool)match["draw"],
forfeit = (bool)match["forfeit"],
opponentOne = opponentOne,
opponentTwo = opponentTwo,
opponentOneResult = (int)match["results"][0]["score"],
opponentTwoResult = (int)match["results"][1]["score"],
numberOfGames = (int)match["number_of_games"],
season = (string)match["tournament"]["name"],
name = (string)match["league"]["name"],
league = league,
status = (string)match["status"],
Videogame = ((string)item["event"]["game"]).Replace("-", " ")
};
live.Videogame = myTI.ToTitleCase(live.Videogame);
liveGames.Add(live);
}
return(Ok(liveGames));
}
System.Diagnostics.Debug.WriteLine("Connection not possible");
return(BadRequest());
}
public LeagueEditViewModel()
{
League = new League();
}
public ActionResult ShowLeagueDetails(int id)
{
League league = leagueRepository.GetLeagueById(id);
return(View(league));
}
public static League GetLeague(int leagueId)
{
League league = new League();
SqlConnection dbConnection = null;
try {
dbConnection = new SqlConnection(DB_CONNECTION_STRING);
dbConnection.Open();
string commandText = "select * from Leagues where id = @leagueId";
SqlCommand cmd = new SqlCommand(commandText, dbConnection);
cmd.Parameters.Add(new SqlParameter("@leagueId", leagueId));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows) {
reader.Read();
league.Id = reader.GetInt32(0);
league.name = reader.GetString(1);
league.country = reader.GetString(2);
}
} finally {
if (dbConnection != null) {
dbConnection.Close();
}
}
return league;
}
public ActionResult AddLeague(League league)
{
leagueRepository.AddNewLeague(league);
return(RedirectToAction("ShowLeagueDetails", new { id = league.Id }));
}
