public NightWindow(User passedPlayer) { InitializeComponent(); sessionPlayer = passedPlayer; PlayersList = UserCollection.ReturnUserList(); timeAmount = TimeSpan.FromSeconds(60); RoleLabel.Content = passedPlayer.UserRoleName; night += 1; NightCount.Content = night.ToString(); Username.Content = sessionPlayer.UserName; SqlConnection connect; string connetionString = null; connetionString = ("user id=Derek;" + "server=localhost;" + "Trusted_Connection=yes;" + "database=Test"); gameTimer = new DispatcherTimer(new TimeSpan(0, 0, 1), DispatcherPriority.Normal, delegate { tbTime.Text = timeAmount.ToString("c"); //enable roles at the very start if (timeAmount == TimeSpan.FromSeconds(60)) { Player1Button.Content = PlayersList[0].UserName; Player2Button.Content = PlayersList[1].UserName; Player3Button.Content = PlayersList[2].UserName; Player4Button.Content = PlayersList[3].UserName; Player5Button.Content = PlayersList[4].UserName; Player6Button.Content = PlayersList[5].UserName; Player7Button.Content = PlayersList[6].UserName; Player8Button.Content = PlayersList[7].UserName; Player9Button.Content = PlayersList[8].UserName; Player10Button.Content = PlayersList[9].UserName; Player11Button.Content = PlayersList[10].UserName; Player12Button.Content = PlayersList[11].UserName; Player13Button.Content = PlayersList[12].UserName; Player14Button.Content = PlayersList[13].UserName; Player15Button.Content = PlayersList[14].UserName; if (PlayersList[0].UserStatus == false) { Player1Button.IsEnabled = true; } if (PlayersList[1].UserStatus == false) { Player2Button.IsEnabled = true; } if (PlayersList[2].UserStatus == false) { Player3Button.IsEnabled = true; } if (PlayersList[3].UserStatus == false) { Player4Button.IsEnabled = true; } if (PlayersList[4].UserStatus == false) { Player5Button.IsEnabled = true; } if (PlayersList[5].UserStatus == false) { Player6Button.IsEnabled = true; } if (PlayersList[6].UserStatus == false) { Player7Button.IsEnabled = true; } if (PlayersList[7].UserStatus == false) { Player8Button.IsEnabled = true; } if (PlayersList[8].UserStatus == false) { Player9Button.IsEnabled = true; } if (PlayersList[9].UserStatus == false) { Player10Button.IsEnabled = true; } if (PlayersList[10].UserStatus == false) { Player11Button.IsEnabled = true; } if (PlayersList[11].UserStatus == false) { Player12Button.IsEnabled = true; } if (PlayersList[12].UserStatus == false) { Player13Button.IsEnabled = true; } if (PlayersList[13].UserStatus == false) { Player14Button.IsEnabled = true; } if (PlayersList[14].UserStatus == false) { Player15Button.IsEnabled = true; } } if (timeAmount == TimeSpan.FromSeconds(10)) { Player1Button.IsEnabled = false; Player2Button.IsEnabled = false; Player3Button.IsEnabled = false; Player4Button.IsEnabled = false; Player5Button.IsEnabled = false; Player6Button.IsEnabled = false; Player7Button.IsEnabled = false; Player8Button.IsEnabled = false; Player9Button.IsEnabled = false; Player10Button.IsEnabled = false; Player11Button.IsEnabled = false; Player12Button.IsEnabled = false; Player13Button.IsEnabled = false; Player14Button.IsEnabled = false; Player15Button.IsEnabled = false; if (sessionPlayer.UserRole == 13) { //veteran activates if (sessionPlayer.UserRoleActive == true) { Veteran.VetNightTime(sessionPlayer); } } } if (timeAmount == TimeSpan.FromSeconds(8)) { //bard role goes if (sessionPlayer.UserRole == 11) { if (sessionPlayer.UserRoleActive == true) { Bard.BardNightTime(targetUser, sessionPlayer); } } } if (timeAmount == TimeSpan.FromSeconds(5)) { using (connect = new SqlConnection(connetionString)) { connect.Open(); //read if the passed User is Armed and get their VisitedBy SqlCommand command = new SqlCommand("Select Blocked FROM [UserStatus] WHERE ID=@ID", connect); command.Parameters.AddWithValue("@ID", sessionPlayer.UserID); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { isBlocked = Convert.ToBoolean(reader["Blocked"]); } } connect.Close(); } //jailor if (sessionPlayer.UserRole == 4) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { Jailor.JailorNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } } if (timeAmount == TimeSpan.FromSeconds(6)) { using (connect = new SqlConnection(connetionString)) { connect.Open(); //read if the passed User is Armed and get their VisitedBy SqlCommand command = new SqlCommand("Select Blocked FROM [UserStatus] WHERE ID=@ID", connect); command.Parameters.AddWithValue("@ID", sessionPlayer.UserID); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { isBlocked = Convert.ToBoolean(reader["Blocked"]); } } connect.Close(); } //conartist if (sessionPlayer.UserRole == 7) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { ConArtist.ConNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } //doctor else if (sessionPlayer.UserRole == 2) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { Doctor.DocNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } //godfather else if (sessionPlayer.UserRole == 6) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { Godfather.GodFatherNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } //townpsycho else if (sessionPlayer.UserRole == 12) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { TownPsycho.TownPsychoNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } //vigilante else if (sessionPlayer.UserRole == 14) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { Vigilante.VigNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } } if (timeAmount == TimeSpan.FromSeconds(4)) { //sheriff if (sessionPlayer.UserRole == 1) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { result = Sheriff.SheriffNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } //investigator else if (sessionPlayer.UserRole == 3) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { result = Investigator.InvNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } } if (timeAmount == TimeSpan.FromSeconds(2)) { //town watch if (sessionPlayer.UserRole == 15) { if (sessionPlayer.UserRoleActive == true) { if (isBlocked == false) { result = TownWatch.TownWatchNightTime(targetUser, sessionPlayer); } else { result = "You were role blocked"; } } } } if (timeAmount == TimeSpan.Zero) { gameTimer.Stop(); //find lowest ID number so table is only accessed and updated by that ID foreach (var element in PlayersList) { if (lowestID > element.UserID) { lowestID = element.UserID; } } if (sessionPlayer.UserID == lowestID) { foreach (var element in PlayersList) { isKilled = false; isSaved = false; using (connect = new SqlConnection(connetionString)) { connect.Open(); //read if the passed User is Armed and get their VisitedBy SqlCommand command = new SqlCommand("Select Killed, Saved FROM [UserStatus] WHERE ID=@ID", connect); command.Parameters.AddWithValue("@ID", element.UserID); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { isKilled = Convert.ToBoolean(reader["Killed"]); isSaved = Convert.ToBoolean(reader["Saved"]); } } if (isSaved == false) { if (isKilled == true) { //element.UserStatus = true; using (SqlCommand cmd = new SqlCommand("UPDATE UserStatus SET Status=@Status" + " WHERE Id=@Id", connect)) { cmd.Parameters.AddWithValue("@Id", element.UserID); cmd.Parameters.AddWithValue("@Status", 1); int rows = cmd.ExecuteNonQuery(); } } } using (SqlCommand cmd = new SqlCommand("UPDATE UserStatus SET " + "Blocked=@Blocked, Conned=@Conned, Saved=@Saved, Killed=@Killed, " + "Armed=@Armed, VisitedBy=@VisitedBy" + " WHERE Id=@Id", connect)) { cmd.Parameters.AddWithValue("@Id", element.UserID); cmd.Parameters.AddWithValue("@Blocked", 0); cmd.Parameters.AddWithValue("@Conned", 0); cmd.Parameters.AddWithValue("@Saved", 0); cmd.Parameters.AddWithValue("@Killed", 0); cmd.Parameters.AddWithValue("@Armed", 0); cmd.Parameters.AddWithValue("@VisitedBy", ""); int rows = cmd.ExecuteNonQuery(); connect.Close(); } } } } GameWindow main = new GameWindow(sessionPlayer, result); App.Current.MainWindow = main; this.Close(); main.Show(); } timeAmount = timeAmount.Add(TimeSpan.FromSeconds(-1)); }, Application.Current.Dispatcher); }
public MainMenu(User passedPlayer) { InitializeComponent(); sessionPlayer = passedPlayer; SqlConnection connect; string connetionString = null; connetionString = ("user id=Derek;" + "server=localhost;" + "Trusted_Connection=yes;" + "database=Test"); //set listing of current players ListOfPlayers = UserCollection.ReturnUserList(); foreach (var element in ListOfPlayers) { if (lowestID > element.UserID) { lowestID = element.UserID; } } if (sessionPlayer.UserID == lowestID) { UserCollection.AssignRoles(); UserCollection.ChangeRoleName(); foreach (var element in ListOfPlayers) { using (connect = new SqlConnection(connetionString)) { connect.Open(); using (SqlCommand cmd = new SqlCommand("UPDATE UserStatus SET Role=@Role, RoleName=@RoleName" + " WHERE Id=@Id", connect)) { cmd.Parameters.AddWithValue("@Id", element.UserID); cmd.Parameters.AddWithValue("@Role", element.UserRole); cmd.Parameters.AddWithValue("@RoleName", element.UserRoleName); int rows = cmd.ExecuteNonQuery(); } connect.Close(); } } } var tempList = from player in ListOfPlayers orderby player.UserName select new { Name = player.UserName, Email = player.UserEmail, ID = player.UserID, //RoleName = player.UserRoleName }; gameTimer = new DispatcherTimer(new TimeSpan(0, 0, 1), DispatcherPriority.Normal, delegate { Clock.Content = DateTime.Now.ToString("H:mm:ss"); timeConversion = Convert.ToInt32(DateTime.Now.ToString("ss")); if (timeConversion == 0) { minuteTracker += 1; } test.Content = minuteTracker.ToString(); if (minuteTracker > 1) { if (timeConversion == 0) { gameTimer.Stop(); GameWindow main = new GameWindow(sessionPlayer, result); App.Current.MainWindow = main; this.Close(); main.Show(); } } }, Application.Current.Dispatcher); this.PlayerListBox.ItemsSource = tempList; }