private void addUserBtn_Click(object sender, RoutedEventArgs e)
{
string result;
if (String.IsNullOrEmpty(txtUserName.Text))
{
MessageBox.Show("Please input 'UserID' for delete");
}
else if (string.IsNullOrEmpty(txtPassword.Password))
{
MessageBox.Show("Please input Password");
}
else
{
using (SqliteConnection db =
new SqliteConnection($"Filename={dbpath}"))
{
db.Open();
SqliteCommand selectCommand = new SqliteCommand
("SELECT COUNT (*) FROM MyLogin", db);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
result = query.GetString(0);
if (result == "0")
{
UserRegister userRegister = new UserRegister();
userRegister.Show();
}
else
{
string userName = txtUserName.Text;
string passWord = txtPassword.Password;
string sql = "SELECT * FROM MyLogin WHERE UserName ='******' AND Password ='******' AND AuthorLevel ='5'";
using (SqliteConnection db1 =
new SqliteConnection($"Filename={dbpath}"))
{
db1.Open();
SqliteCommand selectCommand1 = new SqliteCommand(sql, db1);
SqliteDataReader query1 = selectCommand1.ExecuteReader();
while (query1.Read())
{
this.Hide();
UserRegister userRegister = new UserRegister();
userRegister.Show();
return;
}
db1.Close();
}
}
//MessageBox.Show(result.ToString());
}
db.Close();
}
}
}
private void lblAdminSetting_MouseDown(object sender, MouseButtonEventArgs e)
{
UserRegister userRegister = new UserRegister();
userRegister.Show();
}
