private void ForgotPassword3NextButton_Click(object sender, RoutedEventArgs e) { string selected_ForgotPasswordCode = (App.Current as App).ForgotPasswordCode; if (ForgotPasswordCodeTextBox.Text == selected_ForgotPasswordCode) { const int from = 0; int to = _allowedCharacters.Length; Random r = new Random(); StringBuilder qs = new StringBuilder(); for (int i = 0; i < 8; i++) { qs.Append(_allowedCharacters.Substring(r.Next(from, to), 1)); } LoginPage LP = new LoginPage(); string selected_ForgotPasswordEmail = (App.Current as App).ForgotPasswordEmail; try { SmtpClient client = new SmtpClient("smtp.gmail.com", 587); client.EnableSsl = true; client.Timeout = 10000; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new NetworkCredential("*****@*****.**", "avantguard"); MailMessage mail = new MailMessage(); mail.To.Add(selected_ForgotPasswordEmail); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "This is an email."; mail.Body = "Your new password is " + qs.ToString(); client.Send(mail); System.Windows.MessageBox.Show("Your new password has been sent to your email. You are encouraged to change your password."); } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message); } ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["connString"]; string connectionString = conSettings.ConnectionString; 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(); } this.NavigationService.Navigate(new Uri(@"LoginPage.xaml", UriKind.RelativeOrAbsolute)); } else { MessageBox.Show("Invalid authentication code!"); } }
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(); }
private void SignUp1NextButton_Click(object sender, RoutedEventArgs e) { ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["connString"]; string connectionString = conSettings.ConnectionString; con = new SqlConnection(connectionString); con.Open(); cmd = new SqlCommand("SELECT COUNT (UserID) FROM [dbo].[test] WHERE UserID = '" + SignUpUserIDTextBox.Text + "' ", con); Int32 tempUserID = (Int32)cmd.ExecuteScalar(); cmd = new SqlCommand("SELECT COUNT (Email) FROM [dbo].[test] WHERE Email = '" + SignUpEmailTextBox.Text + "' ", con); Int32 tempEmail = (Int32)cmd.ExecuteScalar(); con.Close(); if (String.IsNullOrEmpty(SignUpUserIDTextBox.Text) || SignUpPasswordTextBox.SecurePassword.Length == 0 || SignUpPasswordTextBox.SecurePassword.Length < 8 || String.IsNullOrEmpty(SignUpNameTextBox.Text) || String.IsNullOrEmpty(SignUpEmailTextBox.Text) || !Regex.IsMatch(SignUpEmailTextBox.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$") || String.IsNullOrEmpty(SignUpContactTextBox.Text) || SignUpDOBDatePicker.SelectedDate == null || tempUserID > 0 || tempEmail > 0) { MessageBox.Show("Please make sure that all blanks are filled."); if (String.IsNullOrEmpty(SignUpUserIDTextBox.Text)) { UserIDImage.Visibility = Visibility.Visible; } else { UserIDImage.Visibility = Visibility.Hidden; } if (SignUpPasswordTextBox.SecurePassword.Length == 0) { PasswordImage.Visibility = Visibility.Visible; } else { PasswordImage.Visibility = Visibility.Hidden; } if (String.IsNullOrEmpty(SignUpNameTextBox.Text)) { NameImage.Visibility = Visibility.Visible; } else { NameImage.Visibility = Visibility.Hidden; } if (String.IsNullOrEmpty(SignUpEmailTextBox.Text)) { EmailImage.Visibility = Visibility.Visible; } else { EmailImage.Visibility = Visibility.Hidden; } if (String.IsNullOrEmpty(SignUpContactTextBox.Text)) { ContactImage.Visibility = Visibility.Visible; } else { ContactImage.Visibility = Visibility.Hidden; } if (SignUpDOBDatePicker.SelectedDate == null) { DOBImage.Visibility = Visibility.Visible; } else { DOBImage.Visibility = Visibility.Hidden; } if (SignUpPasswordTextBox.SecurePassword.Length < 8) { PasswordImage.Visibility = Visibility.Visible; MessageBox.Show("Password must be at least 8 characters."); } else { PasswordImage.Visibility = Visibility.Hidden; } if (!Regex.IsMatch(SignUpEmailTextBox.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$")) { EmailImage.Visibility = Visibility.Visible; MessageBox.Show("Please enter a valid email."); } else { EmailImage.Visibility = Visibility.Hidden; } if (tempUserID > 0) { UserIDImage.Visibility = Visibility.Visible; MessageBox.Show("User ID already exist."); } else { UserIDImage.Visibility = Visibility.Hidden; } if (tempEmail > 0) { EmailImage.Visibility = Visibility.Visible; MessageBox.Show("Email has already been used."); } else { EmailImage.Visibility = Visibility.Hidden; } } else { LoginPage LP = new LoginPage(); SignUpPasswordTextBox.Password = LP.GetSha512FromString(SignUpPasswordTextBox.Password); (App.Current as App).UserID = SignUpUserIDTextBox.Text; (App.Current as App).UserPassword = SignUpPasswordTextBox.Password; (App.Current as App).UserName = SignUpNameTextBox.Text; (App.Current as App).UserEmail = SignUpEmailTextBox.Text; (App.Current as App).UserContact = SignUpContactTextBox.Text; (App.Current as App).UserDOB = SignUpDOBDatePicker.Text; this.NavigationService.Navigate(new Uri(@"SignUp2.xaml? key1=" + SignUpUserIDTextBox.Text, UriKind.RelativeOrAbsolute)); } }
private void runSavePassword() { if (ChangeInfoNewPassword.Password != ChangeInfoReNewPassword.Password) { MessageBox.Show("New password do not match."); } else { LoginPage LP = new LoginPage(); ChangeInfoCurrentPassword.Password = LP.GetSha512FromString(ChangeInfoCurrentPassword.Password); ChangeInfoNewPassword.Password = LP.GetSha512FromString(ChangeInfoNewPassword.Password); try { string selected_UserID = (App.Current as App).LoginUserID; 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 UserID = '" + selected_UserID + "'", 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 UserID = '" + selected_UserID + "'", con); cmd.ExecuteNonQuery(); } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message); } finally { con.Close(); } MessageBox.Show("You have changed your password."); ChangeInfoCurrentPassword.Clear(); ChangeInfoNewPassword.Clear(); ChangeInfoReNewPassword.Clear(); } else { MessageBox.Show("Incorrect current password."); ChangeInfoCurrentPassword.Clear(); ChangeInfoNewPassword.Clear(); ChangeInfoReNewPassword.Clear(); } } catch (Exception ex) { System.Windows.MessageBox.Show(ex.Message); } finally { con.Close(); } } }