protected void Page_Load(Object s, EventArgs e) { userId = Convert.ToInt32(Request.QueryString["userId"]); if (!IsPostBack) { playerColorHash = new Hashtable(); nowStatus = CommonMethods.loadCurrentStatus(); theRounds = CommonMethods.loadRoundsForLobby(); thePlayers = CommonMethods.loadPlayersForLobby(); foreach (Player player in thePlayers) { playerColorHash.Add(player.userId, player.color); } bracketOneName = CommonMethods.loadBracketName(1); bracketTwoName = CommonMethods.loadBracketName(2); bracketThreeName = CommonMethods.loadBracketName(3); bracketFourName = CommonMethods.loadBracketName(4); bracketOneTeams = CommonMethods.SortTeamsByRank(CommonMethods.loadTeamsForBracketView(1)); bracketThreeTeams = CommonMethods.SortTeamsByRank(CommonMethods.loadTeamsForBracketView(3)); bracketFourTeams = CommonMethods.SortTeamsByRank(CommonMethods.loadTeamsForBracketView(4)); bracketTwoTeams = CommonMethods.SortTeamsByRank(CommonMethods.loadTeamsForBracketView(2)); } }
public static CurrentStatus loadCurrentStatus() { string DB = HttpContext.Current.Server.MapPath(SETPATH); dbConnect = new OleDbConnection(CONNECTSTRING + DB); OleDbDataAdapter dbadapter; DataSet clubdataset; OleDbCommand olecommand = new OleDbCommand("getCurrentStatus", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; dbadapter = new OleDbDataAdapter(olecommand); clubdataset = new DataSet(); dbadapter.Fill(clubdataset, "clubsdata"); DataTable statusTable = clubdataset.Tables["clubsdata"]; CurrentStatus nowStatus = new CurrentStatus(); nowStatus.round = Convert.ToInt32(statusTable.Rows[0]["Round"].ToString()); nowStatus.maxHoldOverPoints = Convert.ToInt32(statusTable.Rows[0]["MaxHoldOverPoints"].ToString()); nowStatus.pointsToSpend = Convert.ToInt32(statusTable.Rows[0]["PointsToSpend"].ToString()); nowStatus.totalPlayers = Convert.ToInt32(statusTable.Rows[0]["UserCount"].ToString()); nowStatus.currentOrderIndex = Convert.ToInt32(statusTable.Rows[0]["OrderIndex"].ToString()); nowStatus.finished = (bool)statusTable.Rows[0]["Finished"]; nowStatus.totalRounds = Convert.ToInt32(statusTable.Rows[0]["RoundCount"]); return(nowStatus); }
protected void Page_Load(Object s, EventArgs e) { teamList.ItemDataBound += new DataGridItemEventHandler(teamList_ItemDataBound); nowStatus = CommonMethods.loadCurrentStatus(); theRounds = CommonMethods.loadRoundsForLobby(); thePlayers = CommonMethods.loadPlayersForLobby(); userId = Convert.ToInt32(Request.QueryString["userId"]); if (userId != thePlayers[theRounds[nowStatus.round - 1].roundOrder[nowStatus.currentOrderIndex] - 1].userId) { Response.Redirect("lobby.aspx?userId=" + userId); } else { if (!IsPostBack) { teamTable = CommonMethods.loadUnselectedTeams(Server); nowStatus = CommonMethods.loadCurrentStatus(); pointsAvailable = theRounds[nowStatus.round - 1].pointsToSpend + thePlayers[theRounds[nowStatus.round - 1].roundOrder[nowStatus.currentOrderIndex] - 1].pointsHeldOver; pointsAvailableLabel.Text = pointsAvailable.ToString(); maxHoldOverLabel.Text = theRounds[nowStatus.round - 1].maxHoldOverPoints.ToString(); valPointsAvailable.Type = System.Web.UI.WebControls.ValidationDataType.Integer; valPointsAvailable.ValueToCompare = theRounds[nowStatus.round - 1].maxHoldOverPoints.ToString(); valPointsAvailable.Operator = System.Web.UI.WebControls.ValidationCompareOperator.LessThanEqual; BindGrid(); } } }
public void resetPage(Object s, System.EventArgs e) { teamTable = CommonMethods.loadUnselectedTeams(Server); nowStatus = CommonMethods.loadCurrentStatus(); pointsAvailable = theRounds[nowStatus.round - 1].pointsToSpend + thePlayers[theRounds[nowStatus.round - 1].roundOrder[nowStatus.currentOrderIndex] - 1].pointsHeldOver; maxHoldOverLabel.Text = theRounds[nowStatus.round - 1].maxHoldOverPoints.ToString(); errorMessageLabel.Text = ""; BindGrid(); }
public static Team[] loadTeamsForBracketView(int bracketId) { string DB = HttpContext.Current.Server.MapPath(SETPATH); dbConnect = new OleDbConnection(CONNECTSTRING + DB); OleDbDataAdapter dbadapter; DataSet clubdataset; OleDbCommand olecommand = new OleDbCommand("getBracketOfTeams", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; OleDbParameter parameters = new OleDbParameter("@BracketId", OleDbType.Integer); parameters.Value = bracketId; olecommand.Parameters.Add(parameters); dbadapter = new OleDbDataAdapter(olecommand); clubdataset = new DataSet(); dbadapter.Fill(clubdataset, "clubsdata"); DataTable teamsTable = clubdataset.Tables["clubsdata"]; int recordCount = teamsTable.Rows.Count; Team[] theTeams = new Team[recordCount]; CurrentStatus nowStatus = new CurrentStatus(); for (int i = 0; i < recordCount; i++) { theTeams[i] = new Team(); theTeams[i].sCurveRank = Convert.ToInt32(teamsTable.Rows[i]["SCurveRank"]); theTeams[i].teamName = teamsTable.Rows[i]["TeamName"].ToString(); theTeams[i].bracket = teamsTable.Rows[i]["Bracket"].ToString(); theTeams[i].bracketId = Convert.ToInt32(teamsTable.Rows[i]["BracketId"].ToString()); theTeams[i].eliminated = ((bool)teamsTable.Rows[i]["Eliminated"]); theTeams[i].rank = Convert.ToInt32(teamsTable.Rows[i]["TeamRank"].ToString()); theTeams[i].wins = Convert.ToInt32(teamsTable.Rows[i]["TeamWins"].ToString()); theTeams[i].losses = Convert.ToInt32(teamsTable.Rows[i]["TeamLosses"].ToString()); theTeams[i].cost = Convert.ToInt32(teamsTable.Rows[i]["Cost"]); theTeams[i].pickedByPlayer = Convert.ToInt32(teamsTable.Rows[i]["SelectedBy"].ToString()); } return(theTeams); }
public static Team[] loadTeamCartOfTeams(HttpServerUtility theserver) { string DB = theserver.MapPath(SETPATH); dbConnect = new OleDbConnection(CONNECTSTRING + DB); OleDbDataAdapter dbadapter; DataSet clubdataset; OleDbCommand olecommand = new OleDbCommand("getTeamCart", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; dbadapter = new OleDbDataAdapter(olecommand); clubdataset = new DataSet(); dbadapter.Fill(clubdataset, "clubsdata"); DataTable teamsTable = clubdataset.Tables["clubsdata"]; int recordCount = teamsTable.Rows.Count; Team[] theTeams = new Team[recordCount]; CurrentStatus nowStatus = new CurrentStatus(); for (int i = 0; i < recordCount; i++) { theTeams[i] = new Team(); theTeams[i].sCurveRank = Convert.ToInt32(teamsTable.Rows[i]["SCurveRank"]); theTeams[i].teamName = teamsTable.Rows[i]["TeamName"].ToString(); theTeams[i].bracket = teamsTable.Rows[i]["Bracket"].ToString(); theTeams[i].rank = Convert.ToInt32(teamsTable.Rows[i]["TeamRank"].ToString()); theTeams[i].wins = Convert.ToInt32(teamsTable.Rows[i]["TeamWins"].ToString()); theTeams[i].losses = Convert.ToInt32(teamsTable.Rows[i]["TeamLosses"].ToString()); theTeams[i].cost = Convert.ToInt32(teamsTable.Rows[i]["Cost"]); } return(theTeams); }
public static Player[] loadPlayersForLobby() { string DB = HttpContext.Current.Server.MapPath(SETPATH); dbConnect = new OleDbConnection(CONNECTSTRING + DB); OleDbDataAdapter dbadapter; DataSet clubdataset; OleDbCommand olecommand = new OleDbCommand("getAllUsers", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; dbadapter = new OleDbDataAdapter(olecommand); clubdataset = new DataSet(); dbadapter.Fill(clubdataset, "clubsdata"); DataTable playerTable = clubdataset.Tables["clubsdata"]; CurrentStatus nowStatus = loadCurrentStatus(); int recordCount = playerTable.Rows.Count; Player[] thePlayers = new Player[recordCount]; for (int i = 0; i < recordCount; i++) { thePlayers[i] = new Player(); thePlayers[i].firstName = playerTable.Rows[i]["FirstName"].ToString(); thePlayers[i].lastName = playerTable.Rows[i]["LastName"].ToString(); thePlayers[i].pointsHeldOver = Convert.ToInt32(playerTable.Rows[i]["PointsHeldOver"].ToString()); thePlayers[i].userId = Convert.ToInt32(playerTable.Rows[i]["UserId"].ToString()); thePlayers[i].color = playerTable.Rows[i]["Color"].ToString(); thePlayers[i].initialPickOrder = Convert.ToInt32(playerTable.Rows[i]["InitialOrder"].ToString()); } return(thePlayers); }
public static void advanceDraft(Team[] selectedTeams, Player thePlayer, CurrentStatus nowStatus) { string DB = HttpContext.Current.Server.MapPath(SETPATH); dbConnect = new OleDbConnection(CONNECTSTRING + DB); string logstring = "<b>Round " + nowStatus.round.ToString() + " - " + thePlayer.firstName + " " + thePlayer.lastName + ":</b> "; bool first = true; foreach (Team thisTeam in selectedTeams) { pickATeam(thisTeam, thePlayer); if (!first) { logstring = logstring + ", "; } logstring = logstring + thisTeam.teamName + " (" + thisTeam.rank.ToString() + ", " + thisTeam.bracket + ", " + (thisTeam.cost).ToString() + " points)"; first = false; } logstring = logstring + " <i>Left " + thePlayer.pointsHeldOver.ToString() + " points</i>"; if (nowStatus.currentOrderIndex >= nowStatus.totalPlayers - 1) { nowStatus.currentOrderIndex = 0; nowStatus.round++; logstring = logstring + "<br />"; } else { nowStatus.currentOrderIndex++; } OleDbCommand olecommand; OleDbParameter parameters; if (nowStatus.round <= nowStatus.totalRounds) { olecommand = new OleDbCommand("updateStatus", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; parameters = new OleDbParameter("@Round", OleDbType.Integer); parameters.Value = nowStatus.round; olecommand.Parameters.Add(parameters); parameters = new OleDbParameter("@OrderIndex", OleDbType.Integer); parameters.Value = nowStatus.currentOrderIndex; olecommand.Parameters.Add(parameters); } else { olecommand = new OleDbCommand("finishDraft", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; } olecommand.Connection.Open(); olecommand.ExecuteNonQuery(); dbConnect.Close(); olecommand = new OleDbCommand("updateUserStatus", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; parameters = new OleDbParameter("@PointsHeldOver", OleDbType.Integer); parameters.Value = thePlayer.pointsHeldOver; olecommand.Parameters.Add(parameters); parameters = new OleDbParameter("@UserId", OleDbType.Integer); parameters.Value = thePlayer.userId; olecommand.Parameters.Add(parameters); olecommand.Connection.Open(); olecommand.ExecuteNonQuery(); dbConnect.Close(); writeToLog(logstring); if (nowStatus.round > nowStatus.totalRounds) { runEndOfDraftLottery(); } }
public static Round[] loadRoundsForLobby() { string DB = HttpContext.Current.Server.MapPath(SETPATH); dbConnect = new OleDbConnection(CONNECTSTRING + DB); OleDbDataAdapter dbadapter; DataSet clubdataset; OleDbCommand olecommand = new OleDbCommand("getAllRounds", dbConnect); olecommand.CommandType = CommandType.StoredProcedure; dbadapter = new OleDbDataAdapter(olecommand); clubdataset = new DataSet(); dbadapter.Fill(clubdataset, "clubsdata"); DataTable roundTable = clubdataset.Tables["clubsdata"]; CurrentStatus nowStatus = loadCurrentStatus(); int recordCount = roundTable.Rows.Count; Round[] theRounds = new Round[recordCount]; for (int i = 0; i < recordCount; i++) { theRounds[i] = new Round(); theRounds[i].roundNumber = Convert.ToInt32(roundTable.Rows[i]["RoundNo"].ToString()); theRounds[i].pointsToSpend = Convert.ToInt32(roundTable.Rows[i]["PointsToSpend"].ToString()); theRounds[i].maxHoldOverPoints = Convert.ToInt32(roundTable.Rows[i]["MaxHoldOverPoints"].ToString()); theRounds[i].roundOrder = new int[nowStatus.totalPlayers]; if ((theRounds[i].roundNumber % 4) == 1) { for (int j = 1; j <= nowStatus.totalPlayers; j++) { theRounds[i].roundOrder[j - 1] = j; } } if ((theRounds[i].roundNumber % 4) == 2) { for (int j = 1; j <= nowStatus.totalPlayers; j++) { theRounds[i].roundOrder[j - 1] = nowStatus.totalPlayers + 1 - j; } } if ((theRounds[i].roundNumber % 4) == 3) { for (int j = 1; j <= nowStatus.totalPlayers; j++) { if (j <= (nowStatus.totalPlayers / 2) + (nowStatus.totalPlayers % 2)) { theRounds[i].roundOrder[j - 1] = nowStatus.totalPlayers / 2 + j; } else { theRounds[i].roundOrder[j - 1] = nowStatus.totalPlayers / 2 - (nowStatus.totalPlayers - j); } } } if ((theRounds[i].roundNumber % 4) == 0) { for (int j = 1; j <= nowStatus.totalPlayers; j++) { if (j <= (nowStatus.totalPlayers / 2)) { theRounds[i].roundOrder[j - 1] = nowStatus.totalPlayers / 2 - j + 1; } else { theRounds[i].roundOrder[j - 1] = nowStatus.totalPlayers / 2 + (nowStatus.totalPlayers - j) + 1; } } } } return(theRounds); }
public void submitPage(Object s, System.EventArgs e) { if (Page.IsValid) { nowStatus = CommonMethods.loadCurrentStatus(); theRounds = CommonMethods.loadRoundsForLobby(); thePlayers = CommonMethods.loadPlayersForLobby(); ArrayList tempSelectedTeams = new ArrayList(); Team[] selectedTeams; foreach (DataGridItem thisItem in teamList.Items) { CheckBox chkSelectTeam = thisItem.FindControl("chkSelectTeam") as CheckBox; Label lblSCurveRank = thisItem.FindControl("lblSCurveRank") as Label; Label lblTeamRank = thisItem.FindControl("lblTeamRank") as Label; Label lblBracketId = thisItem.FindControl("lblBracketId") as Label; Label lblSchool = thisItem.FindControl("lblSchool") as Label; Label lblWins = thisItem.FindControl("lblWins") as Label; Label lblLosses = thisItem.FindControl("lblLosses") as Label; Label lblCost = thisItem.FindControl("lblCost") as Label; Label lblBracketName = thisItem.FindControl("lblBracketName") as Label; if (chkSelectTeam.Checked) { Team thisTeam = new Team(); thisTeam.sCurveRank = Convert.ToInt32(lblSCurveRank.Text); thisTeam.bracket = lblBracketName.Text; thisTeam.wins = int.Parse(lblWins.Text); thisTeam.losses = int.Parse(lblLosses.Text); thisTeam.teamName = lblSchool.Text; thisTeam.bracketId = int.Parse(lblBracketId.Text); thisTeam.cost = Convert.ToInt32(lblCost.Text); thisTeam.rank = int.Parse(lblTeamRank.Text); tempSelectedTeams.Add(thisTeam); } } selectedTeams = (Team[])tempSelectedTeams.ToArray(typeof(Team)); Player mePlayer = thePlayers[theRounds[nowStatus.round - 1].roundOrder[nowStatus.currentOrderIndex] - 1]; userId = Convert.ToInt32(Request.QueryString["userId"]); pointsAvailable = Convert.ToInt32(pointsAvailableLabel.Text); if (pointsAvailable <= theRounds[nowStatus.round - 1].maxHoldOverPoints) { int pointCheck = pointsAvailable; foreach (Team a in selectedTeams) { pointCheck = pointCheck + (a.cost); } if (selectedTeams.Length > 0 && pointCheck == theRounds[nowStatus.round - 1].pointsToSpend + thePlayers[theRounds[nowStatus.round - 1].roundOrder[nowStatus.currentOrderIndex] - 1].pointsHeldOver) { mePlayer.pointsHeldOver = pointsAvailable; CommonMethods.advanceDraft(selectedTeams, mePlayer, nowStatus); Response.Redirect("lobby.aspx?userId=" + userId); } else { teamTable = CommonMethods.loadUnselectedTeams(Server); nowStatus = CommonMethods.loadCurrentStatus(); pointsAvailable = theRounds[nowStatus.round - 1].pointsToSpend + thePlayers[theRounds[nowStatus.round - 1].roundOrder[nowStatus.currentOrderIndex] - 1].pointsHeldOver; maxHoldOverLabel.Text = theRounds[nowStatus.round - 1].maxHoldOverPoints.ToString(); errorMessageLabel.Text = "A timeout has occured. Please make your selections again."; BindGrid(); } } else { errorMessageLabel.Text = "You can only hold over " + theRounds[nowStatus.round - 1].maxHoldOverPoints.ToString() + " points."; } } }
protected void Page_Load(object sender, EventArgs e) { _currentStatus = CommonMethods.loadCurrentStatus(); _rounds = CommonMethods.loadRoundsForLobby(); _userId = Convert.ToInt32(Request.QueryString["userId"]); int currentPickOrder = _rounds[_currentStatus.round - 1].roundOrder[_currentStatus.currentOrderIndex]; // Load up the players _players = new Dictionary <int, Player>(); foreach (Player player in CommonMethods.loadPlayersForLobby()) { _players.Add(player.userId, player); if (player.initialPickOrder == currentPickOrder) { _currentStatus.currentUserId = player.userId; } } if (CurrentStatus.currentUserId != UserId) { Response.Redirect(string.Format("lobby.aspx?userid={0}", UserId)); } List <Team> allTeams = new List <Team>(); Team[] teams = CommonMethods.loadTeamsForBracketView(1); _bracketOneTeams = CommonMethods.SortTeamsByRank(teams); BuildBracket(_bracketOneTeams, placeholderBracket1); allTeams.AddRange(teams); teams = CommonMethods.loadTeamsForBracketView(2); _bracketTwoTeams = CommonMethods.SortTeamsByRank(teams); BuildBracket(_bracketTwoTeams, placeholderBracket2); allTeams.AddRange(teams); teams = CommonMethods.loadTeamsForBracketView(3); _bracketThreeTeams = CommonMethods.SortTeamsByRank(teams); BuildBracket(_bracketThreeTeams, placeholderBracket3); allTeams.AddRange(teams); teams = CommonMethods.loadTeamsForBracketView(4); _bracketFourTeams = CommonMethods.SortTeamsByRank(teams); BuildBracket(_bracketFourTeams, placeholderBracket4); allTeams.AddRange(teams); allTeams.Sort(delegate(Team l, Team r) { return(l.sCurveRank.CompareTo(r.sCurveRank)); }); _allTeamsBySCurveRank = new Dictionary <int, Team>(); foreach (Team team in allTeams) { _allTeamsBySCurveRank.Add(team.sCurveRank, team); } _bracketOneName = CommonMethods.loadBracketName(1); _bracketTwoName = CommonMethods.loadBracketName(2); _bracketThreeName = CommonMethods.loadBracketName(3); _bracketFourName = CommonMethods.loadBracketName(4); _allTeamsArray = allTeams.ToArray(); }