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