private void Continue_Click(object sender, EventArgs e)
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlDataAdapter adp2 = new SqlDataAdapter("select Username From login_info WHERE Username = '******' AND Pin = '" + Pin.Text + "' ", connection);
DataTable dt2 = new DataTable();
adp2.Fill(dt2);
if (dt2.Rows.Count >= 1)
{
Form2 frm = new Form2(Username.Text);
frm.Show();
this.Hide();
//this.Close();
}
else
{
MessageBox.Show("the username or password is incorrect, please try again");
Username.Clear();
Pin.Clear();
Username.Focus();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
connection.Open();
SqlDataAdapter adp1 = new SqlDataAdapter("select Pin From login_info where Username = '******' ", connection);
DataTable dt1 = new DataTable();
adp1.Fill(dt1);
if (dt1.Rows.Count >= 1)
{
MessageBox.Show("this username already existed");
}
else
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into login_info values( '" + Username.Text + "','" + Pin.Text + "')";
cmd.ExecuteNonQuery();
connection.Close();
if (label5.ForeColor == System.Drawing.Color.Red || label6.ForeColor == System.Drawing.Color.Red)
{
MessageBox.Show("Please change your password");
Pin.Clear();
Pin.Focus();
}
else
{
MessageBox.Show("successful registration!!!");
Username.Clear();
Pin.Clear();
Username.Focus();
}
}
}
catch (Exception)
{
MessageBox.Show("registration failed!");
}
finally
{
}
}
/*
* submit account no. and PIN for validation
* if valid display
*/
private void submit_Click(object sender, EventArgs e)
{
//TEST
Console.WriteLine("==SIGN IN ATTEMPT==");
//check valid account & PIN
Boolean valid = checkAccount();
if (valid)
{
//TEST
Console.WriteLine("..ACCESS GRANTED!..");
//hide account & PIN input
Account.Hide();
Pin.Hide();
lblAccount.Hide();
lblPin.Hide();
submit.Hide();
Button test = new Button();
//Display options
new_atm_load(sender, e);
new_atm_show(sender, e);
}
else
{
//provide user error message
//
//TEST
Console.WriteLine("..ACCESS DENIED!..");
//clear text boxes
Account.Clear();
Pin.Clear();
}
}
