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(); } }