private void submit_Click(object sender, EventArgs e) { if (userName.Text.Equals("") || email.Text.Equals("")) { CheckValid(userName); CheckValid(email); } else { // build query to check if user exists StringBuilder queryId = new StringBuilder(); queryId.Append("SELECT COUNT(*) FROM TAIKHOAN WHERE USERNAME LIKE '"); queryId.Append(userName.Text); queryId.Append("'"); // create connection SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = queryId.ToString(); // execute command conn.Open(); String count = Convert.ToString(cmd.ExecuteScalar()); conn.Close(); if (count.Equals("0")) { MaterialMessageBox.Show("Không tìm thấy username hãy thử lại", "Thông báo"); userName.Focus(); } else { // build a random password StringBuilder passBuilder = new StringBuilder(); passBuilder.Append(RandomString(4, true)); passBuilder.Append(new Random().Next(1000, 9999)); passBuilder.Append(RandomString(2, false)); // build query to set new password StringBuilder query = new StringBuilder(); query.Append("UPDATE TAIKHOAN SET PWD = '"); query.Append(passBuilder); query.Append("'"); query.Append("WHERE USERNAME LIKE '"); query.Append(userName.Text); query.Append("'"); // create new query for command cmd.CommandText = query.ToString(); // open connection conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // create mail message MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(email.Text); msg.Subject = "[RECOVER PASSWORD]"; msg.Body = ("userName : "******"<br>" + "Recovery password: "******"smtp.gmail.com"; // create Network Credential NetworkCredential ntwd = new NetworkCredential(); ntwd.UserName = "******"; ntwd.Password = "******"; // set specification for smtp client smt.UseDefaultCredentials = true; smt.Credentials = ntwd; smt.Port = 587; smt.EnableSsl = true; smt.Send(msg); MaterialMessageBox.Show("Mật khẩu khôi phục đã được gửi", "Thông báo"); this.Close(); } } }
private void submit_Click(object sender, EventArgs e) { if (oldPassword.Text.Equals("") || newPassword.Text.Equals("") || newPasswordConfirm.Text.Equals("")) { MessageBox.Show("Bạn chưa điền đủ thông tin vui lòng kiểm tra!"); checkFocus(oldPassword); checkFocus(newPassword); checkFocus(newPasswordConfirm); } else { StringBuilder query = new StringBuilder(); query.Append("SELECT COUNT(*) FROM TAIKHOAN WHERE USERNAME LIKE '"); query.Append(userName); query.Append("'"); query.Append("AND PWD LIKE '"); query.Append(oldPassword.Text); query.Append("'"); SqlConnection conn = new SqlConnection(Program.getConnectionString()); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = query.ToString(); conn.Open(); String count = Convert.ToString(cmd.ExecuteScalar()); conn.Close(); if (count.Equals("0")) { MaterialMessageBox.Show("Sai mật khẩu ☻", "Thông báo"); } else { if (oldPassword.Text.Equals(newPassword.Text)) { MaterialMessageBox.Show("Bạn nhập 2 mật khẩu trùng nhau", "Thông báo"); } else { if (newPassword.Text.Equals(newPasswordConfirm.Text)) { cmd.CommandText = "EXEC SP_CHANGEPASSWORD @OLDPASSWORD , @NEWPASSWORD , @USERNAME "; cmd.Parameters.Add("@OLDPASSWORD", SqlDbType.VarChar, 100).Value = oldPassword.Text.ToString(); cmd.Parameters.Add("@NEWPASSWORD", SqlDbType.VarChar, 100).Value = newPassword.Text.ToString(); cmd.Parameters.Add("@USERNAME", SqlDbType.VarChar, 100).Value = userName; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); // clear field oldPassword.Text = ""; newPassword.Text = ""; newPasswordConfirm.Text = ""; this.Close(); MaterialMessageBox.Show("Mật khẩu đã được đổi", "Thông báo"); } } } } }