//Recuperar contraseña
public string recoverPassword(string userRequesting)
{
using (var connection = GetConnection())
{
connection.Open();
using (var command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "select * from usuarios where usuario=@user";
command.Parameters.AddWithValue("@user", userRequesting);
command.CommandType = CommandType.Text;
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
string userName = reader.GetString(0);
string userMail = reader.GetString(2);
string accountPassword = reader.GetString(1);
var mailService = new MailServices.SystemSupportMail();
mailService.sendMail(
subject: "SYSTEM: Solicitud recuperación de contraseña",
body: "Hola, " + userName + "\n Tu request para recuperar tu contraseña. \n" +
"tu contraseña actual es: " + accountPassword +
"\nSin embargo, te recomendamos cambiar tu contraseña \n" +
"\ninmediatamentedespués de iniciar sesión en el sistema.",
recipientMail: new List <string> {
userMail
}
);
return("Hola, " + userName + "\n Tu request para recuperar tu contraseña. \n" +
"Por favor revisa tu correo: " + userMail +
"\nSin embargo, te recomendamos cambiar tu contraseña \n" +
"inmediatamente después de iniciar sesión en el sistema.");
}
else
{
return("Lo sentimos, no tiene una cuenta con \n" +
"este usuario o correo electrónico");
}
}
}
}
public string recoverPassword(string userRequesting)
{
using (var connection = basededatos.ObtenerConexion())
{
// connection.Open();
using (var command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = "select *from usuarios where usuario=@user or email=@mail";
command.Parameters.AddWithValue("@user", userRequesting);
command.Parameters.AddWithValue("@mail", userRequesting);
command.CommandType = CommandType.Text;
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
string userName = reader.GetString(1) + " " + reader.GetString(2);
string userMail = reader.GetString(5);
//En este punto todo se fue alv
//string accountPassword = reader.GetString(4);
string accountPassword = randomcontraseña();
basededatos.Modificarcontraseña(reader.GetString(3), accountPassword);
var mailService = new MailServices.SystemSupportMail();
mailService.sendMail(
subject: "SISTEMA: solicitud de recuperación de contraseña",
body: "Hola, " + userName + "\nSolicitó recuperar su contraseña.\n" +
"Su contraseña actual es: " + accountPassword +
"\nSin embargo, le pedimos que cambie su contraseña inmediatamente una vez que ingrese al sistema.",
recipientMail: new List <string> {
userMail
}
);
return("Hola, " + userName + "\nSolicitó recuperar su contraseña.\n" +
"Por favor revise su correo: " + userMail +
"\nSin embargo, le pedimos que cambie su contraseña \ninmediatamente una vez que ingrese al sistema.");
}
else
{
return("Lo sentimos, no tienes una cuenta con ese correo o nombre de usuario.");
}
}
}
}
public string recoverPassowrd(string userRequesting)
{
using (var connection = GetConnection())
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "Select *from Users where LoginName=@user or Email=@mail";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@user", userRequesting);
command.Parameters.AddWithValue("@mail", userRequesting);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
string userName = reader.GetString(3) + ", " + reader.GetString(4);
string userMail = reader.GetString(6);
string accountPassword = reader.GetString(2);
var mainService = new MailServices.SystemSupportMail();
mainService.sendMail(
subject: "SYSTEM: password recovery request",
body: "Hi " + userName + " \nYou Requested to recover your password.\n" +
"your current password is: " + accountPassword +
"\nHowever, we ask that you change password inmediately once you enter the system.",
recipientMail: new List <string> {
userMail
}
);
return("Hi, " + userName + "\nYou Requested to recover your password.\n" +
"Please check your mail: " + userMail +
"\nHowever, we ask that you change your password inmediately once you enter the systam");
}
else
{
return("Sorry, you do not have an account with tha mail or userName");
}
}
}
}
//Solicitação para recuperar a senha do usuário do banco de dados.
public string recoverPassword(string userRequesting)
{
using (var connection = GetConnection())
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "select *from Users1 where LoginName=@user or Email=@mail";
command.Parameters.AddWithValue("@user", userRequesting);
command.Parameters.AddWithValue("@mail", userRequesting);
command.CommandType = CommandType.Text;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
string userName = reader.GetString(3) + ", " + reader.GetString(4);
string userMail = reader.GetString(6);
string accountPassword = reader.GetString(2);
var mailService = new MailServices.SystemSupportMail();
mailService.sendMail(
subject: "SYSTEM: Password recovery request",
body: "Olá, " + userName + "\nVocê solicitou a recuperação de sua senha.\n" +
"sua senha atual é: " + accountPassword +
"\nPedimos que você altere sua senha imediatamente assim que entrar no sistema.",
recipientMail: new List <string> {
userMail
}
);
return("Olá, " + userName + "\nVocê solicitou a recuperação de sua senha.\n" +
"Por favor cheque seu e-mail: " + userMail +
"\nPedimos que você altere sua senha imediatamente assim que entrar no sistema.");
}
else
{
return("Desculpe, você não tem uma conta com esse e-mail ou nome de usuário");
}
}
}
}
//Solicitar recuperar contraseña del usuario a la base de datos.
public string recoverPassword(string userRequesting)
{
using (var connection = GetConnection())
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "select *from Users where LoginName=@user or Email=@mail";
command.Parameters.AddWithValue("@user", userRequesting);
command.Parameters.AddWithValue("@mail", userRequesting);
command.CommandType = CommandType.Text;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
string userName = reader.GetString(3) + ", " + reader.GetString(4);
string userMail = reader.GetString(6);
string accountPassword = reader.GetString(2);
var mailService = new MailServices.SystemSupportMail();
mailService.sendMail(
subject: "SISTEMA: Solicitudes de recuperación de contraseña",
body: "Hola, " + userName + "\nSolicitó recuperar su contraseña..\n" +
"tu contraseña actual es: " + accountPassword +
"\nSin embargo, le pedimos que cambie su contraseña inmediatamente una vez que ingrese al sistema",
recipientMail: new List <string> {
userMail
}
);
return("Hola, " + userName + "\nSolicite recuperar su contraseña.\n" +
"Por favor revise su correo: " + userMail +
"\nSin embargo, le pedimos que cambie su contraseña inmediatamente una vez que ingrese al sistema.");
}
else
{
return("Lo sentimos, no tienes una cuenta con ese correo o nombre de usuario");
}
}
}
}
public string recoverPassword(string userRequesting)
{
using (var connection = GetConnection())
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "SELECT * FROM Users WHERE UserName = @UserName OR Email = @Email";
command.Parameters.AddWithValue("@UserName", userRequesting);
command.Parameters.AddWithValue("@Email", userRequesting);
command.CommandType = CommandType.Text;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read() == true)
{
string userName = reader.GetString(3) + ", " + reader.GetString(4);
string userMail = reader.GetString(6);
string accountPassword = reader.GetString(2);
var mailService = new MailServices.SystemSupportMail();
mailService.sendMail(
subject: "SISTEMA: solicitud de recuperación de contraseña",
body: "Hola, " + userName + "\n Recientemente solicitaste recuperar tu contraseña.\n" +
"Tu contraseña actual es: " + accountPassword +
"Sin embargo, le pedimos que cambie su contraseña inmediatamente una vez que ingrese al sistema.",
recipientMail: new List <string> {
userMail
}
);
return("Hola, " + userName + "\n Recientemente solicitaste recuperar tu contraseña.\n" +
"Por favor revisa tu correo: " + userMail + "\n" +
"Sin embargo, le pedimos que cambie su contraseña inmediatamente una vez que ingrese al sistema.");
}
else
{
return("Lo sentimos, no hay ninguna cuenta registrada con este nombre de usuario o correo electronico");
}
}
}
}
