public static void LoginOperation(TextBox loginField, TextBox passwordField, Form form)
{
string login = loginField.Text;
string password = passwordField.Text;
string connectionString = @"Data Source=ceres-pc\sqlexpress;Initial Catalog=AutomotiveDb;Integrated Security=True";
string selectLogin = $"SELECT LOGIN, SENHA, STATUS FROM TBUSER WHERE LOGIN = '******' AND SENHA = '{password}';";
string loginReturn, passwordReturn, statusReturn;
string statusActive = "Ativo";
string statusAdmin = "Admin";
string statusMaster = "Master";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand cmdSelectLogin = new SqlCommand(selectLogin, connection);
connection.Open();
SqlDataReader loginReader = cmdSelectLogin.ExecuteReader();
if (loginReader.Read())
{
loginReturn = loginReader[0].ToString();
passwordReturn = loginReader[1].ToString();
statusReturn = loginReader[2].ToString();
if (string.Equals(password, passwordReturn) == true)
{
if (string.Equals(statusActive, statusReturn) == true || string.Equals(statusAdmin, statusReturn) == true ||
string.Equals(statusMaster, statusReturn) == true)
{
FrmInitial frmInitial = new FrmInitial();
frmInitial.Show();
}
else
{
MessageBox.Show("Usuário inativo", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Error);
loginField.Text = string.Empty;
passwordField.Text = string.Empty;
loginField.Focus();
}
}
else
{
MessageBox.Show("Login ou senha invalida!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error);
loginField.Text = string.Empty;
passwordField.Text = string.Empty;
loginField.Focus();
}
}
else
{
MessageBox.Show("Login ou senha invalida!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Error);
loginField.Text = string.Empty;
passwordField.Text = string.Empty;
loginField.Focus();
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
FrmInitial frmInitial = new FrmInitial();
DbOperations.LoginOperation(tbxLogin, tbxPassword, frmInitial);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
