private void Login_Button_Click(object sender, EventArgs e)
{
if (userName_textBox.Text == "" || password_textBox.Text == "")
{
MessageBox.Show("Please enter your username and password");
userName_textBox.Focus();
return;
}
string sqlCommand = "Select * from Account where username=@usrname and password=@passwd";
connection.Open();
using (SqlCommand cmd = new SqlCommand(sqlCommand, connection))
{
cmd.Parameters.AddWithValue("@usrname", userName_textBox.Text);
cmd.Parameters.AddWithValue("@passwd", password_textBox.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{
login.Load(reader);
}
}
//Ko dang nhap dc
if (login.Rows.Count == 0)
{
MessageBox.Show("Wrong username or password, try again");
userName_textBox.Clear();
password_textBox.Clear();
userName_textBox.Focus();
}
else //Dang nhap thanh cong
{
Account account = new Account(login.Rows[0]["username"].ToString(), int.Parse(login.Rows[0]["userID"].ToString()),
login.Rows[0]["phone"].ToString(), login.Rows[0]["name"].ToString(),
login.Rows[0]["DOB"].ToString()
);
MessageBox.Show("Login successfully !");
mainScr.loading_thread.Start();
mainScr.setAccount(account);
mainScr.setAccountButtonUsername(login.Rows[0]["username"].ToString());
/*this.Hide();
* var temp = new MainScreen(account);
* temp.Show();*/
this.Close();
}
login.Clear();
connection.Close();
}
