private void btnlogin_Click(object sender, EventArgs e) { string query = "SELECT Username, Password FROM Login WHERE Username = @Username"; using (SqlConnection conn = new SqlConnection(cls.setConnectionString())) { using (SqlCommand cmd = new SqlCommand(query, conn)) { //add a parameter to sql query cmd.Parameters.AddWithValue("Username", txtuname.Text); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { //read the first row that reader returned and save password from DB into variable reader.Read(); string username = reader["Username"].ToString(); string password = reader["Password"].ToString(); //string priviledgeLevel = reader["PriviledgeLvl"].ToString(); // string prv; if (reader.Read() == true) { return; } else if (txtpwrd.Text == password) { this.Visible = false; MainMenu main = new MainMenu(); main.ShowDialog(); } else if (txtuname.Text != username || txtpwrd.Text != password) { MessageBox.Show("Password not Valid, Please TryAgain", "User Login", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Invalid Access Please TryAgain", "UserLogin", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } }
private void buttondangnhap_Click(object sender, EventArgs e) { NguoiDungBUS ndBUS = new NguoiDungBUS(); NguoiDungDTO tn = new NguoiDungDTO(); string tendangnhap = textBoxuser.Text; string password = textBoxpass.Text; if (ndBUS.kiemtra(tn, tendangnhap, password)) { MainMenu f = new MainMenu(); this.Hide(); f.ShowDialog(); this.Show(); } else { MessageBox.Show("Sai tên tài khoản hoặc mật khẩu!"); } }
private void btnLogin_Click_1(object sender, EventArgs e) { SqlConnection sqlcon = new SqlConnection(Globals_Class.ConnectionString); string Query = "SELECT * FROM Users WHERE UserName='******' and UserPassword ='******'"; SqlDataAdapter SDA = new SqlDataAdapter(Query, sqlcon); DataTable dtbl = new DataTable(); SDA.Fill(dtbl); if (string.IsNullOrEmpty(txtUsername.Text)) { MetroFramework.MetroMessageBox.Show(this, "Please enter your Username.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtUsername.Focus(); return; } else if (string.IsNullOrEmpty(txtPassword.Text)) { MetroFramework.MetroMessageBox.Show(this, "Please enter your Password.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtPassword.Focus(); return; } else if (dtbl.Rows.Count == 1) { SqlConnection sqlcon1 = new SqlConnection(Globals_Class.ConnectionString); sqlcon1.Open(); string Select = "SELECT * FROM Users WHERE UserName ='******' AND UserPassword ='******'"; SqlCommand sqlcom1 = new SqlCommand(Select, sqlcon1); SqlDataReader SQLREADER; SQLREADER = sqlcom1.ExecuteReader(); while (SQLREADER.Read()) { string UserName; int ID; UserName = (SQLREADER["UserName"].ToString()); ID = Convert.ToInt32((SQLREADER["UserID"])); Globals_Class.UserName = UserName; Globals_Class.UserID = ID; if (ID == 1) { Globals_Class.adminNumber = 1; } else { Globals_Class.adminNumber = 0; } } MainMenu myform1 = new MainMenu(); myform1.ShowDialog(); this.Hide(); this.Close(); this.Dispose(true); } else { MetroFramework.MetroMessageBox.Show(this, "The Username and Password entered does not match any records!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }