private void btn_register_Click(object sender, EventArgs e)
{
try
{
con.Open();
cmd.Connection = con;
cmd.CommandText = "select * from Profile where UserName='******'";
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
MessageBox.Show("This username exists,choose another one!");
}
else
{ //we have to close the DataReader so we can execute the insert query
dr.Close();
//we will add a new user by inserting his UserName,his Password and his E-mail
SqlCommand cmd1 = new SqlCommand("insert into Profile(UserName,Password,Email,ProfilePic) values(@UserName,@Password,@Email,@ProfilePic)", con);
//Je dois confgurer les paramétres
cmd1.CommandType = CommandType.Text;//Cette instruction donne le type de la commande , la valeur par defaut est text et elle n'est pas obligatoire
cmd1.Parameters.AddWithValue("@UserName", txt_username.Text);
cmd1.Parameters.AddWithValue("@Password", txt_password.Text);
cmd1.Parameters.AddWithValue("@Email", txt_Email.Text);
var image = new ImageConverter().ConvertTo(pictureBox1.Image, typeof(Byte[]));
cmd1.Parameters.AddWithValue("@ProfilePic", image);
//get the FK
FK = txt_username.Text;
//newuser confirmed
NewUser = true;
Note = true;
//Execut the query
cmd1.ExecuteNonQuery();
//MessageBox.Show("success");
sc.Show();
//this.Hide();
fb.Close();
tw.Close();
gp.Close();
/*PersonalInformation p = new PersonalInformation();
* p.Show();
* this.Hide();*/
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
private void btnSignIn_Click(object sender, EventArgs e)
{
try
{
con.Open();
cmd.Connection = con;
cmd.CommandText = "select * from Profile where UserName='******'";
dr = cmd.ExecuteReader();
if (dr.HasRows)
{ //get the FK
FK = txt_username.Text;
Boolean ok = false;
while (dr.Read() && ok == false)
{
if (!txt_password.Text.Equals(dr["Password"]))
{
PasswordCheck pw = new PasswordCheck();
pw.Show();
// MessageBox.Show("You need to check your password!");
ok = true;
}
else if (!txt_Email.Text.Equals(dr["Email"]))
{ //MessageBox.Show("You need to check your E-mail!");
EmailCheck ec = new EmailCheck();
ec.Show();
ok = true;
}
}
if (ok == false)
{
dsh.Show();
this.Hide();
fb.Close();
tw.Close();
gp.Close();
}
}
else
{
if (txt_password.Text.Equals("") && txt_Email.Text.Equals("") && txt_username.Text.Equals(""))
{
// MessageBox.Show("The fields are empty");
EmptyFields ep = new EmptyFields();
ep.Show();
}
else
{
}
// MessageBox.Show("You need to register!");
CheckRegistration crg1 = new CheckRegistration();
crg1.Show();
dr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}