private void LoginValidation()
{
Cursor.Current = Cursors.WaitCursor;
SQLCon.DbCon();
SQLCon.sql = "SELECT USER_ID, Username, Password, FirstName, LastName , AccessLevel, IsActive FROM Accounts WHERE Username=@1 AND Password=@2";
SQLCon.sqlCommand = new SqlCommand(SQLCon.sql, SQLCon.sqlConnection);
SQLCon.sqlCommand.Parameters.AddWithValue("@1", tb_Username.Text);
SQLCon.sqlCommand.Parameters.AddWithValue("@2", tb_Password.Text);
SQLCon.sqlDataReader = SQLCon.sqlCommand.ExecuteReader();
while (SQLCon.sqlDataReader.Read())
{
WelcomeForm.AccountID = Convert.ToInt32((SQLCon.sqlDataReader["USER_ID"].ToString()));
WelcomeForm.Username = (SQLCon.sqlDataReader["Username"].ToString());
WelcomeForm.Password = (SQLCon.sqlDataReader["Password"].ToString());
WelcomeForm.FirstName = (SQLCon.sqlDataReader["FirstName"].ToString());
WelcomeForm.LastName = (SQLCon.sqlDataReader["LastName"].ToString());
accountValidation = (SQLCon.sqlDataReader["IsActive"].ToString());
role = (SQLCon.sqlDataReader["AccessLevel"].ToString());
}
if (WelcomeForm.Username == tb_Username.Text && WelcomeForm.Password == tb_Password.Text && accountValidation == "True")
{
if (role == "ADMIN")
{
MainForm.accessLevel = "ADMIN";
}
else if (role == "TECHNICIAN")
{
MainForm.accessLevel = "TECHNICIAN";
}
else if (role == "PROGRAMMER")
{
MainForm.accessLevel = "PROGRAMMER";
}
this.Close();
WelcomeForm welcomeForm = new WelcomeForm();
welcomeForm.ShowDialog();
}
else if (accountValidation == "False" && WelcomeForm.Username == tb_Username.Text && WelcomeForm.Password == tb_Password.Text)
{
MessageBox.Show("Your account has been suspended. Please contact the Administrator");
tb_Password.Clear();
tb_Username.Clear();
}
else
{
MessageBox.Show("Incorrect username or password");
tb_Password.Clear();
tb_Username.Clear();
}
Cursor.Current = Cursors.Default;
}
private void BackgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
WelcomeForm welcomeForm = new WelcomeForm();
welcomeForm.ShowDialog();
}