private void btnCreateAcc_Click(object sender, EventArgs e)
{
if (txtDefUser.Text.Trim().Length == 0)
{
MessageBox.Show("Please enter your username ");
txtDefUser.Focus();
}
else if (txtDefPass.Text.Trim().Length == 0)
{
MessageBox.Show("Please enter your password");
txtDefPass.Focus();
}
string UserDef;
UserDef = txtDefUser.Text;
int UserStatus;
string filename = "HauntedBuilding.mdf";
string connectionInfo = String.Format(@"Data Source=(LocalDB)\v11.0;
AttachDbFilename=|DataDirectory|\{0};Integrated Security=True;", filename);
SqlConnection Cnn = new SqlConnection(connectionInfo);
//SqlConnection Cnn = new SqlConnection();
//Cnn.ConnectionString = "Data Source=WIN-PC;Initial Catalog=HauntedBuilding;Integrated Security=True";
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = Cnn;
oCmd.CommandTimeout = 0;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spDefineAcc";
oCmd.Parameters.Add("@UserName", SqlDbType.NVarChar);
oCmd.Parameters.Add("@Password", SqlDbType.NVarChar);
oCmd.Parameters["@UserName"].Value = txtDefUser.Text;
oCmd.Parameters["@Password"].Value = txtDefPass.Text;
try
{
Cnn.Open();
oCmd.ExecuteNonQuery();
MessageBox.Show("welcome " + txtDefUser.Text);
UserStatus = 0;
fmSelectGame ff = new fmSelectGame(UserDef, UserStatus);
this.Hide();
ff.ShowDialog();
this.Close();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
txtDefUser.Clear();
txtDefPass.Clear();
txtDefUser.Focus();
}
finally
{
Cnn.Close();
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUser.Text.Trim().Length == 0)
{
MessageBox.Show("Please enter your username ");
txtUser.Focus();
}
else if (txtPass.Text.Trim().Length == 0)
{
MessageBox.Show("Please enter your password");
txtPass.Focus();
}
string Player;
Player = txtUser.Text;
int UStatus;
string filename = "HauntedBuilding.mdf";
string connectionInfo = String.Format(@"Data Source=(LocalDB)\v11.0;
AttachDbFilename=|DataDirectory|\{0};Integrated Security=True;", filename);
SqlConnection Cnn = new SqlConnection(connectionInfo);
//Cnn.ConnectionString = "Data Source=WIN-PC;Initial Catalog=HauntedBuilding;Integrated Security=True";
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = Cnn;
oCmd.CommandTimeout = 0;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spLogin";
oCmd.Parameters.Add("@UserName", SqlDbType.NVarChar);
oCmd.Parameters.Add("@Password", SqlDbType.NVarChar);
oCmd.Parameters["@UserName"].Value = txtUser.Text;
oCmd.Parameters["@Password"].Value = txtPass.Text;
SqlDataReader DR;
try
{
Cnn.Open();
DR = oCmd.ExecuteReader();
if (DR.Read())
{
DR.Close();
this.Close();
UStatus = 1;
fmSelectGame fmSelGame = new fmSelectGame(Player, UStatus);
fmSelGame.ShowDialog();
}
else
{
MessageBox.Show("Username or password not valid");
DR.Close();
txtUser.Clear();
txtPass.Clear();
txtUser.Focus();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
txtUser.Clear();
txtPass.Clear();
txtUser.Focus();
}
finally
{
Cnn.Close();
}
}
