// Button to create the profile in database
// All textbox designated are checked for input
// The username is checked in the database for any similar usernames ( No double usernames allowed )
private void Button_Register_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(TextBox_Name.Text) ||
string.IsNullOrWhiteSpace(TextBox_userID.Text) ||
string.IsNullOrWhiteSpace(PasswordBox_password.Password) ||
string.IsNullOrWhiteSpace(TextBox_email.Text))
{
MessageBox.Show("Required fields missing, please complete the registration form.");
}
else
{
try
{
var query = from p in db.PlayerInformations
where (p.UserID.Equals(TextBox_userID.Text))
select p;
if (query.Any())
{
MessageBox.Show("Username is already taken. Please choose a different username.");
TextBox_userID.Text = "";
TextBox_userID.Focus();
}
else if (!PasswordBox_ReenterPassword.Password.Equals(PasswordBox_password.Password))
{
MessageBox.Show("Passwords do not match. Please reenter you password.");
PasswordBox_password.Password = "";
PasswordBox_ReenterPassword.Password = "";
PasswordBox_password.Focus();
}
else
{
// Create new player information object
PlayerInformation newplayer = new PlayerInformation();
newplayer.Name = TextBox_Name.Text;
newplayer.UserID = TextBox_userID.Text;
newplayer.Password = PasswordBox_password.Password;
newplayer.Email = TextBox_email.Text.Trim();
db.PlayerInformations.InsertOnSubmit(newplayer);
db.SubmitChanges();
prevWindow.Show();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("There was an error processing your registration, please try again.");
Console.WriteLine(ex.Message);
}
}
}
private void updateHistory()
{
DatabaseDataContext db = new DatabaseDataContext(Properties.Settings.Default.Tfour_ConnectionString);
// save player one information in the database
PlayerHistory newPH = new PlayerHistory();
newPH.PlayerOne = gamePlayers[0].getPlayerID();
newPH.PlayerOneScore = gamePlayers[0].getScore();
newPH.Opponet = gamePlayers[1].getPlayerID();
newPH.OpponetScore = gamePlayers[1].getScore();
newPH.GameDate = DateTime.Now;
if (gamePlayers[0].isWinner())
{
newPH.Winner = gamePlayers[0].getPlayerID();
}
else if (gamePlayers[1].isWinner())
{
newPH.Winner = gamePlayers[1].getPlayerID();
}
else
{
newPH.Winner = "Draw";
}
db.PlayerHistories.InsertOnSubmit(newPH);
db.SubmitChanges();
// save player two ddinformation in the database
PlayerHistory newPH2 = new PlayerHistory();
newPH2.PlayerOne = gamePlayers[1].getPlayerID();
newPH2.PlayerOneScore = gamePlayers[1].getScore();
newPH2.Opponet = gamePlayers[0].getPlayerID();
newPH2.OpponetScore = gamePlayers[0].getScore();
newPH2.GameDate = DateTime.Now;
if (gamePlayers[1].isWinner())
{
newPH2.Winner = gamePlayers[1].getPlayerID();
}
else if (gamePlayers[0].isWinner())
{
newPH2.Winner = gamePlayers[0].getPlayerID();
}
else
{
newPH2.Winner = "Draw";
}
db.PlayerHistories.InsertOnSubmit(newPH2);
db.SubmitChanges();
}
private void updateHistory()
{
DatabaseDataContext db = new DatabaseDataContext(Properties.Settings.Default.Tfour_ConnectionString);
// save player one information in the database
PlayerHistory newPH = new PlayerHistory();
newPH.PlayerOne = gamePlayers[0].getPlayerID();
newPH.PlayerOneScore = gamePlayers[0].getScore();
newPH.Opponet = gamePlayers[1].getPlayerID();
newPH.OpponetScore = gamePlayers[1].getScore();
newPH.GameDate = DateTime.Now;
if (gamePlayers[0].isWinner())
{
newPH.Winner = gamePlayers[0].getPlayerID();
}
else if (gamePlayers[1].isWinner())
{
newPH.Winner = gamePlayers[1].getPlayerID();
}
else
{
newPH.Winner = "Draw";
}
db.PlayerHistories.InsertOnSubmit(newPH);
db.SubmitChanges();
// save player two ddinformation in the database
PlayerHistory newPH2 = new PlayerHistory();
newPH2.PlayerOne = gamePlayers[1].getPlayerID();
newPH2.PlayerOneScore = gamePlayers[1].getScore();
newPH2.Opponet = gamePlayers[0].getPlayerID();
newPH2.OpponetScore = gamePlayers[0].getScore();
newPH2.GameDate = DateTime.Now;
if (gamePlayers[1].isWinner())
{
newPH2.Winner = gamePlayers[1].getPlayerID();
}
else if (gamePlayers[0].isWinner())
{
newPH2.Winner = gamePlayers[0].getPlayerID();
}
else
{
newPH2.Winner = "Draw";
}
db.PlayerHistories.InsertOnSubmit(newPH2);
db.SubmitChanges();
}