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 bunifuTextBox2_TextChange(object sender, EventArgs e) { bunifuTextBox2.IconRight = Form1.incta.imagevalidator(Validation.validateUserName(bunifuTextBox2.Text)); }