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