private void btnSignIn_Click(object sender, EventArgs e)
{
OracleCommand cmd;
OracleDataReader dr;
if (Validation.validateUserName(bunifuTextBox2.Text) && Validation.validatePassword(bunifuTextBox5.Text))
{
cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from username where email=:e and password1=:p";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("e", bunifuTextBox2.Text);
cmd.Parameters.Add("p", bunifuTextBox5.Text);
dr = cmd.ExecuteReader();
if (dr.Read())
{
DateTime d = Convert.ToDateTime(dr[4]);
MyUser.email = dr[0].ToString();
MyUser.firstname = dr[1].ToString();
MyUser.lastname = dr[2].ToString();
MyUser.password = dr[3].ToString();
MyUser.birthdate = dr[4].ToString();
MyUser.gender = dr[5].ToString();
MyUser.phone = dr[6].ToString();
MyUser.role = dr[7].ToString();
MyUser.cash = int.Parse(dr[8].ToString());
MyUser.age = (DateTime.Now.Year - d.Year).ToString();
Form1.incta.Close();
}
else
{
label3.Text = "Email or Password is incorrect.";
return;
}
dr.Close();
}
else
{
label3.Text = "Email or Password is incorrect.";
}
}
private void bunifuButton1_Click(object sender, EventArgs e)
{
OracleCommand cmd;
OracleDataReader dr;
if (Validation.validateUserName(bunifuTextBox2.Text))
{
cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select email from Username where email=:e";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("e", bunifuTextBox2.Text);
dr = cmd.ExecuteReader();
if (dr.Read())
{
label4.Text = "This Mail is taken before.";
return;
}
dr.Close();
}
if (!Validation.validateFirstName(bunifuTextBox1.Text))
{
label4.Text = "Enter at least 5 chars for First name.";
return;
}
if (!Validation.validateLastName(bunifuTextBox3.Text))
{
label4.Text = "Enter at least 5 chars for Last name.";
return;
}
if (!Validation.validatePassword(bunifuTextBox5.Text))
{
label4.Text = "Enter at least 5 chars for Password.";
return;
}
if (!Validation.validatePasswordconfirm(bunifuTextBox5.Text, bunifuTextBox4.Text))
{
label4.Text = "Confirm password should be the same as Password.";
return;
}
if (!Validation.validatePhone(bunifuTextBox6.Text))
{
label4.Text = "This Phone is Wrong.";
}
string gender = "m";
if (bunifuRadioButton2.Checked)
{
gender = "f";
}
int age = DateTime.Now.Year - bunifuDatePicker1.Value.Year;
DateTime d = bunifuDatePicker1.Value;
string urole = "u";
Random random = new Random();
int cash = random.Next(1000, 10000);
cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "CREATEMUSER";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("e", bunifuTextBox2.Text);
cmd.Parameters.Add("f", bunifuTextBox1.Text);
cmd.Parameters.Add("l", bunifuTextBox3.Text);
cmd.Parameters.Add("p1", bunifuTextBox5.Text);
cmd.Parameters.Add("birth", d);
cmd.Parameters.Add("g", gender);
cmd.Parameters.Add("ph", bunifuTextBox6.Text);
cmd.Parameters.Add("r", urole);
cmd.Parameters.Add("c", cash);
cmd.ExecuteNonQuery();
MyUser.email = bunifuTextBox2.Text;
MyUser.firstname = bunifuTextBox1.Text;
MyUser.lastname = bunifuTextBox3.Text;
MyUser.password = bunifuTextBox5.Text;
MyUser.birthdate = d.ToString();
MyUser.gender = gender;
MyUser.age = age.ToString();
MyUser.role = urole;
MyUser.cash = cash;
Form1.incta.Close();
}
private void bunifuTextBox5_TextChange(object sender, EventArgs e)
{
bunifuTextBox5.IconRight = Form1.incta.imagevalidator(Validation.validatePassword(bunifuTextBox5.Text));
}
