private void DropUserSQL()
{
fctSQL.Text = string.Empty;
ePlugin pl = (rbLegacy.Checked) ? ePlugin.Legacy_UserManager : ePlugin.Srp;
string cmd = $@"DROP USER {txtUserName.Text} ";
cmd += $@"USING PLUGIN {pl};";
cmd += Environment.NewLine;
cmd += Environment.NewLine;
cmd += "COMMIT;";
fctSQL.Text = cmd;
}
private void UpdateUserSQL()
{
fctSQL.Text = string.Empty;
ePlugin pl = (rbLegacy.Checked) ? ePlugin.Legacy_UserManager : ePlugin.Srp;
string cmd = $@"ALTER USER {txtUserName.Text} ";
if (txtFirstName.Text.Length > 0)
{
cmd += $@"FIRSTNAME '{txtFirstName.Text}' ";
}
if (txtMiddleName.Text.Length > 0)
{
cmd += $@"MIDDLENAME '{txtMiddleName.Text}' ";
}
if (txtLastName.Text.Length > 0)
{
cmd += $@"LASTNAME '{txtLastName.Text}' ";
}
cmd += $@"PASSWORD '{txtPassword.Text}' ";
if (rbUserActive.Checked)
{
cmd += "ACTIVE ";
}
else
{
cmd += "INACTIVE ";
}
cmd += $@"USING PLUGIN {pl.ToString()} ";
if (rbIsAdmin.Checked)
{
cmd += "GRANT ADMIN ROLE";
}
else
{
cmd += "REVOKE ADMIN ROLE";
}
cmd += ";";
cmd += Environment.NewLine;
cmd += "COMMIT;";
fctSQL.Text = cmd;
}
