Example #1
0
 private void CloseButton(object sender, RoutedEventArgs e)
 {
     closeBackground.Visibility         = Visibility.Collapsed;
     closeButton.Visibility             = Visibility.Collapsed;
     patvirtintiBackround.Visibility    = Visibility.Collapsed;
     patvirtintiButton.Visibility       = Visibility.Collapsed;
     KeistiDescription.Visibility       = Visibility.Collapsed;
     KeistiLabel.Visibility             = Visibility.Collapsed;
     greyedOut.Visibility               = Visibility.Collapsed;
     KeistiWindow.Visibility            = Visibility.Collapsed;
     kodoTextBox.Visibility             = Visibility.Collapsed;
     kodoLabel.Visibility               = Visibility.Collapsed;
     passLabel.Visibility               = Visibility.Collapsed;
     PassTextBox.Visibility             = Visibility.Collapsed;
     newPassLabel.Visibility            = Visibility.Collapsed;
     NewPasswordTextBox.Visibility      = Visibility.Collapsed;
     newPassAgainLabel.Visibility       = Visibility.Collapsed;
     NewPasswordAgainTextBox.Visibility = Visibility.Collapsed;
     passUnderLine.Visibility           = Visibility.Collapsed;
     newPassUnderline.Visibility        = Visibility.Collapsed;
     kodoUnderline.Visibility           = Visibility.Collapsed;
     newPassAgainUnderline.Visibility   = Visibility.Collapsed;
     generalEventText.Visibility        = Visibility.Collapsed;
     kodoTextBox.Clear();
     NewPasswordAgainTextBox.Clear();
     NewPasswordTextBox.Clear();
     PassTextBox.Clear();
     generalEventText.Content = "";
 }
        public AccountPanel()
        {
            InitializeComponent();

            ViewModel = new AccountPanelViewModel();

            this.WhenActivated(d =>
            {
                this.Bind(ViewModel, vm => vm.User, v => v.User).DisposeWith(d);

                this.Bind(ViewModel, vm => vm.IsShowingNewPasswordOptions, v => v.NewPasswordToggleButton.IsChecked).DisposeWith(d);
                this.OneWayBind(ViewModel, vm => vm.IsShowingNewPasswordOptions, v => v.NewPasswordGrid.Visibility).DisposeWith(d);
                this.Bind(ViewModel, vm => vm.NewPassword, v => v.NewPasswordTextBox.Text).DisposeWith(d);
                this.OneWayBind(ViewModel, vm => vm.User.Principal.Enabled, v => v.ToggleEnabledButton.Content, isEnabled => isEnabled != null ? (bool)isEnabled ? "Disable" : "Enable" : "Unavailable").DisposeWith(d);
                this.OneWayBind(ViewModel, vm => vm.User.Principal.Enabled, v => v.ToggleEnabledButton.IsEnabled, isEnabled => isEnabled != null ? true : false).DisposeWith(d);

                this.BindCommand(ViewModel, vm => vm.SetNewPassword, v => v.SetNewPasswordButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.SetNewSimplePassword, v => v.SetNewSimplePasswordButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.SetNewComplexPassword, v => v.SetNewComplexPasswordButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.ExpirePassword, v => v.ExpirePasswordButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.UnlockAccount, v => v.UnlockAccountButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.RunLockoutStatus, v => v.LockOutStatusButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.OpenPermittedWorkstations, v => v.PermittedWorkstationsButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.ToggleEnabled, v => v.ToggleEnabledButton).DisposeWith(d);
                this.BindCommand(ViewModel, vm => vm.OpenSplunk, v => v.SplunkButton).DisposeWith(d);
                NewPasswordTextBox.Events()
                .KeyDown
                .Where(args => args.Key == Key.Enter)
                .ToSignal()
                .InvokeCommand(ViewModel.SetNewPassword).DisposeWith(d);
            });
        }
        private bool IsFormValid()
        {
            if (OldPasswordTextBox.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Old password is Required.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                OldPasswordTextBox.Focus();
                return(false);
            }

            if (NewPasswordTextBox.Text.Trim() == string.Empty)
            {
                MessageBox.Show("New password is Required.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                NewPasswordTextBox.Focus();
                return(false);
            }

            if (ConfirmPasswordTextBox.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Confirm password is Required.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                ConfirmPasswordTextBox.Focus();
                return(false);
            }

            if (NewPasswordTextBox.Text.Trim() != ConfirmPasswordTextBox.Text.Trim())
            {
                MessageBox.Show("New and Confirm password does not match.", "Validation Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                ConfirmPasswordTextBox.Focus();
                return(false);
            }

            return(true);
        }
        private void ResetFormControl()
        {
            NewPasswordTextBox.Clear();
            OldPasswordTextBox.Clear();
            ConfirmPasswordTextBox.Clear();

            OldPasswordTextBox.Focus();
        }
Example #5
0
 private void SecureSettingsShow()
 {
     ChangePassLabel.Show();
     OldPasswordTextBox.Show();
     NewPasswordTextBox.Show();
     ConfirmPasswordTextBox.Show();
     ChangeButton.Show();
     materialDivider1.Show();
     CreateKeyLabel.Show();
     SecureKeyDescLabel.Show();
     CreateKeyButton.Show();
     WarningLabel.Show();
 }
Example #6
0
        private void OK_Click(object sender, RoutedEventArgs e)
        {
            if (NameTextBox.Text == "")
            {
                MessageBox.Show("이름을 입력하세요!!");
                NameTextBox.Focus();
                return;
            }
            else if (AgeTextBox.Text == "")
            {
                MessageBox.Show("나이를 입력하세요!!");
                AgeTextBox.Focus();
                return;
            }
            else if (NewIDTextBox.Text == "")
            {
                MessageBox.Show("ID를 입력하세요!!");
                NewIDTextBox.Focus();
                return;
            }
            else if (NewPasswordTextBox.Password == "")
            {
                MessageBox.Show("PWD를 입력하세요!!");
                NewPasswordTextBox.Focus();
                return;
            }
            string insertQuery = "INSERT INTO info(id,password,name,age) VALUES('" + NewIDTextBox.Text + "','" + NewPasswordTextBox.Password + "','" + NameTextBox.Text + "','" + AgeTextBox.Text + "')";

            conn.Open();
            MySqlCommand cmd = new MySqlCommand(insertQuery, conn);

            try
            {
                if (cmd.ExecuteNonQuery() == 1)//내가 처리한 mysql에 정상적으로 들어감
                {
                    MessageBox.Show("회원가입 완료!!");
                    Window.GetWindow(this).Close();
                }
                else
                {
                    MessageBox.Show("오류");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("같은 아이디가 있습니다ㅜ-ㅜ");
            }
            conn.Close();
        }
Example #7
0
 private void btnOK_Click(object sender, EventArgs e)
 {
     CanClose = false;
     try
     {
         if (NewPasswordTextBox.Text == "")
         {
             MessageBox.Show("新密碼不可空白!", "錯誤",
                             MessageBoxButtons.OK, MessageBoxIcon.Error);
             NewPasswordTextBox.Focus();
             return;
         }
         if (NewPasswordTextBox.Text != ConfirmPasswordTextBox.Text)
         {
             MessageBox.Show("新密碼與確認新密碼不一致!", "錯誤",
                             MessageBoxButtons.OK, MessageBoxIcon.Error);
             NewPasswordTextBox.Focus();
             return;
         }
         using (var context = new XINEntities())
         {
             var qry = (from U in context.XINUsers
                        where U.EmployeeNo == fmMain.FEmployeeNo &&
                        U.PasswordCode == OrignalPasswordTextBox.Text
                        select U).FirstOrDefault();
             if (qry == null)
             {
                 MessageBox.Show("原來的密碼輸入錯誤!", "錯誤",
                                 MessageBoxButtons.OK, MessageBoxIcon.Error);
                 OrignalPasswordTextBox.Focus();
                 return;
             }
             //開始更新使用者的密碼
             qry.PasswordCode = NewPasswordTextBox.Text;
             context.SaveChanges();
             MessageBox.Show("密碼變更完成", "變更密碼",
                             MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message, "錯誤", MessageBoxButtons.OK,
                         MessageBoxIcon.Error);
     }
     //成功完成密碼變更,允許關閉視窗
     CanClose = true;
 }
Example #8
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            //開始密碼變更,禁止關閉視窗
            CanClose = false;

            //驗證程序
            try
            {
                if (NewPasswordTextBox.Text == "")
                {
                    MessageBox.Show("新密碼不可空白!", "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    NewPasswordTextBox.Focus();
                    return;
                }
                if (NewPasswordTextBox.Text != ConfirmPasswordTextBox.Text)
                {
                    MessageBox.Show("新密碼與確認密碼不一致!", "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    NewPasswordTextBox.Focus();
                    return;
                }
                using (var SSEntities = new SmartShoppingEntities())
                {
                    var qry = (from U in SSEntities.SSUsers
                               where U.Employee_ID == frmMain.FUserID && U.Password == OrignalPasswordTextBox.Text
                               select U).FirstOrDefault();
                    if (qry == null)
                    {
                        MessageBox.Show("原來密碼錯誤!", "錯誤",
                                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                        OrignalPasswordTextBox.Focus();
                        return;
                    }

                    //開始更新使用者的密碼
                    qry.Password = NewPasswordTextBox.Text;
                    SSEntities.SaveChanges();
                    MessageBox.Show("密碼變更完成,下次登入請使用新密碼", "變更密碼", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "錯誤", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            //完成密碼變更,允許關閉視窗
            CanClose = true;
        }
 /// <summary>
 /// 修改密码
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void ChangePasswordQQButton_Click(object sender, EventArgs e)
 {
     if (FormBasicFeatrues.GetInstence().GetMd5Hash(MD5.Create(), OldPasswordTextBox.Text).Equals(MainWindow.PASSWORD_HASH))
     {
         if (NewPasswordTextBox.Text.Equals(NewPasswordTextBox2.Text))
         {
             try
             {
                 if (DatabaseConnections.Connector.OnlineUpdateData(
                         "users",
                         new string[] { "password" },
                         new string[] { FormBasicFeatrues.GetInstence().GetMd5Hash(MD5.Create(), NewPasswordTextBox.Text) },
                         MainWindow.ID) > 0)
                 {
                     OldPasswordTextBox.Clear();
                     NewPasswordTextBox.Clear();
                     NewPasswordTextBox2.Clear();
                     MessageBox.Show("修改密码成功!下次登录时候您将需要使用新密码!", "成功");
                     //MainWindow.PASSWORD_HASH = FormBasicFeatrues.GetInstence().GetMd5Hash(MD5.Create(), NewPasswordTextBox.Text);
                     ChangePasswordCheckBox.Checked = false;
                     isChangedPassword = true;
                 }
             }
             catch (Exception ee)
             {
                 MessageBox.Show(ee.Message, "密码修改错误");
                 //throw;
             }
         }
         else
         {
             MessageBox.Show("两次密码不同!", "错误");
             NewPasswordTextBox.Clear();
             NewPasswordTextBox2.Clear();
         }
     }
     else
     {
         MessageBox.Show("旧密码输入错误!", "错误");
         OldPasswordTextBox.Clear();
         NewPasswordTextBox.Clear();
         NewPasswordTextBox2.Clear();
     }
 }
Example #10
0
        private void SaveButton_Click(object sender, EventArgs e)
        {
            SuccessLabel.Visible       = false;
            OldPassLabel.Visible       = false;
            NewPassLabel.Visible       = false;
            RepeatNewPassLabel.Visible = false;

            OldAuthLabel.Visible       = false;
            NewAuthLabel.Visible       = false;
            RepeatNewAuthLabel.Visible = false;

            if (CurrentPasswordTextBox.Text.Length > 0 || NewPasswordTextBox.Text.Length > 0 || AcceptNewPasswordTextBox.Text.Length > 0)
            {
                if (CurrentPasswordTextBox.Text.Length == 0)
                {
                    OldPassLabel.Text    = "Введите старый пароль";
                    OldPassLabel.Visible = true;
                    return;
                }

                if (Security.CheckPass(CurrentPasswordTextBox.Text) == false)
                {
                    OldPassLabel.Text    = "Пароль неверный";
                    OldPassLabel.Visible = true;
                    return;
                }

                if (NewPasswordTextBox.Text.Length == 0)
                {
                    NewPassLabel.Text    = "Введите новый пароль";
                    NewPassLabel.Visible = true;
                    return;
                }

                if (NewPasswordTextBox.Text.Length < 4)
                {
                    NewPassLabel.Text    = "Длина пароля меньше 4 символов";
                    NewPassLabel.Visible = true;
                    return;
                }

                if (AcceptNewPasswordTextBox.Text.Length == 0)
                {
                    RepeatNewPassLabel.Text    = "Повторите новый пароль";
                    RepeatNewPassLabel.Visible = true;
                    return;
                }

                if (AcceptNewPasswordTextBox.Text != NewPasswordTextBox.Text)
                {
                    RepeatNewPassLabel.Text    = "Пароли не совпадают";
                    RepeatNewPassLabel.Visible = true;
                    return;
                }

                Security.ChangePassword(CurrentPasswordTextBox.Text, NewPasswordTextBox.Text);

                SuccessLabel.Visible = true;

                CurrentPasswordTextBox.Clear();
                NewPasswordTextBox.Clear();
                AcceptNewPasswordTextBox.Clear();
            }


            //authorization code
            if (CurrentAuthTextBox.Text.Length > 0 || NewAuthTextBox.Text.Length > 0 || AcceptNewAuthTextBox.Text.Length > 0)
            {
                if (CurrentAuthTextBox.Text.Length == 0)
                {
                    if (Security.CheckAuth(CurrentAuthTextBox.Text) == false)
                    {
                        if (CurrentAuthTextBox.Text.Length == 0)
                        {
                            OldAuthLabel.Text    = "Введите старый авторизационный код";
                            OldAuthLabel.Visible = true;
                            return;
                        }
                    }
                }
                else
                {
                    if (Security.CheckAuth(CurrentAuthTextBox.Text) == false)
                    {
                        OldAuthLabel.Text    = "Авторизационный код неверный";
                        OldAuthLabel.Visible = true;
                        return;
                    }
                }

                if (NewAuthTextBox.Text.Length == 0)
                {
                    NewAuthLabel.Text    = "Введите новый авторизационный код";
                    NewAuthLabel.Visible = true;
                    return;
                }

                if (NewAuthTextBox.Text.Length < 6)
                {
                    NewAuthLabel.Text    = "Длина авторизационного кода меньше 6 символов";
                    NewAuthLabel.Visible = true;
                    return;
                }

                if (AcceptNewAuthTextBox.Text.Length == 0)
                {
                    RepeatNewAuthLabel.Text    = "Повторите новый авторизационный код";
                    RepeatNewAuthLabel.Visible = true;
                    return;
                }

                if (AcceptNewAuthTextBox.Text != NewAuthTextBox.Text)
                {
                    RepeatNewAuthLabel.Text    = "Авторизационные коды не совпадают";
                    RepeatNewAuthLabel.Visible = true;
                    return;
                }

                Security.ChangeAuth(NewAuthTextBox.Text);

                SuccessLabel.Visible = true;

                CurrentAuthTextBox.Clear();
                NewAuthTextBox.Clear();
                AcceptNewAuthTextBox.Clear();
            }
        }
Example #11
0
        private void ChangePasswordButton_Click(object sender, EventArgs e)
        {
            User user = new User()
            {
                UserName = UserNameTextBox.Text.Trim(),
                Password = OriginalPasswordTextBox.Text.Trim()
            };
            Response response = new Response();

            if (string.IsNullOrEmpty(UserNameTextBox.Text.Trim()))
            {
                UserNameTextBox.Focus();
                UserNameErrorProvider.SetError(UserNameTextBox, "UserName can't be vacant!");
            }
            else
            {
                UserNameErrorProvider.SetError(UserNameTextBox, "");
                if (string.IsNullOrEmpty(OriginalPasswordTextBox.Text.Trim()))
                {
                    OriginalPasswordTextBox.Focus();
                    OriginalPasswordErrorProvider.SetError(OriginalPasswordTextBox, "OriginalPassword can't be vacant!");
                }
                else
                {
                    OriginalPasswordErrorProvider.SetError(OriginalPasswordTextBox, "");
                    if (string.IsNullOrEmpty(NewPasswordTextBox.Text.Trim()))
                    {
                        NewPasswordTextBox.Focus();
                        NewPasswordErrorProvider.SetError(NewPasswordTextBox, "NewPassword can't be vacant!");
                    }
                    else
                    {
                        NewPasswordErrorProvider.SetError(NewPasswordTextBox, "");
                        if (string.IsNullOrEmpty(ConfirmPasswordTextBox.Text.Trim()))
                        {
                            ConfirmPasswordTextBox.Focus();
                            ConfirmPasswordErrorProvider.SetError(ConfirmPasswordTextBox, "ConfirmPassword can't be vacant!");
                        }
                        else
                        {
                            try
                            {
                                response = new UserService().Authentication(user);
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show(ex.ToString());
                            }
                            if (string.IsNullOrEmpty(response.Message))
                            {
                                if (NewPasswordTextBox.Text.Trim() != OriginalPasswordTextBox.Text.Trim())
                                {
                                    if (ConfirmPasswordTextBox.Text.Trim() == NewPasswordTextBox.Text.Trim())
                                    {
                                        try
                                        {
                                            user.UserId   = new UserService().GetUserIdByUserName(user.UserName);
                                            user.Password = ConfirmPasswordTextBox.Text.Trim();
                                            response      = new UserService().ChangePassword(user);
                                        }
                                        catch (Exception ex)
                                        {
                                            MessageBox.Show(ex.ToString());
                                        }
                                        if (response.IsFailed)
                                        {
                                            MessageBox.Show("Changing password fails", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                            UserNameTextBox.Focus();
                                            UserNameTextBox.Text         = string.Empty;
                                            OriginalPasswordTextBox.Text = string.Empty;
                                            NewPasswordTextBox.Text      = string.Empty;
                                            ConfirmPasswordTextBox.Text  = string.Empty;
                                        }
                                        else
                                        {
                                            MessageBox.Show("Changing password succeeds", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                            this.Close();
                                        }
                                    }
                                    else
                                    {
                                        MessageBox.Show("Please repeat new password again.", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                        NewPasswordTextBox.Text     = string.Empty;
                                        ConfirmPasswordTextBox.Text = string.Empty;
                                    }
                                }
                                else
                                {
                                    MessageBox.Show("New password and current password are same.", "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                    NewPasswordTextBox.Text     = string.Empty;
                                    ConfirmPasswordTextBox.Text = string.Empty;
                                }
                            }
                            else
                            {
                                MessageBox.Show(response.Message, "System prompt", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                UserNameTextBox.Focus();
                                UserNameTextBox.Text         = string.Empty;
                                OriginalPasswordTextBox.Text = string.Empty;
                                NewPasswordTextBox.Text      = string.Empty;
                                ConfirmPasswordTextBox.Text  = string.Empty;
                            }
                        }
                    }
                }
            }
        }
        private void SaveButton_Click(object sender, EventArgs e)
        {
            if (!UsernameTextBox.Text.Trim().Equals(string.Empty) && !OldPasswordTextBox.Text.Trim().Equals(string.Empty) && !NewPasswordTextBox.Text.Trim().Equals(string.Empty) && !RepeatPasswordTextBox.Text.Trim().Equals(string.Empty))
            {
                userData = XmlDataManager.XmlUserDataReader("userdata.xml");
                string unchangeUsername = userData.Username; // old Username
                string UserAttribut     = userData.UserAttribut;

                userData1 = XmlDataManager.XmlUserDataReader("XMLSystemAdmin.xml");
                string UserAttribut1 = userData1.UserAttribut;

                if (!(UserAttribut.Equals("SuperAdmin")))
                {
                    // return the UserId from the database
                    int UserId = databaseManager.ReturnUserID(unchangeUsername, OldPasswordTextBox.Text);

                    string newUsername    = UsernameTextBox.Text;       // new Username
                    string oldPassword    = OldPasswordTextBox.Text;    // old Password
                    string newPassword    = NewPasswordTextBox.Text;    // new Password
                    string repeatPassword = RepeatPasswordTextBox.Text; // new Password

                    //Edit the UserData as simple user.
                    databaseManager.EditAccountUser(UserId, newUsername, oldPassword, newPassword, repeatPassword);
                    UsernameTextBox.Clear();
                    OldPasswordTextBox.Clear();
                    NewPasswordTextBox.Clear();
                    RepeatPasswordTextBox.Clear();

                    AdminUI adminUI = new AdminUI(Online_User);
                    this.Close();
                    adminUI.Show();
                }
                else
                {
                    string AdminPassword = userData1.Password;
                    if ((OldPasswordTextBox.Text).Equals(AdminPassword))
                    {
                        if (File.Exists("XMLSystemAdmin.xml"))
                        {
                            userData.Username     = UsernameTextBox.Text.Trim();
                            userData.Password     = NewPasswordTextBox.Text.Trim();
                            userData.UserAttribut = UserAttribut;
                            XmlDataManager.XmlDataWriter(userData, "XMLSystemAdmin.xml");
                            MessageBox.Show("SuperAdmin Data changed successful");

                            AdminUI adminUI = new AdminUI(Online_User);
                            this.Close();
                            adminUI.Show();
                        }
                        else
                        {
                            MessageBox.Show("XMLSystemAdmin.xml File not found!");
                        }
                    }
                    else
                    {
                        MessageBox.Show("Wrong Password. Please give a correct password!");
                    }
                }
            }
            else
            {
                MessageBox.Show("Fill all Fields");
            }
        }
Example #13
0
        private void ForgotPassword4NextButton_Click(object sender, RoutedEventArgs e)
        {
            LoginPage LP = new LoginPage();

            OldPasswordTextBox.Password = LP.GetSha512FromString(OldPasswordTextBox.Password);
            NewPasswordTextBox.Password = LP.GetSha512FromString(NewPasswordTextBox.Password);

            string selected_ForgotPasswordEmail = (App.Current as App).ForgotPasswordEmail;

            try
            {
                ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["connString"];
                string connectionString = conSettings.ConnectionString;

                con = new SqlConnection(connectionString);
                con.Open();
                cmd    = new SqlCommand("select * from [dbo].[test] where Password = '******' and Email = '" + selected_ForgotPasswordEmail + "'", con);
                reader = cmd.ExecuteReader();

                int count = 0;
                while (reader.Read())
                {
                    count += 1;
                }
                if (count == 1)
                {
                    try
                    {
                        ConnectionStringSettings conSettings1 = ConfigurationManager.ConnectionStrings["connString"];
                        string connectionString1 = conSettings1.ConnectionString;

                        con = new SqlConnection(connectionString1);
                        con.Open();
                        cmd = new SqlCommand("UPDATE [dbo].[test] SET Password = '******' WHERE Email = '" + selected_ForgotPasswordEmail + "'", con);
                        cmd.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        System.Windows.MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                        con.Close();
                    }

                    MessageBox.Show("You have changed your password.");
                    OldPasswordTextBox.Clear();
                    NewPasswordTextBox.Clear();
                    this.NavigationService.Navigate(new Uri(@"LoginPage.xaml", UriKind.RelativeOrAbsolute));
                }
                else
                {
                    MessageBox.Show("Incorrect old password.");
                }
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }

            OldPasswordTextBox.Clear();
            NewPasswordTextBox.Clear();
        }