//checks if username is already in use
private void Register_Click(object sender, RoutedEventArgs e)
{
bool validCredentials = false;
string enteredUsername;
string enteredEmail;
int nextID = 0;
enteredUsername = Username_Textbox.Text;
enteredEmail = Email_Textbox.Text;
List <User> ListOfPlayers = UserCollection.ReturnUserList();
ListOfPlayers = UserCollection.ReturnUserList();
foreach (User element in ListOfPlayers)
{
if (element.UserID > nextID)
{
nextID = element.UserID;
}
}
validCredentials = UserCollection.checkCredentials(enteredUsername);
if (validCredentials == true)
{
MessageBox.Show("Username already used. Please Retry");
}
else
{
sessionPlayer = UserCollection.addRegisteredUser(1, enteredEmail, enteredUsername);
string connetionString = null;
connetionString = ("user id=Derek;" +
"server=localhost;" +
"Trusted_Connection=yes;" +
"database=Test");
using (connect = new SqlConnection(connetionString))
{
connect.Open();
string command = "INSERT INTO UserTable"
+ " (Email, Name, ID) " +
"VALUES (@Email, @Name, @ID)";
SqlCommand insertCommand = new SqlCommand(command, connect);
insertCommand.Parameters.AddWithValue("@Email", enteredEmail);
insertCommand.Parameters.AddWithValue("@Name", enteredUsername);
insertCommand.Parameters.AddWithValue("@ID", (nextID + 1));
insertCommand.ExecuteNonQuery();
connect.Close();
}
MainMenu main = new MainMenu(sessionPlayer);
App.Current.MainWindow = main;
this.Close();
main.Show();
}
}
//handles daytime
public GameWindow(User passedPlayer, string passedResult)
{
InitializeComponent();
nightResults = passedResult;
sessionPlayer = passedPlayer;
deadCount = 0;
day += 1;
CurrentVotes.Text = "";
SqlConnection connect;
string connetionString = null;
connetionString = ("user id=Derek;" +
"server=localhost;" +
"Trusted_Connection=yes;" +
"database=Test");
PlayersList = UserCollection.ReturnUserList();
if (day == 1)
{
foreach (var element in PlayersList)
{
using (connect = new SqlConnection(connetionString))
{
connect.Open();
//read if the passed User is Armed and get their VisitedBy
SqlCommand command = new SqlCommand("Select Role, RoleName FROM [UserStatus] WHERE ID=@ID", connect);
command.Parameters.AddWithValue("@ID", element.UserID);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
element.UserRole = Convert.ToInt32(reader["Role"]);
element.UserRoleName = reader["RoleName"].ToString();
}
}
connect.Close();
}
}
}
foreach (var element in PlayersList)
{
using (connect = new SqlConnection(connetionString))
{
connect.Open();
//read if the passed User is Armed and get their VisitedBy
SqlCommand command = new SqlCommand("Select Status FROM [UserStatus] WHERE ID=@ID", connect);
command.Parameters.AddWithValue("@ID", element.UserID);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
element.UserStatus = Convert.ToBoolean(reader["Status"]);
}
}
connect.Close();
}
}
UserNameContent.Content = passedPlayer.UserName;
//set current day
DayContent.Content = day.ToString();
//check who is dead at start of round
CheckWhoIsDead();
//set button names for lynching
SetPlayerNamesToButtons();
//set description of role for current player
SetRoleDetails();
//find role of current user's player
RoleLabel.Content = sessionPlayer.UserRoleName;
//set a timer that counts down and at the end of the timer switches to new page
timeAmount = TimeSpan.FromSeconds(15);
sixtySeconds = TimeSpan.FromSeconds(10);
fifteenSeconds = TimeSpan.FromSeconds(5);
maxVotes = PlayersList[0];
gameTimer = new DispatcherTimer(new TimeSpan(0, 0, 1), DispatcherPriority.Normal, delegate
{
tbTime.Text = timeAmount.ToString("c");
//enable lynching at 60 seconds remaining
if (timeAmount == sixtySeconds)
{
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;
}
}
//set votes textbox content
if (timeAmount > fifteenSeconds)
{
CurrentVotes.Text = "";
foreach (var element in PlayersList)
{
if (element.UserLynchNominationVotes >= 1)
{
CurrentVotes.Text += element.UserName;
CurrentVotes.Text += " ";
CurrentVotes.Text += element.UserLynchNominationVotes;
CurrentVotes.Text += "\n";
}
if (element.UserLynchNominationVotes > maxVotes.UserLynchNominationVotes)
{
maxVotes = element;
}
}
}
//disable lynching nomination at 15 seconds remaining
//and check if anyone is up for vote
if (timeAmount == fifteenSeconds)
{
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;
foreach (var element in PlayersList)
{
if (maxVotes.UserLynchNominationVotes >= ((PlayersList.Count - deadCount) / 2))
{
YesButton.IsEnabled = true;
NoButton.IsEnabled = true;
}
}
}
//each second after 15 seconds keep current Lynch Vote Displayed
if (timeAmount < fifteenSeconds)
{
using (connect = new SqlConnection(connetionString))
{
connect.Open();
SqlCommand command = new SqlCommand("Select LynchVotes FROM [LynchTable] WHERE ID=@ID", connect);
command.Parameters.AddWithValue("@ID", maxVotes.UserID);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
maxVotes.UserLynchVotes = Convert.ToInt32(reader["LynchVotes"]);
}
}
}
CurrentVotes.Text = maxVotes.UserName + " " + maxVotes.UserLynchVotes.ToString();
}
//at zero time switch windows
if (timeAmount == TimeSpan.Zero)
{
//kill lynched player if we have enough votes
gameTimer.Stop();
if (maxVotes.UserLynchVotes >= ((PlayersList.Count - deadCount) / 2))
{
maxVotes.UserStatus = true;
}
foreach (var element in PlayersList)
{
element.UserHasNomVoted = false;
element.UserHasVoted = false;
element.UserLynchNominationVotes = 0;
element.UserLynchVotes = 0;
}
NightWindow main = new NightWindow(sessionPlayer);
App.Current.MainWindow = main;
this.Close();
main.Show();
}
timeAmount = timeAmount.Add(TimeSpan.FromSeconds(-1));
}, Application.Current.Dispatcher);
gameTimer.Start();
}
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;
}
