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