public void Login(Users user)
{
ConnectionControl();
command = new SqlCommand("Select UserName,UserPassword From Users Where UserName=@UserName And UserPassword=@UserPassword", _connection);
command.Parameters.AddWithValue("@UserName", user.UserName);
command.Parameters.AddWithValue("@UserPassword", user.UserPassword);
reader = command.ExecuteReader();
if (reader.Read())
{
HomeScreen homeScreen = new HomeScreen();
homeScreen.Show();
}
else
{
MessageBox.Show("Login Failed");
}
_connection.Close();
}
private void btnEntry_Click(object sender, EventArgs e)
{
string query = "SELECT * FROM Users where UserName = '******' AND UserPassword = '******'";
ConnectionControl();
_command.Connection = _connection;
_command.CommandText = query;
_reader = _command.ExecuteReader();
if (_reader.Read())
{
HomeScreen home = new HomeScreen();
this.Hide();
home.Show();
}
else
{
MessageBox.Show("Kullanıcı bilgilerini kontrol ediniz");
}
_connection.Close();
}