private void btn_Login_Click(object sender, EventArgs e) { int member_id; if (txt_Username.Text == "") { MessageBox.Show("Username is required"); } if(txt_Password.Text == "") { MessageBox.Show("Password is required"); } if (txt_Password.Text != "" && txt_Username.Text != "") { try { connection.Open(); OleDbDataAdapter da = new OleDbDataAdapter("select * from MemberData where username = '******' and pass='******'", connection); DataTable dt = new DataTable(); da.Fill(dt); //เก็บค่า member_id เพื่อส่งต่อไปยัง doorder จะได้รุ้ว่าใครทำรายาการ member_id = Int32.Parse(dt.Rows[0][0].ToString()); //ถ้า username และ password ถูกต้อง if (dt.Rows.Count == 1) { MessageBox.Show("Login Successful"); DoOrder doorder = new DoOrder(member_id); this.Hide(); doorder.ShowDialog(); this.Close(); } else { MessageBox.Show("Your Username or Password is invalid"); } connection.Close(); } catch (Exception ex) { connection.Close(); MessageBox.Show("Your Username or Password is invalid"); } } }
private void btn_Login_Click(object sender, EventArgs e) { int member_id; if (txt_RfidNumber.Text == "") { MessageBox.Show("Rfiudnumber is required"); } if (txt_Password.Text == "") { MessageBox.Show("Password is required"); } if (txt_RfidNumber.Text != "" && txt_Password.Text != "") { try { connection.Open(); OleDbDataAdapter da = new OleDbDataAdapter("select * from MemberData where rfid_number = '" + txt_RfidNumber.Text + "' and pass='******'", connection); DataTable dt = new DataTable(); da.Fill(dt); member_id = Int32.Parse(dt.Rows[0][0].ToString()); if (dt.Rows.Count == 1) { MessageBox.Show("Login Successful"); serialPort1.Close(); DoOrder doorder = new DoOrder(member_id); this.Hide(); doorder.ShowDialog(); this.Close(); } else { MessageBox.Show("Rfidnumber or Password is invalid"); } connection.Close(); } catch (Exception ex) { connection.Close(); MessageBox.Show("Your Rfidnumber or Password is invalid"); } } }