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