private void btnRegister_Click(object sender, EventArgs e)
{
if (txtboxConfirmPassword.Text.Length < 2)
{
MessageBox.Show("Enter a longer password");
}
if (passValid)
{
DBConnect connector = new DBConnect();
List <String>[] temp = connector.SelectUsers("SELECT * FROM Users WHERE name='" + txtboxUsername.Text + "'");
if (temp[0].Count == 0)
{
connector.Insert("INSERT INTO Users (name,pass) VALUES ('" + txtboxUsername.Text + "','" + txtboxPassword.Text + "')");
txtboxPassword.Clear();
txtboxConfirmPassword.Clear();
txtboxUsername.Clear();
this.Hide();
parent.Show();
}
else
{
MessageBox.Show("Error user already exists");
}
}
else
{
lblMismatch.Text = "Passwords do no match!";
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
if (txtboxConfirmPassword.Text.Length < 2)
{
MessageBox.Show("Enter a longer password");
}
if (passValid)
{
DBConnect connector = new DBConnect();
List<String>[] temp = connector.SelectUsers("SELECT * FROM Users WHERE name='" + txtboxUsername.Text + "'");
if (temp[0].Count == 0)
{
connector.Insert("INSERT INTO Users (name,pass) VALUES ('" + txtboxUsername.Text + "','" + txtboxPassword.Text + "')");
txtboxPassword.Clear();
txtboxConfirmPassword.Clear();
txtboxUsername.Clear();
this.Hide();
parent.Show();
}
else
{
MessageBox.Show("Error user already exists");
}
}
else
{
lblMismatch.Text = "Passwords do no match!";
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
String givenUserName = Regex.Replace(txtboxUserName.Text, @"[\r\n\x00\x1a\\'""]", @"\$0");
String givenPassword = Regex.Replace(txtboxPassword.Text, @"[\r\n\x00\x1a\\'""]", @"\$0");
DBConnect connector = new DBConnect();
List <String>[] temp = connector.SelectUsers("SELECT * FROM Users WHERE name='" + givenUserName + "' AND pass='******'");
ValidateLogin();
if (temp[0].Count == 1) //Pass
{
userValid = true;
passValid = true;
}
else //Fail because of wrong password
{
userValid = false;
passValid = false;
txtboxPassword.Text = "";
MessageBox.Show("Error: username/password do not match");
lblErrorMsg.Visible = true;
}
if (userValid && passValid) //txtboxUserName.Text.Equals("username") && txtboxPassword.Text.Equals("Password");
{
//MessageBox.Show("UID:" + temp[0][0]);
HomeForm main = new HomeForm(this, int.Parse(temp[0][0]), txtboxUserName.Text);
main.Show();
this.Hide();
txtboxPassword.Text = "";
txtboxUserName.Text = "";
}
else
{
lblErrorMsg.Visible = true;
}
}
