private void changePasswordToolStripMenuItem_Click(object sender, EventArgs e)
{
if (listBoxUsers.SelectedItem == null)
{
return;
}
string userName = listBoxUsers.SelectedItem.ToString();
FormAddUser frmAddUser = new FormAddUser();
if (frmAddUser.ShowDialog(userName) == DialogResult.OK)
{
try
{
GlobalSetting.DataAccess.Excute("exec SP_ChangePassword {0}, {1}",
userName, frmAddUser.Password);
if (GlobalSetting.DataAccess.UserName.Equals(userName, StringComparison.CurrentCultureIgnoreCase))
{
GlobalSetting.DataAccess.Password = frmAddUser.Password;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
private void addUserToolStripMenuItem_Click(object sender, EventArgs e)
{
FormAddUser frmAddUser = new FormAddUser();
if (frmAddUser.ShowDialog() == DialogResult.OK)
{
try
{
GlobalSetting.DataAccess.Excute("exec SP_CreateUser {0}, {1}, 2147483647",
frmAddUser.UserName, frmAddUser.Password);
if (listBoxUsers.Items.Count == 0)
{
MessageBox.Show("User account initiated, you should restart QueryAnalyzer", "Prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
Environment.Exit(0);
}
RefreshUserList();
listBoxUsers.SelectedItem = frmAddUser.UserName;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
